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

Assertion in ha_rnd_init on multi-table 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 because it hits an assertion at handler.h:3533 (11.4 as of git SHA e3477afcc3e3e15c1cd2eadc2a46fa73ffc4a156 ).

        create table t1 (a int, b int) engine=myisam;
        insert into t1 values (1,1),(2,2);
        create table t2 (a int) engine=myisam;
        insert into t2 values (1),(2);
        create table t3 (c int) 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 t1.b>0 with check option;
        update v1, t3 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:
                  Time Spent - 0.5h Remaining Estimate - 1.5d
                  1.5d
                  Logged:
                  Time Spent - 0.5h Remaining Estimate - 1.5d
                  0.5h

                  Git Integration

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