Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.3
-
Fix Version/s: 10.3.11
-
Component/s: Parser
-
Labels:None
Description
These scripts work fine in Oracle:
BEGIN
|
<<history>>
|
NULL; |
END; |
/
|
BEGIN
|
<<system>>
|
NULL; |
END; |
/
|
BEGIN
|
<<versioning>>
|
NULL; |
END; |
/
|
BEGIN
|
<<without>>
|
NULL; |
END; |
/
|
If I try equivalent scripts in MariaDB:
SET sql_mode=ORACLE; |
DELIMITER /
|
BEGIN
|
<<history>>
|
NULL; |
END; |
/
|
DELIMITER ;
|
SET sql_mode=ORACLE; |
DELIMITER /
|
BEGIN
|
<<system>>
|
NULL; |
END; |
/
|
DELIMITER ;
|
SET sql_mode=ORACLE; |
DELIMITER /
|
BEGIN
|
<<versioning>>
|
NULL; |
END; |
/
|
DELIMITER ;
|
SET sql_mode=ORACLE; |
DELIMITER /
|
BEGIN
|
<<without>>
|
NULL; |
END; |
/
|
DELIMITER ;
|
they fail, e.g.:
ERROR 1064 (42000): 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 'history>>
|
Attachments
Issue Links
- blocks
-
MDEV-12518 Unify sql_yacc.yy and sql_yacc_ora.yy
-
- Closed
-
- relates to
-
MDEV-17661 Add sql_mode specific tokens for the keyword DECODE
-
- Closed
-
-
MDEV-17664 Add sql_mode specific tokens for ':' and '%'
-
- Closed
-