Debian Codegraph @

mysql-test/suite/sys_vars/t/slave_rows_search_algorithms_basic.test

raw
1
2 set @saved_slave_rows_search_algorithms = @@global.slave_rows_search_algorithms;
3
4
5 SELECT @@global.slave_rows_search_algorithms;
6
7 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS=DEFAULT;
8 SELECT @@global.slave_rows_search_algorithms;
9
10 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='TABLE_SCAN';
11 SELECT @@global.slave_rows_search_algorithms;
12
13 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='HASH_SCAN';
14 SELECT @@global.slave_rows_search_algorithms;
15
16 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='INDEX_SCAN';
17 SELECT @@global.slave_rows_search_algorithms;
18
19 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='TABLE_SCAN,HASH_SCAN';
20 SELECT @@global.slave_rows_search_algorithms;
21
22 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='TABLE_SCAN,HASH_SCAN,INDEX_SCAN';
23 SELECT @@global.slave_rows_search_algorithms;
24
25 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='TABLE_SCAN,INDEX_SCAN';
26 SELECT @@global.slave_rows_search_algorithms;
27
28 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='HASH_SCAN,INDEX_SCAN';
29 SELECT @@global.slave_rows_search_algorithms;
30
31
32 # checking that setting variable to a non existing value raises error
33 --error ER_WRONG_VALUE_FOR_VAR
34 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='TABLE_5CAN';
35 SELECT @@global.slave_rows_search_algorithms;
36
37 --error ER_WRONG_VALUE_FOR_VAR
38 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='';
39 SELECT @@global.slave_rows_search_algorithms;
40
41 --error ER_WRONG_VALUE_FOR_VAR
42 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='1';
43 SELECT @@global.slave_rows_search_algorithms;
44
45 --error ER_WRONG_VALUE_FOR_VAR
46 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS=NULL;
47 SELECT @@global.slave_rows_search_algorithms;
48
49 set global slave_rows_search_algorithms = @saved_slave_rows_search_algorithms;
50 SELECT @@global.slave_rows_search_algorithms;