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/t
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
..
2024-04-18 07:14:56 +03:00
2024-11-05 14:00:52 -08:00
2022-09-26 14:34:43 +03:00
2023-12-18 08:59:07 +02:00
2025-03-05 20:39:47 +02:00
2022-09-26 13:34:38 +03:00
2024-02-07 13:51:03 +02:00
2024-10-03 09:31:39 +03:00
2024-08-03 09:04:24 +02:00
2024-01-03 15:55:17 +02:00
2024-10-03 10:55:08 +03:00
2025-04-07 10:25:34 +03:00
2025-04-29 13:53:16 +10:00
2024-10-18 11:32:22 +03:00
2022-11-30 13:10:52 +02:00
2025-03-03 11:07:56 +02:00
2025-04-29 13:53:16 +10:00
2022-10-06 08:29:56 +03:00
2022-10-06 08:29:56 +03:00
2025-04-29 13:53:16 +10:00
2023-04-17 16:50:01 +03:00
2023-07-26 15:13:06 +03:00
2025-04-29 13:53:16 +10:00
2024-11-05 14:00:52 -08:00
2025-04-02 14:07:01 +03:00
2022-10-13 10:42:41 +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-24 11:20:56 +02:00
2025-03-28 13:55:21 +02:00
2023-11-24 11:20:56 +02:00
2025-03-28 13:55:21 +02:00
2025-07-16 09:14:33 +07:00
2025-07-16 09:14:33 +07:00
2024-05-30 14:27:07 +03:00