mirror of
				https://github.com/MariaDB/server.git
				synced 2025-10-31 10:56:12 +01:00 
			
		
		
		
	 bd23b3dc06
			
		
	
	
	bd23b3dc06
	
	
	
		
			
			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
 |