summaryrefslogtreecommitdiff
path: root/mysql-test/suite/federated/federated.test
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2013-06-07 15:35:13 +0200
committerSergei Golubchik <sergii@pisem.net>2013-06-07 15:35:13 +0200
commitd0ce9cb83205e87127ca67522d1dac90d98f323e (patch)
tree495c84267bdfead8b5d9340fe8ccb4dfd2919f89 /mysql-test/suite/federated/federated.test
parent742899e59d4d1c4ec8d32c140fe7ac4b134757e4 (diff)
downloadmariadb-git-d0ce9cb83205e87127ca67522d1dac90d98f323e.tar.gz
MDEV-4468 Assertion `error != 0' fails or timeout occurs on select from a FEDERATED table which points at a non-existent table
Federated uses SHOW TABLE STATUS LIKE for ::info(). For nonexisting remote table it doesn't fail, but returns an empty result set. We need to fake the error in the handler.
Diffstat (limited to 'mysql-test/suite/federated/federated.test')
-rw-r--r--mysql-test/suite/federated/federated.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/suite/federated/federated.test b/mysql-test/suite/federated/federated.test
index 88d20817996..cb14dc2a239 100644
--- a/mysql-test/suite/federated/federated.test
+++ b/mysql-test/suite/federated/federated.test
@@ -8,5 +8,17 @@ connection master;
CREATE TABLE t1 (a INT) ENGINE=FEDERATED CONNECTION='non_existing';
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;