Yuchen Pei c5154d8587
MDEV-36055 [wip] Add a check of join table counts before heuristic pruning ...
If 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;
}
2025-07-28 16:33:02 +10:00
2022-12-27 00:02:02 +03:00
2024-07-11 10:21:07 +04:00
2024-11-05 14:00:47 -08:00
2024-02-14 16:12:53 +02:00
2024-07-11 10:21:07 +04:00
2023-11-08 12:17:14 +02:00
2025-07-08 12:30:27 +03:00
2023-11-28 16:33:22 +02:00
2024-06-06 19:09:13 +05:30
2022-12-13 11:37:33 +02:00
2025-07-28 16:33:02 +10:00
2024-10-17 21:37:37 +02:00
2025-07-28 16:33:02 +10:00
2025-02-13 16:28:06 +01:00
2025-03-28 09:05:20 +02:00
2025-07-08 12:30:27 +03:00
2024-10-08 18:20:13 +02:00
2024-07-11 10:21:07 +04:00
2023-12-19 15:53:18 +01:00
2025-04-29 13:53:16 +10:00
2023-04-12 11:04:29 +10:00
2024-04-09 12:12:33 +02:00
2024-04-09 12:12:33 +02:00
2024-07-11 10:21:07 +04:00
2024-02-12 16:52:55 +01:00
2024-02-12 16:52:55 +01:00
2023-11-08 12:17:14 +02:00
2025-07-08 12:30:27 +03:00
2022-10-12 12:14:13 +03:00
2024-02-13 20:42:59 +02:00
2024-02-13 20:42:59 +02:00
2023-01-05 11:07:55 +05:30
2024-11-08 07:17:00 +01:00
2024-08-21 15:13:47 +02:00
2025-07-28 16:33:02 +10:00
2023-11-08 12:17:14 +02:00
2024-08-13 15:22:09 +05:30
2023-11-08 12:17:14 +02:00
2024-12-12 18:02:00 +02:00
2024-07-11 10:21:07 +04:00
2024-07-11 10:21:07 +04:00
2023-11-08 12:17:14 +02:00
2025-04-29 13:53:16 +10:00
2024-02-12 16:52:55 +01:00
2023-04-24 11:06:56 +05:30
2022-12-27 00:02:02 +03:00
2023-01-04 14:52:25 +02:00
c5154d8587