Debian Codegraph @

mysql-test/suite/secondary_engine/t/system_variables.test

raw
1 --echo #
2 --echo # Test system variables related to secondary engine.
3 --echo #
4
5 -- echo # Test use_secondary_engine system variable.
6 SET @my_use_secondary_engine = @@use_secondary_engine;
7 --echo # Test with an invalid argument.
8 --error ER_WRONG_VALUE_FOR_VAR
9 SET @@use_secondary_engine = INVALID;
10 SELECT @@use_secondary_engine;
11 --echo # Test with integer arguments.
12 SET @@use_secondary_engine = 0;
13 SELECT @@use_secondary_engine;
14 SET @@use_secondary_engine = 1;
15 SELECT @@use_secondary_engine;
16 SET @@use_secondary_engine = 2;
17 SELECT @@use_secondary_engine;
18 --error ER_WRONG_VALUE_FOR_VAR
19 SET @@use_secondary_engine = 3;
20 SELECT @@use_secondary_engine;
21 SET @@use_secondary_engine = "FORCED";
22 SELECT @@use_secondary_engine;
23 SET @@use_secondary_engine = FORCED;
24 SELECT @@use_secondary_engine;
25 SET @@use_secondary_engine = "ON";
26 SELECT @@use_secondary_engine;
27 SET @@use_secondary_engine = ON;
28 SELECT @@use_secondary_engine;
29 SET @@use_secondary_engine = "OFF";
30 SELECT @@use_secondary_engine;
31 SET @@use_secondary_engine = OFF;
32 SELECT @@use_secondary_engine;
33 SET @@use_secondary_engine = @my_use_secondary_engine;
34
35 --echo #
36 --echo # Bug#28319475: MAKE USE_SECONDARY_ENGINE SESSION-ONLY AND NONPERSISTENT
37 --echo #
38 --error ER_LOCAL_VARIABLE
39 SET GLOBAL use_secondary_engine = ON;
40 --error ER_LOCAL_VARIABLE
41 SET PERSIST use_secondary_engine = ON;
42 --error ER_LOCAL_VARIABLE
43 SET PERSIST_ONLY use_secondary_engine = ON;