[MDEV-17666] sql_mode=ORACLE: Keyword ELSEIF should not be reserved - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.3(EOL)
Fix Version/s: 10.3.11
Component/s: Parser
Labels:
None

Description

The keyword ELSEIF does not have a special meaning on Oracle. These scripts work fine on Oracle:

DECLARE

  ELSEIF INT;

BEGIN

  ELSEIF:=1;

END;

BEGIN

<<ELSEIF>>

  NULL;

END;

Equivalent MariaDB scripts produce systax errors:

SET sql_mode=ORACLE;

DELIMITER /

DECLARE

  ELSEIF INT;

BEGIN

  ELSEIF:=1;

END;

DELIMITER ;

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 'ELSEIF INT;...

SET sql_mode=ORACLE;

DELIMITER /

BEGIN

<<ELSEIF>>

  NULL;

END;

DELIMITER ;

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 'ELSEIF>>

Attachments

Issue Links

blocks

MDEV-12518 Unify sql_yacc.yy and sql_yacc_ora.yy

Closed

Activity

There are no comments yet on this issue.

People

Assignee:: Alexander Barkov

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2018-11-11 15:44

Updated:: 2018-11-11 20:01

Resolved:: 2018-11-11 20:01

Git Integration

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

MariaDB Server