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

Drastic loss of precision in COLUMN_JSON() on DOUBLEs

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.18
    • 10.0.23, 10.1.10
    • Dynamic Columns
    • None
    • 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
    • 10.0.23

    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"}

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          sanja Oleksandr Byelkin added a comment - - edited

          inside JSON converter just used %g pritf format to print the value, if you have ideas how to do it universal and not loosing precision just share you thoughts. (and reopen the bug, please)

          sanja Oleksandr Byelkin added a comment - - edited inside JSON converter just used %g pritf format to print the value, if you have ideas how to do it universal and not loosing precision just share you thoughts. (and reopen the bug, please)
          sanja Oleksandr Byelkin added a comment -

          OK, We got some ideas how to fix...

          sanja Oleksandr Byelkin added a comment - OK, We got some ideas how to fix...
          sanja Oleksandr Byelkin added a comment -

          revision-id: 0e6c2f514ebcdb693c3a714f6bdb06cff376b357 (mariadb-10.0.22-39-g0e6c2f5)
          parent(s): 6eb86763619be92f73ba91a126313351b6155d8e
          committer: Oleksandr Byelkin
          timestamp: 2015-12-10 16:17:20 +0100
          message:

          MDEV-8521 Drastic loss of precision in COLUMN_JSON() on DOUBLEs

          fixed conversion

          —

          sanja Oleksandr Byelkin added a comment - revision-id: 0e6c2f514ebcdb693c3a714f6bdb06cff376b357 (mariadb-10.0.22-39-g0e6c2f5) parent(s): 6eb86763619be92f73ba91a126313351b6155d8e committer: Oleksandr Byelkin timestamp: 2015-12-10 16:17:20 +0100 message: MDEV-8521 Drastic loss of precision in COLUMN_JSON() on DOUBLEs fixed conversion —

          People

            sanja Oleksandr Byelkin
            thefsb Tom
            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.