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

On DEB distributions LDI returns a value saturation error when using cpimport insert insert

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.5.2
    • Fix Version/s: 5.5.1
    • Component/s: DMLProc
    • Labels:
      None

      Description

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

      Distributions tested: Debian 9.1 and 10, Ubuntu 16.04, 18.04, and 20.04.

      When running "load data infield" with columnstore_use_import_for_batchinsert=1, LDI returned a value saturation error:

      MariaDB [mytest]> load data infile "/data/qa/source/dbt3/1g/orders.tbl" into table orders fields terminated by "|";
      ERROR 9999 (HY000): Values saturated

      But all rows were actually loaded.

      LDI without using batch insert, as well as cpimport itself, did not complain about value saturation.
      The same LDI statement also did not return value saturation error in release 1.4.4-1.

      1.5.2-1 on Centos 7, 8, Suse 12, 15 did not have this issue.

        Attachments

          Activity

            People

            Assignee:
            dleeyh Daniel Lee
            Reporter:
            dleeyh Daniel Lee
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.