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

cpimport tool bug wtih decimal table

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.0.9
    • Icebox
    • cpimport
    • None
    • centos6.8

    Description

      I have a column defined as decimal(7,2), when using cpimport I see the following behavior when importing values to this column. ( csv files )
      CREATE TABLE `test_dec` (
      `id` int(11) DEFAULT NULL,
      `a` decimal(7,2) DEFAULT NULL
      ) ENGINE=columnstore DEFAULT CHARSET=latin1 |

      When importing 23.45, the resulting value is 23.45.
      When import 23.5, the resulting value is 2.35, should be 23.50

      cpimport is shifting the decimal place if the source file value does not contain 2 decimal places.

      by the way,when we change column a before column id, the cpimport result is correct!

      Attachments

        1. 1.png
          9 kB
          jerry ma
        2. test.csv
          0.1 kB
          jerry ma

        Activity

          People

            Unassigned Unassigned
            jerryma jerry ma
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.