[MDEV-16259] sql_mode=ORACLE: Keywords from keyword_sp_head do not work in assignments - Jira

XML

Word

Printable

In Oracle these keywords work in assignments:

In MariaDB this script returns a syntax error:

SET sql_mode=ORACLE;

DELIMITER /

DECLARE

  CONTAINS INT;

BEGIN

  CONTAINS:=10;

END;

DECLARE

  LANGUAGE INT;

BEGIN

  LANGUAGE:=10;

END;

DECLARE

  NO INT;

BEGIN

  NO:=10;

END;

DECLARE

  CHARSET INT;

BEGIN

  CHARSET:=10;

END;

DECLARE

  FOLLOWS INT;

BEGIN

  FOLLOWS:=10;

END;

DECLARE

  PRECEDES INT;

BEGIN

  PRECEDES:=10;

END;

relates to

MDEV-10485 "Unreserve" MariaDB reserved keywords that are not reserved in the other databases

MDEV-16244 sql_mode=ORACLE: Some keywords do not work in variable declarations

MDEV-16258 sql_mode=ORACLE: Keywords from keyword_verb_clause do not work in assignments

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