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

Columnstore decimal number string conversion problem

    XMLWordPrintable

Details

    Description

      Hello,

      the string conversion of the field v1 in the following example provides unexpected number formatting results. All values in the range between ]-0.1 ... +0.1[ are formatted without a zero before the decimal point. You get for example

      .0200
      -.0200

      That could be reproduced just for columnstore tables. With innodb tables the 0 digits appear as expected. The number format causes problems when used in JSON objects where that number syntax is not allowed. The expected behaviour is to get the same format for all decimal numbers between ]-1.000 ... + 1.000[ ideally of cource with the missing zero before the decimal point (as I get it with innoDB storage engine).

      Best regards
      Matthias

      drop table if exists numbconv;
      create table if not exists numbconv (v1 decimal(14,4)) ENGINE=Columnstore;
      insert into numbconv values(0.0200);

      SELECT
      CONCAT(v1) AS erval
      FROM
      numbconv

      Attachments

        Activity

          People

            Unassigned Unassigned
            mdg62 Matthias Dr. Döring
            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.