Debian Codegraph @

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

raw
1 #
2 # Tests for WL#12086: Cryptographically signed SET statements
3 #
4 # Testing FR1 and FR1.5.
5 # Must be empty
6 SELECT @@GLOBAL.persist_only_admin_x509_subject;
7 @@GLOBAL.persist_only_admin_x509_subject
8
9 SELECT @@SESSION.persist_only_admin_x509_subject;
10 ERROR HY000: Variable 'persist_only_admin_x509_subject' is a GLOBAL variable
11 # Testing FR1.1.
12 SET GLOBAL persist_only_admin_x509_subject = 'haha';
13 ERROR HY000: Variable 'persist_only_admin_x509_subject' is a read only variable
14 SET SESSION persist_only_admin_x509_subject = 'haha';
15 ERROR HY000: Variable 'persist_only_admin_x509_subject' is a read only variable
16 # Testing FR1.2.
17 SELECT CHARSET(@@global.persist_only_admin_x509_subject);
18 CHARSET(@@global.persist_only_admin_x509_subject)
19 utf8mb3
20 # Testing FR1.4.
21 SET PERSIST_ONLY persist_only_admin_x509_subject = 'persist_only';
22 ERROR HY000: Variable 'persist_only_admin_x509_subject' is a non persistent read only variable
23 # Testing FR3
24 # Must be empty
25 SELECT @@GLOBAL.persist_only_admin_x509_subject;
26 @@GLOBAL.persist_only_admin_x509_subject
27
28 SET PERSIST_ONLY auto_generate_certs = DEFAULT;
29 ERROR HY000: Variable 'auto_generate_certs' is a non persistent read only variable
30 SET PERSIST_ONLY basedir = DEFAULT;
31 ERROR HY000: Variable 'basedir' is a non persistent read only variable
32 SET PERSIST_ONLY bind_address = DEFAULT;
33 ERROR HY000: Variable 'bind_address' is a non persistent read only variable
34 SET PERSIST_ONLY character_sets_dir = DEFAULT;
35 ERROR HY000: Variable 'character_sets_dir' is a non persistent read only variable
36 SET PERSIST_ONLY datadir = DEFAULT;
37 ERROR HY000: Variable 'datadir' is a non persistent read only variable
38 SET PERSIST_ONLY default_authentication_plugin = DEFAULT;
39 ERROR HY000: Variable 'default_authentication_plugin' is a non persistent read only variable
40 SET PERSIST_ONLY ft_stopword_file = DEFAULT;
41 ERROR HY000: Variable 'ft_stopword_file' is a non persistent read only variable
42 SET PERSIST_ONLY init_file = DEFAULT;
43 ERROR HY000: Variable 'init_file' is a non persistent read only variable
44 SET PERSIST_ONLY keyring_operations = DEFAULT;
45 ERROR HY000: Variable 'keyring_operations' is a non persistent variable
46 SET PERSIST_ONLY lc_messages_dir = DEFAULT;
47 ERROR HY000: Variable 'lc_messages_dir' is a non persistent read only variable
48 SET PERSIST_ONLY log_bin_use_v1_row_events = DEFAULT;
49 ERROR HY000: Variable 'log_bin_use_v1_row_events' is a non persistent variable
50 SET PERSIST_ONLY log_error = DEFAULT;
51 ERROR HY000: Variable 'log_error' is a non persistent read only variable
52 SET PERSIST_ONLY pid_file = DEFAULT;
53 ERROR HY000: Variable 'pid_file' is a non persistent read only variable
54 SET PERSIST_ONLY plugin_dir = DEFAULT;
55 ERROR HY000: Variable 'plugin_dir' is a non persistent read only variable
56 SET PERSIST_ONLY port = DEFAULT;
57 ERROR HY000: Variable 'port' is a non persistent read only variable
58 SET PERSIST_ONLY relay_log = DEFAULT;
59 ERROR HY000: Variable 'relay_log' is a non persistent read only variable
60 SET PERSIST_ONLY relay_log_info_file = DEFAULT;
61 ERROR HY000: Variable 'relay_log_info_file' is a non persistent read only variable
62 SET PERSIST_ONLY secure_file_priv = DEFAULT;
63 ERROR HY000: Variable 'secure_file_priv' is a non persistent read only variable
64 SET PERSIST_ONLY skip_networking = DEFAULT;
65 ERROR HY000: Variable 'skip_networking' is a non persistent read only variable
66 SET PERSIST_ONLY replica_load_tmpdir = DEFAULT;
67 ERROR HY000: Variable 'replica_load_tmpdir' is a non persistent read only variable
68 SET PERSIST_ONLY socket = DEFAULT;
69 ERROR HY000: Variable 'socket' is a non persistent read only variable
70 SET PERSIST_ONLY tmpdir = DEFAULT;
71 ERROR HY000: Variable 'tmpdir' is a non persistent read only variable
72 SET PERSIST_ONLY caching_sha2_password_auto_generate_rsa_keys = DEFAULT;
73 ERROR HY000: Variable 'caching_sha2_password_auto_generate_rsa_keys' is a non persistent read only variable
74 SET PERSIST_ONLY caching_sha2_password_private_key_path = DEFAULT;
75 ERROR HY000: Variable 'caching_sha2_password_private_key_path' is a non persistent read only variable
76 SET PERSIST_ONLY caching_sha2_password_public_key_path = DEFAULT;
77 ERROR HY000: Variable 'caching_sha2_password_public_key_path' is a non persistent read only variable
78 SET PERSIST_ONLY innodb_buffer_pool_load_at_startup = DEFAULT;
79 ERROR HY000: Variable 'innodb_buffer_pool_load_at_startup' is a non persistent read only variable
80 SET PERSIST_ONLY innodb_data_file_path = DEFAULT;
81 ERROR HY000: Variable 'innodb_data_file_path' is a non persistent read only variable
82 SET PERSIST_ONLY innodb_data_home_dir = DEFAULT;
83 ERROR HY000: Variable 'innodb_data_home_dir' is a non persistent read only variable
84 SET PERSIST_ONLY innodb_dedicated_server = DEFAULT;
85 ERROR HY000: Variable 'innodb_dedicated_server' is a non persistent read only variable
86 SET PERSIST_ONLY innodb_directories = DEFAULT;
87 ERROR HY000: Variable 'innodb_directories' is a non persistent read only variable
88 SET PERSIST_ONLY innodb_log_group_home_dir = DEFAULT;
89 ERROR HY000: Variable 'innodb_log_group_home_dir' is a non persistent read only variable
90 SET PERSIST_ONLY innodb_page_size = DEFAULT;
91 ERROR HY000: Variable 'innodb_page_size' is a non persistent read only variable
92 SET PERSIST_ONLY innodb_read_only = DEFAULT;
93 ERROR HY000: Variable 'innodb_read_only' is a non persistent read only variable
94 SET PERSIST_ONLY innodb_temp_data_file_path = DEFAULT;
95 ERROR HY000: Variable 'innodb_temp_data_file_path' is a non persistent read only variable
96 SET PERSIST_ONLY innodb_temp_tablespaces_dir = DEFAULT;
97 ERROR HY000: Variable 'innodb_temp_tablespaces_dir' is a non persistent read only variable
98 SET PERSIST_ONLY innodb_undo_directory = DEFAULT;
99 ERROR HY000: Variable 'innodb_undo_directory' is a non persistent read only variable
100 SET PERSIST_ONLY innodb_undo_tablespaces = DEFAULT;
101 ERROR HY000: Variable 'innodb_undo_tablespaces' is a non persistent variable
102 SET PERSIST_ONLY sha256_password_auto_generate_rsa_keys = DEFAULT;
103 ERROR HY000: Variable 'sha256_password_auto_generate_rsa_keys' is a non persistent read only variable
104 SET PERSIST_ONLY sha256_password_private_key_path = DEFAULT;
105 ERROR HY000: Variable 'sha256_password_private_key_path' is a non persistent read only variable
106 SET PERSIST_ONLY sha256_password_public_key_path = DEFAULT;
107 ERROR HY000: Variable 'sha256_password_public_key_path' is a non persistent read only variable
108 SET PERSIST_ONLY innodb_force_load_corrupted = DEFAULT;
109 ERROR HY000: Variable 'innodb_force_load_corrupted' is a non persistent read only variable
110 # Following variables will never be settable
111 SET PERSIST_ONLY innodb_version = DEFAULT;
112 ERROR HY000: Variable 'innodb_version' is a non persistent read only variable
113 SET PERSIST_ONLY persisted_globals_load = DEFAULT;
114 ERROR HY000: Variable 'persisted_globals_load' is a non persistent read only variable
115 SET PERSIST_ONLY character_set_system = DEFAULT;
116 ERROR HY000: Variable 'character_set_system' is a non persistent read only variable
117 SET PERSIST_ONLY core_file = DEFAULT;
118 ERROR HY000: Variable 'core_file' is a non persistent read only variable
119 SET PERSIST_ONLY have_statement_timeout = DEFAULT;
120 ERROR HY000: Variable 'have_statement_timeout' is a non persistent read only variable
121 SET PERSIST_ONLY have_symlink = DEFAULT;
122 ERROR HY000: Variable 'have_symlink' is a non persistent read only variable
123 SET PERSIST_ONLY hostname = DEFAULT;
124 ERROR HY000: Variable 'hostname' is a non persistent read only variable
125 SET PERSIST_ONLY large_files_support = DEFAULT;
126 ERROR HY000: Variable 'large_files_support' is a non persistent read only variable
127 SET PERSIST_ONLY large_page_size = DEFAULT;
128 ERROR HY000: Variable 'large_page_size' is a non persistent read only variable
129 SET PERSIST_ONLY license = DEFAULT;
130 ERROR HY000: Variable 'license' is a non persistent read only variable
131 SET PERSIST_ONLY log_bin = DEFAULT;
132 ERROR HY000: Variable 'log_bin' is a non persistent read only variable
133 SET PERSIST_ONLY log_bin_basename = DEFAULT;
134 ERROR HY000: Variable 'log_bin_basename' is a non persistent read only variable
135 SET PERSIST_ONLY log_bin_index = DEFAULT;
136 ERROR HY000: Variable 'log_bin_index' is a non persistent read only variable
137 SET PERSIST_ONLY lower_case_file_system = DEFAULT;
138 ERROR HY000: Variable 'lower_case_file_system' is a non persistent read only variable
139 SET PERSIST_ONLY protocol_version = DEFAULT;
140 ERROR HY000: Variable 'protocol_version' is a non persistent read only variable
141 SET PERSIST_ONLY relay_log_basename = DEFAULT;
142 ERROR HY000: Variable 'relay_log_basename' is a non persistent read only variable
143 SET PERSIST_ONLY relay_log_index = DEFAULT;
144 ERROR HY000: Variable 'relay_log_index' is a non persistent read only variable
145 SET PERSIST_ONLY server_uuid = DEFAULT;
146 ERROR HY000: Variable 'server_uuid' is a non persistent read only variable
147 SET PERSIST_ONLY skip_external_locking = DEFAULT;
148 ERROR HY000: Variable 'skip_external_locking' is a non persistent read only variable
149 SET PERSIST_ONLY system_time_zone = DEFAULT;
150 ERROR HY000: Variable 'system_time_zone' is a non persistent read only variable
151 SET PERSIST_ONLY version_comment = DEFAULT;
152 ERROR HY000: Variable 'version_comment' is a non persistent read only variable
153 SET PERSIST_ONLY version_compile_machine = DEFAULT;
154 ERROR HY000: Variable 'version_compile_machine' is a non persistent read only variable
155 SET PERSIST_ONLY version_compile_os = DEFAULT;
156 ERROR HY000: Variable 'version_compile_os' is a non persistent read only variable
157 SET PERSIST_ONLY version_compile_zlib = DEFAULT;
158 ERROR HY000: Variable 'version_compile_zlib' is a non persistent read only variable