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

Assertion `fld->field_no < table->n_v_def' failed on cascade FK update of table with vcol index in parent

    XMLWordPrintable

Details

    Description

      --source include/have_debug_sync.inc
      --source include/have_innodb.inc
      --connect (con2, localhost, root,,)
      --connection default
      set default_storage_engine= innodb;
       
       
      create table t1 (a int primary key, b int as (a), key(b));
      insert into t1(a) values (1),(2),(3);
      create table t2 (a int, foreign key (a) references t1 (a)
        on delete cascade on update cascade);
      insert into t2(a) values (1),(2),(3);
      set debug_sync= "find_table_for_vc_table_valid SIGNAL found WAIT_FOR go";
      UPDATE t1 set a = 11 where a = 1;
      --send
      UPDATE t1 set a = 22 where a = 2;
      --connection con2
      set debug_sync= "now WAIT_FOR found TIMEOUT 3";
      UPDATE t1 set a= 33 where a = 3;
      set debug_sync= "now SIGNAL go";
       
      --connection default
      --reap
       
      # Cleanup
      drop table t1, t2;
      set debug_sync= reset;
      --connection default
      

      Attachments

        Issue Links

          Activity

            People

              nikitamalyavin Nikita Malyavin
              nikitamalyavin Nikita Malyavin
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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