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

[MDEV-19476] sql_mode="oracle" errors on create procedure AS... ORDER/NOORDER Created: 2019-05-15  Updated: 2019-09-11

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

Type: Technical task Priority: Minor
Reporter: Austin Rutherford (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: Compatibility


 Description   

CREATE SEQUENCE "SQ_TEST1" MINVALUE 1 INCREMENT BY 1 START WITH 1 NOORDER NOCYCLE ;

This statement fails due to NOORDER not being recognized by MariaDB. ORDER is also not allowed as a attribute of CREATE SEQUENCE.



 Comments   
Comment by Alexander Barkov [ 2019-09-10 ]

austinrutherford,manjot, is the idea just to recognize the ORDER and NOORDER optional keywords and ignore them?

monty In MariaDB sequences are always ORDER. Can you confirm please?

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