blob: 4eb96488840752747b92f4d209db7ba7e7059e13 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
--source include/have_rocksdb.inc
# We cannot use the rocskdb_sys_var.inc script as some of the strings we set
# need to be quoted and that doesn't work with this script. Run through
# valid options by hand.
SET @start_global_value = @@global.ROCKSDB_STRICT_COLLATION_EXCEPTIONS;
SELECT @start_global_value;
--echo "Trying to set @session.ROCKSDB_STRICT_COLLATION_EXCEPTIONS to simple table name."
SET @@global.ROCKSDB_STRICT_COLLATION_EXCEPTIONS = mytable;
SELECT @@global.ROCKSDB_STRICT_COLLATION_EXCEPTIONS;
--echo "Trying to set @session.ROCKSDB_STRICT_COLLATION_EXCEPTIONS to regex table name(s)."
SET @@global.ROCKSDB_STRICT_COLLATION_EXCEPTIONS = "t.*";
SELECT @@global.ROCKSDB_STRICT_COLLATION_EXCEPTIONS;
--echo "Trying to set @session.ROCKSDB_STRICT_COLLATION_EXCEPTIONS to multiple regex table names."
SET @@global.ROCKSDB_STRICT_COLLATION_EXCEPTIONS = "s.*,t.*";
SELECT @@global.ROCKSDB_STRICT_COLLATION_EXCEPTIONS;
--echo "Trying to set @session.ROCKSDB_STRICT_COLLATION_EXCEPTIONS to empty."
SET @@global.ROCKSDB_STRICT_COLLATION_EXCEPTIONS = "";
SELECT @@global.ROCKSDB_STRICT_COLLATION_EXCEPTIONS;
--echo "Trying to set @session.ROCKSDB_STRICT_COLLATION_EXCEPTIONS to default."
SET @@global.ROCKSDB_STRICT_COLLATION_EXCEPTIONS = DEFAULT;
SELECT @@global.ROCKSDB_STRICT_COLLATION_EXCEPTIONS;
--echo "Trying to set @session.ROCKSDB_STRICT_COLLATION_EXCEPTIONS to 444. It should fail because it is not session."
--Error ER_GLOBAL_VARIABLE
SET @@session.ROCKSDB_STRICT_COLLATION_EXCEPTIONS = 444;
SET @@global.ROCKSDB_STRICT_COLLATION_EXCEPTIONS = @start_global_value;
SELECT @@global.ROCKSDB_STRICT_COLLATION_EXCEPTIONS;
|
