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

transaction gets autocommitted if non columnstore query executed

    XMLWordPrintable

    Details

    • Sprint:
      2017-12

      Description

      It looks like ColumnStore is not respecting a transaction ROLLBACK if, inside the transaction, we issue a SELECT statement.

      This happens regardless of the table engine (we tested with InnoDB and ColumStore).

      Test case:

      CREATE TABLE `countries_innodb` (
      `code` varchar(255) NOT NULL
      ) ENGINE=InnoDB;

      INSERT INTO countries_innodb (code) VALUES ('BR');

      BEGIN;
      INSERT INTO countries_innodb (code) VALUES ('UK');
      SELECT 'INSIDE TRANSACTION' AS '';
      ROLLBACK;

      – Result: two countries.
      – Expected: one country.
      SELECT * FROM countries_innodb;

      It looks like only the SELECT generates this behavior. If we INSERT or UPDATE multiple times, the transaction is still ROLL'd back fine.

      Current version: 1.0.9.

        Attachments

          Activity

            People

            Assignee:
            dleeyh Daniel Lee
            Reporter:
            dthompson David Thompson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.