You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by "LingweiKuang (via GitHub)" <gi...@apache.org> on 2024/11/20 08:26:24 UTC

[I] [Bug] The CAST operator has a logical error causing precision loss when converting floating-point values. [iotdb]

LingweiKuang opened a new issue, #14149:
URL: https://github.com/apache/iotdb/issues/14149

   ### Search before asking
   
   - [X] I searched in the [issues](https://github.com/apache/iotdb/issues) and found nothing similar.
   
   
   ### Version
   
   version 1.3.3 (Build: ad95a7e)
   
   ### Describe the bug and provide the minimal reproduce step
   
   ```
   DROP DATABASE root.db0
   CREATE DATABASE root.db0
   
   CREATE TIMESERIES root.db0.t1 WITH datatype=FLOAT compressor=GZIP 'MAX_POINT_NUMBER'='6';
   INSERT INTO root.db0(timestamp, t1) VALUES (1643027794590, 0.5522);
   INSERT INTO root.db0(timestamp, t1) VALUES (1643027794600, 0.8044);
   
   # query 1
   select t1 from root.db0 where t1 <= 0.8044
   
   # query 2
   select t1 from root.db0 where cast(t1 as float) <= 0.8044
   ```
   
   ### What did you expect to see?
   
   Query 1 returned result set: 0.5522 and 0.8044
   
   Query 2 returned result set: 0.5522 and 0.8044
   
   
   ### What did you see instead?
   
   Query 1 returned result set: 0.5522 and 0.8044
   
   Query 2 returned result set: 0.5522
   
   
   ### Anything else?
   
   Dear IoTDB team, When using the CAST operator to convert a FLOAT value to FLOAT, the value theoretically should remain unchanged. However, the above test case indicates that a logical error causing precision loss occurs after the CAST conversion.
   
   ### Are you willing to submit a PR?
   
   - [X] I'm willing to submit a PR!


-- 
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.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Bug] The CAST operator has a logical error causing precision loss when converting floating-point values. [iotdb]

Posted by "LingweiKuang (via GitHub)" <gi...@apache.org>.
LingweiKuang commented on issue #14149:
URL: https://github.com/apache/iotdb/issues/14149#issuecomment-2487873850

   ![The CAST operator has a logical error causing precision loss when converting floating-point values](https://github.com/user-attachments/assets/7506069e-6d5f-4061-b0a8-b2bfc1b109a4)
   


-- 
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.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Bug] The CAST operator has a logical error causing precision loss when converting floating-point values. [iotdb]

Posted by "CritasWang (via GitHub)" <gi...@apache.org>.
CritasWang commented on issue #14149:
URL: https://github.com/apache/iotdb/issues/14149#issuecomment-2492885524

   Thank you for your feedback


-- 
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.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org