Debian Codegraph @

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

raw
1 SET GLOBAL ssl_fips_mode=0;
2 ERROR HY000: Variable 'ssl_fips_mode' is a read only variable
3 SELECT @@GLOBAL.ssl_fips_mode;
4 @@GLOBAL.ssl_fips_mode
5 OFF
6 Warnings:
7 Warning 1287 '@@ssl_fips_mode' is deprecated and will be removed in a future release.
8 SET GLOBAL ssl_fips_mode=1;
9 ERROR HY000: Variable 'ssl_fips_mode' is a read only variable
10 SELECT @@GLOBAL.ssl_fips_mode;
11 @@GLOBAL.ssl_fips_mode
12 OFF
13 Warnings:
14 Warning 1287 '@@ssl_fips_mode' is deprecated and will be removed in a future release.
15 SET GLOBAL ssl_fips_mode=2;
16 ERROR HY000: Variable 'ssl_fips_mode' is a read only variable
17 SELECT @@GLOBAL.ssl_fips_mode;
18 @@GLOBAL.ssl_fips_mode
19 OFF
20 Warnings:
21 Warning 1287 '@@ssl_fips_mode' is deprecated and will be removed in a future release.
22 SET GLOBAL ssl_fips_mode=off;
23 ERROR HY000: Variable 'ssl_fips_mode' is a read only variable
24 SELECT @@GLOBAL.ssl_fips_mode;
25 @@GLOBAL.ssl_fips_mode
26 OFF
27 Warnings:
28 Warning 1287 '@@ssl_fips_mode' is deprecated and will be removed in a future release.
29 SET GLOBAL ssl_fips_mode=on;
30 ERROR HY000: Variable 'ssl_fips_mode' is a read only variable
31 SELECT @@GLOBAL.ssl_fips_mode;
32 @@GLOBAL.ssl_fips_mode
33 OFF
34 Warnings:
35 Warning 1287 '@@ssl_fips_mode' is deprecated and will be removed in a future release.
36 SET GLOBAL ssl_fips_mode=strict;
37 ERROR HY000: Variable 'ssl_fips_mode' is a read only variable
38 SELECT @@GLOBAL.ssl_fips_mode;
39 @@GLOBAL.ssl_fips_mode
40 OFF
41 Warnings:
42 Warning 1287 '@@ssl_fips_mode' is deprecated and will be removed in a future release.
43 SET GLOBAL ssl_fips_mode='oFf';
44 ERROR HY000: Variable 'ssl_fips_mode' is a read only variable
45 SELECT @@GLOBAL.ssl_fips_mode;
46 @@GLOBAL.ssl_fips_mode
47 OFF
48 Warnings:
49 Warning 1287 '@@ssl_fips_mode' is deprecated and will be removed in a future release.
50 SET GLOBAL ssl_fips_mode='oN';
51 ERROR HY000: Variable 'ssl_fips_mode' is a read only variable
52 SELECT @@GLOBAL.ssl_fips_mode;
53 @@GLOBAL.ssl_fips_mode
54 OFF
55 Warnings:
56 Warning 1287 '@@ssl_fips_mode' is deprecated and will be removed in a future release.
57 SET GLOBAL ssl_fips_mode='Strict';
58 ERROR HY000: Variable 'ssl_fips_mode' is a read only variable
59 SELECT @@GLOBAL.ssl_fips_mode;
60 @@GLOBAL.ssl_fips_mode
61 OFF
62 Warnings:
63 Warning 1287 '@@ssl_fips_mode' is deprecated and will be removed in a future release.
64 SET GLOBAL ssl_fips_mode='';
65 ERROR HY000: Variable 'ssl_fips_mode' is a read only variable
66 SET GLOBAL ssl_fips_mode=3;
67 ERROR HY000: Variable 'ssl_fips_mode' is a read only variable
68 SET GLOBAL ssl_fips_mode=-1;
69 ERROR HY000: Variable 'ssl_fips_mode' is a read only variable
70 SET SESSION ssl_fips_mode=1;
71 ERROR HY000: Variable 'ssl_fips_mode' is a read only variable
72 CREATE USER u1 IDENTIFIED BY 'pwd';
73 ##Test: User without admin/super privilege
74 SET GLOBAL ssl_fips_mode=ON;
75 ERROR HY000: Variable 'ssl_fips_mode' is a read only variable
76 ##Test: User with admin privilege
77 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO u1;
78 SET GLOBAL ssl_fips_mode=ON;
79 ERROR HY000: Variable 'ssl_fips_mode' is a read only variable
80 REVOKE SYSTEM_VARIABLES_ADMIN ON *.* FROM u1;
81 ##Test: User with SUPER privilege
82 GRANT SUPER ON *.* TO u1;
83 Warnings:
84 Warning 1287 The SUPER privilege identifier is deprecated
85 SET GLOBAL ssl_fips_mode=ON;
86 ERROR HY000: Variable 'ssl_fips_mode' is a read only variable
87 CLEANUP
88 DROP USER u1;