diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 18:00:34 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 18:00:34 +0000 |
commit | 3f619478f796eddbba6e39502fe941b285dd97b1 (patch) | |
tree | e2c7b5777f728320e5b5542b6213fd3591ba51e2 /mysql-test/suite/s3/alter2.test | |
parent | Initial commit. (diff) | |
download | mariadb-upstream.tar.xz mariadb-upstream.zip |
Adding upstream version 1:10.11.6.upstream/1%10.11.6upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to '')
-rw-r--r-- | mysql-test/suite/s3/alter2.test | 64 |
1 files changed, 64 insertions, 0 deletions
diff --git a/mysql-test/suite/s3/alter2.test b/mysql-test/suite/s3/alter2.test new file mode 100644 index 00000000..856b1415 --- /dev/null +++ b/mysql-test/suite/s3/alter2.test @@ -0,0 +1,64 @@ +--source include/have_s3.inc +--source include/have_partition.inc +--source create_database.inc + +--echo # +--echo # MDEV-19575 Assertion `page_st == 1' failed upon SELECT from S3 +--echo # table which is being converted into Aria +--echo # + +CREATE TABLE t1 (f INT); +insert into t1 values (1),(2); + +ALTER TABLE t1 ENGINE=S3; +select * from t1; +--connect (con1,localhost,root,,$database) +--send + ALTER TABLE t1 ENGINE=Aria; + +--connection default +SELECT * FROM t1; + +# Cleanup + +--connection con1 +--reap +--disconnect con1 +--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,,$database) +--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 +# +--source drop_database.inc |