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

..

alter.result

MDEV-27293 Allow converting a versioned table from implicit

2024-10-29 17:46:40 +03:00

autoinc.result

…

binlog.result

MDEV-19123 Change default charset from latin1 to utf8mb4

2024-07-11 10:21:07 +04:00

commit_id.result

Removed "<select expression> INTO <destination>" deprication.

2023-02-03 11:57:50 +03:00

create.result

MDEV-19123 Change default charset from latin1 to utf8mb4

2024-07-11 10:21:07 +04:00

cte,32bit.rdiff

MDEV-32188 make TIMESTAMP use whole 32-bit unsigned range

2024-05-27 12:39:02 +02:00

cte.result

MDEV-32188 make TIMESTAMP use whole 32-bit unsigned range

2024-05-27 12:39:02 +02:00

data.result

Merge branch '11.4' into 11.7

2025-02-06 16:46:36 +01:00

debug.result

MDEV-19123 Change default charset from latin1 to utf8mb4

2024-07-11 10:21:07 +04:00

delete_history,32bit.rdiff

MDEV-32188 make TIMESTAMP use whole 32-bit unsigned range

2024-05-27 12:39:02 +02:00

delete_history.result

Merge tag '11.4' into 11.6

2024-11-08 07:17:00 +01:00

delete.result

MDEV-25644 UPDATE not working properly on transaction precise system versioned table

2023-07-20 18:22:31 +03:00

derived.result

MDEV-15751 CURRENT_TIMESTAMP should return a TIMESTAMP [WITH TIME ZONE?]

2024-10-19 22:48:23 +02:00

foreign.result

MDEV-28933: Per-table unique FOREIGN KEY constraint names

2025-07-08 12:30:27 +03:00

insert2.result

MDEV-32188 make TIMESTAMP use whole 32-bit unsigned range

2024-05-27 12:39:02 +02:00

insert.result

MDEV-36397 Record change_user command in MTR output

2025-06-23 20:38:36 +02:00

misc.result

MDEV-32188 make TIMESTAMP use whole 32-bit unsigned range

2024-05-27 12:39:02 +02:00

not_embedded.result

cleanup: disconnect before DROP USER

2025-07-16 09:14:33 +07:00

old_timestamp.result

Merge branch '11.4' into 11.7

2025-02-06 16:46:36 +01:00

online.result

MDEV-19123 Change default charset from latin1 to utf8mb4

2024-07-11 10:21:07 +04:00

optimized.result

MDEV-19123 Change default charset from latin1 to utf8mb4

2024-07-11 10:21:07 +04:00

partition,heap.rdiff

Merge branch '11.4' into 11.5

2024-08-05 17:50:18 +02:00

partition.result

Merge branch '11.8' into 12.0

2025-06-18 07:50:39 +02:00

replace.result

MDEV-35343 unexpected replace behaviour when long unique index on

2025-01-14 18:56:13 +03:00

rpl_mix.result

MDEV-19123 Change default charset from latin1 to utf8mb4

2024-07-11 10:21:07 +04:00

rpl_row.result

Merge tag '11.4' into 11.6

2024-11-08 07:17:00 +01:00

rpl_stmt.result

MDEV-19123 Change default charset from latin1 to utf8mb4

2024-07-11 10:21:07 +04:00

rpl.result

Merge tag '11.4' into 11.6

2024-11-08 07:17:00 +01:00

select2,trx_id.rdiff

Merge 10.11 into 11.4

2025-01-09 07:58:08 +02:00

select2.result

Removed "<select expression> INTO <destination>" deprication.

2023-02-03 11:57:50 +03:00

select.result

MDEV-36055 [wip] Add a check of join table counts before heuristic pruning

2025-07-28 16:33:02 +10:00

simple.result

MDEV-28632 Change default of explicit_defaults_for_timestamp to ON

2022-08-10 15:03:22 +02:00

sysvars.result

…

trx_id.result

MDEV-19123 Change default charset from latin1 to utf8mb4

2024-07-11 10:21:07 +04:00

update-big.result

MDEV-17554 Auto-create new partition for system versioned tables with history partitioned by INTERVAL/LIMIT

2022-05-06 15:11:02 +03:00

update,trx_id.rdiff

Merge branch '10.11' into 11.0

2023-08-09 07:53:48 +02:00

update.result

fix incorrect merge 15700f54c2

2025-04-18 09:41:24 +02:00

view.result

…