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

          thefsb Tom created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Status Open [ 1 ] Confirmed [ 10101 ]
          elenst Elena Stepanova made changes -
          Fix Version/s 10.0 [ 16000 ]
          Assignee Oleksandr Byelkin [ sanja ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Sprint 10.0.23-1 [ 23 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Rank Ranked higher
          sanja Oleksandr Byelkin made changes -
          Status Confirmed [ 10101 ] In Progress [ 3 ]
          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 made changes -
          Status In Progress [ 3 ] Stalled [ 10000 ]
          sanja Oleksandr Byelkin made changes -
          Fix Version/s 10.0.23 [ 20401 ]
          Fix Version/s 10.0 [ 16000 ]
          Resolution Won't Fix [ 2 ]
          Status Stalled [ 10000 ] Closed [ 6 ]

          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 made changes -
          Resolution Won't Fix [ 2 ]
          Status Closed [ 6 ] Stalled [ 10000 ]

          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 —
          sanja Oleksandr Byelkin made changes -
          Fix Version/s 10.1.10 [ 20402 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 70742 ] MariaDB v4 [ 149408 ]

          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.