summaryrefslogtreecommitdiff
path: root/mysql-test/r/sp.result
diff options
context:
space:
mode:
authorunknown <msvensson@neptunus.(none)>2006-03-09 13:12:20 +0100
committerunknown <msvensson@neptunus.(none)>2006-03-09 13:12:20 +0100
commit8a384d3c9b621243c2e2171dda9ec2d884ca9bdf (patch)
treee77bb5cfacc21f72cdfc816429472957fa3272bb /mysql-test/r/sp.result
parent132c219df067ec16f442ec9aec9c6d0aa1a29072 (diff)
parentd478899a728f90fd35652480a8c5649d201a14f7 (diff)
downloadmariadb-git-8a384d3c9b621243c2e2171dda9ec2d884ca9bdf.tar.gz
Merge neptunus.(none):/home/msvensson/mysql/bug10656/my51-bug10656
into neptunus.(none):/home/msvensson/mysql/mysql-5.1 mysql-test/r/sp.result: Auto merged mysql-test/t/sp.test: Auto merged
Diffstat (limited to 'mysql-test/r/sp.result')
-rw-r--r--mysql-test/r/sp.result71
1 files changed, 0 insertions, 71 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result
index 9d4730d9e73..6925d351384 100644
--- a/mysql-test/r/sp.result
+++ b/mysql-test/r/sp.result
@@ -2197,35 +2197,6 @@ select @i, from_unixtime(@stamped_time, '%d-%m-%Y %h:%i:%s') as time|
2 01-01-1970 03:16:40
drop procedure bug3426|
create table t3 (
-a int primary key,
-ach char(1)
-) engine = innodb|
-create table t4 (
-b int primary key ,
-bch char(1)
-) engine = innodb|
-insert into t3 values (1 , 'aCh1' ) , ('2' , 'aCh2')|
-Warnings:
-Warning 1265 Data truncated for column 'ach' at row 1
-Warning 1265 Data truncated for column 'ach' at row 2
-insert into t4 values (1 , 'bCh1' )|
-Warnings:
-Warning 1265 Data truncated for column 'bch' at row 1
-drop procedure if exists bug3448|
-create procedure bug3448()
-select * from t3 inner join t4 on t3.a = t4.b|
-select * from t3 inner join t4 on t3.a = t4.b|
-a ach b bch
-1 a 1 b
-call bug3448()|
-a ach b bch
-1 a 1 b
-call bug3448()|
-a ach b bch
-1 a 1 b
-drop procedure bug3448|
-drop table t3, t4|
-create table t3 (
id int unsigned auto_increment not null primary key,
title VARCHAR(200),
body text,
@@ -4009,48 +3980,6 @@ DROP VIEW bug13095_v1
DROP PROCEDURE IF EXISTS bug13095;
DROP VIEW IF EXISTS bug13095_v1;
DROP TABLE IF EXISTS bug13095_t1;
-drop procedure if exists bug14210|
-set @@session.max_heap_table_size=16384|
-select @@session.max_heap_table_size|
-@@session.max_heap_table_size
-16384
-create table t3 (a char(255)) engine=InnoDB|
-create procedure bug14210_fill_table()
-begin
-declare table_size, max_table_size int default 0;
-select @@session.max_heap_table_size into max_table_size;
-delete from t3;
-insert into t3 (a) values (repeat('a', 255));
-repeat
-insert into t3 select a from t3;
-select count(*)*255 from t3 into table_size;
-until table_size > max_table_size*2 end repeat;
-end|
-call bug14210_fill_table()|
-drop procedure bug14210_fill_table|
-create table t4 like t3|
-create procedure bug14210()
-begin
-declare a char(255);
-declare done int default 0;
-declare c cursor for select * from t3;
-declare continue handler for sqlstate '02000' set done = 1;
-open c;
-repeat
-fetch c into a;
-if not done then
-insert into t4 values (upper(a));
-end if;
-until done end repeat;
-close c;
-end|
-call bug14210()|
-select count(*) from t4|
-count(*)
-256
-drop table t3, t4|
-drop procedure bug14210|
-set @@session.max_heap_table_size=default|
drop function if exists bug14723|
drop procedure if exists bug14723|
/*!50003 create function bug14723()