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

[MDEV-19682] sql_mode="oracle" does not support sysdate Created: 2019-06-04  Updated: 2021-06-01  Resolved: 2021-05-20

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

Type: Technical task Priority: Major
Reporter: Austin Rutherford (Inactive) Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: Compatibility

Attachments: File sysdate.diff    

 Description   

The following Oracle statement is not supported in MariaDB with sql_mode="oracle".

select sysdate from dual; <<<< does not work

select sysdate() from dual; <<<<< does work (but not how existing oracle SQL exists)

 Comments   
Comment by Michael Widenius [ 2020-11-17 ]

Done in bb-10.6-monty. Will be pushed when all my code in this branch is reviewed

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