Debian Codegraph @

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

raw
1 SET @start_value = @@global.max_prepared_stmt_count;
2 SELECT @start_value;
3 @start_value
4 16382
5 '#--------------------FN_DYNVARS_081_01------------------------#'
6 SET @@global.max_prepared_stmt_count = 5000;
7 SET @@global.max_prepared_stmt_count = DEFAULT;
8 SELECT @@global.max_prepared_stmt_count;
9 @@global.max_prepared_stmt_count
10 16382
11 '#---------------------FN_DYNVARS_081_02-------------------------#'
12 SET @@global.max_prepared_stmt_count = @start_value;
13 SELECT @@global.max_prepared_stmt_count = 16382;
14 @@global.max_prepared_stmt_count = 16382
15 1
16 '#--------------------FN_DYNVARS_081_03------------------------#'
17 SET @@global.max_prepared_stmt_count = 0;
18 SELECT @@global.max_prepared_stmt_count;
19 @@global.max_prepared_stmt_count
20 0
21 SET @@global.max_prepared_stmt_count = 1;
22 SELECT @@global.max_prepared_stmt_count;
23 @@global.max_prepared_stmt_count
24 1
25 SET @@global.max_prepared_stmt_count = 1048576;
26 SELECT @@global.max_prepared_stmt_count;
27 @@global.max_prepared_stmt_count
28 1048576
29 SET @@global.max_prepared_stmt_count = 1048575;
30 SELECT @@global.max_prepared_stmt_count;
31 @@global.max_prepared_stmt_count
32 1048575
33 SET @@global.max_prepared_stmt_count = 65535;
34 SELECT @@global.max_prepared_stmt_count;
35 @@global.max_prepared_stmt_count
36 65535
37 '#--------------------FN_DYNVARS_081_04-------------------------#'
38 SET @@global.max_prepared_stmt_count = -1;
39 Warnings:
40 Warning 1292 Truncated incorrect max_prepared_stmt_count value: '-1'
41 SELECT @@global.max_prepared_stmt_count;
42 @@global.max_prepared_stmt_count
43 0
44 SET @@global.max_prepared_stmt_count = 100000000000;
45 Warnings:
46 Warning 1292 Truncated incorrect max_prepared_stmt_count value: '100000000000'
47 SELECT @@global.max_prepared_stmt_count;
48 @@global.max_prepared_stmt_count
49 4194304
50 SET @@global.max_prepared_stmt_count = 10000.01;
51 ERROR 42000: Incorrect argument type to variable 'max_prepared_stmt_count'
52 SELECT @@global.max_prepared_stmt_count;
53 @@global.max_prepared_stmt_count
54 4194304
55 SET @@global.max_prepared_stmt_count = -1024;
56 Warnings:
57 Warning 1292 Truncated incorrect max_prepared_stmt_count value: '-1024'
58 SELECT @@global.max_prepared_stmt_count;
59 @@global.max_prepared_stmt_count
60 0
61 SET @@global.max_prepared_stmt_count = 1048577;
62 SELECT @@global.max_prepared_stmt_count;
63 @@global.max_prepared_stmt_count
64 1048577
65 SET @@global.max_prepared_stmt_count = 4194304;
66 SELECT @@global.max_prepared_stmt_count;
67 @@global.max_prepared_stmt_count
68 4194304
69 SET @@global.max_prepared_stmt_count = 4194305;
70 Warnings:
71 Warning 1292 Truncated incorrect max_prepared_stmt_count value: '4194305'
72 SELECT @@global.max_prepared_stmt_count;
73 @@global.max_prepared_stmt_count
74 4194304
75 SET @@global.max_prepared_stmt_count = 104857612;
76 Warnings:
77 Warning 1292 Truncated incorrect max_prepared_stmt_count value: '104857612'
78 SELECT @@global.max_prepared_stmt_count;
79 @@global.max_prepared_stmt_count
80 4194304
81 SET @@global.max_prepared_stmt_count = ON;
82 ERROR 42000: Incorrect argument type to variable 'max_prepared_stmt_count'
83 SELECT @@global.max_prepared_stmt_count;
84 @@global.max_prepared_stmt_count
85 4194304
86 SET @@global.max_prepared_stmt_count = 'test';
87 ERROR 42000: Incorrect argument type to variable 'max_prepared_stmt_count'
88 SELECT @@global.max_prepared_stmt_count;
89 @@global.max_prepared_stmt_count
90 4194304
91 SET @@global.max_prepared_stmt_count = ' ';
92 ERROR 42000: Incorrect argument type to variable 'max_prepared_stmt_count'
93 SELECT @@global.max_prepared_stmt_count;
94 @@global.max_prepared_stmt_count
95 4194304
96 '#-------------------FN_DYNVARS_081_05----------------------------#'
97 SET @@session.max_prepared_stmt_count = 4096;
98 ERROR HY000: Variable 'max_prepared_stmt_count' is a GLOBAL variable and should be set with SET GLOBAL
99 SELECT @@session.max_prepared_stmt_count;
100 ERROR HY000: Variable 'max_prepared_stmt_count' is a GLOBAL variable
101 '#----------------------FN_DYNVARS_081_06------------------------#'
102 SELECT @@global.max_prepared_stmt_count = VARIABLE_VALUE
103 FROM performance_schema.global_variables
104 WHERE VARIABLE_NAME='max_prepared_stmt_count';
105 @@global.max_prepared_stmt_count = VARIABLE_VALUE
106 1
107 SELECT @@max_prepared_stmt_count = VARIABLE_VALUE
108 FROM performance_schema.session_variables
109 WHERE VARIABLE_NAME='max_prepared_stmt_count';
110 @@max_prepared_stmt_count = VARIABLE_VALUE
111 1
112 '#---------------------FN_DYNVARS_081_07----------------------#'
113 SET @@global.max_prepared_stmt_count = TRUE;
114 SELECT @@global.max_prepared_stmt_count;
115 @@global.max_prepared_stmt_count
116 1
117 SET @@global.max_prepared_stmt_count = FALSE;
118 SELECT @@global.max_prepared_stmt_count;
119 @@global.max_prepared_stmt_count
120 0
121 '#---------------------FN_DYNVARS_081_08----------------------#'
122 SET @@global.max_prepared_stmt_count = 5000;
123 SELECT @@max_prepared_stmt_count = @@global.max_prepared_stmt_count;
124 @@max_prepared_stmt_count = @@global.max_prepared_stmt_count
125 1
126 '#---------------------FN_DYNVARS_081_09----------------------#'
127 SET max_prepared_stmt_count = 6000;
128 ERROR HY000: Variable 'max_prepared_stmt_count' is a GLOBAL variable and should be set with SET GLOBAL
129 SELECT @@max_prepared_stmt_count;
130 @@max_prepared_stmt_count
131 5000
132 SET local.max_prepared_stmt_count = 7000;
133 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.max_prepared_stmt_count = 7000' at line 1
134 SELECT local.max_prepared_stmt_count;
135 ERROR 42S02: Unknown table 'local' in field list
136 SET global.max_prepared_stmt_count = 8000;
137 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 'global.max_prepared_stmt_count = 8000' at line 1
138 SELECT global.max_prepared_stmt_count;
139 ERROR 42S02: Unknown table 'global' in field list
140 SELECT max_prepared_stmt_count;
141 ERROR 42S22: Unknown column 'max_prepared_stmt_count' in 'field list'
142 SELECT @@session.max_prepared_stmt_count;
143 ERROR HY000: Variable 'max_prepared_stmt_count' is a GLOBAL variable
144 SET @@global.max_prepared_stmt_count = @start_value;
145 SELECT @@global.max_prepared_stmt_count;
146 @@global.max_prepared_stmt_count
147 16382