1
0
mirror of https://github.com/MariaDB/server.git synced 2025-08-08 11:22:35 +03:00
Files
mariadb/mysql-test/suite/innodb/r
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
..
2025-03-05 20:39:47 +02:00
2024-11-08 07:17:00 +01:00
2024-10-03 16:09:56 +03:00
2025-04-07 10:25:34 +03:00
2023-11-24 11:20:56 +02:00
2025-04-29 13:53:16 +10:00
2022-09-13 16:36:38 +03:00
2022-09-13 16:36:38 +03:00
2022-11-30 12:12:07 +02:00
2024-12-02 11:35:34 +02:00
2025-04-02 14:07:01 +03:00
2024-05-12 12:18:28 +02:00
2024-06-10 15:22:15 +03:00
2025-04-02 14:07:01 +03:00
2024-10-03 16:09:56 +03:00
2025-04-02 14:07:01 +03:00
2024-03-12 09:19:57 +02:00
2023-11-08 17:09:44 +01:00
2025-03-28 13:55:21 +02:00
2024-02-21 13:08:23 +02:00