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

[MDEV-19146] sql_mode="oracle" does not support nclob data type Created: 2019-04-02  Updated: 2021-05-11

Status: Open
Project: MariaDB Server
Component/s: Data types, Parser
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, Oracle


 Description    

MariaDB [test]> CREATE TABLE dttest2 (nc NCLOB);
 
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NCLOB)' at line 1
 
MariaDB [test]> CREATE TABLE dttest2 (nc CLOB);
 
Query OK, 0 rows affected (0.010 sec)


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