summaryrefslogtreecommitdiff
path: root/mysql-test/t/lowercase_table4.test
diff options
context:
space:
mode:
authorVladislav Vaintroub <wlad@montyprogram.com>2013-07-15 13:43:15 +0200
committerVladislav Vaintroub <wlad@montyprogram.com>2013-07-15 13:43:15 +0200
commitb427da7651f348550deb886024c0d3101720f00e (patch)
tree8befa2b2d8533b75b53efee43281d815b6f9646f /mysql-test/t/lowercase_table4.test
parent00653d7f575a42dd824d5cea638c15d4a8c56d95 (diff)
downloadmariadb-git-b427da7651f348550deb886024c0d3101720f00e.tar.gz
Fix main test suite on Windows
Diffstat (limited to 'mysql-test/t/lowercase_table4.test')
-rw-r--r--mysql-test/t/lowercase_table4.test4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/t/lowercase_table4.test b/mysql-test/t/lowercase_table4.test
index 3758ab62214..d13b1a16be1 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;