diff options
| author | Jon Olav Hauglid <jon.hauglid@sun.com> | 2009-12-10 14:41:41 +0100 |
|---|---|---|
| committer | Jon Olav Hauglid <jon.hauglid@sun.com> | 2009-12-10 14:41:41 +0100 |
| commit | 6c13f657dbcbf1d3d0b2d391c158aedcd0437735 (patch) | |
| tree | 0c91670c9b51bb7274d89f5c3e3a13c296a719a1 /mysql-test/r/partition_sync.result | |
| parent | fb6b5ee4622c5dc02a86d1fe9a0de1f6f8aac799 (diff) | |
| download | mariadb-git-6c13f657dbcbf1d3d0b2d391c158aedcd0437735.tar.gz | |
Backport of revno: 2617.80.1
Also re-enables the test for Bug #43867
Followup to Bug#46654 False deadlock on concurrent DML/DDL with partitions,
inconsistent behavior
Partition_sync.test uses features only available in debug builds.
Disabling the test for non-debug builds.
Diffstat (limited to 'mysql-test/r/partition_sync.result')
| -rw-r--r-- | mysql-test/r/partition_sync.result | 27 |
1 files changed, 25 insertions, 2 deletions
diff --git a/mysql-test/r/partition_sync.result b/mysql-test/r/partition_sync.result index fbea2e0273a..d48362cb57c 100644 --- a/mysql-test/r/partition_sync.result +++ b/mysql-test/r/partition_sync.result @@ -1,5 +1,28 @@ -# Disabled until Bug#46654 False deadlock on concurrent DML/DDL -# with partitions, inconsistent behavior is backported +# +# Bug #43867 ALTER TABLE on a partitioned table +# causes unnecessary deadlocks +# +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); +# Connection 2 +BEGIN; +SELECT * FROM t1; +a +0 +1 +# Connection 1 +ALTER TABLE t1 DROP PARTITION p3; +ERROR HY000: Error in list of partitions to DROP +# Connection 2 +# This failed with deadlock and should not do so. +SELECT * FROM t1; +a +0 +1 +# Connection 1 +DROP TABLE t1; # # Bug #46654 False deadlock on concurrent DML/DDL # with partitions, inconsistent behavior |