Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.optimizer_selectivity_sampling_limit;
2 SELECT @start_global_value;
3 @start_global_value
4 100
5 SET @start_session_value = @@session.optimizer_selectivity_sampling_limit;
6 SELECT @start_session_value;
7 @start_session_value
8 100
9 '#--------------------FN_DYNVARS_115_01-------------------------#'
10 SET @@global.optimizer_selectivity_sampling_limit = DEFAULT;
11 SELECT @@global.optimizer_selectivity_sampling_limit;
12 @@global.optimizer_selectivity_sampling_limit
13 100
14 SET @@session.optimizer_selectivity_sampling_limit = DEFAULT;
15 SELECT @@session.optimizer_selectivity_sampling_limit;
16 @@session.optimizer_selectivity_sampling_limit
17 100
18 '#--------------------FN_DYNVARS_115_02-------------------------#'
19 SET @@global.optimizer_selectivity_sampling_limit = DEFAULT;
20 SELECT @@global.optimizer_selectivity_sampling_limit = 100;
21 @@global.optimizer_selectivity_sampling_limit = 100
22 1
23 SET @@session.optimizer_selectivity_sampling_limit = DEFAULT;
24 SELECT @@session.optimizer_selectivity_sampling_limit = 100;
25 @@session.optimizer_selectivity_sampling_limit = 100
26 1
27 '#--------------------FN_DYNVARS_115_03-------------------------#'
28 SELECT @@global.optimizer_selectivity_sampling_limit;
29 @@global.optimizer_selectivity_sampling_limit
30 100
31 SET @@global.optimizer_selectivity_sampling_limit = 9;
32 Warnings:
33 Warning 1292 Truncated incorrect optimizer_selectivity_samplin... value: '9'
34 SELECT @@global.optimizer_selectivity_sampling_limit;
35 @@global.optimizer_selectivity_sampling_limit
36 10
37 SET @@global.optimizer_selectivity_sampling_limit = 10;
38 SELECT @@global.optimizer_selectivity_sampling_limit;
39 @@global.optimizer_selectivity_sampling_limit
40 10
41 SET @@global.optimizer_selectivity_sampling_limit = 11;
42 SELECT @@global.optimizer_selectivity_sampling_limit;
43 @@global.optimizer_selectivity_sampling_limit
44 11
45 SET @@global.optimizer_selectivity_sampling_limit = 7777;
46 SELECT @@global.optimizer_selectivity_sampling_limit;
47 @@global.optimizer_selectivity_sampling_limit
48 7777
49 SET @@global.optimizer_selectivity_sampling_limit = 4294967294;
50 SELECT @@global.optimizer_selectivity_sampling_limit;
51 @@global.optimizer_selectivity_sampling_limit
52 4294967294
53 SET @@global.optimizer_selectivity_sampling_limit = 4294967295;
54 SELECT @@global.optimizer_selectivity_sampling_limit;
55 @@global.optimizer_selectivity_sampling_limit
56 4294967295
57 SET @@global.optimizer_selectivity_sampling_limit = 4294967296;
58 Warnings:
59 Warning 1292 Truncated incorrect optimizer_selectivity_samplin... value: '4294967296'
60 SELECT @@global.optimizer_selectivity_sampling_limit;
61 @@global.optimizer_selectivity_sampling_limit
62 4294967295
63 '#--------------------FN_DYNVARS_115_04-------------------------#'
64 SELECT @@session.optimizer_selectivity_sampling_limit;
65 @@session.optimizer_selectivity_sampling_limit
66 100
67 SET @@session.optimizer_selectivity_sampling_limit = 9;
68 Warnings:
69 Warning 1292 Truncated incorrect optimizer_selectivity_samplin... value: '9'
70 SELECT @@session.optimizer_selectivity_sampling_limit;
71 @@session.optimizer_selectivity_sampling_limit
72 10
73 SET @@session.optimizer_selectivity_sampling_limit = 10;
74 SELECT @@session.optimizer_selectivity_sampling_limit;
75 @@session.optimizer_selectivity_sampling_limit
76 10
77 SET @@session.optimizer_selectivity_sampling_limit = 11;
78 SELECT @@session.optimizer_selectivity_sampling_limit;
79 @@session.optimizer_selectivity_sampling_limit
80 11
81 SET @@session.optimizer_selectivity_sampling_limit = 7777;
82 SELECT @@session.optimizer_selectivity_sampling_limit;
83 @@session.optimizer_selectivity_sampling_limit
84 7777
85 SET @@session.optimizer_selectivity_sampling_limit = 4294967294;
86 SELECT @@session.optimizer_selectivity_sampling_limit;
87 @@session.optimizer_selectivity_sampling_limit
88 4294967294
89 SET @@session.optimizer_selectivity_sampling_limit = 4294967295;
90 SELECT @@session.optimizer_selectivity_sampling_limit;
91 @@session.optimizer_selectivity_sampling_limit
92 4294967295
93 SET @@session.optimizer_selectivity_sampling_limit = 4294967296;
94 Warnings:
95 Warning 1292 Truncated incorrect optimizer_selectivity_samplin... value: '4294967296'
96 SELECT @@session.optimizer_selectivity_sampling_limit;
97 @@session.optimizer_selectivity_sampling_limit
98 4294967295
99 '#------------------FN_DYNVARS_115_05-----------------------#'
100 SET @@global.optimizer_selectivity_sampling_limit = ON;
101 ERROR 42000: Incorrect argument type to variable 'optimizer_selectivity_sampling_limit'
102 SET @@global.optimizer_selectivity_sampling_limit = OFF;
103 ERROR 42000: Incorrect argument type to variable 'optimizer_selectivity_sampling_limit'
104 SET @@session.optimizer_selectivity_sampling_limit = 65530.34;
105 ERROR 42000: Incorrect argument type to variable 'optimizer_selectivity_sampling_limit'
106 SET @@session.optimizer_selectivity_sampling_limit = test;
107 ERROR 42000: Incorrect argument type to variable 'optimizer_selectivity_sampling_limit'
108 '#------------------FN_DYNVARS_115_06-----------------------#'
109 SELECT @@global.optimizer_selectivity_sampling_limit = VARIABLE_VALUE
110 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
111 WHERE VARIABLE_NAME='optimizer_selectivity_sampling_limit';
112 @@global.optimizer_selectivity_sampling_limit = VARIABLE_VALUE
113 1
114 '#------------------FN_DYNVARS_115_07-----------------------#'
115 SELECT @@session.optimizer_selectivity_sampling_limit = VARIABLE_VALUE
116 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
117 WHERE VARIABLE_NAME='optimizer_selectivity_sampling_limit';
118 @@session.optimizer_selectivity_sampling_limit = VARIABLE_VALUE
119 1
120 '#---------------------FN_DYNVARS_115_08----------------------#'
121 SET @@optimizer_selectivity_sampling_limit = 10;
122 SET @@global.optimizer_selectivity_sampling_limit = 30;
123 SELECT @@optimizer_selectivity_sampling_limit = @@global.optimizer_selectivity_sampling_limit;
124 @@optimizer_selectivity_sampling_limit = @@global.optimizer_selectivity_sampling_limit
125 0
126 '#---------------------FN_DYNVARS_115_09----------------------#'
127 SET @@optimizer_selectivity_sampling_limit = 20;
128 SELECT @@optimizer_selectivity_sampling_limit = @@local.optimizer_selectivity_sampling_limit;
129 @@optimizer_selectivity_sampling_limit = @@local.optimizer_selectivity_sampling_limit
130 1
131 SELECT @@local.optimizer_selectivity_sampling_limit = @@session.optimizer_selectivity_sampling_limit;
132 @@local.optimizer_selectivity_sampling_limit = @@session.optimizer_selectivity_sampling_limit
133 1
134 SET @@global.optimizer_selectivity_sampling_limit = @start_global_value;
135 SELECT @@global.optimizer_selectivity_sampling_limit;
136 @@global.optimizer_selectivity_sampling_limit
137 100
138 SET @@session.optimizer_selectivity_sampling_limit = @start_session_value;
139 SELECT @@session.optimizer_selectivity_sampling_limit;
140 @@session.optimizer_selectivity_sampling_limit
141 100