Debian Codegraph @

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

raw
1 #
2 # Tests for WL#12086: Cryptographically signed SET statements
3 #
4 # Testing FR2
5 # must be /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
6 SELECT @@GLOBAL.persist_only_admin_x509_subject;
7 @@GLOBAL.persist_only_admin_x509_subject
8 /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
9 SET PERSIST_ONLY auto_generate_certs = DEFAULT;
10 SET PERSIST_ONLY basedir = DEFAULT;
11 SET PERSIST_ONLY bind_address = DEFAULT;
12 SET PERSIST_ONLY character_sets_dir = DEFAULT;
13 SET PERSIST_ONLY datadir = DEFAULT;
14 SET PERSIST_ONLY default_authentication_plugin = DEFAULT;
15 Warnings:
16 Warning 1287 '@@default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
17 SET PERSIST_ONLY ft_stopword_file = DEFAULT;
18 SET PERSIST_ONLY init_file = DEFAULT;
19 SET PERSIST_ONLY keyring_operations = DEFAULT;
20 SET PERSIST_ONLY lc_messages_dir = DEFAULT;
21 SET PERSIST_ONLY log_bin_use_v1_row_events = DEFAULT;
22 Warnings:
23 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
24 SET PERSIST_ONLY log_error = DEFAULT;
25 SET PERSIST_ONLY pid_file = DEFAULT;
26 SET PERSIST_ONLY plugin_dir = DEFAULT;
27 SET PERSIST_ONLY port = DEFAULT;
28 SET PERSIST_ONLY relay_log = DEFAULT;
29 SET PERSIST_ONLY relay_log_info_file = DEFAULT;
30 Warnings:
31 Warning 1287 '@@relay_log_info_file' is deprecated and will be removed in a future release.
32 SET PERSIST_ONLY secure_file_priv = DEFAULT;
33 SET PERSIST_ONLY skip_networking = DEFAULT;
34 SET PERSIST_ONLY replica_load_tmpdir = DEFAULT;
35 SET PERSIST_ONLY socket = DEFAULT;
36 SET PERSIST_ONLY tmpdir = DEFAULT;
37 SET PERSIST_ONLY caching_sha2_password_auto_generate_rsa_keys = DEFAULT;
38 SET PERSIST_ONLY caching_sha2_password_private_key_path = DEFAULT;
39 SET PERSIST_ONLY caching_sha2_password_public_key_path = DEFAULT;
40 SET PERSIST_ONLY innodb_buffer_pool_load_at_startup = DEFAULT;
41 SET PERSIST_ONLY innodb_data_file_path = DEFAULT;
42 SET PERSIST_ONLY innodb_data_home_dir = DEFAULT;
43 SET PERSIST_ONLY innodb_dedicated_server = DEFAULT;
44 SET PERSIST_ONLY innodb_directories = DEFAULT;
45 SET PERSIST_ONLY innodb_log_group_home_dir = DEFAULT;
46 SET PERSIST_ONLY innodb_page_size = DEFAULT;
47 SET PERSIST_ONLY innodb_read_only = DEFAULT;
48 SET PERSIST_ONLY innodb_temp_data_file_path = DEFAULT;
49 SET PERSIST_ONLY innodb_temp_tablespaces_dir = DEFAULT;
50 SET PERSIST_ONLY innodb_undo_directory = DEFAULT;
51 SET PERSIST_ONLY innodb_undo_tablespaces = DEFAULT;
52 SET PERSIST_ONLY sha256_password_auto_generate_rsa_keys = DEFAULT;
53 SET PERSIST_ONLY sha256_password_private_key_path = DEFAULT;
54 SET PERSIST_ONLY sha256_password_public_key_path = DEFAULT;
55 SET PERSIST_ONLY innodb_force_load_corrupted = DEFAULT;
56 # Following variables will never be settable
57 SET PERSIST_ONLY innodb_version = DEFAULT;
58 ERROR HY000: Variable 'innodb_version' is a non persistent read only variable
59 SET PERSIST_ONLY persisted_globals_load = DEFAULT;
60 ERROR HY000: Variable 'persisted_globals_load' is a non persistent read only variable
61 SET PERSIST_ONLY character_set_system = DEFAULT;
62 ERROR HY000: Variable 'character_set_system' is a non persistent read only variable
63 SET PERSIST_ONLY core_file = DEFAULT;
64 ERROR HY000: Variable 'core_file' is a non persistent read only variable
65 SET PERSIST_ONLY have_statement_timeout = DEFAULT;
66 ERROR HY000: Variable 'have_statement_timeout' is a non persistent read only variable
67 SET PERSIST_ONLY have_symlink = DEFAULT;
68 ERROR HY000: Variable 'have_symlink' is a non persistent read only variable
69 SET PERSIST_ONLY hostname = DEFAULT;
70 ERROR HY000: Variable 'hostname' is a non persistent read only variable
71 SET PERSIST_ONLY large_files_support = DEFAULT;
72 ERROR HY000: Variable 'large_files_support' is a non persistent read only variable
73 SET PERSIST_ONLY large_page_size = DEFAULT;
74 ERROR HY000: Variable 'large_page_size' is a non persistent read only variable
75 SET PERSIST_ONLY license = DEFAULT;
76 ERROR HY000: Variable 'license' is a non persistent read only variable
77 SET PERSIST_ONLY log_bin = DEFAULT;
78 ERROR HY000: Variable 'log_bin' is a non persistent read only variable
79 SET PERSIST_ONLY log_bin_basename = DEFAULT;
80 ERROR HY000: Variable 'log_bin_basename' is a non persistent read only variable
81 SET PERSIST_ONLY log_bin_index = DEFAULT;
82 ERROR HY000: Variable 'log_bin_index' is a non persistent read only variable
83 SET PERSIST_ONLY lower_case_file_system = DEFAULT;
84 ERROR HY000: Variable 'lower_case_file_system' is a non persistent read only variable
85 SET PERSIST_ONLY protocol_version = DEFAULT;
86 ERROR HY000: Variable 'protocol_version' is a non persistent read only variable
87 SET PERSIST_ONLY relay_log_basename = DEFAULT;
88 ERROR HY000: Variable 'relay_log_basename' is a non persistent read only variable
89 SET PERSIST_ONLY relay_log_index = DEFAULT;
90 ERROR HY000: Variable 'relay_log_index' is a non persistent read only variable
91 SET PERSIST_ONLY server_uuid = DEFAULT;
92 ERROR HY000: Variable 'server_uuid' is a non persistent read only variable
93 SET PERSIST_ONLY skip_external_locking = DEFAULT;
94 ERROR HY000: Variable 'skip_external_locking' is a non persistent read only variable
95 SET PERSIST_ONLY system_time_zone = DEFAULT;
96 ERROR HY000: Variable 'system_time_zone' is a non persistent read only variable
97 SET PERSIST_ONLY version_comment = DEFAULT;
98 ERROR HY000: Variable 'version_comment' is a non persistent read only variable
99 SET PERSIST_ONLY version_compile_machine = DEFAULT;
100 ERROR HY000: Variable 'version_compile_machine' is a non persistent read only variable
101 SET PERSIST_ONLY version_compile_os = DEFAULT;
102 ERROR HY000: Variable 'version_compile_os' is a non persistent read only variable
103 SET PERSIST_ONLY version_compile_zlib = DEFAULT;
104 ERROR HY000: Variable 'version_compile_zlib' is a non persistent read only variable
105 # Cleanup
106 RESET PERSIST;
107 #
108 # BUG#28589736: PID_FILE OPTION MUST NOT HAVE DEFAULT VALUE AS NULL
109 #
110 SET PERSIST_ONLY pid_file = DEFAULT;
111 include/assert_grep.inc [Check mysqld-auto.cnf for "pid_file" value]
112 # Cleanup
113 RESET PERSIST;