PL/SQL parser (MDEV-10142)

[MDEV-10343] sql_mode=ORACLE: Providing compatibility for basic SQL data types Created: 2016-07-07  Updated: 2020-08-27  Resolved: 2016-08-18

Status: Closed
Project: MariaDB Server
Component/s: OTHER, Parser
Affects Version/s: None
Fix Version/s: 10.3.0

Type: Technical task Priority: Major
Reporter: Dmitry Tolpeko Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: Compatibility

Sprint: 10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.1.18

 Description   

The following should be supported in MariaDB when running with sql_mode=ORACLE:

  • VARCHAR2 - a synonym to VARCHAR
  • NUMBER - a synonym to DECIMAL
  • DATE (with time portion) - a synonym to MariaDB DATETIME
  • RAW - a synonym to VARBINARY
  • CLOB - a synonym to LONGTEXT
  • BLOB - a synonym to LONGBLOB

 Comments   
Comment by Paul Pogonyshev [ 2018-05-04 ]

Why wasn't NVARCHAR2 made a synonym to NVARCHAR too? In our (currently Oracle) database NVARCHAR2 is used even more often than VARCHAR2..

Generated at Thu Feb 08 07:41:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.