Debian Codegraph @

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

raw
1 SET @start_value = @@global.delayed_queue_size;
2 SELECT @start_value;
3 @start_value
4 1000
5 '#--------------------FN_DYNVARS_026_01------------------------#'
6 SET @@global.delayed_queue_size = 100;
7 SET @@global.delayed_queue_size = DEFAULT;
8 SELECT @@global.delayed_queue_size;
9 @@global.delayed_queue_size
10 1000
11 '#---------------------FN_DYNVARS_026_02-------------------------#'
12 SET @@global.delayed_queue_size = @start_value;
13 SELECT @@global.delayed_queue_size = 1000;
14 @@global.delayed_queue_size = 1000
15 1
16 '#--------------------FN_DYNVARS_026_03------------------------#'
17 SET @@global.delayed_queue_size = 10000;
18 SELECT @@global.delayed_queue_size;
19 @@global.delayed_queue_size
20 10000
21 SET @@global.delayed_queue_size = 4294967295;
22 SELECT @@global.delayed_queue_size;
23 @@global.delayed_queue_size
24 4294967295
25 SET @@global.delayed_queue_size = 1;
26 SELECT @@global.delayed_queue_size;
27 @@global.delayed_queue_size
28 1
29 '#--------------------FN_DYNVARS_026_04-------------------------#'
30 SET @@global.delayed_queue_size = 0;
31 Warnings:
32 Warning 1292 Truncated incorrect delayed_queue_size value: '0'
33 SELECT @@global.delayed_queue_size;
34 @@global.delayed_queue_size
35 1
36 SET @@global.delayed_queue_size = -1024;
37 Warnings:
38 Warning 1292 Truncated incorrect delayed_queue_size value: '-1024'
39 SELECT @@global.delayed_queue_size;
40 @@global.delayed_queue_size
41 1
42 SET @@global.delayed_queue_size = 42949672950;
43 Warnings:
44 Warning 1292 Truncated incorrect delayed_queue_size value: '42949672950'
45 SELECT @@global.delayed_queue_size;
46 @@global.delayed_queue_size
47 4294967295
48 SET @@global.delayed_queue_size = 429496729.5;
49 ERROR 42000: Incorrect argument type to variable 'delayed_queue_size'
50 SELECT @@global.delayed_queue_size;
51 @@global.delayed_queue_size
52 4294967295
53 SET @@global.delayed_queue_size = ON;
54 ERROR 42000: Incorrect argument type to variable 'delayed_queue_size'
55 SELECT @@delayed_queue_size;
56 @@delayed_queue_size
57 4294967295
58 '#-------------------FN_DYNVARS_026_05----------------------------#'
59 SET @@session.delayed_queue_size = 0;
60 ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable and should be set with SET GLOBAL
61 SELECT @@session.delayed_queue_size;
62 ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable
63 '#----------------------FN_DYNVARS_026_06------------------------#'
64 SELECT @@global.delayed_queue_size = VARIABLE_VALUE
65 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
66 WHERE VARIABLE_NAME='delayed_queue_size';
67 @@global.delayed_queue_size = VARIABLE_VALUE
68 1
69 SELECT @@delayed_queue_size = VARIABLE_VALUE
70 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
71 WHERE VARIABLE_NAME='delayed_queue_size';
72 @@delayed_queue_size = VARIABLE_VALUE
73 1
74 '#---------------------FN_DYNVARS_026_07----------------------#'
75 SET @@global.delayed_queue_size = TRUE;
76 SELECT @@global.delayed_queue_size;
77 @@global.delayed_queue_size
78 1
79 SET @@global.delayed_queue_size = FALSE;
80 Warnings:
81 Warning 1292 Truncated incorrect delayed_queue_size value: '0'
82 SELECT @@global.delayed_queue_size;
83 @@global.delayed_queue_size
84 1
85 '#---------------------FN_DYNVARS_026_08----------------------#'
86 SET @@global.delayed_queue_size = 1;
87 SELECT @@delayed_queue_size = @@global.delayed_queue_size;
88 @@delayed_queue_size = @@global.delayed_queue_size
89 1
90 '#---------------------FN_DYNVARS_026_09----------------------#'
91 SET delayed_queue_size = 1;
92 ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable and should be set with SET GLOBAL
93 SELECT @@delayed_queue_size;
94 @@delayed_queue_size
95 1
96 SELECT local.delayed_queue_size;
97 ERROR 42S02: Unknown table 'local' in SELECT
98 SELECT global.delayed_queue_size;
99 ERROR 42S02: Unknown table 'global' in SELECT
100 SELECT delayed_queue_size = @@session.delayed_queue_size;
101 ERROR 42S22: Unknown column 'delayed_queue_size' in 'SELECT'
102 SET @@global.delayed_queue_size = @start_value;
103 SELECT @@global.delayed_queue_size;
104 @@global.delayed_queue_size
105 1000