[
https://issues.apache.org/jira/browse/TRAFODION-3262?focusedWorklogId=219790&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-219790
]
ASF GitHub Bot logged work on TRAFODION-3262:
---------------------------------------------
Author: ASF GitHub Bot
Created on: 28/Mar/19 03:33
Start Date: 28/Mar/19 03:33
Worklog Time Spent: 10m
Work Description: SuJinpei commented on pull request #1818:
[TRAFODION-3262] Insert float to numeric(19,0) lost precision for some case
URL: https://github.com/apache/trafodion/pull/1818
root cause: when the target numeric type's precision is bigger than 18, the
source float or double data will first be converted to char string which will
call the double_to_char function, then transfer to the server. original
double_to_char only keep 'precision' significant digits. In this case, the
caller provides the precision with 6 for float datatype, so last 2 digits'
precision lost.
solution: now, the 'precision' parameter means the number of digits after
the decimal point which is the caller really meant to do. To prevent precision
lost, the conversion will fail if the caller doesn't provide enough space to
receive the result.
verify: no new issue was found by running coast to verify the fix.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 219790)
Time Spent: 4h (was: 3h 50m)
> Insert float to numeric(19,0) lost precision for some case.
> -----------------------------------------------------------
>
> Key: TRAFODION-3262
> URL: https://issues.apache.org/jira/browse/TRAFODION-3262
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-odbc-linux, client-odbc-windows
> Affects Versions: 2.2.0
> Reporter: 苏锦佩
> Assignee: 苏锦佩
> Priority: Critical
> Time Spent: 4h
> Remaining Estimate: 0h
>
> For example,the ddl of table is "create table tb(c1 numeric(18,0), c2
> numeric(19,0))".Insert the same value 12345678 by SQL_C_FLOAT,the values of
> C1 and C2 are inconsistent when querying the table.C1:12345678,C2:12345700。
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
