/usr/lib/mysql-testsuite/r/wl6443_deprecation.result is in percona-server-test-5.6 5.6.22-rel71.0-0ubuntu4.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 | CALL mtr.add_suppression("Dictionary file not specified");
#
# Tests for deprecation warnings introduced by wl#6443
#
# System variables
select @@global.max_tmp_tables;
@@global.max_tmp_tables
32
Warnings:
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
select @@local.max_tmp_tables;
@@local.max_tmp_tables
32
Warnings:
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
set @default_max_tmp_tables= @@global.max_tmp_tables;
Warnings:
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
select @@global.date_format;
@@global.date_format
%Y-%m-%d
Warnings:
Warning 1287 '@@date_format' is deprecated and will be removed in a future release.
select @@global.time_format;
@@global.time_format
%H:%i:%s
Warnings:
Warning 1287 '@@time_format' is deprecated and will be removed in a future release.
select @@global.datetime_format;
@@global.datetime_format
%Y-%m-%d %H:%i:%s
Warnings:
Warning 1287 '@@datetime_format' is deprecated and will be removed in a future release.
set @@global.max_tmp_tables= 64;
Warnings:
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
set @@global.max_tmp_tables= @@global.max_tmp_tables;
Warnings:
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
set @@global.max_tmp_tables= @default_max_tmp_tables;
Warnings:
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
select @@global.profiling;
@@global.profiling
0
Warnings:
Warning 1287 '@@profiling' is deprecated and will be removed in a future release.
select @@local.profiling;
@@local.profiling
0
Warnings:
Warning 1287 '@@profiling' is deprecated and will be removed in a future release.
select @@global.profiling_history_size;
@@global.profiling_history_size
15
Warnings:
Warning 1287 '@@profiling_history_size' is deprecated and will be removed in a future release.
select @@local.profiling_history_size;
@@local.profiling_history_size
15
Warnings:
Warning 1287 '@@profiling_history_size' is deprecated and will be removed in a future release.
select @@global.have_profiling;
@@global.have_profiling
YES
Warnings:
Warning 1287 '@@have_profiling' is deprecated and will be removed in a future release.
set @@local.profiling= @@global.profiling;
Warnings:
Warning 1287 '@@profiling' is deprecated and will be removed in a future release.
Warning 1287 '@@profiling' is deprecated and will be removed in a future release.
set @@local.profiling_history_size= @@global.profiling_history_size;
Warnings:
Warning 1287 '@@profiling_history_size' is deprecated and will be removed in a future release.
Warning 1287 '@@profiling_history_size' is deprecated and will be removed in a future release.
set @wl6443_have_profiling= @@global.have_profiling;
Warnings:
Warning 1287 '@@have_profiling' is deprecated and will be removed in a future release.
# SHOW PROFILE and SHOW PROFILES
SHOW PROFILE;
Status Duration
Warnings:
Warning 1287 'SHOW PROFILE' is deprecated and will be removed in a future release. Please use Performance Schema instead
SHOW PROFILE ALL;
Status Duration CPU_user CPU_system Context_voluntary Context_involuntary Block_ops_in Block_ops_out Messages_sent Messages_received Page_faults_major Page_faults_minor Swaps Source_function Source_file Source_line
Warnings:
Warning 1287 'SHOW PROFILE' is deprecated and will be removed in a future release. Please use Performance Schema instead
SHOW PROFILE IPC;
Status Duration Messages_sent Messages_received
Warnings:
Warning 1287 'SHOW PROFILE' is deprecated and will be removed in a future release. Please use Performance Schema instead
SHOW PROFILES;
Query_ID Duration Query
Warnings:
Warning 1287 'SHOW PROFILES' is deprecated and will be removed in a future release. Please use Performance Schema instead
# --plugin-xyz
INSTALL PLUGIN validate_password SONAME 'validate_password.so';
# restarting the server
# Restart server.
UNINSTALL PLUGIN validate_password;
# Search for deprecation warnings in error log.
# YMMDD HH:MM:SS [Warning] The syntax 'plugin-validate-password-length' is deprecated and will be removed in a future release. Please use validate-password-length instead.
Deprecation warning count : 1
# Host table deprecation
select count(*) from information_schema.tables where table_name like 'host' and table_schema like 'mysql' and table_type like 'BASE TABLE';
count(*)
0
create table mysql.host(c1 int) engine MyISAM;
insert into mysql.host values(1);
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slave_master_info OK
mysql.slave_relay_log_info OK
mysql.slave_worker_info OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Warning: Using a password on the command line interface can be insecure.
Warning 1642 Table mysql.host is not empty. It is deprecated and will be removed in a future release.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
mtr.global_suppressions OK
mtr.test_suppressions OK
drop table mysql.host;
create view mysql.host as select HOST from mysql.db;
create user 'wl6443_u1'@'10.10.10.1' identified by 'sql';
select count(*) from mysql.host;
count(*)
2
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slave_master_info OK
mysql.slave_relay_log_info OK
mysql.slave_worker_info OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
mtr.global_suppressions OK
mtr.test_suppressions OK
drop view mysql.host;
drop user 'wl6443_u1'@'10.10.10.1';
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slave_master_info OK
mysql.slave_relay_log_info OK
mysql.slave_worker_info OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
mtr.global_suppressions OK
mtr.test_suppressions OK
|