Debian Codegraph @

mysql-test/suite/secondary_engine/r/system_variables.result

raw
1 #
2 # Test system variables related to secondary engine.
3 #
4 # Test use_secondary_engine system variable.
5 SET @my_use_secondary_engine = @@use_secondary_engine;
6 # Test with an invalid argument.
7 SET @@use_secondary_engine = INVALID;
8 ERROR 42000: Variable 'use_secondary_engine' can't be set to the value of 'INVALID'
9 SELECT @@use_secondary_engine;
10 @@use_secondary_engine
11 ON
12 # Test with integer arguments.
13 SET @@use_secondary_engine = 0;
14 SELECT @@use_secondary_engine;
15 @@use_secondary_engine
16 OFF
17 SET @@use_secondary_engine = 1;
18 SELECT @@use_secondary_engine;
19 @@use_secondary_engine
20 ON
21 SET @@use_secondary_engine = 2;
22 SELECT @@use_secondary_engine;
23 @@use_secondary_engine
24 FORCED
25 SET @@use_secondary_engine = 3;
26 ERROR 42000: Variable 'use_secondary_engine' can't be set to the value of '3'
27 SELECT @@use_secondary_engine;
28 @@use_secondary_engine
29 FORCED
30 SET @@use_secondary_engine = "FORCED";
31 SELECT @@use_secondary_engine;
32 @@use_secondary_engine
33 FORCED
34 SET @@use_secondary_engine = FORCED;
35 SELECT @@use_secondary_engine;
36 @@use_secondary_engine
37 FORCED
38 SET @@use_secondary_engine = "ON";
39 SELECT @@use_secondary_engine;
40 @@use_secondary_engine
41 ON
42 SET @@use_secondary_engine = ON;
43 SELECT @@use_secondary_engine;
44 @@use_secondary_engine
45 ON
46 SET @@use_secondary_engine = "OFF";
47 SELECT @@use_secondary_engine;
48 @@use_secondary_engine
49 OFF
50 SET @@use_secondary_engine = OFF;
51 SELECT @@use_secondary_engine;
52 @@use_secondary_engine
53 OFF
54 SET @@use_secondary_engine = @my_use_secondary_engine;
55 #
56 # Bug#28319475: MAKE USE_SECONDARY_ENGINE SESSION-ONLY AND NONPERSISTENT
57 #
58 SET GLOBAL use_secondary_engine = ON;
59 ERROR HY000: Variable 'use_secondary_engine' is a SESSION variable and can't be used with SET GLOBAL
60 SET PERSIST use_secondary_engine = ON;
61 ERROR HY000: Variable 'use_secondary_engine' is a SESSION variable and can't be used with SET GLOBAL
62 SET PERSIST_ONLY use_secondary_engine = ON;
63 ERROR HY000: Variable 'use_secondary_engine' is a SESSION variable and can't be used with SET GLOBAL