[jira] [Created] (IOTDB-2814) The native addition, subtraction, multiplication and division in the current sql will cause precision problems

["limeng32 (Jira)" <ji...@apache.org>]

limeng32 created IOTDB-2814:
-------------------------------

             Summary: The native addition, subtraction, multiplication and division in the current sql will cause precision problems
                 Key: IOTDB-2814
                 URL: https://issues.apache.org/jira/browse/IOTDB-2814
             Project: Apache IoTDB
          Issue Type: Improvement
            Reporter: limeng32
         Attachments: image-2022-03-28-10-32-44-405.png

 Currently, native addition, subtraction, multiplication and division of Float fields on SQL will cause problems with the accuracy of the results, as shown in the following figure:
!image-2022-03-28-10-32-44-405.png!
This is mainly due to the fact that there is no special treatment for precision when converting the Float type to the Double type in the program. This problem will not appear when there are no four arithmetic operations, but the problem is obvious when there are four arithmetic operations.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)