Details
Description
Initial valgrind error from maria revno 3503: (release build)
					Use of uninitialised value of size 8
			 | 
		
					at: fix_semijoin_strategies_for_picked_join_order (opt_subselect.cc:3191)
			 | 
		
					by: get_best_combination (sql_select.cc:7672)
			 | 
		
					by: make_join_statistics (sql_select.cc:3864)
			 | 
		
					by: JOIN::optimize_inner (sql_select.cc:1264)
			 | 
		
					by: JOIN::optimize (sql_select.cc:986)
			 | 
		
					by: mysql_select (sql_select.cc:3178)
			 | 
		
					by: handle_select (sql_select.cc:363)
			 | 
		
					by: execute_sqlcom_select (sql_parse.cc:5004)
			 | 
		
					by: mysql_execute_command (sql_parse.cc:2472)
			 | 
		
					by: mysql_parse (sql_parse.cc:6124)
			 | 
		
					by: dispatch_command (sql_parse.cc:1266)
			 | 
		
					by: do_handle_one_connection (sql_connect.cc:1267)
			 | 
		
					by: handle_one_connection (sql_connect.cc:1181)
			 | 
		
					by: start_thread (pthread_create.c:309)
			 | 
		
					by: clone (clone.S:115)
			 | 
		
Debug build asserts:
					bool greedy_search(JOIN*, table_map, uint, uint): Assertion `!is_interleave_error' failed.
			 | 
		
					--source include/have_innodb.inc
			 | 
		
					Â  | 
		
					drop table if exists y,e,j;  | 
		
					create table e(a int,unique key (a)) engine=innodb;  | 
		
					create table j(b int) engine=innodb;  | 
		
					create table y(a int,b int)engine=innodb;  | 
		
					set optimizer_prune_level=0;  | 
		
					set optimizer_search_depth=2;  | 
		
					select 1 from y join e a  | 
		
					natural left join e b  | 
		
					natural right outer join j;  | 
		
Attachments
Issue Links
- relates to
 - 
                    
MDEV-621 LP:693329 - Assertion `!is_interleave_error' failed on low optimizer_search_depth
-         
 - Closed
 
 -