[MDEV-13078] NOT NULL routine variables - Jira

XML

Word

Printable

For Oracle compatibility, we'll allow NOT NULL constraint for routine variables in sql_mode=ORACLE

DECLARE

  a NOT NULL INT;

BEGIN

  a:=1;

  a:=NULL; -- This should return an error

END;

and in the default sql_mode:

BEGIN

  DECLARE a NOT NULL INT;

  SET a=1;

  SET a=NULL; -- This should return an error

END;

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