diff options
Diffstat (limited to 'mysql-test/suite/federated/federated.test')
-rw-r--r-- | mysql-test/suite/federated/federated.test | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/suite/federated/federated.test b/mysql-test/suite/federated/federated.test new file mode 100644 index 00000000..0cb0551d --- /dev/null +++ b/mysql-test/suite/federated/federated.test @@ -0,0 +1,25 @@ +source include/federated.inc; + +connection master; +# +# MDEV-388 Creating a federated table with a non-existing server returns a random error code +# +--error 1 +CREATE TABLE t1 (a INT) ENGINE=FEDERATED CONNECTION='non_existing'; +--replace_result "Not owner" "Operation not permitted" +SHOW WARNINGS; + +# +# MDEV-4468 Assertion `error != 0' fails or timeout occurs on select from a FEDERATED table which points at a non-existent table +# + +create table t1 (a int); +--replace_result $MASTER_MYPORT MASTER_PORT +eval create table fed (a int) engine=Federated CONNECTION='mysql://root@127.0.0.1:$MASTER_MYPORT/test/t1'; +drop table t1; +--error 1146,1431 +select * from fed; +drop table fed; + +source include/federated_cleanup.inc; + |