-
Type:
Technical task
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.3
-
Fix Version/s: None
-
Component/s: Parser, Stored routines
-
Labels:None
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; |