summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/federated/federated.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/federated/federated.test')
-rw-r--r--mysql-test/suite/federated/federated.test25
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;
+