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