diff options
Diffstat (limited to 'mysql-test/suite/federated/federated_bug_35333.result')
-rw-r--r-- | mysql-test/suite/federated/federated_bug_35333.result | 36 |
1 files changed, 5 insertions, 31 deletions
diff --git a/mysql-test/suite/federated/federated_bug_35333.result b/mysql-test/suite/federated/federated_bug_35333.result index ca7aa960b73..e1319cfeeae 100644 --- a/mysql-test/suite/federated/federated_bug_35333.result +++ b/mysql-test/suite/federated/federated_bug_35333.result @@ -10,35 +10,10 @@ # error that occurs during a query against I_S.TABLES.de CREATE DATABASE federated; CREATE DATABASE federated; -CREATE DATABASE IF NOT EXISTS realdb; -DROP TABLE IF EXISTS realdb.t0; DROP TABLE IF EXISTS federated.t0; # -# Create the base table to be referenced -# -CREATE TABLE realdb.t0 (a text, b text) ENGINE=MYISAM; -# -# Create a federated table with a bogus port number -# -CREATE TABLE federated.t0 (a text, b text) ENGINE=FEDERATED -CONNECTION='mysql://root@127.0.0.1:63333/realdb/t0'; -# -# Trigger a federated system error during a INFORMATION_SCHEMA.TABLES query -# -SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ENGINE, ROW_FORMAT, TABLE_ROWS, DATA_LENGTH, TABLE_COMMENT -FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'realdb' or TABLE_SCHEMA = 'federated'; -TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE ROW_FORMAT TABLE_ROWS DATA_LENGTH TABLE_COMMENT -federated t0 BASE TABLE FEDERATED NULL 0 Unable to connect to foreign data source: Can't connect to MySQL server on '127.0.0.1' (socket errno) -realdb t0 BASE TABLE MyISAM Dynamic 0 0 -Warnings: -Warning 1429 Unable to connect to foreign data source: Can't connect to MySQL server on '127.0.0.1' (socket errno) -SHOW WARNINGS; -Level Code Message -Warning 1429 Unable to connect to foreign data source: Can't connect to MySQL server on '127.0.0.1' (socket errno) -# # Create a MyISAM table then corrupt the file # -USE realdb; CREATE TABLE t1 (c1 int) ENGINE=MYISAM; # # Corrupt the MyISAM table by deleting the base file @@ -49,19 +24,18 @@ CREATE TABLE t1 (c1 int) ENGINE=MYISAM; SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ENGINE, ROW_FORMAT, TABLE_ROWS, DATA_LENGTH, TABLE_COMMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'; TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE ROW_FORMAT TABLE_ROWS DATA_LENGTH TABLE_COMMENT -realdb t1 BASE TABLE NULL NULL NULL NULL Can't find file: 't1' (errno: 2) +test t1 BASE TABLE NULL NULL NULL NULL Can't find file: 't1' (errno: 2) Warnings: Warning 1017 Can't find file: 't1' (errno: 2) SHOW WARNINGS; Level Code Message Warning 1017 Can't find file: 't1' (errno: 2) +DROP TABLE t1; +ERROR 42S02: Unknown table 't1' # # Cleanup # -DROP TABLE IF EXISTS realdb.t0; -DROP TABLE IF EXISTS federated.t0; -DROP DATABASE realdb; DROP TABLE IF EXISTS federated.t1; -DROP DATABASE federated; +DROP DATABASE IF EXISTS federated; DROP TABLE IF EXISTS federated.t1; -DROP DATABASE federated; +DROP DATABASE IF EXISTS federated; |