mariadb/mysql-test/suite/period/r/i_s_notembedded,win.rdiff
Nikita Malyavin 5c2f8c017c MDEV-32503 Queries from I_S.KEY_PERIOD_USAGE do not obey case-sensitivity
Set the correct values for idx_field1, idx_field2 (i.e. db and table name
fields) of ST_SCHEMA_TABLE instance.
2024-02-12 22:26:06 +01:00

20 lines
847 B
Text

--- suite/period/r/i_s_notembedded.result 2024-01-01 19:50:37.000000000 +0100
+++ suite/period/r/i_s_notembedded,win.reject 2024-01-01 19:57:18.888306500 +0100
@@ -69,13 +69,17 @@
set names latin1 collate latin1_general_cs;
select table_name from information_schema.periods where table_schema = 'TEST';
table_name
+t
select table_name from information_schema.key_period_usage where table_schema = 'TEST';
table_name
+t
set names latin1 collate latin1_general_ci;
select table_name from information_schema.periods where table_schema = 'TEST';
table_name
+t
select table_name from information_schema.key_period_usage where table_schema = 'TEST';
table_name
+t
# [DUPLICATE] MDEV-32504 Search by I_S.KEY_PERIOD_USAGE.CONSTRAINT_NAME
# does not work
select constraint_name from information_schema.key_period_usage where table_name = 't';