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
7--error ER_UNKNOWN_ERROR
8CREATE TABLE abc (id INT PRIMARY KEY, value varchar(50), index(value)) engine=rocksdb charset utf8;
9--error ER_UNKNOWN_ERROR
10CREATE TABLE ABC (id INT PRIMARY KEY, value varchar(50), index(value)) engine=rocksdb charset utf8;
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;
17--error ER_UNKNOWN_ERROR
18CREATE TABLE bcd (id INT PRIMARY KEY, value varchar(50), index(value)) engine=rocksdb charset utf8;
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
32--error ER_UNKNOWN_ERROR
33CREATE TABLE ZABC (id INT PRIMARY KEY, value varchar(50), index(value)) engine=rocksdb charset utf8;
34
35SET GLOBAL rocksdb_strict_collation_exceptions=@old_rocksdb_strict_collation_exceptions;
36