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

User defined variable not recorded into context

    XMLWordPrintable

Details

    • Unexpected results

    Description

      Issue:
      --------
      User defined variable not recorded to context
      During record , variable is substituted with assigned value.
      During replay , Variable has no assigned value , so it remains as it is .
      Mtr test fails with result length mismatch

      For mtr output refer : mtr9.out

      MTR testcase to repro issue: (Say example.test)

      create or replace table t1 (
        x int unsigned,
        y int unsigned
      ) with system versioning;
      create or replace table t2 (
        x int unsigned,
        y int unsigned
      ) with system versioning;
       
      insert into t1 values (1, 1), (1, 2), (1, 3), (4, 4), (5, 5);
      insert into t2 values (1, 2), (2, 1), (3, 1);
      set @t0= now(6);
       
      delete from t1;
      delete from t2;
       
      explain extended select * from (select t1.x as IJ2_x1, t1.y as y1, t2.x as x2, t2.y as y2 from t1 inner join t2 on t1.x = t2.x)
      for system_time as of timestamp @t0 as t;
      drop table t1,t2;
      

      How to repro:

      ./mtr example.test  --replay-server
      

      Attachments

        1. mtr9.out
          2 kB
          Pavithra Pandith

        Issue Links

          Activity

            People

              bsrikanth Srikanth Bondalapati
              mariadb-pavithrapandith Pavithra Pandith
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.