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

Auto increment no longer support in "load data infile"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.4.4, 1.5.2
    • Fix Version/s: Icebox
    • Component/s: DMLProc
    • Labels:
      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

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