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

cpimport scientific notation conversion problem

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.0.15, 1.1.6, 1.2.2
    • 1.0.16, 1.1.7, 1.2.3
    • cpimport
    • None

    Description

      After loading data (using cpimport), noticed some issues with it. When I load the data using cpimport, the field value which is stored as in scientific form (8e-05), it gets loaded into the database as 0.000008 instead of 0.000080

      When I use the regular load infile command, the data is loaded just fine.

      [root@localhost ~]# cat t1.dat
      8e-5|8e-5|8e-5|
      after cpimport, I got
      MariaDB [mytest]> select * from t1;
      +------------+---------+---------+
      | c1         | c2      | c3      |
      +------------+---------+---------+
      | 0.00000008 | 0.00008 | 0.00008 |
      +------------+---------+---------+
      1 row in set (0.155 sec)
      so issue is with cpimport on decimal column
      insert looks good
      MariaDB [mytest]> insert t1 values (8e-5,8e-5,8e-5);
      Query OK, 1 row affected (0.439 sec)
       
      MariaDB [mytest]> select * from t1;
      +------------+---------+---------+
      | c1         | c2      | c3      |
      +------------+---------+---------+
      | 0.00000008 | 0.00008 | 0.00008 |
      | 0.00008000 | 0.00008 | 0.00008 |
      +------------+---------+---------+
      2 rows in set (0.194 sec)
      first row is cpimport, 2nd row is insert.  Insert matched that on Innodb
      

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              juan.vera Juan (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.