summaryrefslogtreecommitdiff
path: root/mysql-test/main/partition_innodb.test
diff options
context:
space:
mode:
authorLena Startseva <lena.startseva@mariadb.com>2022-06-09 10:32:51 +0700
committerLena Startseva <lena.startseva@mariadb.com>2022-09-12 16:01:18 +0700
commit8aa98565a5d4e6b69d3f19833c02ed176fe38c1c (patch)
tree2c53d43ebe3bcb356319f00561441e80ab57769b /mysql-test/main/partition_innodb.test
parent99d5306350dc492ad843e806ca8a9d46f5a709d2 (diff)
downloadmariadb-git-bb-10.3-MDEV-27691.tar.gz
MDEV-27691: make working view-protocolbb-10.3-MDEV-27691
Tests with checking metadata or that cannot be run with the view-protocol are excluded from --view-protocol. For tests that do not allow the use of an additional connection, the util connection is disabled with "--disable_service_connection". Also cases with bugs for --view-protocol are disabled.
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 6a89a0a6467..5bdc24b7cdd 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';
@@ -84,7 +85,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;
@@ -136,11 +137,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,
@@ -179,7 +181,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)
@@ -578,6 +580,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,
@@ -612,6 +615,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
@@ -943,6 +947,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,
@@ -976,7 +981,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
@@ -1116,3 +1121,4 @@ DROP TABLE t1;
--echo #
--echo # End of 10.3 tests
--echo #
+--enable_service_connection