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

INSERT cannot get row_start/row_end values

    XMLWordPrintable

Details

    Description

      Reproduce

      create table t0 (c0 int, c1 timestamp(6), c2 timestamp(6)) with system versioning;
      insert into t0 values (0, '2000-01-01 00:00:00', c1);
      insert into t0 values (1, '2001-01-01 00:00:00', row_start);
      insert into t0 values (2, '2002-01-01 00:00:00', row_end);
      select * from t0;
      drop table t0;
      

      Result

      select * from t0;
      c0      c1      c2
      0       2000-01-01 00:00:00.000000      2000-01-01 00:00:00.000000
      1       2001-01-01 00:00:00.000000      0000-00-00 00:00:00.000000
      2       2002-01-01 00:00:00.000000      0000-00-00 00:00:00.000000
      

      Expected

      Field c2 is filled with correct values for rows 1 and 2.

      Attachments

        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.