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

Abort (signal 6) in multi_update::send_data on UPDATE

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.4
    • 11.4
    • Optimizer
    • Can result in hang or crash

    Description

      The following UPDATE crashes in a Debug build with signal 6 on 11.4 as of git SHA e3477afcc3e3e15c1cd2eadc2a46fa73ffc4a156

        create table t1 (a int not null, b int not null) engine=myisam;
        insert into t1 values (1,1),(2,2),(3,3),(4,4);
        create table t2 (a int not null, b int not null) engine=myisam;
        insert into t2 values (1,1),(2,2),(3,3),(4,4);
        create table t3 (c int not null) engine=myisam;
        insert into t3 values (1),(2);
        create view v1 as
          select t1.a, t1.b from t2 join t1 on t1.a=t2.a where t2.b>0
          with check option;
        update t3, v1 set v1.b=v1.b+100, t3.c=t3.c+10;
      

      Attachments

        Issue Links

          Activity

            People

              Gosselin Dave Gosselin
              Gosselin Dave Gosselin
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 0d
                  0d
                  Remaining:
                  Remaining Estimate - 1.5d
                  1.5d
                  Logged:
                  Remaining Estimate - 1.5d
                  5m

                  Git Integration

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