diff options
author | Oleksandr Byelkin <sanja@mariadb.com> | 2022-10-17 08:43:55 +0200 |
---|---|---|
committer | Oleksandr Byelkin <sanja@mariadb.com> | 2022-10-17 08:43:55 +0200 |
commit | 851b31bcc47b742cd3b39ad06176b0e8be591c18 (patch) | |
tree | 93da42af4bd22fc448df71777bedb0a4690478ba /mysql-test/main/partition_symlink.test | |
parent | 618d82064618bda06bcd080af5b664b3d173dbe3 (diff) | |
parent | a4234f0410008e14aa2ad7ad56973127f3046d5c (diff) | |
download | mariadb-git-851b31bcc47b742cd3b39ad06176b0e8be591c18.tar.gz |
Merge branch 'bb-10.8-vp-MDEV-27691' into 10.8
Diffstat (limited to 'mysql-test/main/partition_symlink.test')
-rw-r--r-- | mysql-test/main/partition_symlink.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/main/partition_symlink.test b/mysql-test/main/partition_symlink.test index 7e09c7d0642..07d653ee4d6 100644 --- a/mysql-test/main/partition_symlink.test +++ b/mysql-test/main/partition_symlink.test @@ -1,5 +1,6 @@ # Test that must have symlink. eg. using DATA/INDEX DIR # (DATA/INDEX DIR requires symlinks) + # This test is only useful for MyISAM, since no other engine supports DATA DIR -- source include/have_partition.inc -- source include/have_symlink.inc @@ -15,6 +16,7 @@ DROP DATABASE IF EXISTS mysqltest2; --echo # --echo # Test for WL#4445: EXCHANGE PARTITION --echo # +--disable_service_connection --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR eval CREATE TABLE t1 (a INT) ENGINE = MyISAM @@ -44,6 +46,7 @@ ALTER TABLE t1 EXCHANGE PARTITION p2 WITH TABLE t2; SELECT * FROM t1; SELECT * FROM t2; DROP TABLE t1, t2; +--enable_service_connection # skipped because of bug#52354 #CREATE TABLE t1 LIKE t2; #ALTER TABLE t1 PARTITION BY LIST (a) @@ -72,6 +75,7 @@ DROP TABLE t1, t2; -- echo # Creating two non colliding tables mysqltest2.t1 and test.t1 -- echo # test.t1 have partitions in mysqltest2-directory! -- echo # user root: +--disable_service_connection CREATE USER mysqltest_1@localhost; CREATE DATABASE mysqltest2; USE mysqltest2; @@ -110,6 +114,7 @@ connection default; SELECT * FROM t1; DROP TABLE t1; DROP DATABASE mysqltest2; + --enable_service_connection # The below test shows that a pre-existing partition can not be # destroyed by a new partition from another table. # (Remember that a table or partition that uses the DATA/INDEX DIR |