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

Auto increment no longer support in "load data infile"

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 1.4.4, 1.5.2
    • Icebox
    • DMLProc
    • None

    Description

      Build tested: 1.5.2-1 (community edition, hasty b33685)

      Per ColumnStore's original design, auto increment column is supported as the following:

      create table t1 (cidx int, c1 integer comment 'autoincrement', c2 date, c3 char(25)) engine=Columnstore;

      With insert, or LDI, if the column value for c1 is 'NULL', the value for that column would take the next increment value.

      It seems that after ColumnStore became an engine to the MariaDB server, 'NULL' is being rejected in 'load data infile" processing.

      data file:

      1|NULL|2020-06-23|HELLO|
      1|NULL|2020-06-23|HELLO|

      MariaDB [mytest]> load data infile '/tmp/t.tbl' into table t1 fields terminated by "|";
      ERROR 1366 (22007): Incorrect integer value: 'NULL' for column `mytest`.`t1`.`c1` at row 1

      The error occurred when columnstore_use_import_for_batchinsert is set to 1 or 0.

      insert and cpimport are working correctly.
      For cpimport, '-n 1' switch is needed for this to work.

      Attachments

        Activity

          People

            Unassigned Unassigned
            dleeyh Daniel Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.