1CALL mtr.add_suppression("Dictionary file not specified"); 2# 3# Tests for deprecation warnings introduced by wl#6443 4# 5# System variables 6select @@global.max_tmp_tables; 7@@global.max_tmp_tables 832 9Warnings: 10Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 11select @@local.max_tmp_tables; 12@@local.max_tmp_tables 1332 14Warnings: 15Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 16set @default_max_tmp_tables= @@global.max_tmp_tables; 17Warnings: 18Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 19select @@global.date_format; 20@@global.date_format 21%Y-%m-%d 22Warnings: 23Warning 1287 '@@date_format' is deprecated and will be removed in a future release. 24select @@global.time_format; 25@@global.time_format 26%H:%i:%s 27Warnings: 28Warning 1287 '@@time_format' is deprecated and will be removed in a future release. 29select @@global.datetime_format; 30@@global.datetime_format 31%Y-%m-%d %H:%i:%s 32Warnings: 33Warning 1287 '@@datetime_format' is deprecated and will be removed in a future release. 34set @@global.max_tmp_tables= 64; 35Warnings: 36Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 37set @@global.max_tmp_tables= @@global.max_tmp_tables; 38Warnings: 39Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 40Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 41set @@global.max_tmp_tables= @default_max_tmp_tables; 42Warnings: 43Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 44select @@global.profiling; 45@@global.profiling 460 47Warnings: 48Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 49select @@local.profiling; 50@@local.profiling 510 52Warnings: 53Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 54select @@global.profiling_history_size; 55@@global.profiling_history_size 5615 57Warnings: 58Warning 1287 '@@profiling_history_size' is deprecated and will be removed in a future release. 59select @@local.profiling_history_size; 60@@local.profiling_history_size 6115 62Warnings: 63Warning 1287 '@@profiling_history_size' is deprecated and will be removed in a future release. 64select @@global.have_profiling; 65@@global.have_profiling 66YES 67Warnings: 68Warning 1287 '@@have_profiling' is deprecated and will be removed in a future release. 69set @@local.profiling= @@global.profiling; 70Warnings: 71Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 72Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 73set @@local.profiling_history_size= @@global.profiling_history_size; 74Warnings: 75Warning 1287 '@@profiling_history_size' is deprecated and will be removed in a future release. 76Warning 1287 '@@profiling_history_size' is deprecated and will be removed in a future release. 77set @wl6443_have_profiling= @@global.have_profiling; 78Warnings: 79Warning 1287 '@@have_profiling' is deprecated and will be removed in a future release. 80# SHOW PROFILE and SHOW PROFILES 81SHOW PROFILE; 82Status Duration 83Warnings: 84Warning 1287 'SHOW PROFILE' is deprecated and will be removed in a future release. Please use Performance Schema instead 85SHOW PROFILE ALL; 86Status 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 87Warnings: 88Warning 1287 'SHOW PROFILE' is deprecated and will be removed in a future release. Please use Performance Schema instead 89SHOW PROFILE IPC; 90Status Duration Messages_sent Messages_received 91Warnings: 92Warning 1287 'SHOW PROFILE' is deprecated and will be removed in a future release. Please use Performance Schema instead 93SHOW PROFILES; 94Query_ID Duration Query 95Warnings: 96Warning 1287 'SHOW PROFILES' is deprecated and will be removed in a future release. Please use Performance Schema instead 97# --plugin-xyz 98INSTALL PLUGIN validate_password SONAME 'validate_password.so'; 99# restarting the server 100# Restart server. 101UNINSTALL PLUGIN validate_password; 102# Search for deprecation warnings in error log. 103# 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. 104Deprecation warning count : 1 105# Host table deprecation 106select count(*) from information_schema.tables where table_name like 'host' and table_schema like 'mysql' and table_type like 'BASE TABLE'; 107count(*) 1080 109create table mysql.host(c1 int) engine MyISAM; 110insert into mysql.host values(1); 111mysql_upgrade: (non fatal) [WARNING] 1642: Table mysql.host is not empty. It is deprecated and will be removed in a future release. 112mysql.columns_priv OK 113mysql.db OK 114mysql.engine_cost OK 115mysql.event OK 116mysql.func OK 117mysql.general_log OK 118mysql.gtid_executed OK 119mysql.help_category OK 120mysql.help_keyword OK 121mysql.help_relation OK 122mysql.help_topic OK 123mysql.host OK 124mysql.innodb_index_stats OK 125mysql.innodb_table_stats OK 126mysql.ndb_binlog_index OK 127mysql.plugin OK 128mysql.proc OK 129mysql.procs_priv OK 130mysql.proxies_priv OK 131mysql.server_cost OK 132mysql.servers OK 133mysql.slave_master_info OK 134mysql.slave_relay_log_info OK 135mysql.slave_worker_info OK 136mysql.slow_log OK 137mysql.tables_priv OK 138mysql.time_zone OK 139mysql.time_zone_leap_second OK 140mysql.time_zone_name OK 141mysql.time_zone_transition OK 142mysql.time_zone_transition_type OK 143mysql.user OK 144mtr.global_suppressions OK 145mtr.test_suppressions OK 146sys.sys_config OK 147drop table mysql.host; 148create view mysql.host as select HOST from mysql.db; 149create user 'wl6443_u1'@'10.10.10.1' identified by 'sql'; 150select count(*) from mysql.host; 151count(*) 1524 153mysql.columns_priv OK 154mysql.db OK 155mysql.engine_cost OK 156mysql.event OK 157mysql.func OK 158mysql.general_log OK 159mysql.gtid_executed OK 160mysql.help_category OK 161mysql.help_keyword OK 162mysql.help_relation OK 163mysql.help_topic OK 164mysql.innodb_index_stats OK 165mysql.innodb_table_stats OK 166mysql.ndb_binlog_index OK 167mysql.plugin OK 168mysql.proc OK 169mysql.procs_priv OK 170mysql.proxies_priv OK 171mysql.server_cost OK 172mysql.servers OK 173mysql.slave_master_info OK 174mysql.slave_relay_log_info OK 175mysql.slave_worker_info OK 176mysql.slow_log OK 177mysql.tables_priv OK 178mysql.time_zone OK 179mysql.time_zone_leap_second OK 180mysql.time_zone_name OK 181mysql.time_zone_transition OK 182mysql.time_zone_transition_type OK 183mysql.user OK 184mtr.global_suppressions OK 185mtr.test_suppressions OK 186sys.sys_config OK 187drop view mysql.host; 188drop user 'wl6443_u1'@'10.10.10.1'; 189mysql.columns_priv OK 190mysql.db OK 191mysql.engine_cost OK 192mysql.event OK 193mysql.func OK 194mysql.general_log OK 195mysql.gtid_executed OK 196mysql.help_category OK 197mysql.help_keyword OK 198mysql.help_relation OK 199mysql.help_topic OK 200mysql.innodb_index_stats OK 201mysql.innodb_table_stats OK 202mysql.ndb_binlog_index OK 203mysql.plugin OK 204mysql.proc OK 205mysql.procs_priv OK 206mysql.proxies_priv OK 207mysql.server_cost OK 208mysql.servers OK 209mysql.slave_master_info OK 210mysql.slave_relay_log_info OK 211mysql.slave_worker_info OK 212mysql.slow_log OK 213mysql.tables_priv OK 214mysql.time_zone OK 215mysql.time_zone_leap_second OK 216mysql.time_zone_name OK 217mysql.time_zone_transition OK 218mysql.time_zone_transition_type OK 219mysql.user OK 220mtr.global_suppressions OK 221mtr.test_suppressions OK 222sys.sys_config OK 223# End of 5.6 tests 224# 225# WL#6802: Deprecate the INFORMATION_SCHEMA.PROFILING table 226# 227SELECT * FROM INFORMATION_SCHEMA.profiling; 228QUERY_ID SEQ STATE 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 229Warnings: 230Warning 1287 'INFORMATION_SCHEMA.PROFILING' is deprecated and will be removed in a future release. Please use Performance Schema instead 231# End of 5.7 tests 232