mirror of
https://github.com/MariaDB/server.git
synced 2025-10-24 16:38:14 +02:00
InnoDB could return off-by-1 estimates for the involved tables.
This would cause off-by-many difference in join output cardinality
for the top-level SELECT, and so different query plan for the subquery.
The fix: Introduce mysql-test/include/innodb_stable_estimates.{inc,opt}
which disables InnoDB's background statistics collection, and use it.
1 line
29 B
Text
1 line
29 B
Text
--innodb_stats_auto_recalc=0
|