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

System versioning and CONNECT engine don't work well together: current data is not returned

Details

    Description

      Currently system versioning does not work at all even for simplest table types of CONNECT engine, e.g. DOS, I assume due to MDEV-15967 – microseconds are not stored, so the stored value of row end is less than expected, and all data is considered outdated.

      MariaDB [test]> create or replace table t3 (a int) engine=CONNECT table_type=DOS file_name='t3.file' with system versioning;
      Query OK, 0 rows affected (0.05 sec)
       
      MariaDB [test]> insert into t3 values (1);
      Query OK, 1 row affected (0.00 sec)
       
      MariaDB [test]> select * from t3;
      Empty set (0.01 sec)
       
      MariaDB [test]> select *, row_start, row_end from t3 for system_time all;
      +------+----------------------------+----------------------------+
      | a    | row_start                  | row_end                    |
      +------+----------------------------+----------------------------+
      |    1 | 2018-04-22 02:46:28.000000 | 2038-01-19 05:14:07.000000 |
      +------+----------------------------+----------------------------+
      1 row in set (0.00 sec)
      

      So, unless MDEV-15967 is fixed by GA, versioning for CONNECT should be disabled.

      However, I'm not sure it makes much sense to keep it even if MDEV-15967 gets fixed. Most CONNECT table types provide access to external data sources, and versioning will be either impossible at all, or its semantics will be questionable.

      Attachments

        Issue Links

          Activity

            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Assignee Elena Stepanova [ elenst ] Sergei Golubchik [ serg ]
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.4 [ 22408 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 86707 ] MariaDB v4 [ 144030 ]
            elenst Elena Stepanova made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Sergei Golubchik [ serg ]
            elenst Elena Stepanova made changes -
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.3 [ 22126 ]

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.