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

Decimal offset incorrect after cpimport

    XMLWordPrintable

    Details

    • Sprint:
      2021-8, 2021-9

      Description

      See test011 bug3801

      create table bug3801 (
        id int,
        c1 decimal(10,3),
        c2 decimal(9,2)
      ) engine=columnstore;
      

      The following values are added via colxml and cpimport

      Contents of tables/bug3801.tbl
      1|000250.000|232.20|
      2|99.233|004.00|
      3|2333.2|23.99|
      

      colxml -j 1114 -t bug3801 $DB
      cpimport -j 1114 -f STDIN < tables/bug3801.tbl
      

      select * from bug3801;
      

      +------+-------------+----------+
      | id   | c1          | c2       |
      +------+-------------+----------+
      |    1 |  250000.000 | 23220.00 |
      |    2 |   99233.000 |   400.00 |
      |    3 | 2333200.000 |  2399.00 |
      +------+-------------+----------+
      3 rows in set (0.151 sec)
      

        Attachments

          Activity

            People

            Assignee:
            David.Hall David Hall
            Reporter:
            David.Hall David Hall
            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.