Some basic datatypes and functions in oracle compatibility mode do not work
(MDEV-19162)
|
|
| 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? |