[MDEV-17660] sql_mode=ORACLE: Some keywords do not work as label names: history, system, versioning, without - Jira

XML

Word

Printable

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

Activity

People

Assignee:: Alexander Barkov

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2018-11-10 18:36

Updated:: 2018-11-11 04:33

Resolved:: 2018-11-10 19:13

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.