diff options
Diffstat (limited to 'mysql-test/t/sp-error.test')
-rw-r--r-- | mysql-test/t/sp-error.test | 34 |
1 files changed, 17 insertions, 17 deletions
diff --git a/mysql-test/t/sp-error.test b/mysql-test/t/sp-error.test index dd3bf916260..63850f409dc 100644 --- a/mysql-test/t/sp-error.test +++ b/mysql-test/t/sp-error.test @@ -22,48 +22,48 @@ create function func1() returns int return 42| # Can't create recursively ---error 1255 +--error 1259 create procedure foo() create procedure bar() set @x=3| ---error 1255 +--error 1259 create procedure foo() create function bar() returns double return 2.3| # Already exists ---error 1256 +--error 1260 create procedure proc1() set @x = 42| ---error 1256 +--error 1260 create function func1() returns int return 42| # Does not exist ---error 1257 +--error 1261 alter procedure foo| ---error 1257 +--error 1261 alter function foo| ---error 1257 +--error 1261 drop procedure foo| ---error 1257 +--error 1261 drop function foo| ---error 1257 +--error 1261 call foo()| drop procedure if exists foo| # LEAVE/ITERATE with no match ---error 1260 +--error 1264 create procedure foo() foo: loop leave bar; end loop| ---error 1260 +--error 1264 create procedure foo() foo: loop iterate bar; end loop| # Redefining label ---error 1261 +--error 1265 create procedure foo() foo: loop foo: loop @@ -72,14 +72,14 @@ foo: loop end loop foo| # End label mismatch ---error 1262 +--error 1266 create procedure foo() foo: loop set @x=2; end loop bar| # Referring to undef variable ---error 1263 +--error 1267 create procedure foo(out x int) begin declare y int; @@ -87,17 +87,17 @@ begin end| # We require INTO in SELECTs (for now; this might change in the future) ---error 1264 +--error 1268 create procedure foo(x int) select * from test.t1| # RETURN in FUNCTION only ---error 1265 +--error 1269 create procedure foo() return 42| # Doesn't allow queries in FUNCTIONs (for now :-( ) ---error 1266 +--error 1270 create function foo() returns int begin declare x int; |