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

[MDEV-19589] sql_mode="oracle" Rem does not work for comments Created: 2019-05-24  Updated: 2019-07-15

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   

This code in a sourced sql script throws errors:

Rem
 
Rem    MODIFIED   (MM/DD/YY)
 
Rem    bnnguyen
 
Rem


MariaDB [(none)]> source test.sql
 
ERROR 1064 (42000) at line 1 in file: 'test.sql': 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 'Rem ' at line 2


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