diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2018-02-15 13:31:22 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2018-02-23 15:33:21 +0100 |
| commit | 221d010f3e5429e667725e57c9f025939eef8ed1 (patch) | |
| tree | e5c850629a81d2c121cd6539dd7c8b1d344ba114 /mysql-test/suite/federated | |
| parent | 5f6b3f9c07241a7f539dbe7c51bf3a9cd8800f26 (diff) | |
| download | mariadb-git-221d010f3e5429e667725e57c9f025939eef8ed1.tar.gz | |
MDEV-14789 Creating federated table on versioned table fails
don't allow to discover WITH SYSTEM VERSIONING clause
originally by: Aleksey Midenkov
Diffstat (limited to 'mysql-test/suite/federated')
| -rw-r--r-- | mysql-test/suite/federated/assisted_discovery.result | 8 | ||||
| -rw-r--r-- | mysql-test/suite/federated/assisted_discovery.test | 9 |
2 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/suite/federated/assisted_discovery.result b/mysql-test/suite/federated/assisted_discovery.result index 4818ff7bb02..d44f69effcd 100644 --- a/mysql-test/suite/federated/assisted_discovery.result +++ b/mysql-test/suite/federated/assisted_discovery.result @@ -72,6 +72,14 @@ t1 CREATE TABLE `t1` ( drop table t1; connection slave; drop table t1; +create or replace table t1 (x int) with system versioning; +connection master; +create table t1 engine=federated connection='mysql://root@127.0.0.1:SLAVE_MYPORT/test/t1'; +ERROR HY000: Engine FEDERATED failed to discover table `test`.`t1` with 'CREATE TABLE `t1` ( + `x` int(11) DEFAULT NULL +) WITH SYSTEM VERSIONING CONNECTION='mysql://root@127.0.0.1:SLAVE_MYPORT/test/t1'' +connection slave; +drop table t1; connection master; DROP TABLE IF EXISTS federated.t1; DROP DATABASE IF EXISTS federated; diff --git a/mysql-test/suite/federated/assisted_discovery.test b/mysql-test/suite/federated/assisted_discovery.test index fa83a2a8e19..7099cfedb23 100644 --- a/mysql-test/suite/federated/assisted_discovery.test +++ b/mysql-test/suite/federated/assisted_discovery.test @@ -54,5 +54,14 @@ drop table t1; connection slave; drop table t1; +create or replace table t1 (x int) with system versioning; +connection master; +--replace_result $SLAVE_MYPORT SLAVE_MYPORT +--error ER_SQL_DISCOVER_ERROR +eval create table t1 engine=federated connection='mysql://root@127.0.0.1:$SLAVE_MYPORT/test/t1'; + +connection slave; +drop table t1; + source include/federated_cleanup.inc; |