[MDEV-19477] sql_mode="oracle" errors on create procedure AS ... MAXVALUE Created: 2019-05-15 Updated: 2019-09-11 Resolved: 2019-09-11 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Sequences |
| Affects Version/s: | 10.3.8 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Austin Rutherford (Inactive) | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | Compatibility | ||
| Description |
|
CREATE SEQUENCE "SQ_TEST2" MINVALUE 1 MAXVALUE 99999999999999999 INCREMENT BY 1; The MAXVALUE in this case causes error in MariaDB Server with Oracle Compatibility mode - it works in ORACLE. |
| Comments |
| Comment by Ralf Gebhardt [ 2019-07-15 ] | ||
|
austinrutherford I have tried it with 10.4.6 and could not see an issue. Can you test it again? | ||
| Comment by Alexander Barkov [ 2019-09-10 ] | ||
|
manjot, austinrutherford,
Can we close this issue? | ||
| Comment by Manjot Singh (Inactive) [ 2019-09-10 ] | ||
|
What is the fix version? Is it documented? Thanks, On Mon, Sep 9, 2019, 8:08 PM Alexander Barkov (Jira) <jira@mariadb.org> | ||
| Comment by Alexander Barkov [ 2019-09-10 ] | ||
|
manjot I think it worked from the very beginning, when CREATE SEQUENCE was introduced. | ||
| Comment by Manjot Singh (Inactive) [ 2019-09-10 ] | ||
|
The test version I used (I believe 10.3.8) didn't support it as you can see |