Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Not a Bug
-
10.8(EOL)
-
None
Description
10.8.0 aff084d139a9fca9d569fedd9ec80bd9576614b1 preview-10.8-MDEV-10654-inout-params |
10.8.0>SET sql_mode=''; # Optional, here to show the clear difference oracle mode makes
|
Query OK, 0 rows affected (0.000 sec)
|
|
10.8.0>DELIMITER #
|
10.8.0>CREATE FUNCTION f(OUT c INT) RETURNS INT BEGIN SET c=1; RETURN c; END; #
|
Query OK, 0 rows affected (0.010 sec)
|
|
10.8.0>DELIMITER ;
|
Yet
10.8.0 aff084d139a9fca9d569fedd9ec80bd9576614b1 preview-10.8-MDEV-10654-inout-params |
10.8.0>SET sql_mode='oracle';
|
Query OK, 0 rows affected (0.000 sec)
|
|
10.8.0>DELIMITER #
|
10.8.0>CREATE FUNCTION f(OUT c INT) RETURNS INT BEGIN SET c=1; RETURN c; END; #
|
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 'OUT c INT) RETURNS INT BEGIN SET c=1; RETURN c; END' at line 1
|
10.8.0>DELIMITER ;
|
Attachments
Issue Links
- is caused by
-
MDEV-10654 IN, OUT, INOUT parameters in CREATE FUNCTION
- Closed