summaryrefslogtreecommitdiff
path: root/mysql-test/r/lowercase_table4.result
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/r/lowercase_table4.result
parent00653d7f575a42dd824d5cea638c15d4a8c56d95 (diff)
downloadmariadb-git-b427da7651f348550deb886024c0d3101720f00e.tar.gz
Fix main test suite on Windows
Diffstat (limited to 'mysql-test/r/lowercase_table4.result')
-rw-r--r--mysql-test/r/lowercase_table4.result26
1 files changed, 2 insertions, 24 deletions
diff --git a/mysql-test/r/lowercase_table4.result b/mysql-test/r/lowercase_table4.result
index aa81eff5194..02e2012a186 100644
--- a/mysql-test/r/lowercase_table4.result
+++ b/mysql-test/r/lowercase_table4.result
@@ -28,18 +28,7 @@ Create Table CREATE TABLE `Table2` (
KEY `fk1` (`c2`),
CONSTRAINT `fk1` FOREIGN KEY (`c2`) REFERENCES `Table1` (`c1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
-SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS;
-CONSTRAINT_CATALOG def
-CONSTRAINT_SCHEMA mysql
-CONSTRAINT_NAME innodb_index_stats_ibfk_1
-UNIQUE_CONSTRAINT_CATALOG def
-UNIQUE_CONSTRAINT_SCHEMA mysql
-UNIQUE_CONSTRAINT_NAME PRIMARY
-MATCH_OPTION NONE
-UPDATE_RULE RESTRICT
-DELETE_RULE RESTRICT
-TABLE_NAME innodb_index_stats
-REFERENCED_TABLE_NAME innodb_table_stats
+SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='test';
CONSTRAINT_CATALOG def
CONSTRAINT_SCHEMA test
CONSTRAINT_NAME fk1
@@ -98,18 +87,7 @@ Create Table CREATE TABLE `Customer` (
`Id` int(11) NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
-SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS;
-CONSTRAINT_CATALOG def
-CONSTRAINT_SCHEMA mysql
-CONSTRAINT_NAME innodb_index_stats_ibfk_1
-UNIQUE_CONSTRAINT_CATALOG def
-UNIQUE_CONSTRAINT_SCHEMA mysql
-UNIQUE_CONSTRAINT_NAME PRIMARY
-MATCH_OPTION NONE
-UPDATE_RULE RESTRICT
-DELETE_RULE RESTRICT
-TABLE_NAME innodb_index_stats
-REFERENCED_TABLE_NAME innodb_table_stats
+SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='test';
CONSTRAINT_CATALOG def
CONSTRAINT_SCHEMA test
CONSTRAINT_NAME product_order_ibfk_1