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

MTR --ps fails with result mismatch

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11
    • 10.11
    • Tests, MTR
    • None
    • bb-10.11-midenok
    • Not for Release Notes

    Description

      Can be reproduced after MDEV-28650 fix (currently in bb-10.11-midenok).

      Reproduce

      --source include/have_sequence.inc
      create sequence s;
      create table t1 (a int not null default nextval(s));
      insert into t1 values(),();
      flush tables;
      select default(a) from t1;
       
      create algorithm=merge view v1 as select default(a) from t1;
      select * from v1;
      Select * from v1;
      prepare ps from 'SELECT * from v1';
      execute ps; Execute ps;
      drop prepare ps;
       
      create or replace algorithm=temptable view v1 as select default(a) from t1;
      select * from v1;
      Select * from v1;
      prepare ps from 'SELECT * from v1';
      execute ps; Execute ps;
      drop prepare ps;
       
      # cleanup
      drop view v1;
      drop table t1;
      drop sequence s;
      

      Result

      mtr --ps bug.28650-2
      ...
      mysqltest: At line 6: The result of the 1st execution does not match with
      the result of the 2nd execution of ps-protocol:
       1st:
      default(a)
      1001
      1002
       
       2nd:
       default(a)
      1003
      1004
      

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              midenok Aleksey Midenkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.