[MDEV-8521] Drastic loss of precision in COLUMN_JSON() on DOUBLEs Created: 2015-07-22  Updated: 2015-12-10  Resolved: 2015-12-10

Status: Closed
Project: MariaDB Server
Component/s: Dynamic Columns
Affects Version/s: 10.0.18
Fix Version/s: 10.0.23, 10.1.10

Type: Bug Priority: Major
Reporter: Tom Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
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

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



 Comments   
Comment by Oleksandr Byelkin [ 2015-12-10 ]

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)

Comment by Oleksandr Byelkin [ 2015-12-10 ]

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

Comment by Oleksandr Byelkin [ 2015-12-10 ]

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

—

Generated at Thu Feb 08 07:27:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.