diff options
Diffstat (limited to 'mysql-test/t/innodb-big.test')
-rw-r--r-- | mysql-test/t/innodb-big.test | 152 |
1 files changed, 0 insertions, 152 deletions
diff --git a/mysql-test/t/innodb-big.test b/mysql-test/t/innodb-big.test deleted file mode 100644 index dcb32cd8e71..00000000000 --- a/mysql-test/t/innodb-big.test +++ /dev/null @@ -1,152 +0,0 @@ -# -# Test some things that takes a long time - --- source include/big_test.inc --- source include/have_innodb.inc - ---disable_warnings -DROP TABLE IF EXISTS t1, t2, t3, t4; ---enable_warnings - -# -# Test test how filesort and buffered-record-reads works with innodb -# - -CREATE TABLE t1 (id INTEGER) ENGINE=MYISAM; -CREATE TABLE t2 (id INTEGER primary key) ENGINE=INNODB; -CREATE TABLE t3 (a char(32) primary key,id INTEGER) ENGINE=INNODB; -CREATE TABLE t4 (a char(32) primary key,id INTEGER) ENGINE=MYISAM; - -INSERT INTO t1 (id) VALUES (1); -INSERT INTO t1 SELECT id+1 FROM t1; -INSERT INTO t1 SELECT id+2 FROM t1; -INSERT INTO t1 SELECT id+4 FROM t1; -INSERT INTO t1 SELECT id+8 FROM t1; -INSERT INTO t1 SELECT id+16 FROM t1; -INSERT INTO t1 SELECT id+32 FROM t1; -INSERT INTO t1 SELECT id+64 FROM t1; -INSERT INTO t1 SELECT id+128 FROM t1; -INSERT INTO t1 SELECT id+256 FROM t1; -INSERT INTO t1 SELECT id+512 FROM t1; -INSERT INTO t1 SELECT id+1024 FROM t1; -INSERT INTO t1 SELECT id+2048 FROM t1; -INSERT INTO t1 SELECT id+4096 FROM t1; -INSERT INTO t1 SELECT id+8192 FROM t1; -INSERT INTO t1 SELECT id+16384 FROM t1; -INSERT INTO t1 SELECT id+32768 FROM t1; -INSERT INTO t1 SELECT id+65536 FROM t1; -INSERT INTO t1 SELECT id+131072 FROM t1; -INSERT INTO t1 SELECT id+262144 FROM t1; -INSERT INTO t1 SELECT id+524288 FROM t1; -INSERT INTO t1 SELECT id+1048576 FROM t1; -INSERT INTO t2 SELECT * FROM t1; -INSERT INTO t3 SELECT concat(id),id from t2 ORDER BY -id; -INSERT INTO t4 SELECT * from t3 ORDER BY concat(a); -select sum(id) from t3; -drop table t1,t2,t3,t4; - -# -# Bug#24989: The DEADLOCK error is improperly handled by InnoDB. -# -CREATE TABLE t1 (f1 int NOT NULL) ENGINE=InnoDB; -CREATE TABLE t2 (f2 int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB; -DELIMITER |; -CREATE TRIGGER t1_bi before INSERT - ON t1 FOR EACH ROW -BEGIN - DECLARE CONTINUE HANDLER FOR SQLSTATE '40001' SET @a:= 'deadlock'; - DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET @a:= 'exception'; - INSERT INTO t2 (f2) VALUES (1); - DELETE FROM t2 WHERE f2 = 1; -END;| - -CREATE PROCEDURE proc24989() -BEGIN - DECLARE CONTINUE HANDLER FOR SQLSTATE '40001' SET @b:= 'deadlock'; - DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET @a:= 'exception'; - INSERT INTO t2 (f2) VALUES (1); - DELETE FROM t2 WHERE f2 = 1; -END;| - -create procedure proc24989_2() - deterministic -begin - declare continue handler for sqlexception - select 'Outer handler' as 'exception'; - - insert into t1 values(1); - select "continued"; -end| - -DELIMITER ;| - -connect (con1,localhost,root,,); -connect (con2,localhost,root,,); - -connection con1; -start transaction; -insert into t1 values(1); - -connection con2; -start transaction; -insert into t2 values(123); -send insert into t1 values(1); - -connection con1; ---sleep 1 -insert into t1 values(1); - -connection con2; ---error 1213 -reap; -select @a; -# check that the whole transaction was rolled back -select * from t2; - -connection con1; -commit; -start transaction; -insert into t1 values(1); - -connection con2; -start transaction; -insert into t2 values(123); -send call proc24989(); - -connection con1; ---sleep 1 -insert into t1 values(1); - -connection con2; -reap; -select @a,@b; -# check that the whole transaction was rolled back -select * from t2; - -connection con1; -commit; -start transaction; -insert into t1 values(1); - -connection con2; -start transaction; -insert into t2 values(123); -send call proc24989_2(); - -connection con1; ---sleep 1 -insert into t1 values(1); -commit; - -connection con2; -reap; -# check that the whole transaction was rolled back -select * from t2; - -disconnect con1; -disconnect con2; -connection default; -drop procedure proc24989; -drop procedure proc24989_2; -drop table t1,t2; - |