diff options
Diffstat (limited to 'mysql-test/suite/funcs_1/r/storedproc.result')
| -rw-r--r-- | mysql-test/suite/funcs_1/r/storedproc.result | 57 |
1 files changed, 16 insertions, 41 deletions
diff --git a/mysql-test/suite/funcs_1/r/storedproc.result b/mysql-test/suite/funcs_1/r/storedproc.result index c68e2221801..30cbdb2c32a 100644 --- a/mysql-test/suite/funcs_1/r/storedproc.result +++ b/mysql-test/suite/funcs_1/r/storedproc.result @@ -5862,9 +5862,7 @@ BEGIN declare x default '0' char; SELECT x; END// -ERROR 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 'default '0' char; -SELECT x; -END' at line 3 +ERROR HY000: Unknown data type: 'default' DROP PROCEDURE IF EXISTS sp6; CREATE PROCEDURE sp6( ) BEGIN @@ -5909,8 +5907,7 @@ CREATE PROCEDURE sp6( ) BEGIN declare x default 'a' char; END// -ERROR 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 'default 'a' char; -END' at line 3 +ERROR HY000: Unknown data type: 'default' DROP PROCEDURE IF EXISTS sp6; CREATE PROCEDURE sp6( ) BEGIN @@ -5965,8 +5962,7 @@ CREATE PROCEDURE sp6( ) BEGIN declare handler continue for sqlstate '02000' set @x2 = 1; END// -ERROR 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 'continue for sqlstate '02000' set @x2 = 1; -END' at line 3 +ERROR HY000: Unknown data type: 'continue' DROP PROCEDURE IF EXISTS sp6; CREATE PROCEDURE sp6( ) BEGIN @@ -5979,8 +5975,7 @@ CREATE PROCEDURE sp6( ) BEGIN declare handler undo for sqlstate '02000' set @x2 = 1; END// -ERROR 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 'undo for sqlstate '02000' set @x2 = 1; -END' at line 3 +ERROR HY000: Unknown data type: 'undo' DROP PROCEDURE IF EXISTS sp1; CREATE PROCEDURE sp1( ) BEGIN @@ -6873,45 +6868,35 @@ BEGIN declare date not null x; SELECT f101 into x from tb2 limit 9998, 1; END// -ERROR 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 'not null x; -SELECT f101 into x from tb2 limit 9998, 1; -END' at line 3 +ERROR HY000: Unknown data type: 'not' DROP PROCEDURE IF EXISTS sp1; CREATE PROCEDURE sp1( ) BEGIN declare time not null x; SELECT f102 into x from tb2 limit 9998, 1; END// -ERROR 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 'not null x; -SELECT f102 into x from tb2 limit 9998, 1; -END' at line 3 +ERROR HY000: Unknown data type: 'not' DROP PROCEDURE IF EXISTS sp1; CREATE PROCEDURE sp1( ) BEGIN declare datetime not null x; SELECT f103 into x from tb2 limit 9998, 1; END// -ERROR 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 'not null x; -SELECT f103 into x from tb2 limit 9998, 1; -END' at line 3 +ERROR HY000: Unknown data type: 'not' DROP PROCEDURE IF EXISTS sp1; CREATE PROCEDURE sp1( ) BEGIN declare timestamp not null x; SELECT f104 into x from tb2 limit 9998, 1; END// -ERROR 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 'not null x; -SELECT f104 into x from tb2 limit 9998, 1; -END' at line 3 +ERROR HY000: Unknown data type: 'not' DROP PROCEDURE IF EXISTS sp1; CREATE PROCEDURE sp1( ) BEGIN declare year not null x; SELECT f105 into x from tb2 limit 9998, 1; END// -ERROR 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 'not null x; -SELECT f105 into x from tb2 limit 9998, 1; -END' at line 3 +ERROR HY000: Unknown data type: 'not' DROP PROCEDURE IF EXISTS sp1; CREATE PROCEDURE sp1( ) BEGIN @@ -9344,8 +9329,7 @@ CREATE PROCEDURE sp1( ) BEGIN declare x char1; END// -ERROR 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 'char1; -END' at line 3 +ERROR HY000: Unknown data type: 'char1' DROP PROCEDURE IF EXISTS sp1; Warnings: Note 1305 PROCEDURE db_storedproc.sp1 does not exist @@ -11636,9 +11620,7 @@ set @x = 2; insert into t values (1); set @x = 3; END// -ERROR 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 'handler for sqlstate '2300' set @x2 = 1; -set @x = 1; -insert into t values (1)...' at line 3 +ERROR HY000: Unknown data type: 'handler' DROP PROCEDURE IF EXISTS handler1; Warnings: Note 1305 PROCEDURE db_storedproc.handler1 does not exist @@ -11651,9 +11633,7 @@ set @x = 2; insert into t values (1); set @x = 3; END// -ERROR 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 'handler for sqlstate '2300' set @x2 = 1; -set @x = 1; -insert into t values (1)...' at line 3 +ERROR HY000: Unknown data type: 'handler' DROP PROCEDURE IF EXISTS handler1; Warnings: Note 1305 PROCEDURE db_storedproc.handler1 does not exist @@ -11666,9 +11646,7 @@ set @x = 2; insert into t values (1); set @x = 3; END// -ERROR 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 'handler for sqlstate '2300' set @x2 = 1; -set @x = 1; -insert into t values (1)...' at line 3 +ERROR HY000: Unknown data type: 'handler' DROP PROCEDURE IF EXISTS sp1; Warnings: Note 1305 PROCEDURE db_storedproc.sp1 does not exist @@ -12919,8 +12897,7 @@ CREATE PROCEDURE sp1( ) BEGIN declare option handler for sqlstate '02000' set @var2 = 1; END// -ERROR 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 'handler for sqlstate '02000' set @var2 = 1; -END' at line 3 +ERROR HY000: Unknown data type: 'handler' DROP PROCEDURE IF EXISTS sp1; Warnings: Note 1305 PROCEDURE db_storedproc.sp1 does not exist @@ -13000,8 +12977,7 @@ CREATE PROCEDURE sp1( ) BEGIN declare privileges handler for sqlstate '02000' set @var2 = 1; END// -ERROR 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 'handler for sqlstate '02000' set @var2 = 1; -END' at line 3 +ERROR HY000: Unknown data type: 'handler' DROP PROCEDURE IF EXISTS sp1; Warnings: Note 1305 PROCEDURE db_storedproc.sp1 does not exist @@ -13054,8 +13030,7 @@ CREATE PROCEDURE sp1( ) BEGIN declare read_only handler for sqlstate '02000' set @var2 = 1; END// -ERROR 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 'handler for sqlstate '02000' set @var2 = 1; -END' at line 3 +ERROR HY000: Unknown data type: 'handler' DROP PROCEDURE IF EXISTS sp1; Warnings: Note 1305 PROCEDURE db_storedproc.sp1 does not exist |