diff options
Diffstat (limited to 'mysql-test/t/lowercase_table4.test')
-rw-r--r-- | mysql-test/t/lowercase_table4.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/t/lowercase_table4.test b/mysql-test/t/lowercase_table4.test index 0775d87fc9d..435ff0dae66 100644 --- a/mysql-test/t/lowercase_table4.test +++ b/mysql-test/t/lowercase_table4.test @@ -72,7 +72,7 @@ CREATE TABLE `Table1`(c1 INT PRIMARY KEY) ENGINE=InnoDB; CREATE TABLE `Table2`(c1 INT PRIMARY KEY, c2 INT) ENGINE=InnoDB; ALTER TABLE `Table2` ADD CONSTRAINT fk1 FOREIGN KEY(c2) REFERENCES `Table1`(c1); query_vertical SHOW CREATE TABLE `Table2`; -query_vertical SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS; +query_vertical SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='test'; DROP TABLE `Table2`; DROP TABLE `Table1`; @@ -101,7 +101,7 @@ CREATE TABLE Product_Order (No INT NOT NULL AUTO_INCREMENT, query_vertical SHOW CREATE TABLE Product_Order; query_vertical SHOW CREATE TABLE Product; query_vertical SHOW CREATE TABLE Customer; -query_vertical SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS; +query_vertical SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='test'; DROP TABLE Product_Order; DROP TABLE Product; DROP TABLE Customer; |