Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.3.0
-
None
-
win10 x64, Heidisql 9.4.0.5125
Description
When testing out the row data type example supplied in the doc (and MDEV-10142):
CREATE PROCEDURE p1() |
BEGIN
|
DECLARE r ROW (c1 INT, c2 VARCHAR(10)); |
SET r.c1= 10; |
SET r.c2= 'test'; |
-- INSERT INTO t1 VALUES (r.c1, r.c2); |
END; |
Mariadb 10.3.0 returns an sql 1064 error on the very first line, followed by 4056 errors on the subsequent lines:
CREATE PROCEDURE p1() |
BEGIN
|
DECLARE r ROW (c1 INT, c2 VARCHAR(10)); |
/* SQL Error (1064): 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 '' at line 3 */
|
SET r.c1= 10; |
/* SQL Error (4056): Unknown structured system variable or ROW routine variable 'r' */
|
SET r.c2= 'test'; |
/* SQL Error (4056): Unknown structured system variable or ROW routine variable 'r' */ |