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
