Debian Codegraph @

mysql-test/suite/sys_vars/r/slave_rows_search_algorithms_basic.result

raw
1 set @saved_slave_rows_search_algorithms = @@global.slave_rows_search_algorithms;
2 Warnings:
3 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
4 SELECT @@global.slave_rows_search_algorithms;
5 @@global.slave_rows_search_algorithms
6 INDEX_SCAN,HASH_SCAN
7 Warnings:
8 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
9 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS=DEFAULT;
10 Warnings:
11 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
12 SELECT @@global.slave_rows_search_algorithms;
13 @@global.slave_rows_search_algorithms
14 INDEX_SCAN,HASH_SCAN
15 Warnings:
16 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
17 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='TABLE_SCAN';
18 Warnings:
19 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
20 SELECT @@global.slave_rows_search_algorithms;
21 @@global.slave_rows_search_algorithms
22 TABLE_SCAN
23 Warnings:
24 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
25 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='HASH_SCAN';
26 Warnings:
27 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
28 SELECT @@global.slave_rows_search_algorithms;
29 @@global.slave_rows_search_algorithms
30 HASH_SCAN
31 Warnings:
32 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
33 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='INDEX_SCAN';
34 Warnings:
35 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
36 SELECT @@global.slave_rows_search_algorithms;
37 @@global.slave_rows_search_algorithms
38 INDEX_SCAN
39 Warnings:
40 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
41 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='TABLE_SCAN,HASH_SCAN';
42 Warnings:
43 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
44 SELECT @@global.slave_rows_search_algorithms;
45 @@global.slave_rows_search_algorithms
46 TABLE_SCAN,HASH_SCAN
47 Warnings:
48 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
49 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='TABLE_SCAN,HASH_SCAN,INDEX_SCAN';
50 Warnings:
51 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
52 SELECT @@global.slave_rows_search_algorithms;
53 @@global.slave_rows_search_algorithms
54 TABLE_SCAN,INDEX_SCAN,HASH_SCAN
55 Warnings:
56 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
57 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='TABLE_SCAN,INDEX_SCAN';
58 Warnings:
59 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
60 SELECT @@global.slave_rows_search_algorithms;
61 @@global.slave_rows_search_algorithms
62 TABLE_SCAN,INDEX_SCAN
63 Warnings:
64 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
65 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='HASH_SCAN,INDEX_SCAN';
66 Warnings:
67 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
68 SELECT @@global.slave_rows_search_algorithms;
69 @@global.slave_rows_search_algorithms
70 INDEX_SCAN,HASH_SCAN
71 Warnings:
72 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
73 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='TABLE_5CAN';
74 ERROR 42000: Variable 'slave_rows_search_algorithms' can't be set to the value of 'TABLE_5CAN'
75 SELECT @@global.slave_rows_search_algorithms;
76 @@global.slave_rows_search_algorithms
77 INDEX_SCAN,HASH_SCAN
78 Warnings:
79 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
80 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='';
81 ERROR 42000: Variable 'slave_rows_search_algorithms' can't be set to the value of ''
82 SELECT @@global.slave_rows_search_algorithms;
83 @@global.slave_rows_search_algorithms
84 INDEX_SCAN,HASH_SCAN
85 Warnings:
86 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
87 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='1';
88 ERROR 42000: Variable 'slave_rows_search_algorithms' can't be set to the value of '1'
89 SELECT @@global.slave_rows_search_algorithms;
90 @@global.slave_rows_search_algorithms
91 INDEX_SCAN,HASH_SCAN
92 Warnings:
93 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
94 SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS=NULL;
95 ERROR 42000: Variable 'slave_rows_search_algorithms' can't be set to the value of 'NULL'
96 SELECT @@global.slave_rows_search_algorithms;
97 @@global.slave_rows_search_algorithms
98 INDEX_SCAN,HASH_SCAN
99 Warnings:
100 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
101 set global slave_rows_search_algorithms = @saved_slave_rows_search_algorithms;
102 Warnings:
103 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
104 SELECT @@global.slave_rows_search_algorithms;
105 @@global.slave_rows_search_algorithms
106 INDEX_SCAN,HASH_SCAN
107 Warnings:
108 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.