mirror of
https://github.com/MariaDB/server.git
synced 2026-02-01 16:29:08 +01:00
c5154d8587If we completely disable heuristic pruning, the test
main.greedy_optimizer will grind to almost hanging when the following
iterates to i > 20:
let $query= SELECT COUNT(*) FROM t1 AS x;
let $i= 1;
while ($i < 61)
{
let $query= $query JOIN t$i ON t$i.I=x.I;
inc $i;
select @@optimizer_prune_level;
select @@optimizer_search_depth;
eval EXPLAIN $query;
}
|
||
|---|---|---|
| .. | ||
| r | ||
| t | ||
| common.inc | ||
| common.opt | ||
| common_finish.inc | ||
| disabled.def | ||
| engines.combinations | ||
| engines.inc | ||
| innodb.combinations | ||
| innodb.inc | ||
| key_type.combinations | ||
| key_type.inc | ||
| sys_time.inc | ||
| wait_system_clock.inc | ||