diff options
author | unknown <msvensson@neptunus.(none)> | 2006-03-09 12:55:56 +0100 |
---|---|---|
committer | unknown <msvensson@neptunus.(none)> | 2006-03-09 12:55:56 +0100 |
commit | d478899a728f90fd35652480a8c5649d201a14f7 (patch) | |
tree | a6dcb64d728aa62e6a63f0d9e1d7181ef9c3fa2b /mysql-test/r/sp.result | |
parent | 1ba0179301fa78dfb238058ab4d9bf42885bd4ed (diff) | |
parent | 2acff5c36d99b9726b152bcf8b5286fb46849d88 (diff) | |
download | mariadb-git-d478899a728f90fd35652480a8c5649d201a14f7.tar.gz |
Merge neptunus.(none):/home/msvensson/mysql/bug10656/my50-bug10656
into neptunus.(none):/home/msvensson/mysql/bug10656/my51-bug10656
mysql-test/r/sp.result:
Auto merged
mysql-test/r/sp_trans.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.result | 71 |
1 files changed, 0 insertions, 71 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 6636f799b5d..365b57f8f0c 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() |