summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <pem@mysql.comhem.se>2003-10-23 16:06:51 +0200
committerunknown <pem@mysql.comhem.se>2003-10-23 16:06:51 +0200
commitec3a39dc67e264eadb0b924dd7f872f566c8b2dc (patch)
tree108f29b190519d6452fd2acf8e29bd331d52a384 /mysql-test
parent24f8b1cfa8798b11503b516da018140026895ce2 (diff)
downloadmariadb-git-ec3a39dc67e264eadb0b924dd7f872f566c8b2dc.tar.gz
Post-merge fixes.
mysql-test/r/sp-error.result: Post-merge fixes. Error codes renumbered. mysql-test/r/sp.result: Post-merge fixes. Error codes renumbered. mysql-test/r/variables.result: Post-merge fixes. Error codes renumbered. mysql-test/t/sp-error.test: Post-merge fixes. Error codes renumbered. mysql-test/t/sp.test: Post-merge fixes. Error codes renumbered. sql/item_subselect.cc: Post-merge fixes. thd->lex is a pointer. sql/slave.cc: Post-merge fixes. Undid imported patch that's not 5.0 compatible. sql/sql_parse.cc: Post-merge fixes. Changed access API calls, and fixed merge error. sql/sql_table.cc: Post-merge fixes. No update log in 5.0.
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/query_cache.result4
-rw-r--r--mysql-test/r/sp-error.result2
-rw-r--r--mysql-test/r/sp.result4
-rw-r--r--mysql-test/r/variables.result2
-rw-r--r--mysql-test/t/sp-error.test66
-rw-r--r--mysql-test/t/sp.test4
6 files changed, 41 insertions, 41 deletions
diff --git a/mysql-test/r/query_cache.result b/mysql-test/r/query_cache.result
index 3cc0b3e9852..619f44f457d 100644
--- a/mysql-test/r/query_cache.result
+++ b/mysql-test/r/query_cache.result
@@ -762,7 +762,7 @@ Variable_name Value
Qcache_queries_in_cache 0
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 44
+Qcache_inserts 48
show status like "Qcache_hits";
Variable_name Value
Qcache_hits 12
@@ -775,7 +775,7 @@ Variable_name Value
Qcache_queries_in_cache 1
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 45
+Qcache_inserts 49
show status like "Qcache_hits";
Variable_name Value
Qcache_hits 13
diff --git a/mysql-test/r/sp-error.result b/mysql-test/r/sp-error.result
index ef8b2ac1552..4cd1c4c961c 100644
--- a/mysql-test/r/sp-error.result
+++ b/mysql-test/r/sp-error.result
@@ -35,7 +35,7 @@ call foo();
ERROR HY000: PROCEDURE foo does not exist
drop procedure if exists foo;
Warnings:
-Warning 1281 PROCEDURE foo does not exist
+Warning 1282 PROCEDURE foo does not exist
create procedure foo()
foo: loop
leave bar;
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result
index 4f9c1ed5f7e..05bb2348442 100644
--- a/mysql-test/r/sp.result
+++ b/mysql-test/r/sp.result
@@ -533,7 +533,7 @@ drop procedure hndlr4;
create procedure cur1()
begin
declare done int default 0;
-declare continue handler for 1305 set done = 1;
+declare continue handler for 1306 set done = 1;
declare c cursor for select * from test.t2;
declare a char(16);
declare b int;
@@ -560,7 +560,7 @@ create table t3 ( s char(16), i int );
create procedure cur2()
begin
declare done int default 0;
-declare continue handler for 1305 set done = 1;
+declare continue handler for 1306 set done = 1;
declare c1 cursor for select id,data from test.t1;
declare c2 cursor for select i from test.t2;
open c1;
diff --git a/mysql-test/r/variables.result b/mysql-test/r/variables.result
index 709bf2d65eb..986d82012a2 100644
--- a/mysql-test/r/variables.result
+++ b/mysql-test/r/variables.result
@@ -345,7 +345,7 @@ set sql_log_bin=1;
set sql_log_off=1;
set sql_log_update=1;
Warnings:
-Note 1291 The update log is deprecated and replaced by the binary log. SET SQL_LOG_UPDATE has been ignored.
+Note 1292 The update log is deprecated and replaced by the binary log. SET SQL_LOG_UPDATE has been ignored.
set sql_low_priority_updates=1;
set sql_max_join_size=200;
select @@sql_max_join_size,@@max_join_size;
diff --git a/mysql-test/t/sp-error.test b/mysql-test/t/sp-error.test
index c075e96cc78..7c541029452 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 1279
+--error 1280
create procedure foo()
create procedure bar() set @x=3|
---error 1279
+--error 1280
create procedure foo()
create function bar() returns double return 2.3|
# Already exists
---error 1280
+--error 1281
create procedure proc1()
set @x = 42|
---error 1280
+--error 1281
create function func1() returns int
return 42|
@@ -51,32 +51,32 @@ drop procedure proc1|
drop function func1|
# Does not exist
---error 1281
+--error 1282
alter procedure foo|
---error 1281
+--error 1282
alter function foo|
---error 1281
+--error 1282
drop procedure foo|
---error 1281
+--error 1282
drop function foo|
---error 1281
+--error 1282
call foo()|
drop procedure if exists foo|
# LEAVE/ITERATE with no match
---error 1284
+--error 1285
create procedure foo()
foo: loop
leave bar;
end loop|
---error 1284
+--error 1285
create procedure foo()
foo: loop
iterate bar;
end loop|
# Redefining label
---error 1285
+--error 1286
create procedure foo()
foo: loop
foo: loop
@@ -85,14 +85,14 @@ foo: loop
end loop foo|
# End label mismatch
---error 1286
+--error 1287
create procedure foo()
foo: loop
set @x=2;
end loop bar|
# Referring to undef variable
---error 1287
+--error 1288
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 1288
+--error 1289
call foo()|
drop procedure foo|
# RETURN in FUNCTION only
---error 1289
+--error 1290
create procedure foo()
return 42|
# Doesn't allow queries in FUNCTIONs (for now :-( )
---error 1290
+--error 1291
create function foo() returns int
begin
declare x int;
@@ -130,19 +130,19 @@ create procedure p(x int)
create function f(x int) returns int
return x+42|
---error 1294
+--error 1295
call p()|
---error 1294
+--error 1295
call p(1, 2)|
---error 1294
+--error 1295
select f()|
---error 1294
+--error 1295
select f(1, 2)|
drop procedure p|
drop function f|
---error 1295
+--error 1296
create procedure p(val int, out res int)
begin
declare x int default 0;
@@ -156,7 +156,7 @@ begin
end if;
end|
---error 1295
+--error 1296
create procedure p(val int, out res int)
begin
declare x int default 0;
@@ -171,7 +171,7 @@ begin
end if;
end|
---error 1296
+--error 1297
create function f(val int) returns int
begin
declare x int;
@@ -189,12 +189,12 @@ begin
end if;
end|
---error 1297
+--error 1298
select f(10)|
drop function f|
---error 1298
+--error 1299
create procedure p()
begin
declare c cursor for insert into test.t1 values ("foo", 42);
@@ -203,7 +203,7 @@ begin
close c;
end|
---error 1299
+--error 1300
create procedure p()
begin
declare x int;
@@ -213,7 +213,7 @@ begin
close c;
end|
---error 1300
+--error 1301
create procedure p()
begin
declare c cursor for select * from test.t;
@@ -235,7 +235,7 @@ begin
open c;
close c;
end|
---error 1301
+--error 1302
call p()|
drop procedure p|
@@ -247,7 +247,7 @@ begin
close c;
close c;
end|
---error 1302
+--error 1303
call p()|
drop procedure p|
@@ -259,7 +259,7 @@ drop table if exists t1|
create table t1 (val int, x float)|
insert into t1 values (42, 3.1), (19, 1.2)|
---error 1303
+--error 1304
create procedure p()
begin
declare c cursor for select * from t1;
@@ -279,7 +279,7 @@ begin
fetch c into x;
close c;
end|
---error 1304
+--error 1305
call p()|
drop procedure p|
@@ -294,7 +294,7 @@ begin
fetch c into x, y, z;
close c;
end|
---error 1304
+--error 1305
call p()|
drop procedure p|
diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test
index ad5dbe9f25e..ebc07f8fca8 100644
--- a/mysql-test/t/sp.test
+++ b/mysql-test/t/sp.test
@@ -636,7 +636,7 @@ drop procedure hndlr4|
create procedure cur1()
begin
declare done int default 0;
- declare continue handler for 1305 set done = 1;
+ declare continue handler for 1306 set done = 1;
declare c cursor for select * from test.t2;
declare a char(16);
declare b int;
@@ -665,7 +665,7 @@ create table t3 ( s char(16), i int )|
create procedure cur2()
begin
declare done int default 0;
- declare continue handler for 1305 set done = 1;
+ declare continue handler for 1306 set done = 1;
declare c1 cursor for select id,data from test.t1;
declare c2 cursor for select i from test.t2;