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