Debian Codegraph @

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

raw
1 SET @start_value = @@global.mysql56_temporal_format;
2 SELECT @start_value;
3 @start_value
4 1
5 '#--------------------FN_DYNVARS_030_01------------------------#'
6 SET @@global.mysql56_temporal_format = ON;
7 SET @@global.mysql56_temporal_format = DEFAULT;
8 SELECT @@global.mysql56_temporal_format;
9 @@global.mysql56_temporal_format
10 1
11 '#---------------------FN_DYNVARS_030_02-------------------------#'
12 SET @@global.mysql56_temporal_format = @start_value;
13 SELECT @@global.mysql56_temporal_format;
14 @@global.mysql56_temporal_format
15 1
16 '#--------------------FN_DYNVARS_030_03------------------------#'
17 SET @@global.mysql56_temporal_format = ON;
18 SELECT @@global.mysql56_temporal_format;
19 @@global.mysql56_temporal_format
20 1
21 SET @@global.mysql56_temporal_format = OFF;
22 SELECT @@global.mysql56_temporal_format;
23 @@global.mysql56_temporal_format
24 0
25 SET @@global.mysql56_temporal_format = 0;
26 SELECT @@global.mysql56_temporal_format;
27 @@global.mysql56_temporal_format
28 0
29 SET @@global.mysql56_temporal_format = 1;
30 SELECT @@global.mysql56_temporal_format;
31 @@global.mysql56_temporal_format
32 1
33 '#--------------------FN_DYNVARS_030_04-------------------------#'
34 SET @@global.mysql56_temporal_format = 2;
35 ERROR 42000: Variable 'mysql56_temporal_format' can't be set to the value of '2'
36 SET @@global.mysql56_temporal_format = -1;
37 ERROR 42000: Variable 'mysql56_temporal_format' can't be set to the value of '-1'
38 SET @@global.mysql56_temporal_format = TRUEF;
39 ERROR 42000: Variable 'mysql56_temporal_format' can't be set to the value of 'TRUEF'
40 SET @@global.mysql56_temporal_format = TRUE_F;
41 ERROR 42000: Variable 'mysql56_temporal_format' can't be set to the value of 'TRUE_F'
42 SET @@global.mysql56_temporal_format = FALSE0;
43 ERROR 42000: Variable 'mysql56_temporal_format' can't be set to the value of 'FALSE0'
44 SET @@global.mysql56_temporal_format = OON;
45 ERROR 42000: Variable 'mysql56_temporal_format' can't be set to the value of 'OON'
46 SET @@global.mysql56_temporal_format = ONN;
47 ERROR 42000: Variable 'mysql56_temporal_format' can't be set to the value of 'ONN'
48 SET @@global.mysql56_temporal_format = OOFF;
49 ERROR 42000: Variable 'mysql56_temporal_format' can't be set to the value of 'OOFF'
50 SET @@global.mysql56_temporal_format = 0FF;
51 ERROR 42000: Variable 'mysql56_temporal_format' can't be set to the value of '0FF'
52 SET @@global.mysql56_temporal_format = ' ';
53 ERROR 42000: Variable 'mysql56_temporal_format' can't be set to the value of ' '
54 SET @@global.mysql56_temporal_format = " ";
55 ERROR 42000: Variable 'mysql56_temporal_format' can't be set to the value of ' '
56 SET @@global.mysql56_temporal_format = '';
57 ERROR 42000: Variable 'mysql56_temporal_format' can't be set to the value of ''
58 '#-------------------FN_DYNVARS_030_05----------------------------#'
59 SET @@session.mysql56_temporal_format = 1;
60 ERROR HY000: Variable 'mysql56_temporal_format' is a GLOBAL variable and should be set with SET GLOBAL
61 SELECT @@session.mysql56_temporal_format;
62 ERROR HY000: Variable 'mysql56_temporal_format' is a GLOBAL variable
63 '#----------------------FN_DYNVARS_030_06------------------------#'
64 SELECT IF(@@global.mysql56_temporal_format, "ON", "OFF") = VARIABLE_VALUE
65 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
66 WHERE VARIABLE_NAME='mysql56_temporal_format';
67 IF(@@global.mysql56_temporal_format, "ON", "OFF") = VARIABLE_VALUE
68 1
69 '#---------------------FN_DYNVARS_030_07----------------------#'
70 SET @@global.mysql56_temporal_format = TRUE;
71 SELECT @@global.mysql56_temporal_format;
72 @@global.mysql56_temporal_format
73 1
74 SET @@global.mysql56_temporal_format = FALSE;
75 SELECT @@global.mysql56_temporal_format;
76 @@global.mysql56_temporal_format
77 0
78 '#---------------------FN_DYNVARS_030_08----------------------#'
79 SET @@global.mysql56_temporal_format = 1;
80 SELECT @@mysql56_temporal_format = @@global.mysql56_temporal_format;
81 @@mysql56_temporal_format = @@global.mysql56_temporal_format
82 1
83 '#---------------------FN_DYNVARS_030_09----------------------#'
84 SET mysql56_temporal_format = 1;
85 ERROR HY000: Variable 'mysql56_temporal_format' is a GLOBAL variable and should be set with SET GLOBAL
86 SELECT global.mysql56_temporal_format;
87 ERROR 42S02: Unknown table 'global' in SELECT
88 SELECT mysql56_temporal_format = @@session.mysql56_temporal_format;
89 ERROR 42S22: Unknown column 'mysql56_temporal_format' in 'SELECT'
90 SET @@global.mysql56_temporal_format = @start_value;
91 SELECT @@global.mysql56_temporal_format;
92 @@global.mysql56_temporal_format
93 1