diff options
| author | Nirbhay Choubey <nirbhay@mariadb.com> | 2016-09-06 10:36:10 -0400 |
|---|---|---|
| committer | Nirbhay Choubey <nirbhay@mariadb.com> | 2016-09-06 10:36:10 -0400 |
| commit | 780c40ef0e1d200fd6874a9e8e65705e685d76c0 (patch) | |
| tree | 0a29ad51f0192f865d79de65b566da61add4b536 /mysql-test/t/trigger.test | |
| parent | d8ad96eac0df9241ba200634717227a7153086e1 (diff) | |
| download | mariadb-git-10.2-mdev7635.tar.gz | |
MDEV-7635: Part 110.2-mdev7635
innodb_buffer_pool_dump_at_shutdown = ON
innodb_buffer_pool_dump_pct = 25
innodb_buffer_pool_load_at_startup = ON
innodb_checksum_algorithm = CRC32
innodb_file_format = Barracuda
innodb_file_format_max = Barracuda
innodb_large_prefix = ON
innodb_log_compressed_pages = ON
innodb_log_file_size = 128M
innodb_purge_threads = 4
innodb_stats_traditional = OFF
innodb_strict_mode = ON
binlog_annotate_row_events = ON
binlog_format = MIXED
group_concat_max_len = 1M
histogram_size = 255
long-query-time = 2
lower_case_table_names = 2
max_allowed_packet = 16M
replicate_annotate_row_events = ON
slave_net_timeout = 60
sync_binlog = 1
use_stat_tables = complementary
aria_recover = FORCE,BACKUP
myisam_recover_options = FORCE,BACKUP
Diffstat (limited to 'mysql-test/t/trigger.test')
| -rw-r--r-- | mysql-test/t/trigger.test | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/t/trigger.test b/mysql-test/t/trigger.test index a02dce34837..6e29761d0ba 100644 --- a/mysql-test/t/trigger.test +++ b/mysql-test/t/trigger.test @@ -2410,6 +2410,10 @@ USE test; # # Test that using a trigger will not open mysql.proc # +let $use_stat_tables_saved= `SELECT @@session.use_stat_tables`; +--disable_query_log +SET SESSION use_stat_tables=never; +--enable_query_log create table t1 (i int); create table t2 (i int); flush tables; @@ -2428,6 +2432,9 @@ show status like 'Opened_tables'; select * from t1; select * from t2; drop table t1,t2; +--disable_query_log +eval SET SESSION use_stat_tables=$use_stat_tables_saved; +--enable_query_log --echo End of 5.2 tests. |