Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.old_passwords;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 SET @start_session_value = @@session.old_passwords;
6 SELECT @start_session_value;
7 @start_session_value
8 0
9 '#--------------------FN_DYNVARS_114_01-------------------------#'
10 SET @@global.old_passwords = ON;
11 SET @@global.old_passwords = DEFAULT;
12 SELECT @@global.old_passwords;
13 @@global.old_passwords
14 0
15 SET @@session.old_passwords = ON;
16 SET @@session.old_passwords = DEFAULT;
17 SELECT @@session.old_passwords;
18 @@session.old_passwords
19 0
20 '#--------------------FN_DYNVARS_114_02-------------------------#'
21 SET @@global.old_passwords = DEFAULT;
22 SELECT @@global.old_passwords = FALSE;
23 @@global.old_passwords = FALSE
24 1
25 SET @@session.old_passwords = DEFAULT;
26 SELECT @@session.old_passwords = FALSE;
27 @@session.old_passwords = FALSE
28 1
29 '#--------------------FN_DYNVARS_114_03-------------------------#'
30 SET @@global.old_passwords = ON;
31 SELECT @@global.old_passwords;
32 @@global.old_passwords
33 1
34 SET @@global.old_passwords = OFF;
35 SELECT @@global.old_passwords;
36 @@global.old_passwords
37 0
38 SET @@global.old_passwords = 0;
39 SELECT @@global.old_passwords;
40 @@global.old_passwords
41 0
42 SET @@global.old_passwords = 1;
43 SELECT @@global.old_passwords;
44 @@global.old_passwords
45 1
46 SET @@global.old_passwords = TRUE;
47 SELECT @@global.old_passwords;
48 @@global.old_passwords
49 1
50 SET @@global.old_passwords = FALSE;
51 SELECT @@global.old_passwords;
52 @@global.old_passwords
53 0
54 '#--------------------FN_DYNVARS_114_04-------------------------#'
55 SET @@session.old_passwords = ON;
56 SELECT @@session.old_passwords;
57 @@session.old_passwords
58 1
59 SET @@session.old_passwords = OFF;
60 SELECT @@session.old_passwords;
61 @@session.old_passwords
62 0
63 SET @@session.old_passwords = 0;
64 SELECT @@session.old_passwords;
65 @@session.old_passwords
66 0
67 SET @@session.old_passwords = 1;
68 SELECT @@session.old_passwords;
69 @@session.old_passwords
70 1
71 SET @@session.old_passwords = TRUE;
72 SELECT @@session.old_passwords;
73 @@session.old_passwords
74 1
75 SET @@session.old_passwords = FALSE;
76 SELECT @@session.old_passwords;
77 @@session.old_passwords
78 0
79 '#------------------FN_DYNVARS_114_05-----------------------#'
80 SET @@global.old_passwords = 'ONN';
81 ERROR 42000: Variable 'old_passwords' can't be set to the value of 'ONN'
82 SET @@global.old_passwords = "OFFF";
83 ERROR 42000: Variable 'old_passwords' can't be set to the value of 'OFFF'
84 SET @@global.old_passwords = TTRUE;
85 ERROR 42000: Variable 'old_passwords' can't be set to the value of 'TTRUE'
86 SET @@global.old_passwords = FELSE;
87 ERROR 42000: Variable 'old_passwords' can't be set to the value of 'FELSE'
88 SET @@global.old_passwords = -1024;
89 ERROR 42000: Variable 'old_passwords' can't be set to the value of '-1024'
90 SET @@global.old_passwords = 65536;
91 ERROR 42000: Variable 'old_passwords' can't be set to the value of '65536'
92 SET @@global.old_passwords = 65530.34;
93 ERROR 42000: Incorrect argument type to variable 'old_passwords'
94 SET @@global.old_passwords = test;
95 ERROR 42000: Variable 'old_passwords' can't be set to the value of 'test'
96 SET @@session.old_passwords = ONN;
97 ERROR 42000: Variable 'old_passwords' can't be set to the value of 'ONN'
98 SET @@session.old_passwords = ONF;
99 ERROR 42000: Variable 'old_passwords' can't be set to the value of 'ONF'
100 SET @@session.old_passwords = OF;
101 ERROR 42000: Variable 'old_passwords' can't be set to the value of 'OF'
102 SET @@session.old_passwords = 'OFN';
103 ERROR 42000: Variable 'old_passwords' can't be set to the value of 'OFN'
104 SET @@session.old_passwords = -2;
105 ERROR 42000: Variable 'old_passwords' can't be set to the value of '-2'
106 SET @@session.old_passwords = 65530.34;
107 ERROR 42000: Incorrect argument type to variable 'old_passwords'
108 SET @@session.old_passwords = 65550;
109 ERROR 42000: Variable 'old_passwords' can't be set to the value of '65550'
110 SET @@session.old_passwords = test;
111 ERROR 42000: Variable 'old_passwords' can't be set to the value of 'test'
112 '#------------------FN_DYNVARS_114_06-----------------------#'
113 SELECT IF(@@global.old_passwords, "ON", "OFF") = VARIABLE_VALUE
114 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
115 WHERE VARIABLE_NAME='old_passwords';
116 IF(@@global.old_passwords, "ON", "OFF") = VARIABLE_VALUE
117 1
118 '#------------------FN_DYNVARS_114_07-----------------------#'
119 SELECT IF(@@session.old_passwords, "ON", "OFF") = VARIABLE_VALUE
120 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
121 WHERE VARIABLE_NAME='old_passwords';
122 IF(@@session.old_passwords, "ON", "OFF") = VARIABLE_VALUE
123 1
124 '#---------------------FN_DYNVARS_114_08----------------------#'
125 SET @@old_passwords = OFF;
126 SET @@global.old_passwords = ON;
127 SELECT @@old_passwords = @@global.old_passwords;
128 @@old_passwords = @@global.old_passwords
129 0
130 '#---------------------FN_DYNVARS_114_09----------------------#'
131 SET @@old_passwords = ON;
132 SELECT @@old_passwords = @@local.old_passwords;
133 @@old_passwords = @@local.old_passwords
134 1
135 SELECT @@local.old_passwords = @@session.old_passwords;
136 @@local.old_passwords = @@session.old_passwords
137 1
138 '#---------------------FN_DYNVARS_114_10----------------------#'
139 SET old_passwords = 1;
140 SELECT @@old_passwords;
141 @@old_passwords
142 1
143 SELECT local.old_passwords;
144 ERROR 42S02: Unknown table 'local' in SELECT
145 SELECT session.old_passwords;
146 ERROR 42S02: Unknown table 'session' in SELECT
147 SELECT old_passwords = @@session.old_passwords;
148 ERROR 42S22: Unknown column 'old_passwords' in 'SELECT'
149 SET @@global.old_passwords = @start_global_value;
150 SELECT @@global.old_passwords;
151 @@global.old_passwords
152 0
153 SET @@session.old_passwords = @start_session_value;
154 SELECT @@session.old_passwords;
155 @@session.old_passwords
156 0