diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2022-06-02 16:51:13 +0300 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2022-06-02 16:51:13 +0300 |
commit | 4b3c3e526e7067da921d0aef8451b6e2736a5fe0 (patch) | |
tree | 40a6d851d7c39c443c587e29a725afda85c65929 /mysql-test/main/partition_error.result | |
parent | e7de50a82187cbaaa192c2065d64c0041cd9a6a1 (diff) | |
parent | 96f4b4a55b449a29af7e4b70bebf0ff238ae7f80 (diff) | |
download | mariadb-git-4b3c3e526e7067da921d0aef8451b6e2736a5fe0.tar.gz |
Merge 10.4 into 10.5
Diffstat (limited to 'mysql-test/main/partition_error.result')
-rw-r--r-- | mysql-test/main/partition_error.result | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/mysql-test/main/partition_error.result b/mysql-test/main/partition_error.result index 25c29938f91..b6cd903ccca 100644 --- a/mysql-test/main/partition_error.result +++ b/mysql-test/main/partition_error.result @@ -6,7 +6,18 @@ drop table if exists t1, t2; CREATE TABLE t1 (a int); CREATE OR REPLACE VIEW v1 AS SELECT * FROM t1; ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE v1; -ERROR 42000: Can't open table +ERROR HY000: 'test.v1' is not of type 'BASE TABLE' +DROP VIEW v1; +DROP TABLE t1; +# +# MDEV-28599 EXCHANGE PARTITION on view causes ER_CHECK_NO_SUCH_TABLE instead of ER_WRONG_OBJECT +# +CREATE TABLE t1 (a int) +PARTITION BY HASH (a) +PARTITIONS 2; +CREATE OR REPLACE VIEW v1 AS SELECT * FROM t1; +ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE v1; +ERROR HY000: 'test.v1' is not of type 'BASE TABLE' DROP VIEW v1; DROP TABLE t1; # |