Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5323

Check whether INSERT..SELECT is atomic

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 22.08.4
    • Icebox
    • None
    • None

    Description

      A simple scenario isn't deterministic. It occasionally fails to return a row with the last select b/c INSERT..SELECT lacks atomicity thus there is a small delay b/w time A when INSERT..SELECT returns and time B when records become available.

      CREATE DATABASE mcs25_db;
      USE mcs25_db;
       
      CREATE TABLE t_cs(
      c1 INT,
      c2 INT
      )ENGINE=Columnstore;
       
      CREATE TABLE t_myisam(
      c1 INT,
      c2 INT
      )ENGINE=MyISAM;
       
      INSERT INTO t_cs SELECT * FROM t_myisam;
      SELECT * FROM t_cs;
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            drrtuy Roman
            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.