Debian Codegraph @

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

raw
1 SET @start_value = @@global.expire_logs_days;
2 '#--------------------FN_DYNVARS_029_01------------------------#'
3 SET @@global.expire_logs_days = 99;
4 SET @@global.expire_logs_days = DEFAULT;
5 SELECT @@global.expire_logs_days = 0;
6 @@global.expire_logs_days = 0
7 1
8 '#---------------------FN_DYNVARS_029_02-------------------------#'
9 SET @@global.expire_logs_days = @start_value;
10 SELECT @@global.expire_logs_days = @start_value;
11 @@global.expire_logs_days = @start_value
12 1
13 '#--------------------FN_DYNVARS_029_03------------------------#'
14 SET @@global.expire_logs_days = 0;
15 SELECT @@global.expire_logs_days;
16 @@global.expire_logs_days
17 0.000000
18 SET @@global.expire_logs_days = 99;
19 SELECT @@global.expire_logs_days;
20 @@global.expire_logs_days
21 99.000000
22 SET @@global.expire_logs_days = 10;
23 SELECT @@global.expire_logs_days;
24 @@global.expire_logs_days
25 10.000000
26 SET @@global.expire_logs_days = 21;
27 SELECT @@global.expire_logs_days;
28 @@global.expire_logs_days
29 21.000000
30 '#--------------------FN_DYNVARS_029_04-------------------------#'
31 SET @@global.expire_logs_days = -1;
32 Warnings:
33 Warning 1292 Truncated incorrect expire_logs_days value: '-1'
34 SELECT @@global.expire_logs_days;
35 @@global.expire_logs_days
36 0.000000
37 SET @@global.expire_logs_days = 100;
38 Warnings:
39 Warning 1292 Truncated incorrect expire_logs_days value: '100'
40 SELECT @@global.expire_logs_days;
41 @@global.expire_logs_days
42 99.000000
43 SET @@global.expire_logs_days = 1024;
44 Warnings:
45 Warning 1292 Truncated incorrect expire_logs_days value: '1024'
46 SELECT @@global.expire_logs_days;
47 @@global.expire_logs_days
48 99.000000
49 SET @@global.expire_logs_days = 10000.01;
50 Warnings:
51 Warning 1292 Truncated incorrect expire_logs_days value: '10000.01'
52 SELECT @@global.expire_logs_days;
53 @@global.expire_logs_days
54 99.000000
55 SET @@global.expire_logs_days = -1024;
56 Warnings:
57 Warning 1292 Truncated incorrect expire_logs_days value: '-1024'
58 SELECT @@global.expire_logs_days;
59 @@global.expire_logs_days
60 0.000000
61 SET @@global.expire_logs_days = 42949672950;
62 Warnings:
63 Warning 1292 Truncated incorrect expire_logs_days value: '42949672950'
64 SELECT @@global.expire_logs_days;
65 @@global.expire_logs_days
66 99.000000
67 SET @@global.expire_logs_days = ON;
68 ERROR 42000: Incorrect argument type to variable 'expire_logs_days'
69 SELECT @@global.expire_logs_days;
70 @@global.expire_logs_days
71 99.000000
72 SET @@global.expire_logs_days = 'test';
73 ERROR 42000: Incorrect argument type to variable 'expire_logs_days'
74 SELECT @@global.expire_logs_days;
75 @@global.expire_logs_days
76 99.000000
77 '#-------------------FN_DYNVARS_029_05----------------------------#'
78 SET @@session.expire_logs_days = 0;
79 ERROR HY000: Variable 'expire_logs_days' is a GLOBAL variable and should be set with SET GLOBAL
80 SELECT @@expire_logs_days;
81 @@expire_logs_days
82 99.000000
83 '#----------------------FN_DYNVARS_029_06------------------------#'
84 SELECT @@global.expire_logs_days = VARIABLE_VALUE
85 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
86 WHERE VARIABLE_NAME='expire_logs_days';
87 @@global.expire_logs_days = VARIABLE_VALUE
88 1
89 SELECT @@expire_logs_days = VARIABLE_VALUE
90 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
91 WHERE VARIABLE_NAME='expire_logs_days';
92 @@expire_logs_days = VARIABLE_VALUE
93 1
94 '#---------------------FN_DYNVARS_029_07----------------------#'
95 SET @@global.expire_logs_days = TRUE;
96 SELECT @@global.expire_logs_days;
97 @@global.expire_logs_days
98 1.000000
99 SET @@global.expire_logs_days = FALSE;
100 SELECT @@global.expire_logs_days;
101 @@global.expire_logs_days
102 0.000000
103 '#---------------------FN_DYNVARS_029_08----------------------#'
104 SET @@global.expire_logs_days = 1;
105 SELECT @@expire_logs_days = @@global.expire_logs_days;
106 @@expire_logs_days = @@global.expire_logs_days
107 1
108 '#---------------------FN_DYNVARS_029_09----------------------#'
109 SET expire_logs_days = 1;
110 ERROR HY000: Variable 'expire_logs_days' is a GLOBAL variable and should be set with SET GLOBAL
111 SELECT @@expire_logs_days;
112 @@expire_logs_days
113 1.000000
114 SELECT local.expire_logs_days;
115 ERROR 42S02: Unknown table 'local' in SELECT
116 SELECT global.expire_logs_days;
117 ERROR 42S02: Unknown table 'global' in SELECT
118 SELECT expire_logs_days = @@session.expire_logs_days;
119 ERROR 42S22: Unknown column 'expire_logs_days' in 'SELECT'
120 SET @@global.expire_logs_days = @start_value;