summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorpem@mysql.telia.com <>2003-09-24 15:26:20 +0200
committerpem@mysql.telia.com <>2003-09-24 15:26:20 +0200
commit6e55a3428aa3615e15a1c56f47817ab6e962f036 (patch)
treefdea976683e3ed29968154712c74254ba5b0aa07 /mysql-test
parent8d884c02bb2ca2f2b4bce6dccbaf69d6935e293d (diff)
downloadmariadb-git-6e55a3428aa3615e15a1c56f47817ab6e962f036.tar.gz
Post-merge fixes.
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/distinct.result4
-rw-r--r--mysql-test/r/query_cache.result8
-rw-r--r--mysql-test/r/sp-error.result2
-rw-r--r--mysql-test/r/variables.result2
-rw-r--r--mysql-test/t/distinct.test4
-rw-r--r--mysql-test/t/sp-error.test46
6 files changed, 33 insertions, 33 deletions
diff --git a/mysql-test/r/distinct.result b/mysql-test/r/distinct.result
index 5e713f59100..38df7674ed8 100644
--- a/mysql-test/r/distinct.result
+++ b/mysql-test/r/distinct.result
@@ -457,10 +457,10 @@ drop table t1,t2;
CREATE TABLE t1 (
html varchar(5) default NULL,
rin int(11) default '0',
-out int(11) default '0'
+rout int(11) default '0'
) TYPE=MyISAM;
INSERT INTO t1 VALUES ('1',1,0);
-SELECT DISTINCT html,SUM(out)/(SUM(rin)+1) as 'prod' FROM t1 GROUP BY rin;
+SELECT DISTINCT html,SUM(rout)/(SUM(rin)+1) as 'prod' FROM t1 GROUP BY rin;
html prod
1 0.00
drop table t1;
diff --git a/mysql-test/r/query_cache.result b/mysql-test/r/query_cache.result
index 3207443369b..611c8464626 100644
--- a/mysql-test/r/query_cache.result
+++ b/mysql-test/r/query_cache.result
@@ -715,10 +715,10 @@ Variable_name Value
Qcache_queries_in_cache 0
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 44
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 1
+Qcache_hits 12
/**/ select * from t1;
a
/**/ select * from t1;
@@ -728,8 +728,8 @@ Variable_name Value
Qcache_queries_in_cache 1
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 2
+Qcache_inserts 45
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 2
+Qcache_hits 13
drop table t1;
diff --git a/mysql-test/r/sp-error.result b/mysql-test/r/sp-error.result
index d839b8a3af8..109d84b2b8a 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 1275 PROCEDURE foo does not exist
+Warning 1281 PROCEDURE foo does not exist
create procedure foo()
foo: loop
leave bar;
diff --git a/mysql-test/r/variables.result b/mysql-test/r/variables.result
index 8bbe773ed01..55f49d49b87 100644
--- a/mysql-test/r/variables.result
+++ b/mysql-test/r/variables.result
@@ -311,7 +311,7 @@ set sql_log_bin=1;
set sql_log_off=1;
set sql_log_update=1;
Warnings:
-Note 1285 The update log is deprecated and replaced by the binary log. SET SQL_LOG_UPDATE has been ignored.
+Note 1291 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/distinct.test b/mysql-test/t/distinct.test
index 56c00e7501c..54e50fc7147 100644
--- a/mysql-test/t/distinct.test
+++ b/mysql-test/t/distinct.test
@@ -326,9 +326,9 @@ drop table t1,t2;
CREATE TABLE t1 (
html varchar(5) default NULL,
rin int(11) default '0',
- out int(11) default '0'
+ rout int(11) default '0'
) TYPE=MyISAM;
INSERT INTO t1 VALUES ('1',1,0);
-SELECT DISTINCT html,SUM(out)/(SUM(rin)+1) as 'prod' FROM t1 GROUP BY rin;
+SELECT DISTINCT html,SUM(rout)/(SUM(rin)+1) as 'prod' FROM t1 GROUP BY rin;
drop table t1;
diff --git a/mysql-test/t/sp-error.test b/mysql-test/t/sp-error.test
index 5d46c39b601..ab3ee6a9ac6 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 1273
+--error 1279
create procedure foo()
create procedure bar() set @x=3|
---error 1273
+--error 1279
create procedure foo()
create function bar() returns double return 2.3|
# Already exists
---error 1274
+--error 1280
create procedure proc1()
set @x = 42|
---error 1274
+--error 1280
create function func1() returns int
return 42|
@@ -51,32 +51,32 @@ drop procedure proc1|
drop function func1|
# Does not exist
---error 1275
+--error 1281
alter procedure foo|
---error 1275
+--error 1281
alter function foo|
---error 1275
+--error 1281
drop procedure foo|
---error 1275
+--error 1281
drop function foo|
---error 1275
+--error 1281
call foo()|
drop procedure if exists foo|
# LEAVE/ITERATE with no match
---error 1278
+--error 1284
create procedure foo()
foo: loop
leave bar;
end loop|
---error 1278
+--error 1284
create procedure foo()
foo: loop
iterate bar;
end loop|
# Redefining label
---error 1279
+--error 1285
create procedure foo()
foo: loop
foo: loop
@@ -85,14 +85,14 @@ foo: loop
end loop foo|
# End label mismatch
---error 1280
+--error 1286
create procedure foo()
foo: loop
set @x=2;
end loop bar|
# Referring to undef variable
---error 1281
+--error 1287
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 1282
+--error 1288
call foo()|
drop procedure foo|
# RETURN in FUNCTION only
---error 1283
+--error 1289
create procedure foo()
return 42|
# Doesn't allow queries in FUNCTIONs (for now :-( )
---error 1284
+--error 1290
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 1288
+--error 1294
call p()|
---error 1288
+--error 1294
call p(1, 2)|
---error 1288
+--error 1294
select f()|
---error 1288
+--error 1294
select f(1, 2)|
drop procedure p|
drop function f|
---error 1289
+--error 1295
create procedure p(val int, out res int)
begin
declare x int default 0;
@@ -156,7 +156,7 @@ begin
end if;
end|
---error 1289
+--error 1295
create procedure p(val int, out res int)
begin
declare x int default 0;