Debian Codegraph @

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

raw
1 SET @start_value = @@session.secondary_engine_cost_threshold;
2 SELECT @start_value;
3 @start_value
4 100000
5 SET @start_value_global = @@global.secondary_engine_cost_threshold;
6 SELECT @start_value_global;
7 @start_value_global
8 100000
9 SET @@session.secondary_engine_cost_threshold = 8734635;
10 SET @@session.secondary_engine_cost_threshold = DEFAULT;
11 SELECT @@session.secondary_engine_cost_threshold;
12 @@session.secondary_engine_cost_threshold
13 100000.000000
14 SET @@session.secondary_engine_cost_threshold = 0;
15 SELECT @@session.secondary_engine_cost_threshold;
16 @@session.secondary_engine_cost_threshold
17 0.000000
18 SET @@session.secondary_engine_cost_threshold = 99;
19 SELECT @@session.secondary_engine_cost_threshold;
20 @@session.secondary_engine_cost_threshold
21 99.000000
22 SET @@session.secondary_engine_cost_threshold = 10;
23 SELECT @@session.secondary_engine_cost_threshold;
24 @@session.secondary_engine_cost_threshold
25 10.000000
26 SET @@session.secondary_engine_cost_threshold = 10000.01;
27 SELECT @@session.secondary_engine_cost_threshold;
28 @@session.secondary_engine_cost_threshold
29 10000.010000
30 SET @@session.secondary_engine_cost_threshold = 21;
31 SELECT @@session.secondary_engine_cost_threshold;
32 @@session.secondary_engine_cost_threshold
33 21.000000
34 SET @@session.secondary_engine_cost_threshold = -1;
35 Warnings:
36 Warning 1292 Truncated incorrect secondary_engine_cost_threshold value: '-1'
37 SELECT @@session.secondary_engine_cost_threshold;
38 @@session.secondary_engine_cost_threshold
39 0.000000
40 SET @@session.secondary_engine_cost_threshold = -1024;
41 Warnings:
42 Warning 1292 Truncated incorrect secondary_engine_cost_threshold value: '-1024'
43 SELECT @@session.secondary_engine_cost_threshold;
44 @@session.secondary_engine_cost_threshold
45 0.000000
46 SET @@session.secondary_engine_cost_threshold = 42949672950;
47 SELECT @@session.secondary_engine_cost_threshold;
48 @@session.secondary_engine_cost_threshold
49 42949672950.000000
50 SET @@session.secondary_engine_cost_threshold = ON;
51 ERROR 42000: Incorrect argument type to variable 'secondary_engine_cost_threshold'
52 SELECT @@session.secondary_engine_cost_threshold;
53 @@session.secondary_engine_cost_threshold
54 42949672950.000000
55 SET @@session.secondary_engine_cost_threshold = 'test';
56 ERROR 42000: Incorrect argument type to variable 'secondary_engine_cost_threshold'
57 SELECT @@session.secondary_engine_cost_threshold;
58 @@session.secondary_engine_cost_threshold
59 42949672950.000000
60 SELECT @@global.secondary_engine_cost_threshold,@@session.secondary_engine_cost_threshold;
61 @@global.secondary_engine_cost_threshold @@session.secondary_engine_cost_threshold
62 100000.000000 42949672950.000000
63 SET @@global.secondary_engine_cost_threshold = 0;
64 SELECT @@global.secondary_engine_cost_threshold,@@session.secondary_engine_cost_threshold;
65 @@global.secondary_engine_cost_threshold @@session.secondary_engine_cost_threshold
66 0.000000 42949672950.000000
67 SELECT @@session.secondary_engine_cost_threshold = VARIABLE_VALUE
68 FROM performance_schema.session_variables
69 WHERE VARIABLE_NAME='secondary_engine_cost_threshold';
70 @@session.secondary_engine_cost_threshold = VARIABLE_VALUE
71 1
72 SELECT @@global.secondary_engine_cost_threshold = VARIABLE_VALUE
73 FROM performance_schema.global_variables
74 WHERE VARIABLE_NAME='secondary_engine_cost_threshold';
75 @@global.secondary_engine_cost_threshold = VARIABLE_VALUE
76 1
77 SET @@session.secondary_engine_cost_threshold = TRUE;
78 SELECT @@session.secondary_engine_cost_threshold;
79 @@session.secondary_engine_cost_threshold
80 1.000000
81 SET @@session.secondary_engine_cost_threshold = FALSE;
82 SELECT @@session.secondary_engine_cost_threshold;
83 @@session.secondary_engine_cost_threshold
84 0.000000
85 SET @@session.secondary_engine_cost_threshold = 1;
86 SELECT @@secondary_engine_cost_threshold = @@session.secondary_engine_cost_threshold;
87 @@secondary_engine_cost_threshold = @@session.secondary_engine_cost_threshold
88 1
89 SET local.secondary_engine_cost_threshold = 1;
90 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.secondary_engine_cost_threshold = 1' at line 1
91 SELECT local.secondary_engine_cost_threshold;
92 ERROR 42S02: Unknown table 'local' in field list
93 SET session.secondary_engine_cost_threshold = 1;
94 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'session.secondary_engine_cost_threshold = 1' at line 1
95 SELECT session.secondary_engine_cost_threshold;
96 ERROR 42S02: Unknown table 'session' in field list
97 SELECT secondary_engine_cost_threshold;
98 ERROR 42S22: Unknown column 'secondary_engine_cost_threshold' in 'field list'
99 SET @@session.secondary_engine_cost_threshold = @start_value;
100 SET @@global.secondary_engine_cost_threshold = @start_value_global;
101 SELECT @@session.secondary_engine_cost_threshold,@@global.secondary_engine_cost_threshold;
102 @@session.secondary_engine_cost_threshold @@global.secondary_engine_cost_threshold
103 100000.000000 100000.000000