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

Crash during optimization for insert or create table with select

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.3.8
    • 10.3.10
    • Optimizer
    • None
    • RedHat-6.5

    Description

      Following query causes the crash during optimization.

      create table t1 (f1 int,f2 int, primary key (f1));
      insert into t1 values(1,10),(2,20);
       
      create table t2 (f1 int,f3 int, primary key (f1));
      insert into t2 values(1,100),(2,200);
       
      create table t3 (f1 int ,f2 int ,f3 int, primary key(f1,f2) );
      insert into t3 values (1,10,100),(2,20,200);
       
      create temporary table temp
      (
      select * from
      (select  A.f1
         from  
           ( select f1 , f3   from t3 where  f2 in 
             ( select  t2.f3  from t1  ,t2  
                where  t1.f1 = t2.f1 ) 
             group by f1  ) A  ,
             t3     
       where  t3.f1=A.f1 
       group by A.f1) D
       ) ;
      

      The crash happens on creating (temporary) table or inserting the data.
      Select itself does not cause the crash.

      Attachments

        Activity

          People

            Unassigned Unassigned
            sxsns243 Wataru Matsumoto
            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.