Debian Codegraph @

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

raw
1 SET @start_value = @@global.mysql_native_password_proxy_users;
2 SELECT @start_value;
3 @start_value
4 0
5 '#----- 2.2.1 Default value -----------------------------------#'
6 SET @@global.mysql_native_password_proxy_users = 1;
7 SET @@global.mysql_native_password_proxy_users = DEFAULT;
8 SELECT @@global.mysql_native_password_proxy_users;
9 @@global.mysql_native_password_proxy_users
10 0
11 SET @@global.mysql_native_password_proxy_users = @start_value;
12 SELECT @@global.mysql_native_password_proxy_users = 0;
13 @@global.mysql_native_password_proxy_users = 0
14 1
15 '#----- 2.2.1 Valid values ------------------------------------#'
16 SET @@global.mysql_native_password_proxy_users = 0;
17 SELECT @@global.mysql_native_password_proxy_users;
18 @@global.mysql_native_password_proxy_users
19 0
20 SET @@global.mysql_native_password_proxy_users = 1;
21 SELECT @@global.mysql_native_password_proxy_users;
22 @@global.mysql_native_password_proxy_users
23 1
24 SET @@global.mysql_native_password_proxy_users = TRUE;
25 SELECT @@global.mysql_native_password_proxy_users;
26 @@global.mysql_native_password_proxy_users
27 1
28 SET @@global.mysql_native_password_proxy_users = FALSE;
29 SELECT @@global.mysql_native_password_proxy_users;
30 @@global.mysql_native_password_proxy_users
31 0
32 SET @@global.mysql_native_password_proxy_users = ON;
33 SELECT @@global.mysql_native_password_proxy_users;
34 @@global.mysql_native_password_proxy_users
35 1
36 SET @@global.mysql_native_password_proxy_users = OFF;
37 SELECT @@global.mysql_native_password_proxy_users;
38 @@global.mysql_native_password_proxy_users
39 0
40 '#----- 2.2.1 Invalid values -----------------------------------#'
41 SET @@global.mysql_native_password_proxy_users = -1;
42 ERROR 42000: Variable 'mysql_native_password_proxy_users' can't be set to the value of '-1'
43 SELECT @@global.mysql_native_password_proxy_users;
44 @@global.mysql_native_password_proxy_users
45 0
46 SET @@global.mysql_native_password_proxy_users = 4294967296;
47 ERROR 42000: Variable 'mysql_native_password_proxy_users' can't be set to the value of '4294967296'
48 SELECT @@global.mysql_native_password_proxy_users;
49 @@global.mysql_native_password_proxy_users
50 0
51 SET @@global.mysql_native_password_proxy_users = 10240022115;
52 ERROR 42000: Variable 'mysql_native_password_proxy_users' can't be set to the value of '10240022115'
53 SELECT @@global.mysql_native_password_proxy_users;
54 @@global.mysql_native_password_proxy_users
55 0
56 SET @@global.mysql_native_password_proxy_users = 10000.01;
57 ERROR 42000: Incorrect argument type to variable 'mysql_native_password_proxy_users'
58 SELECT @@global.mysql_native_password_proxy_users;
59 @@global.mysql_native_password_proxy_users
60 0
61 SET @@global.mysql_native_password_proxy_users = -1024;
62 ERROR 42000: Variable 'mysql_native_password_proxy_users' can't be set to the value of '-1024'
63 SELECT @@global.mysql_native_password_proxy_users;
64 @@global.mysql_native_password_proxy_users
65 0
66 SET @@global.mysql_native_password_proxy_users = 42949672950;
67 ERROR 42000: Variable 'mysql_native_password_proxy_users' can't be set to the value of '42949672950'
68 SELECT @@global.mysql_native_password_proxy_users;
69 @@global.mysql_native_password_proxy_users
70 0
71 SET @@global.mysql_native_password_proxy_users = 'test';
72 ERROR 42000: Variable 'mysql_native_password_proxy_users' can't be set to the value of 'test'
73 SELECT @@global.mysql_native_password_proxy_users;
74 @@global.mysql_native_password_proxy_users
75 0
76 '#----- 2.2.5 Session variable -----------------------------------#'
77 SET @@session.mysql_native_password_proxy_users = 0;
78 ERROR HY000: Variable 'mysql_native_password_proxy_users' is a GLOBAL variable and should be set with SET GLOBAL
79 SELECT @@mysql_native_password_proxy_users;
80 @@mysql_native_password_proxy_users
81 0
82 SELECT IF(@@global.mysql_native_password_proxy_users, "ON", "OFF") = VARIABLE_VALUE
83 FROM performance_schema.global_variables
84 WHERE VARIABLE_NAME='mysql_native_password_proxy_users';
85 IF(@@global.mysql_native_password_proxy_users, "ON", "OFF") = VARIABLE_VALUE
86 1
87 SELECT IF(@@mysql_native_password_proxy_users, "ON", "OFF") = VARIABLE_VALUE
88 FROM performance_schema.session_variables
89 WHERE VARIABLE_NAME='mysql_native_password_proxy_users';
90 IF(@@mysql_native_password_proxy_users, "ON", "OFF") = VARIABLE_VALUE
91 1
92 SET @@global.mysql_native_password_proxy_users = 1;
93 SELECT @@mysql_native_password_proxy_users = @@global.mysql_native_password_proxy_users;
94 @@mysql_native_password_proxy_users = @@global.mysql_native_password_proxy_users
95 1
96 '#----- 2.2.6 Notation with/without @@ sign --------------#'
97 SET mysql_native_password_proxy_users = 1;
98 ERROR HY000: Variable 'mysql_native_password_proxy_users' is a GLOBAL variable and should be set with SET GLOBAL
99 SELECT @@mysql_native_password_proxy_users;
100 @@mysql_native_password_proxy_users
101 1
102 SET local.mysql_native_password_proxy_users = 1;
103 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.mysql_native_password_proxy_users = 1' at line 1
104 SELECT local.mysql_native_password_proxy_users;
105 ERROR 42S02: Unknown table 'local' in field list
106 SET global.mysql_native_password_proxy_users = 1;
107 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.mysql_native_password_proxy_users = 1' at line 1
108 SELECT global.mysql_native_password_proxy_users;
109 ERROR 42S02: Unknown table 'global' in field list
110 SELECT mysql_native_password_proxy_users;
111 ERROR 42S22: Unknown column 'mysql_native_password_proxy_users' in 'field list'
112 SELECT @@session.mysql_native_password_proxy_users;
113 ERROR HY000: Variable 'mysql_native_password_proxy_users' is a GLOBAL variable
114 SET @@global.mysql_native_password_proxy_users = @start_value;
115 SELECT @@global.mysql_native_password_proxy_users;
116 @@global.mysql_native_password_proxy_users
117 0