Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8521

Drastic loss of precision in COLUMN_JSON() on DOUBLEs

        Details

        • Type: Bug
        • Status: Confirmed
        • Priority: Major
        • Resolution: Unresolved
        • Affects Version/s: 10.0.18
        • Fix Version/s: 10.0
        • Component/s: Dynamic Columns
        • Labels:
          None
        • Environment:
          Darwin yossy.local 14.3.0 Darwin Kernel Version 14.3.0: Mon Mar 23 11:59:05 PDT 2015; root:xnu-2782.20.48~5/RELEASE_X86_64 x86_64

          Description

          select column_get(column_create('float', 1.23456789012345E+100 as double), 'float' as double);
-> 1.23456789012345e100

select column_json(column_create('float', 1.23456789012345E+100 as double));
-> {"float":"1e100"}

select column_json(column_create('float', 1.23456789012345E+10 as double));
-> {"float":"1.2e10"}

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

                  • Assignee:
                    sanja Oleksandr Byelkin
                    Reporter:
                    thefsb Tom
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated: