database/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-08-08 11:22:35 +03:00
Code Activity
Files
bb-12.2-mdev-36055-limit-heuristic-pruning
mariadb/mysql-test/suite
History
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
..
archive
Merge remote-tracking branch 'github/bb-11.4-release' into bb-11.8-serg
2025-04-27 19:40:00 +02:00
atomic
Fix the test: changing charset should be dome when we can not skip the test.
2025-05-09 07:36:15 +02:00
binlog
MDEV-35617: DROP USER should leave no active session for that user
2025-07-16 09:14:33 +07:00
binlog_encryption
MDEV-35617: DROP USER should leave no active session for that user
2025-07-16 09:14:33 +07:00
client
Fix typos in mysql-test/
2025-04-29 13:53:16 +10:00
compat
mariadb-test: wait on disconnect
2025-07-16 09:14:33 +07:00
csv
mariadb-test: wait on disconnect
2025-07-16 09:14:33 +07:00
encryption
mariadb-test: wait on disconnect
2025-07-16 09:14:33 +07:00
engines
MDEV-35617: DROP USER should leave no active session for that user
2025-07-16 09:14:33 +07:00
events
MDEV-35617: DROP USER should leave no active session for that user
2025-07-16 09:14:33 +07:00
federated
MDEV-35617: DROP USER should leave no active session for that user
2025-07-16 09:14:33 +07:00
funcs_1
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
funcs_2
Merge 11.4 into 11.8
2025-04-02 14:07:01 +03:00
galera
MDEV-35617: DROP USER should leave no active session for that user
2025-07-16 09:14:33 +07:00
galera_3nodes
Merge branch '11.8' into 12.0
2025-06-18 07:50:39 +02:00
galera_3nodes_sr
Merge 11.4 into 11.8
2025-04-02 14:07:01 +03:00
galera_sr
Fix typos in mysql-test/
2025-04-29 13:53:16 +10:00
gcol
MDEV-36132 Substitute vcol expressions with indexed vcol fields in ORDER BY and GROUP BY
2025-07-22 10:44:12 +10:00
handler
mariadb-test: wait on disconnect
2025-07-16 09:14:33 +07:00
heap
…
innodb
MDEV-36055 [wip] Add a check of join table counts before heuristic pruning
2025-07-28 16:33:02 +10:00
innodb_fts
MDEV-36055 [wip] Add a check of join table counts before heuristic pruning
2025-07-28 16:33:02 +10:00
innodb_gis
mariadb-test: wait on disconnect
2025-07-16 09:14:33 +07:00
innodb_i_s
…
innodb_zip
Fix typos in mysql-test/
2025-04-29 13:53:16 +10:00
jp
Fix typos in mysql-test/
2025-04-29 13:53:16 +10:00
json
Merge branch '11.8' into 12.0
2025-05-22 09:22:55 +02:00
large_tests
…
maria
MDEV-36055 [wip] Add a check of join table counts before heuristic pruning
2025-07-28 16:33:02 +10:00
mariabackup
mariadb-test: wait on disconnect
2025-07-16 09:14:33 +07:00
merge
mariadb-test: wait on disconnect
2025-07-16 09:14:33 +07:00
mtr/t
…
mtr2
…
multi_source
MDEV-35304: Fix multi_source.connects_tried
2025-04-29 11:00:37 -06:00
optimizer_unfixed_bugs
…
parts
Fix typos in mysql-test/
2025-04-29 13:53:16 +10:00
perfschema
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
perfschema_stress
remove features that were deprecated in 10.5
2025-04-29 16:53:02 +02:00
period
Fix typos in mysql-test/
2025-04-29 13:53:16 +10:00
plugins
MDEV-35617: DROP USER should leave no active session for that user
2025-07-16 09:14:33 +07:00
roles
MDEV-35617: DROP USER should leave no active session for that user
2025-07-16 09:14:33 +07:00
rpl
MDEV-35617: DROP USER should leave no active session for that user
2025-07-16 09:14:33 +07:00
s3
Merge branch '11.8' into 12.0
2025-06-18 07:50:39 +02:00
sql_sequence
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
storage_engine
mariadb-test: wait on disconnect
2025-07-16 09:14:33 +07:00
stress
…
sys_vars
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
sysschema
MDEV-34888 Implement SEMIJOIN() and SUBQUERY() hints
2025-05-05 12:02:47 +07:00
unit
…
vcol
MDEV-36132 Substitute vcol expressions with indexed vcol fields in ORDER BY and GROUP BY
2025-07-22 10:44:12 +10:00
versioning
MDEV-36055 [wip] Add a check of join table counts before heuristic pruning
2025-07-28 16:33:02 +10:00
wsrep
Fix typos in mysql-test/
2025-04-29 13:53:16 +10:00