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

SIGSEGV in Item_equal::add_key_fields

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 12.0.2
    • N/A
    • N/A
    • None
    • Not for Release Notes

    Description

      Complex query with `IN` subquery and `HAVING` clause causes a crash in the optimizer.

      CREATE DATABASE IF NOT EXISTS HuangHe;
      USE HuangHe;
      SET optimizer_switch= 'condition_pushdown_for_subquery=on' ;
      CREATE  TABLE main_tab (f1 INT );
      INSERT  INTO main_tab VALUES (1),(2);
      CREATE  TABLE sec_tab (f2 INT );
      INSERT  INTO main_tab VALUES (3),(4);
      SELECT * FROM main_tab, sec_tab WHERE f2 IN ( SELECT f1 FROM main_tab HAVING f1 = 5 ) AND f1 = 6 AND ( 0 OR f1 = f2 );
      DROP  TABLE main_tab, sec_tab;
      

      mariadbd(_ZN10Item_equal14add_key_fieldsEP4JOINPP9KEY_FIELDPjyPP14SARGABLE_PARAM+0x9c)[0x64a09c21520c]
      mariadbd(_ZN4JOIN14optimize_innerEv+0x1311)[0x64a09c2272a1]
      mariadbd(_ZN4JOIN8optimizeEv+0x10a)[0x64a09c2278ba]
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            maohaogang maohaogang
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.