Edit File: wl6443_deprecation.result
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