← Back to branch summary

~vadim-tk/percona-server/percona-5.5.15-galera

« back to all changes in this revision

Viewing changes to mysql-test/suite/parts/t/partition_innodb_status_file.test

  • Committer: root
  • Date: 2011-09-10 16:37:18 UTC
  • Revision ID: root@r815.office.percona.com-20110910163718-ydh4zj8hcdgoyavb
Porting Galera to 5.5.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/parts/t/partition_innodb_status_file.test
 
1
--source include/have_innodb.inc
 
2
--source include/have_partition.inc
 
3
 
 
4
CREATE TABLE t1 (a INT) ENGINE = InnoDB PARTITION BY HASH(a);
 
5
INSERT INTO t1 VALUES (0), (1), (2);
 
6
START TRANSACTION;
 
7
UPDATE t1 SET a = 5 WHERE a = 1;
 
8
connect (con1, localhost, root,,);
 
9
--echo # Connection con1
 
10
--echo # InnoDB lock timeout and monitor thread runs every 15 seconds
 
11
SET innodb_lock_wait_timeout = 20;
 
12
START TRANSACTION;
 
13
--error ER_LOCK_WAIT_TIMEOUT
 
14
UPDATE t1 SET a = 3 WHERE a = 1;
 
15
COMMIT;
 
16
disconnect con1;
 
17
connection default;
 
18
--echo # Connection default
 
19
COMMIT;
 
20
DROP TABLE t1;