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

crash in fix_semijoin_strategies_for_picked_join_order

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.1, 5.5.30, 5.1.67, 5.2.14, 5.3.12
    • 10.0.3, 5.5.31, 5.1.73, 5.2.15, 5.3.13
    • None
    • None
    • 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;

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              sbester1 sbester1
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.