diff options
Diffstat (limited to 'mysql-test/suite/s3/alter2.test')
| -rw-r--r-- | mysql-test/suite/s3/alter2.test | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/mysql-test/suite/s3/alter2.test b/mysql-test/suite/s3/alter2.test index de2bc001298..0be82f5a7ff 100644 --- a/mysql-test/suite/s3/alter2.test +++ b/mysql-test/suite/s3/alter2.test @@ -1,4 +1,5 @@ --source include/have_s3.inc +--source include/have_partition.inc --source create_database.inc --echo # @@ -26,6 +27,38 @@ SELECT * FROM t1; --connection default DROP TABLE t1; +--echo # +--echo # MDEV-20302 Server hangs upon concurrent SELECT from partitioned S3 +--echo # table +--echo # + +CREATE TABLE t1 ( + pk INT AUTO_INCREMENT, + c CHAR(12), + PRIMARY KEY(pk), + KEY(c) +) ENGINE=Aria + PARTITION BY KEY(pk) PARTITIONS 2; + +CREATE VIEW v1 AS SELECT * FROM t1; +INSERT INTO t1 VALUES (NULL,'ill'),(NULL,'loop'); +ALTER TABLE t1 ENGINE=S3; + +--connect (con1,localhost,root,,test) +--send + SELECT * FROM t1 WHERE c BETWEEN 'bar' AND 'foo'; + +--connection default +SELECT pk FROM v1; + +--connection con1 +--reap + +--disconnect con1 +--connection default +DROP VIEW v1; +DROP TABLE t1; + # # clean up # |