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