[MDEV-16244] sql_mode=ORACLE: Some keywords do not work in variable declarations Created: 2018-05-22 Updated: 2019-07-19 Resolved: 2018-05-23 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Parser |
| Affects Version/s: | 10.3 |
| Fix Version/s: | 10.3.8 |
| Type: | Bug | Priority: | Major |
| Reporter: | Alexander Barkov | Assignee: | Alexander Barkov |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Compatibility | ||
| Issue Links: |
|
||||||||||||||||||||||||
| Description |
|
In Oracle, all these keywords can be used for SP variables (in declarations and as INTO targets):
In MariaDB this script:
returns an error:
In Oracle the same script (without SET sql_mode and DELIMITER commands) works without errors. |