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

When columnstore_use_import_for_batchinsert=ALWAYS, rollback does not work

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 6.3.1
    • Fix Version/s: Icebox
    • Component/s: DDLProc
    • Labels:
      None

      Description

      Build tested: 6.3.1-1

      When columnstore_use_import_for_batchinsert=ALWAYS, ROLLBACK does not rollback inserted rows in a transaction.

      MariaDB [tpch1]> create table region1
        ->  (
        ->   r_regionkey int,
        ->   r_name char(25),
        ->   r_comment varchar(152)
        ->  ) engine=columnstore;
      Query OK, 0 rows affected (0.281 sec)
      MariaDB [tpch1]> start transaction;
      Query OK, 0 rows affected (0.000 sec)
      MariaDB [tpch1]> insert into region1 select * from tpch1.region;
      Query OK, 5 rows affected (1.571 sec)
      Records: 5 Duplicates: 0 Warnings: 0
      MariaDB [tpch1]> rollback;
      Query OK, 0 rows affected (0.005 sec)
      MariaDB [tpch1]> select * from region1;
      +-------------+-------------+---------------------------------------------------------------------------------------------------------------------+
      | r_regionkey | r_name   | r_comment                                                      |
      +-------------+-------------+---------------------------------------------------------------------------------------------------------------------+
      |      0 | AFRICA   | lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to |
      |      1 | AMERICA   | hs use ironic, even requests. s                                           |
      |      2 | ASIA    | ges. thinly even pinto beans ca                                           |
      |      3 | EUROPE   | ly final courts cajole furiously final excuse                                    |
      |      4 | MIDDLE EAST | uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl    |
      +-------------+-------------+---------------------------------------------------------------------------------------------------------------------+
      5 rows in set (0.011 sec)
      

      5 rows still exist after rollback. ROLLBACK is not supported when insert cache is enabled. In this case, insert cache was disabled.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            dleeyh Daniel Lee
            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.