Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.long_query_time;
2 SET @start_session_value = @@session.long_query_time;
3 '#--------------------FN_DYNVARS_068_01-------------------------#'
4 SET @@global.long_query_time = 100;
5 SET @@global.long_query_time = DEFAULT;
6 SELECT @@global.long_query_time >= 0;
7 @@global.long_query_time >= 0
8 1
9 SET @@session.long_query_time = 200;
10 SET @@session.long_query_time = DEFAULT;
11 SELECT @@session.long_query_time >= 0;
12 @@session.long_query_time >= 0
13 1
14 '#--------------------FN_DYNVARS_068_03-------------------------#'
15 SET @@global.long_query_time = 0;
16 SELECT @@global.long_query_time;
17 @@global.long_query_time
18 0.000000
19 SET @@global.long_query_time = 1;
20 SELECT @@global.long_query_time;
21 @@global.long_query_time
22 1.000000
23 SET @@global.long_query_time = 60020;
24 SELECT @@global.long_query_time;
25 @@global.long_query_time
26 60020.000000
27 SET @@global.long_query_time = 31536000;
28 SELECT @@global.long_query_time;
29 @@global.long_query_time
30 31536000.000000
31 SET @@global.long_query_time = 65536;
32 SELECT @@global.long_query_time;
33 @@global.long_query_time
34 65536.000000
35 '#--------------------FN_DYNVARS_068_04-------------------------#'
36 SET @@session.long_query_time = 0;
37 SELECT @@session.long_query_time;
38 @@session.long_query_time
39 0.000000
40 SET @@session.long_query_time = 1;
41 SELECT @@session.long_query_time;
42 @@session.long_query_time
43 1.000000
44 SET @@session.long_query_time = 50050;
45 SELECT @@session.long_query_time;
46 @@session.long_query_time
47 50050.000000
48 SET @@session.long_query_time = 31536000;
49 SELECT @@session.long_query_time;
50 @@session.long_query_time
51 31536000.000000
52 SET @@session.long_query_time = 65550;
53 SELECT @@session.long_query_time;
54 @@session.long_query_time
55 65550.000000
56 '#------------------FN_DYNVARS_068_05-----------------------#'
57 SET @@global.long_query_time = 100000000000;
58 Warnings:
59 Warning 1292 Truncated incorrect long_query_time value: '100000000000'
60 SELECT @@global.long_query_time;
61 @@global.long_query_time
62 31536000.000000
63 SET @@global.long_query_time = -1;
64 Warnings:
65 Warning 1292 Truncated incorrect long_query_time value: '-1'
66 SELECT @@global.long_query_time;
67 @@global.long_query_time
68 0.000000
69 SET @@global.long_query_time = 65530.34;
70 SELECT @@global.long_query_time;
71 @@global.long_query_time
72 65530.340000
73 SET @@global.long_query_time = test;
74 ERROR 42000: Incorrect argument type to variable 'long_query_time'
75 SELECT @@global.long_query_time;
76 @@global.long_query_time
77 65530.340000
78 SET @@session.long_query_time = 100000000000;
79 Warnings:
80 Warning 1292 Truncated incorrect long_query_time value: '100000000000'
81 SELECT @@session.long_query_time;
82 @@session.long_query_time
83 31536000.000000
84 SET @@session.long_query_time = -2;
85 Warnings:
86 Warning 1292 Truncated incorrect long_query_time value: '-2'
87 SELECT @@session.long_query_time;
88 @@session.long_query_time
89 0.000000
90 SET @@session.long_query_time = 65530.34;
91 SELECT @@session.long_query_time;
92 @@session.long_query_time
93 65530.340000
94 SET @@session.long_query_time = test;
95 ERROR 42000: Incorrect argument type to variable 'long_query_time'
96 SELECT @@session.long_query_time;
97 @@session.long_query_time
98 65530.340000
99 '#------------------FN_DYNVARS_068_06-----------------------#'
100 SELECT @@global.long_query_time = VARIABLE_VALUE
101 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
102 WHERE VARIABLE_NAME='long_query_time';
103 @@global.long_query_time = VARIABLE_VALUE
104 1
105 '#------------------FN_DYNVARS_068_07-----------------------#'
106 SELECT @@session.long_query_time = VARIABLE_VALUE
107 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
108 WHERE VARIABLE_NAME='long_query_time';
109 @@session.long_query_time = VARIABLE_VALUE
110 1
111 '#------------------FN_DYNVARS_068_08-----------------------#'
112 SET @@global.long_query_time = TRUE;
113 SELECT @@global.long_query_time;
114 @@global.long_query_time
115 1.000000
116 SET @@global.long_query_time = FALSE;
117 SELECT @@global.long_query_time;
118 @@global.long_query_time
119 0.000000
120 '#---------------------FN_DYNVARS_001_09----------------------#'
121 SET @@global.long_query_time = 10;
122 SELECT @@long_query_time = @@global.long_query_time;
123 @@long_query_time = @@global.long_query_time
124 0
125 '#---------------------FN_DYNVARS_001_10----------------------#'
126 SET @@long_query_time = 100;
127 SELECT @@long_query_time = @@local.long_query_time;
128 @@long_query_time = @@local.long_query_time
129 1
130 SELECT @@local.long_query_time = @@session.long_query_time;
131 @@local.long_query_time = @@session.long_query_time
132 1
133 '#---------------------FN_DYNVARS_001_11----------------------#'
134 SET long_query_time = 1;
135 SELECT @@long_query_time;
136 @@long_query_time
137 1.000000
138 SELECT local.long_query_time;
139 ERROR 42S02: Unknown table 'local' in SELECT
140 SELECT session.long_query_time;
141 ERROR 42S02: Unknown table 'session' in SELECT
142 SELECT long_query_time = @@session.long_query_time;
143 ERROR 42S22: Unknown column 'long_query_time' in 'SELECT'
144 SET @@global.long_query_time = @start_global_value;