MDEV-3818: Query against view over IS tables worse than equivalent query without view

Fixed the test to be lower-case because it fails on windows with mixed case.

1 files changed, 6 insertions, 6 deletions

diff --git a/mysql-test/t/information_schema.test b/mysql-test/t/information_schema.test
index 9ed61a90be2..b6ee712ec28 100644
--- a/mysql-test/t/information_schema.test
+++ b/mysql-test/t/information_schema.test
@@ -1794,16 +1794,16 @@ disconnect con12828477_3;
 --echo # MDEV-3818: Query against view over IS tables worse than equivalent query without view
 --echo #
 
-CREATE VIEW v1 AS SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS;
+create view v1 as select table_schema, table_name, column_name from information_schema.columns;
 
 explain extended
-SELECT column_name FROM v1
-WHERE (TABLE_SCHEMA = "osm") AND (TABLE_NAME = "test");
+select column_name from v1
+where (table_schema = "osm") and (table_name = "test");
 
 explain extended
-SELECT INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME AS COLUMN_NAME
-FROM INFORMATION_SCHEMA.COLUMNS
-WHERE (information_schema.COLUMNS.TABLE_SCHEMA = 'osm') and (information_schema.COLUMNS.TABLE_NAME = 'test');
+select information_schema.columns.column_name as column_name
+from information_schema.columns
+where (information_schema.columns.table_schema = 'osm') and (information_schema.columns.table_name = 'test');
 
 drop view v1;