1# tests case sensitivity behavior as intersection between 2# rocksdb_strict_collation_exceptions and lower_case_table_names=1 3--source include/have_rocksdb.inc 4 5SET @old_rocksdb_strict_collation_exceptions = @@global.rocksdb_strict_collation_exceptions; 6 7CREATE TABLE abc (id INT PRIMARY KEY, value varchar(50), index(value)) engine=rocksdb charset utf8; 8DROP TABLE abc; 9CREATE TABLE ABC (id INT PRIMARY KEY, value varchar(50), index(value)) engine=rocksdb charset utf8; 10DROP TABLE ABC; 11 12SET GLOBAL rocksdb_strict_collation_exceptions="abc"; 13CREATE TABLE abc (id INT PRIMARY KEY, value varchar(50), index(value)) engine=rocksdb charset utf8; 14DROP TABLE abc; 15CREATE TABLE ABC (id INT PRIMARY KEY, value varchar(50), index(value)) engine=rocksdb charset utf8; 16DROP TABLE ABC; 17CREATE TABLE bcd (id INT PRIMARY KEY, value varchar(50), index(value)) engine=rocksdb charset utf8; 18DROP TABLE bcd; 19 20SET GLOBAL rocksdb_strict_collation_exceptions="ABC"; 21CREATE TABLE abc (id INT PRIMARY KEY, value varchar(50), index(value)) engine=rocksdb charset utf8; 22DROP TABLE abc; 23CREATE TABLE ABC (id INT PRIMARY KEY, value varchar(50), index(value)) engine=rocksdb charset utf8; 24DROP TABLE ABC; 25 26SET GLOBAL rocksdb_strict_collation_exceptions="^ABC"; 27CREATE TABLE abcd (id INT PRIMARY KEY, value varchar(50), index(value)) engine=rocksdb charset utf8; 28DROP TABLE abcd; 29CREATE TABLE ABCD (id INT PRIMARY KEY, value varchar(50), index(value)) engine=rocksdb charset utf8; 30DROP TABLE ABCD; 31 32CREATE TABLE ZABC (id INT PRIMARY KEY, value varchar(50), index(value)) engine=rocksdb charset utf8; 33DROP TABLE ZABC; 34 35SET GLOBAL rocksdb_strict_collation_exceptions=@old_rocksdb_strict_collation_exceptions; 36