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

Crash during optimization for insert or create table with select

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3.8
    • Fix Version/s: 10.3.10
    • Component/s: Optimizer
    • Labels:
      None
    • Environment:
      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

            • Assignee:
              Unassigned
              Reporter:
              sxsns243 Wataru Matsumoto
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: