Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4270

crash in fix_semijoin_strategies_for_picked_join_order

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.0.1, 5.5.30, 5.1.67, 5.2.14, 5.3.12
        • Fix Version/s: 10.0.3, 5.5.31, 5.3.13, 5.2.15, 5.1.73
        • Component/s: None
        • Labels:
          None
        • Environment:
          winx64, linux x64

          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;

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Bug - A problem which impairs or prevents the functions of the product. MDEV-621 LP:693329 - Assertion `!is_interleave_error' failed on low optimizer_search_depth

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Closed

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  Could be a duplicate of, or related to, MDEV-621.

                  Show
                  elenst Elena Stepanova added a comment - Could be a duplicate of, or related to, MDEV-621 .
                  Hide
                  Permalink
                  psergey Sergei Petrunia added a comment -

                  Added testcase

                  Show
                  psergey Sergei Petrunia added a comment - Added testcase
                  Hide
                  Permalink
                  psergey Sergei Petrunia added a comment -

                  The problem itself was fixed by fix for MDEV-621

                  Show
                  psergey Sergei Petrunia added a comment - The problem itself was fixed by fix for MDEV-621

                    People

                    • Assignee:
                      psergey Sergei Petrunia
                      Reporter:
                      sbester1 sbester1
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      4 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: