Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.optimizer_use_condition_selectivity;
2 SET @start_session_value = @@session.optimizer_use_condition_selectivity;
3 '#--------------------FN_DYNVARS_115_03-------------------------#'
4 SET @@global.optimizer_use_condition_selectivity = 0;
5 Warnings:
6 Warning 1292 Truncated incorrect optimizer_use_condition_selec... value: '0'
7 SELECT @@global.optimizer_use_condition_selectivity;
8 @@global.optimizer_use_condition_selectivity
9 1
10 SET @@global.optimizer_use_condition_selectivity = 1;
11 SELECT @@global.optimizer_use_condition_selectivity;
12 @@global.optimizer_use_condition_selectivity
13 1
14 SET @@global.optimizer_use_condition_selectivity = 2;
15 SELECT @@global.optimizer_use_condition_selectivity;
16 @@global.optimizer_use_condition_selectivity
17 2
18 SET @@global.optimizer_use_condition_selectivity = 3;
19 SELECT @@global.optimizer_use_condition_selectivity;
20 @@global.optimizer_use_condition_selectivity
21 3
22 SET @@global.optimizer_use_condition_selectivity = 4;
23 SELECT @@global.optimizer_use_condition_selectivity;
24 @@global.optimizer_use_condition_selectivity
25 4
26 SET @@global.optimizer_use_condition_selectivity = 5;
27 SELECT @@global.optimizer_use_condition_selectivity;
28 @@global.optimizer_use_condition_selectivity
29 5
30 SET @@global.optimizer_use_condition_selectivity = 6;
31 Warnings:
32 Warning 1292 Truncated incorrect optimizer_use_condition_selec... value: '6'
33 SELECT @@global.optimizer_use_condition_selectivity;
34 @@global.optimizer_use_condition_selectivity
35 5
36 '#--------------------FN_DYNVARS_115_04-------------------------#'
37 SET @@session.optimizer_use_condition_selectivity = 0;
38 Warnings:
39 Warning 1292 Truncated incorrect optimizer_use_condition_selec... value: '0'
40 SELECT @@session.optimizer_use_condition_selectivity;
41 @@session.optimizer_use_condition_selectivity
42 1
43 SET @@session.optimizer_use_condition_selectivity = 1;
44 SELECT @@session.optimizer_use_condition_selectivity;
45 @@session.optimizer_use_condition_selectivity
46 1
47 SET @@session.optimizer_use_condition_selectivity = 2;
48 SELECT @@session.optimizer_use_condition_selectivity;
49 @@session.optimizer_use_condition_selectivity
50 2
51 SET @@session.optimizer_use_condition_selectivity = 3;
52 SELECT @@session.optimizer_use_condition_selectivity;
53 @@session.optimizer_use_condition_selectivity
54 3
55 SET @@session.optimizer_use_condition_selectivity = 4;
56 SELECT @@session.optimizer_use_condition_selectivity;
57 @@session.optimizer_use_condition_selectivity
58 4
59 SET @@session.optimizer_use_condition_selectivity = 5;
60 SELECT @@session.optimizer_use_condition_selectivity;
61 @@session.optimizer_use_condition_selectivity
62 5
63 SET @@session.optimizer_use_condition_selectivity = 6;
64 Warnings:
65 Warning 1292 Truncated incorrect optimizer_use_condition_selec... value: '6'
66 SELECT @@session.optimizer_use_condition_selectivity;
67 @@session.optimizer_use_condition_selectivity
68 5
69 '#------------------FN_DYNVARS_115_05-----------------------#'
70 SET @@global.optimizer_use_condition_selectivity = ON;
71 ERROR 42000: Incorrect argument type to variable 'optimizer_use_condition_selectivity'
72 SET @@global.optimizer_use_condition_selectivity = OFF;
73 ERROR 42000: Incorrect argument type to variable 'optimizer_use_condition_selectivity'
74 SET @@session.optimizer_use_condition_selectivity = 65530.34;
75 ERROR 42000: Incorrect argument type to variable 'optimizer_use_condition_selectivity'
76 SET @@session.optimizer_use_condition_selectivity = test;
77 ERROR 42000: Incorrect argument type to variable 'optimizer_use_condition_selectivity'
78 '#------------------FN_DYNVARS_115_06-----------------------#'
79 SELECT @@global.optimizer_use_condition_selectivity = VARIABLE_VALUE
80 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
81 WHERE VARIABLE_NAME='optimizer_use_condition_selectivity';
82 @@global.optimizer_use_condition_selectivity = VARIABLE_VALUE
83 1
84 '#------------------FN_DYNVARS_115_07-----------------------#'
85 SELECT @@session.optimizer_use_condition_selectivity = VARIABLE_VALUE
86 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
87 WHERE VARIABLE_NAME='optimizer_use_condition_selectivity';
88 @@session.optimizer_use_condition_selectivity = VARIABLE_VALUE
89 1
90 '#---------------------FN_DYNVARS_115_08----------------------#'
91 SET @@optimizer_use_condition_selectivity = 1;
92 SET @@global.optimizer_use_condition_selectivity = 3;
93 SELECT @@optimizer_use_condition_selectivity = @@global.optimizer_use_condition_selectivity;
94 @@optimizer_use_condition_selectivity = @@global.optimizer_use_condition_selectivity
95 0
96 '#---------------------FN_DYNVARS_115_09----------------------#'
97 SET @@optimizer_use_condition_selectivity = 2;
98 SELECT @@optimizer_use_condition_selectivity = @@local.optimizer_use_condition_selectivity;
99 @@optimizer_use_condition_selectivity = @@local.optimizer_use_condition_selectivity
100 1
101 SELECT @@local.optimizer_use_condition_selectivity = @@session.optimizer_use_condition_selectivity;
102 @@local.optimizer_use_condition_selectivity = @@session.optimizer_use_condition_selectivity
103 1
104 SET @@global.optimizer_use_condition_selectivity = @start_global_value;