mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-08-15 15:01:33 +02:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/suite
History
Exact
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 Merge branch '11.4' into 11.7 2025-02-06 16:46:36 +01:00
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 Remove dates from all rdiff files 2025-01-05 16:40:11 +02:00
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 MDEV-34453 Trying to read 16384 bytes at 70368744161280 outside the bounds of the file: ./ibdata1 2024-09-20 20:26:43 +05:30
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 Merge branch '11.4' into 11.5 2024-08-05 17:50:18 +02:00
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