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

LDI Crash With columnstore_use_import_for_batchinsert = ON/ALWAYS

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.4.3
    • Component/s: None
    • Labels:
      None

      Description

      When using LDI with columnstore_use_import_for_batchinsert = ON/ALWAYS (cpimport), MariaDB will crash if the values contain a curly brace and it is going into an TEXT field.

      MariaDB [json]> LOAD DATA INFILE '/tmp/MOCK_DATA.csv' into table test6 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
      ERROR 2013 (HY000): Lost connection to MySQL server during query
      

      MariaDB [json]> show create table test6;
      +-------+-------------------------------------------------------------------------------------------+
      | Table | Create Table                                                                              |
      +-------+-------------------------------------------------------------------------------------------+
      | test6 | CREATE TABLE `test6` (
        `id` text DEFAULT NULL
      ) ENGINE=Columnstore DEFAULT CHARSET=utf8 |
      +-------+-------------------------------------------------------------------------------------------+
      

        Attachments

          Activity

            People

            Assignee:
            dleeyh Daniel Lee
            Reporter:
            toddstoffel Todd Stoffel
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: