Some basic datatypes and functions in oracle compatibility mode do not work (MDEV-19162)

[MDEV-18510] sql_mode="oracle" does not support COMMENT statements in PL/SQL Created: 2019-02-07  Updated: 2024-01-12

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Technical task Priority: Major
Reporter: Manjot Singh (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: Compatibility


 Description   

Please add support for commands such as

COMMENT ON  COLUMN tablename.columnname  IS "some comment";

https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4009.htm



 Comments   
Comment by Dmitry Tolpeko [ 2019-06-25 ]

Should be single quoted string: IS 'some comment'

Comment by Manjot Singh (Inactive) [ 2020-05-14 ]

PL/SQL supports double quote.

Generated at Thu Feb 08 08:44:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.