summaryrefslogtreecommitdiff
path: root/mysql-test/suite/federated/federated_bug_35333.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/federated/federated_bug_35333.test')
-rw-r--r--mysql-test/suite/federated/federated_bug_35333.test23
1 files changed, 13 insertions, 10 deletions
diff --git a/mysql-test/suite/federated/federated_bug_35333.test b/mysql-test/suite/federated/federated_bug_35333.test
index 58c217d24f2..8bce63c34e5 100644
--- a/mysql-test/suite/federated/federated_bug_35333.test
+++ b/mysql-test/suite/federated/federated_bug_35333.test
@@ -12,12 +12,13 @@
--source federated.inc
--disable_warnings
-CREATE DATABASE IF NOT EXISTS realdb;
# Federated database exists
-DROP TABLE IF EXISTS realdb.t0;
DROP TABLE IF EXISTS federated.t0;
--enable_warnings
+--disable_parsing
+# This test doesn't work with federatedx, as it doesn't allow wrong connections
+
--echo #
--echo # Create the base table to be referenced
--echo #
@@ -42,18 +43,20 @@ SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ENGINE, ROW_FORMAT, TABLE_ROWS, DAT
# Remove O/S-specific socket error
--replace_regex /\(.*\)/(socket errno)/
SHOW WARNINGS;
+DROP TABLE federated.t0;
+
+--enable_parsing
--echo #
--echo # Create a MyISAM table then corrupt the file
--echo #
-USE realdb;
CREATE TABLE t1 (c1 int) ENGINE=MYISAM;
--echo #
--echo # Corrupt the MyISAM table by deleting the base file
--echo #
let $MYSQLD_DATADIR= `SELECT @@datadir`;
---remove_file $MYSQLD_DATADIR/realdb/t1.MYD
---remove_file $MYSQLD_DATADIR/realdb/t1.MYI
+--remove_file $MYSQLD_DATADIR/test/t1.MYD
+--remove_file $MYSQLD_DATADIR/test/t1.MYI
--echo #
--echo # Trigger a MyISAM system error during an INFORMATION_SCHEMA.TABLES query
@@ -62,13 +65,13 @@ SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ENGINE, ROW_FORMAT, TABLE_ROWS, DAT
FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
SHOW WARNINGS;
+--disable_warnings
+--error 1051
+DROP TABLE t1;
+--enable_warnings
+
--echo #
--echo # Cleanup
--echo #
---disable_warnings
-DROP TABLE IF EXISTS realdb.t0;
-DROP TABLE IF EXISTS federated.t0;
-DROP DATABASE realdb;
---enable_warnings
--source federated_cleanup.inc