summaryrefslogtreecommitdiff
path: root/mysql-test/main/partition_innodb.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/partition_innodb.test')
-rw-r--r--mysql-test/main/partition_innodb.test14
1 files changed, 10 insertions, 4 deletions
diff --git a/mysql-test/main/partition_innodb.test b/mysql-test/main/partition_innodb.test
index 16fd7ea60ef..cef10e745e0 100644
--- a/mysql-test/main/partition_innodb.test
+++ b/mysql-test/main/partition_innodb.test
@@ -3,6 +3,7 @@
--source include/have_innodb.inc
--source include/default_optimizer_switch.inc
+--disable_service_connection
call mtr.add_suppression("Deadlock found when trying to get lock; try restarting transaction");
set global default_storage_engine='innodb';
@@ -94,7 +95,7 @@ DROP TABLE t1;
--echo # Bug#54747: Deadlock between REORGANIZE PARTITION and
--echo # SELECT is not detected
--echo #
-
+--disable_view_protocol
SET @old_innodb_thread_concurrency := @@innodb_thread_concurrency;
SET @old_innodb_thread_sleep_delay := @@innodb_thread_sleep_delay;
SET GLOBAL innodb_thread_concurrency = 1;
@@ -146,11 +147,12 @@ COMMIT;
SET GLOBAL innodb_thread_concurrency = @old_innodb_thread_concurrency;
SET GLOBAL innodb_thread_sleep_delay = @old_innodb_thread_sleep_delay;
DROP TABLE t1;
-
+--enable_view_protocol
--echo #
--echo # Bug#50418: DROP PARTITION does not interact with transactions
--echo #
+--disable_view_protocol
CREATE TABLE t1 (
id INT AUTO_INCREMENT NOT NULL,
name CHAR(50) NOT NULL,
@@ -189,7 +191,7 @@ SELECT * FROM t1;
--echo # No changes.
COMMIT;
DROP TABLE t1;
-
+--enable_view_protocol
--echo #
--echo # Bug#51830: Incorrect partition pruning on range partition (regression)
@@ -588,6 +590,7 @@ DROP TABLE t1;
--echo # Bug#47343: InnoDB fails to clean-up after lock wait timeout on
--echo # REORGANIZE PARTITION
--echo #
+--disable_view_protocol
CREATE TABLE t1 (
a INT,
b DATE NOT NULL,
@@ -622,6 +625,7 @@ connection default;
SELECT * FROM t1;
COMMIT;
DROP TABLE t1;
+--enable_view_protocol
#
# Bug #55146 Assertion `m_part_spec.start_part == m_part_spec.end_part' in index_read_idx_map
@@ -974,6 +978,7 @@ set global default_storage_engine=default;
--echo # Bug#13737949: CRASH IN HA_PARTITION::INDEX_INIT
--echo # Bug#18694052: SERVER CRASH IN HA_PARTITION::INIT_RECORD_PRIORITY_QUEUE
--echo #
+--disable_view_protocol
CREATE TABLE t1
(a INT,
b INT,
@@ -1007,7 +1012,7 @@ SELECT b FROM t1 WHERE b = 0;
SELECT b FROM t1 WHERE b = 0;
--disconnect con1
DROP TABLE t1;
-
+--enable_view_protocol
--echo #
--echo # MDEV-11167: InnoDB: Warning: using a partial-field key prefix
--echo # in search, results in assertion failure or "Can't find record" error
@@ -1150,3 +1155,4 @@ DROP TABLE t1;
--echo #
--echo # End of 10.3 tests
--echo #
+--enable_service_connection