diff options
author | unknown <pem@mysql.telia.com> | 2003-08-26 17:41:40 +0200 |
---|---|---|
committer | unknown <pem@mysql.telia.com> | 2003-08-26 17:41:40 +0200 |
commit | 55e776d14565ea6ee9841612069c24f6b8a3023c (patch) | |
tree | e00ec7150a2654f1664e7aa2eba806887f08ee30 /mysql-test/t/sp-error.test | |
parent | 138f0adf2d47c995b9e4aca96147c6afe59fdfa7 (diff) | |
download | mariadb-git-55e776d14565ea6ee9841612069c24f6b8a3023c.tar.gz |
Post-merge fixes.
Diffstat (limited to 'mysql-test/t/sp-error.test')
-rw-r--r-- | mysql-test/t/sp-error.test | 42 |
1 files changed, 21 insertions, 21 deletions
diff --git a/mysql-test/t/sp-error.test b/mysql-test/t/sp-error.test index 448a571fa11..01e05246d3e 100644 --- a/mysql-test/t/sp-error.test +++ b/mysql-test/t/sp-error.test @@ -32,18 +32,18 @@ create function func1() returns int return 42| # Can't create recursively ---error 1270 +--error 1273 create procedure foo() create procedure bar() set @x=3| ---error 1270 +--error 1273 create procedure foo() create function bar() returns double return 2.3| # Already exists ---error 1271 +--error 1274 create procedure proc1() set @x = 42| ---error 1271 +--error 1274 create function func1() returns int return 42| @@ -51,32 +51,32 @@ drop procedure proc1| drop function func1| # Does not exist ---error 1272 +--error 1275 alter procedure foo| ---error 1272 +--error 1275 alter function foo| ---error 1272 +--error 1275 drop procedure foo| ---error 1272 +--error 1275 drop function foo| ---error 1272 +--error 1275 call foo()| drop procedure if exists foo| # LEAVE/ITERATE with no match ---error 1275 +--error 1278 create procedure foo() foo: loop leave bar; end loop| ---error 1275 +--error 1278 create procedure foo() foo: loop iterate bar; end loop| # Redefining label ---error 1276 +--error 1279 create procedure foo() foo: loop foo: loop @@ -85,14 +85,14 @@ foo: loop end loop foo| # End label mismatch ---error 1277 +--error 1280 create procedure foo() foo: loop set @x=2; end loop bar| # Referring to undef variable ---error 1278 +--error 1281 create procedure foo(out x int) begin declare y int; @@ -106,17 +106,17 @@ begin select name from mysql.proc; select type from mysql.proc; end| ---error 1279 +--error 1282 call foo()| drop procedure foo| # RETURN in FUNCTION only ---error 1280 +--error 1283 create procedure foo() return 42| # Doesn't allow queries in FUNCTIONs (for now :-( ) ---error 1281 +--error 1284 create function foo() returns int begin declare x int; @@ -130,13 +130,13 @@ create procedure p(x int) create function f(x int) returns int return x+42| ---error 1285 +--error 1288 call p()| ---error 1285 +--error 1288 call p(1, 2)| ---error 1285 +--error 1288 select f()| ---error 1285 +--error 1288 select f(1, 2)| drop procedure p| |