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 4294967295
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 4294967295
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 = 4294967296;
62 Warnings:
63 Warning 1292 Truncated incorrect max_prepared_stmt_count value: '4294967296'
64 SELECT @@global.max_prepared_stmt_count;
65 @@global.max_prepared_stmt_count
66 4294967295
67 SET @@global.max_prepared_stmt_count = 4294967295*1024;
68 Warnings:
69 Warning 1292 Truncated incorrect max_prepared_stmt_count value: '4398046510080'
70 SELECT @@global.max_prepared_stmt_count;
71 @@global.max_prepared_stmt_count
72 4294967295
73 SET @@global.max_prepared_stmt_count = ON;
74 ERROR 42000: Incorrect argument type to variable 'max_prepared_stmt_count'
75 SELECT @@global.max_prepared_stmt_count;
76 @@global.max_prepared_stmt_count
77 4294967295
78 SET @@global.max_prepared_stmt_count = 'test';
79 ERROR 42000: Incorrect argument type to variable 'max_prepared_stmt_count'
80 SELECT @@global.max_prepared_stmt_count;
81 @@global.max_prepared_stmt_count
82 4294967295
83 '#-------------------FN_DYNVARS_081_05----------------------------#'
84 SET @@session.max_prepared_stmt_count = 4096;
85 ERROR HY000: Variable 'max_prepared_stmt_count' is a GLOBAL variable and should be set with SET GLOBAL
86 SELECT @@session.max_prepared_stmt_count;
87 ERROR HY000: Variable 'max_prepared_stmt_count' is a GLOBAL variable
88 '#----------------------FN_DYNVARS_081_06------------------------#'
89 SELECT @@global.max_prepared_stmt_count = VARIABLE_VALUE
90 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
91 WHERE VARIABLE_NAME='max_prepared_stmt_count';
92 @@global.max_prepared_stmt_count = VARIABLE_VALUE
93 1
94 SELECT @@max_prepared_stmt_count = VARIABLE_VALUE
95 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
96 WHERE VARIABLE_NAME='max_prepared_stmt_count';
97 @@max_prepared_stmt_count = VARIABLE_VALUE
98 1
99 '#---------------------FN_DYNVARS_081_07----------------------#'
100 SET @@global.max_prepared_stmt_count = TRUE;
101 SELECT @@global.max_prepared_stmt_count;
102 @@global.max_prepared_stmt_count
103 1
104 SET @@global.max_prepared_stmt_count = FALSE;
105 SELECT @@global.max_prepared_stmt_count;
106 @@global.max_prepared_stmt_count
107 0
108 '#---------------------FN_DYNVARS_081_08----------------------#'
109 SET @@global.max_prepared_stmt_count = 5000;
110 SELECT @@max_prepared_stmt_count = @@global.max_prepared_stmt_count;
111 @@max_prepared_stmt_count = @@global.max_prepared_stmt_count
112 1
113 '#---------------------FN_DYNVARS_081_09----------------------#'
114 SET max_prepared_stmt_count = 6000;
115 ERROR HY000: Variable 'max_prepared_stmt_count' is a GLOBAL variable and should be set with SET GLOBAL
116 SELECT @@max_prepared_stmt_count;
117 @@max_prepared_stmt_count
118 5000
119 SELECT local.max_prepared_stmt_count;
120 ERROR 42S02: Unknown table 'local' in SELECT
121 SELECT global.max_prepared_stmt_count;
122 ERROR 42S02: Unknown table 'global' in SELECT
123 SELECT max_prepared_stmt_count = @@session.max_prepared_stmt_count;
124 ERROR 42S22: Unknown column 'max_prepared_stmt_count' in 'SELECT'
125 SET @@global.max_prepared_stmt_count = @start_value;
126 SELECT @@global.max_prepared_stmt_count;
127 @@global.max_prepared_stmt_count
128 16382