Debian Codegraph @

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

raw
1 SET @start_value = @@global.slow_launch_time;
2 SELECT @start_value;
3 @start_value
4 2
5 '#--------------------FN_DYNVARS_150_01------------------------#'
6 SET @@global.slow_launch_time = 99;
7 SET @@global.slow_launch_time = DEFAULT;
8 SELECT @@global.slow_launch_time;
9 @@global.slow_launch_time
10 2
11 '#---------------------FN_DYNVARS_150_02-------------------------#'
12 SET @@global.slow_launch_time = @start_value;
13 SELECT @@global.slow_launch_time = 2;
14 @@global.slow_launch_time = 2
15 1
16 '#--------------------FN_DYNVARS_150_03------------------------#'
17 SET @@global.slow_launch_time = 0;
18 SELECT @@global.slow_launch_time;
19 @@global.slow_launch_time
20 0
21 SET @@global.slow_launch_time = 1;
22 SELECT @@global.slow_launch_time;
23 @@global.slow_launch_time
24 1
25 SET @@global.slow_launch_time = 31536000;
26 SELECT @@global.slow_launch_time;
27 @@global.slow_launch_time
28 31536000
29 SET @@global.slow_launch_time = 31535999;
30 SELECT @@global.slow_launch_time;
31 @@global.slow_launch_time
32 31535999
33 SET @@global.slow_launch_time = 65536;
34 SELECT @@global.slow_launch_time;
35 @@global.slow_launch_time
36 65536
37 '#--------------------FN_DYNVARS_150_04-------------------------#'
38 SET @@global.slow_launch_time = -1;
39 Warnings:
40 Warning 1292 Truncated incorrect slow_launch_time value: '-1'
41 SELECT @@global.slow_launch_time;
42 @@global.slow_launch_time
43 0
44 SET @@global.slow_launch_time = 31536001;
45 Warnings:
46 Warning 1292 Truncated incorrect slow_launch_time value: '31536001'
47 SELECT @@global.slow_launch_time;
48 @@global.slow_launch_time
49 31536000
50 SET @@global.slow_launch_time = 10240022115;
51 Warnings:
52 Warning 1292 Truncated incorrect slow_launch_time value: '10240022115'
53 SELECT @@global.slow_launch_time;
54 @@global.slow_launch_time
55 31536000
56 SET @@global.slow_launch_time = 10000.01;
57 ERROR 42000: Incorrect argument type to variable 'slow_launch_time'
58 SELECT @@global.slow_launch_time;
59 @@global.slow_launch_time
60 31536000
61 SET @@global.slow_launch_time = -1024;
62 Warnings:
63 Warning 1292 Truncated incorrect slow_launch_time value: '-1024'
64 SELECT @@global.slow_launch_time;
65 @@global.slow_launch_time
66 0
67 SET @@global.slow_launch_time = 42949672950;
68 Warnings:
69 Warning 1292 Truncated incorrect slow_launch_time value: '42949672950'
70 SELECT @@global.slow_launch_time;
71 @@global.slow_launch_time
72 31536000
73 SET @@global.slow_launch_time = ON;
74 ERROR 42000: Incorrect argument type to variable 'slow_launch_time'
75 SELECT @@global.slow_launch_time;
76 @@global.slow_launch_time
77 31536000
78 SET @@global.slow_launch_time = 'test';
79 ERROR 42000: Incorrect argument type to variable 'slow_launch_time'
80 SELECT @@global.slow_launch_time;
81 @@global.slow_launch_time
82 31536000
83 '#-------------------FN_DYNVARS_150_05----------------------------#'
84 SET @@session.slow_launch_time = 0;
85 ERROR HY000: Variable 'slow_launch_time' is a GLOBAL variable and should be set with SET GLOBAL
86 SELECT @@slow_launch_time;
87 @@slow_launch_time
88 31536000
89 '#----------------------FN_DYNVARS_150_06------------------------#'
90 SELECT @@global.slow_launch_time = VARIABLE_VALUE
91 FROM performance_schema.global_variables
92 WHERE VARIABLE_NAME='slow_launch_time';
93 @@global.slow_launch_time = VARIABLE_VALUE
94 1
95 SELECT @@slow_launch_time = VARIABLE_VALUE
96 FROM performance_schema.session_variables
97 WHERE VARIABLE_NAME='slow_launch_time';
98 @@slow_launch_time = VARIABLE_VALUE
99 1
100 '#---------------------FN_DYNVARS_150_07----------------------#'
101 SET @@global.slow_launch_time = TRUE;
102 SELECT @@global.slow_launch_time;
103 @@global.slow_launch_time
104 1
105 SET @@global.slow_launch_time = FALSE;
106 SELECT @@global.slow_launch_time;
107 @@global.slow_launch_time
108 0
109 '#---------------------FN_DYNVARS_150_08----------------------#'
110 SET @@global.slow_launch_time = 1;
111 SELECT @@slow_launch_time = @@global.slow_launch_time;
112 @@slow_launch_time = @@global.slow_launch_time
113 1
114 '#---------------------FN_DYNVARS_150_09----------------------#'
115 SET slow_launch_time = 1;
116 ERROR HY000: Variable 'slow_launch_time' is a GLOBAL variable and should be set with SET GLOBAL
117 SELECT @@slow_launch_time;
118 @@slow_launch_time
119 1
120 SET local.slow_launch_time = 1;
121 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.slow_launch_time = 1' at line 1
122 SELECT local.slow_launch_time;
123 ERROR 42S02: Unknown table 'local' in field list
124 SET global.slow_launch_time = 1;
125 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.slow_launch_time = 1' at line 1
126 SELECT global.slow_launch_time;
127 ERROR 42S02: Unknown table 'global' in field list
128 SELECT slow_launch_time;
129 ERROR 42S22: Unknown column 'slow_launch_time' in 'field list'
130 SELECT @@session.slow_launch_time;
131 ERROR HY000: Variable 'slow_launch_time' is a GLOBAL variable
132 SET @@global.slow_launch_time = @start_value;
133 SELECT @@global.slow_launch_time;
134 @@global.slow_launch_time
135 2