Debian Codegraph @

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

raw
1 SET @@global.information_schema_stats_expiry = DEFAULT;
2 SELECT @@global.information_schema_stats_expiry;
3 @@global.information_schema_stats_expiry
4 86400
5 SET @@session.information_schema_stats_expiry = DEFAULT;
6 SELECT @@session.information_schema_stats_expiry;
7 @@session.information_schema_stats_expiry
8 86400
9 SET @@global.information_schema_stats_expiry= 0;
10 SELECT @@global.information_schema_stats_expiry;
11 @@global.information_schema_stats_expiry
12 0
13 SET @@global.information_schema_stats_expiry = 31536000;
14 SELECT @@global.information_schema_stats_expiry;
15 @@global.information_schema_stats_expiry
16 31536000
17 SET @@session.information_schema_stats_expiry =6000;
18 SELECT @@session.information_schema_stats_expiry;
19 @@session.information_schema_stats_expiry
20 6000
21 SET @@global.information_schema_stats_expiry = 0;
22 SELECT @@global.information_schema_stats_expiry;
23 @@global.information_schema_stats_expiry
24 0
25 SET @@global.information_schema_stats_expiry = -1024;
26 Warnings:
27 Warning 1292 Truncated incorrect information_schema_stats_expiry value: '-1024'
28 SELECT @@global.information_schema_stats_expiry;
29 @@global.information_schema_stats_expiry
30 0
31 SET @@global.information_schema_stats_expiry = 123456789031;
32 Warnings:
33 Warning 1292 Truncated incorrect information_schema_stats_expiry value: '123456789031'
34 SELECT @@global.information_schema_stats_expiry;
35 @@global.information_schema_stats_expiry
36 31536000
37 SET @@global.information_schema_stats_expiry = 31536003;
38 Warnings:
39 Warning 1292 Truncated incorrect information_schema_stats_expiry value: '31536003'
40 SELECT @@global.information_schema_stats_expiry;
41 @@global.information_schema_stats_expiry
42 31536000
43 SET @@global.information_schema_stats_expiry = ' ';
44 ERROR 42000: Incorrect argument type to variable 'information_schema_stats_expiry'
45 SELECT @@global.information_schema_stats_expiry;
46 @@global.information_schema_stats_expiry
47 31536000
48 SET @@global.information_schema_stats_expiry = ON;
49 ERROR 42000: Incorrect argument type to variable 'information_schema_stats_expiry'
50 SET @@global.information_schema_stats_expiry = OFF;
51 ERROR 42000: Incorrect argument type to variable 'information_schema_stats_expiry'
52 SET @@global.information_schema_stats_expiry = True;
53 SELECT @@global.information_schema_stats_expiry;
54 @@global.information_schema_stats_expiry
55 1
56 SET @@global.information_schema_stats_expiry = False;
57 SELECT @@global.information_schema_stats_expiry;
58 @@global.information_schema_stats_expiry
59 0
60 SET @@global.information_schema_stats_expiry = 65530.34;
61 ERROR 42000: Incorrect argument type to variable 'information_schema_stats_expiry'
62 SELECT @@global.information_schema_stats_expiry;
63 @@global.information_schema_stats_expiry
64 0
65 SET @@global.information_schema_stats_expiry ="Test";
66 ERROR 42000: Incorrect argument type to variable 'information_schema_stats_expiry'
67 SET @@session.information_schema_stats_expiry = ON;
68 ERROR 42000: Incorrect argument type to variable 'information_schema_stats_expiry'
69 SET @@session.information_schema_stats_expiry = OFF;
70 ERROR 42000: Incorrect argument type to variable 'information_schema_stats_expiry'
71 SET @@session.information_schema_stats_expiry = True;
72 SELECT @@session.information_schema_stats_expiry;
73 @@session.information_schema_stats_expiry
74 1
75 SET @@session.information_schema_stats_expiry = False;
76 SELECT @@session.information_schema_stats_expiry;
77 @@session.information_schema_stats_expiry
78 0
79 SET @@session.information_schema_stats_expiry = "Test";
80 ERROR 42000: Incorrect argument type to variable 'information_schema_stats_expiry'
81 SET @@session.information_schema_stats_expiry = 65530.34;
82 ERROR 42000: Incorrect argument type to variable 'information_schema_stats_expiry'
83 SELECT @@session.information_schema_stats_expiry;
84 @@session.information_schema_stats_expiry
85 0
86 SET @@session.information_schema_stats_expiry = 'test';
87 ERROR 42000: Incorrect argument type to variable 'information_schema_stats_expiry'
88 SET @@session.information_schema_stats_expiry = 0;
89 SELECT @@session.information_schema_stats_expiry;
90 @@session.information_schema_stats_expiry
91 0
92 SET @@session.information_schema_stats_expiry = ' ';
93 ERROR 42000: Incorrect argument type to variable 'information_schema_stats_expiry'
94 SELECT @@session.information_schema_stats_expiry;
95 @@session.information_schema_stats_expiry
96 0
97 SET @@global.information_schema_stats_expiry = 30000;
98 SET @@global.information_schema_stats_expiry = 40000;
99 SELECT @@information_schema_stats_expiry = @@global.information_schema_stats_expiry;
100 @@information_schema_stats_expiry = @@global.information_schema_stats_expiry
101 0
102 SET @@information_schema_stats_expiry = 100;
103 SELECT @@information_schema_stats_expiry = @@local.information_schema_stats_expiry;
104 @@information_schema_stats_expiry = @@local.information_schema_stats_expiry
105 1
106 SELECT @@local.information_schema_stats_expiry = @@session.information_schema_stats_expiry;
107 @@local.information_schema_stats_expiry = @@session.information_schema_stats_expiry
108 1
109 SET @@global.information_schema_stats_expiry = default;
110 SET @@session.information_schema_stats_expiry = default;