From d0ce9cb83205e87127ca67522d1dac90d98f323e Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Fri, 7 Jun 2013 15:35:13 +0200 Subject: 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. --- mysql-test/suite/federated/federated.test | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'mysql-test/suite/federated/federated.test') 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; -- cgit v1.2.1