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

            Assignee:
            Unassigned
            Reporter:
            mdg62 Matthias Dr. Döring
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: