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

System versioning and MROONGA don't work well together: WARN_DATA_TRUNCATED makes DELETEs be ignored

    XMLWordPrintable

Details

    Description

      INSTALL SONAME 'ha_mroonga';
      		 
       
      		 
      CREATE OR REPLACE TABLE t1 (i INT PRIMARY KEY) ENGINE=Mroonga WITH SYSTEM VERSIONING;
      		 
      INSERT INTO t1 VALUES (1);
      		 
      DELETE FROM t1;
      		 
      SELECT * FROM t1;
      		 
      SELECT i, row_start, row_end FROM t1 FOR SYSTEM_TIME ALL;
      		 
       
      		 
      # Cleanup
      		 
      DROP TABLE t1;
      		 
      UNINSTALL SONAME 'ha_mroonga';

      10.3 c39f8a80c9fe

      		 
      DELETE FROM t1;
      		 
      Warnings:
      		 
      Warning	1265	data truncated for primary key column: <row_end>
      		 
      SELECT * FROM t1;
      		 
      i
      		 
      1
      		 
      SELECT i, row_start, row_end FROM t1 FOR SYSTEM_TIME ALL;
      		 
      i	row_start	row_end
      		 
      1	2018-04-22 13:58:34.397398	2038-01-19 05:14:07.999999

      So far I haven't heard from any MariaDB users who would actually use Mroonga (only those who had troubles with it while building the server), so I doubt that fixing it in 10.3 worth the trouble, maybe again, just disable versioning for Mroonga (if such disabling is possible at all).

      Attachments

        Activity

          People

            serg Sergei Golubchik
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.