diff options
author | Michael Widenius <monty@mariadb.org> | 2018-03-09 14:05:35 +0200 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2018-03-29 13:59:44 +0300 |
commit | a7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch) | |
tree | 70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/t/partition_sync.test | |
parent | ab1941266c59a19703a74b5593cf3f508a5752d7 (diff) | |
download | mariadb-git-a7abddeffa6a760ce948c2dfb007cdf3f1a369d5.tar.gz |
Create 'main' test directory and move 't' and 'r' there
Diffstat (limited to 'mysql-test/t/partition_sync.test')
-rw-r--r-- | mysql-test/t/partition_sync.test | 83 |
1 files changed, 0 insertions, 83 deletions
diff --git a/mysql-test/t/partition_sync.test b/mysql-test/t/partition_sync.test deleted file mode 100644 index fd704f35534..00000000000 --- a/mysql-test/t/partition_sync.test +++ /dev/null @@ -1,83 +0,0 @@ ---source include/have_partition.inc ---source include/have_debug.inc -# Save the initial number of concurrent sessions. ---source include/count_sessions.inc - ---echo # ---echo # Bug #43867 ALTER TABLE on a partitioned table ---echo # causes unnecessary deadlocks ---echo # - -CREATE TABLE t1 (a int) PARTITION BY RANGE (a) -(PARTITION p0 VALUES LESS THAN (1), - PARTITION p1 VALUES LESS THAN (2)); - -INSERT INTO t1 VALUES (0),(1); - -connect(con1,localhost,root); - -connection con1; -BEGIN; -SELECT * FROM t1; - -connection default; ---error ER_DROP_PARTITION_NON_EXISTENT -ALTER TABLE t1 DROP PARTITION p3; - -connection con1; ---echo # This failed with deadlock and should not do so. -SELECT * FROM t1; - -connection default; -disconnect con1; -DROP TABLE t1; - - ---echo # ---echo # Bug #46654 False deadlock on concurrent DML/DDL ---echo # with partitions, inconsistent behavior ---echo # - ---disable_warnings -DROP TABLE IF EXISTS tbl_with_partitions; ---enable_warnings - -CREATE TABLE tbl_with_partitions ( i INT ) - PARTITION BY HASH(i); -INSERT INTO tbl_with_partitions VALUES (1); - -connect(con2,localhost,root); -connect(con3,localhost,root); - -connection con3; -LOCK TABLE tbl_with_partitions READ; - ---echo # Access table with disabled autocommit -connection default; -SET AUTOCOMMIT = 0; -SELECT * FROM tbl_with_partitions; - ---echo # Alter table, abort after prepare -connection con2; -set session debug_dbug="+d,abort_copy_table"; ---error ER_LOCK_WAIT_TIMEOUT -ALTER TABLE tbl_with_partitions ADD COLUMN f INT; - ---echo # Try accessing the table after Alter aborted. ---echo # This used to give ER_LOCK_DEADLOCK. -connection default; -SELECT * FROM tbl_with_partitions; - -connection con3; -UNLOCK TABLES; - ---echo # Cleanup -connection default; -disconnect con2; -disconnect con3; -DROP TABLE tbl_with_partitions; - - -# Check that all connections opened by test cases in this file are really -# gone so execution of other tests won't be affected by their presence. ---source include/wait_until_count_sessions.inc |