summaryrefslogtreecommitdiff
path: root/mysql-test/t/join_outer.test
diff options
context:
space:
mode:
authorNirbhay Choubey <nirbhay@mariadb.com>2016-09-06 10:36:10 -0400
committerNirbhay Choubey <nirbhay@mariadb.com>2016-09-06 10:36:10 -0400
commit780c40ef0e1d200fd6874a9e8e65705e685d76c0 (patch)
tree0a29ad51f0192f865d79de65b566da61add4b536 /mysql-test/t/join_outer.test
parentd8ad96eac0df9241ba200634717227a7153086e1 (diff)
downloadmariadb-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/join_outer.test')
-rw-r--r--mysql-test/t/join_outer.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/join_outer.test b/mysql-test/t/join_outer.test
index a3a1278ef1e..fc67a0412d5 100644
--- a/mysql-test/t/join_outer.test
+++ b/mysql-test/t/join_outer.test
@@ -1368,6 +1368,10 @@ drop table t1,t2,t3,t4;
--echo # Bug#57024: Poor performance when conjunctive condition over the outer
--echo # table is used in the on condition of an outer join
--echo #
+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 (a int);
insert into t1 values (NULL), (NULL), (NULL), (NULL);
@@ -1410,6 +1414,10 @@ show status like "handler_read%";
drop table t1,t2,t3;
+--disable_query_log
+eval SET SESSION use_stat_tables=$use_stat_tables_saved;
+--enable_query_log
+
--echo #
--echo # Bug#57688 Assertion `!table || (!table->write_set || bitmap_is_set(table->write_set, field
--echo #