Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.secure_auth;
2 SELECT @global_start_value;
3 @global_start_value
4 1
5 '#--------------------FN_DYNVARS_143_01------------------------#'
6 SET @@global.secure_auth = 1;
7 Warnings:
8 Warning 1287 '@@secure_auth' is deprecated and will be removed in a future release
9 SET @@global.secure_auth = DEFAULT;
10 Warnings:
11 Warning 1287 '@@secure_auth' is deprecated and will be removed in a future release
12 SELECT @@global.secure_auth;
13 @@global.secure_auth
14 1
15 '#---------------------FN_DYNVARS_143_02-------------------------#'
16 SET secure_auth = 1;
17 ERROR HY000: Variable 'secure_auth' is a GLOBAL variable and should be set with SET GLOBAL
18 SELECT @@secure_auth;
19 @@secure_auth
20 1
21 SELECT global.secure_auth;
22 ERROR 42S02: Unknown table 'global' in SELECT
23 SET global secure_auth = 1;
24 Warnings:
25 Warning 1287 '@@secure_auth' is deprecated and will be removed in a future release
26 SELECT @@global.secure_auth;
27 @@global.secure_auth
28 1
29 '#--------------------FN_DYNVARS_143_03------------------------#'
30 SET @@global.secure_auth = 0;
31 Warnings:
32 Warning 1287 '@@secure_auth' is deprecated and will be removed in a future release
33 SELECT @@global.secure_auth;
34 @@global.secure_auth
35 0
36 SET @@global.secure_auth = 1;
37 Warnings:
38 Warning 1287 '@@secure_auth' is deprecated and will be removed in a future release
39 SELECT @@global.secure_auth;
40 @@global.secure_auth
41 1
42 '#--------------------FN_DYNVARS_143_04-------------------------#'
43 SET @@global.secure_auth = -1;
44 ERROR 42000: Variable 'secure_auth' can't be set to the value of '-1'
45 SET @@global.secure_auth = 2;
46 ERROR 42000: Variable 'secure_auth' can't be set to the value of '2'
47 SET @@global.secure_auth = "T";
48 ERROR 42000: Variable 'secure_auth' can't be set to the value of 'T'
49 SET @@global.secure_auth = "Y";
50 ERROR 42000: Variable 'secure_auth' can't be set to the value of 'Y'
51 SET @@global.secure_auth = YES;
52 ERROR 42000: Variable 'secure_auth' can't be set to the value of 'YES'
53 SET @@global.secure_auth = ONN;
54 ERROR 42000: Variable 'secure_auth' can't be set to the value of 'ONN'
55 SET @@global.secure_auth = OOF;
56 ERROR 42000: Variable 'secure_auth' can't be set to the value of 'OOF'
57 SET @@global.secure_auth = 0FF;
58 ERROR 42000: Variable 'secure_auth' can't be set to the value of '0FF'
59 SET @@global.secure_auth = ' 1';
60 ERROR 42000: Variable 'secure_auth' can't be set to the value of ' 1'
61 SET @@global.secure_auth = NO;
62 ERROR 42000: Variable 'secure_auth' can't be set to the value of 'NO'
63 '#-------------------FN_DYNVARS_143_05----------------------------#'
64 SET @@session.secure_auth = 0;
65 ERROR HY000: Variable 'secure_auth' is a GLOBAL variable and should be set with SET GLOBAL
66 SET @@secure_auth = 0;
67 ERROR HY000: Variable 'secure_auth' is a GLOBAL variable and should be set with SET GLOBAL
68 SET @@local.secure_auth = 0;
69 ERROR HY000: Variable 'secure_auth' is a GLOBAL variable and should be set with SET GLOBAL
70 SELECT @@session.secure_auth;
71 ERROR HY000: Variable 'secure_auth' is a GLOBAL variable
72 SELECT @@local.secure_auth;
73 ERROR HY000: Variable 'secure_auth' is a GLOBAL variable
74 '#----------------------FN_DYNVARS_143_06------------------------#'
75 SELECT count(VARIABLE_VALUE)
76 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
77 WHERE VARIABLE_NAME='secure_auth';
78 count(VARIABLE_VALUE)
79 1
80 '#----------------------FN_DYNVARS_143_07------------------------#'
81 SELECT IF(@@global.secure_auth, "ON", "OFF") = VARIABLE_VALUE
82 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
83 WHERE VARIABLE_NAME='secure_auth';
84 IF(@@global.secure_auth, "ON", "OFF") = VARIABLE_VALUE
85 1
86 SELECT @@global.secure_auth;
87 @@global.secure_auth
88 1
89 SELECT VARIABLE_VALUE
90 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
91 WHERE VARIABLE_NAME='secure_auth';
92 VARIABLE_VALUE
93 ON
94 '#---------------------FN_DYNVARS_143_08-------------------------#'
95 SET @@global.secure_auth = OFF;
96 Warnings:
97 Warning 1287 '@@secure_auth' is deprecated and will be removed in a future release
98 SELECT @@global.secure_auth;
99 @@global.secure_auth
100 0
101 SET @@global.secure_auth = ON;
102 Warnings:
103 Warning 1287 '@@secure_auth' is deprecated and will be removed in a future release
104 SELECT @@global.secure_auth;
105 @@global.secure_auth
106 1
107 '#---------------------FN_DYNVARS_143_09----------------------#'
108 SET @@global.secure_auth = TRUE;
109 Warnings:
110 Warning 1287 '@@secure_auth' is deprecated and will be removed in a future release
111 SELECT @@global.secure_auth;
112 @@global.secure_auth
113 1
114 SET @@global.secure_auth = FALSE;
115 Warnings:
116 Warning 1287 '@@secure_auth' is deprecated and will be removed in a future release
117 SELECT @@global.secure_auth;
118 @@global.secure_auth
119 0
120 SET @@global.secure_auth = @global_start_value;
121 Warnings:
122 Warning 1287 '@@secure_auth' is deprecated and will be removed in a future release
123 SELECT @@global.secure_auth;
124 @@global.secure_auth
125 1