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

main.delete_use_source fails (hangs) with view-protocol

    XMLWordPrintable

Details

    Description

      10.4 f5dceafd

      $ perl ./mtr main.delete_use_source --view-protocol
       
      main.delete_use_source 'innodb'          [ fail ]  timeout after 900 seconds
       
      create table t1(c1 integer not null,c2 integer not null, key (c1))
      ENGINE=InnoDB STATS_PERSISTENT=1;
      create view v1 as select * from t1 where c1 in (0,1);
      insert t1 select 0,seq from seq_1_to_500;
      insert t1 select 1,seq from seq_1_to_100;
      insert t1 select 2,seq from seq_1_to_50;
      insert t1 select 3,seq from seq_1_to_20;
      analyze table t1;
      Table	Op	Msg_type	Msg_text
      test.t1	analyze	status	OK
      #
      # Delete with limit (quick select - range acces)
      #
      start transaction;
      delete from t1 where (select count(*) from t1 b where b.c1=t1.c1) = 500 limit 1;
      affected rows: 1
      delete from t1 where (select count(*) from t1 b where b.c1=t1.c1) = 500 limit 1;
      affected rows: 0
      select count(*) from v1 where c1=0;
      

      Attachments

        Issue Links

          Activity

            People

              lstartseva Lena Startseva
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.