[GitHub] [incubator-paimon] JingsongLi opened a new issue, #736: [Bug] Table Store records and fetches incorrect results with NaN

["JingsongLi (via GitHub)" <gi...@apache.org>]

JingsongLi opened a new issue, #736:
URL: https://github.com/apache/incubator-paimon/issues/736

   ### Search before asking
   
   - [X] I searched in the [issues](https://github.com/apache/incubator-paimon/issues) and found nothing similar.
   
   
   ### Paimon version
   
   0.4
   
   ### Compute Engine
   
   flink
   
   ### Minimal reproduce step
   
   Use the following test data and SQL to reproduce this issue.
   
   gao.csv:
   
   1.0,2.0,aaaaaaaaaaaaaaa
   0.0,0.0,aaaaaaaaaaaaaaa
   1.0,1.0,aaaaaaaaaaaaaaa
   0.0,0.0,aaaaaaaaaaaaaaa
   1.0,0.0,aaaaaaaaaaaaaaa
   0.0,0.0,aaaaaaaaaaaaaaa
   -1.0,0.0,aaaaaaaaaaaaaaa
   1.0,-1.0,aaaaaaaaaaaaaaa
   1.0,-2.0,aaaaaaaaaaaaaaa
   Flink SQL:
   
   Flink SQL> create table T ( a double, b double, c string ) WITH ( 'connector' = 'filesystem', 'path' = '/tmp/gao.csv', 'format' = 'csv' );
   [INFO] Execute statement succeed.
   
   Flink SQL> create table S ( a string, b double ) WITH ( 'path' = '/tmp/store' );
   [INFO] Execute statement succeed.
   
   Flink SQL> insert into S select c, a / b from T;
   [INFO] Submitting SQL update statement to the cluster...
   [INFO] SQL update statement has been successfully submitted to the cluster:
   Job ID: 851d7b3c233061733bdabbf30f20d16f
   
   
   Flink SQL> select c, a / b from T;
   +-----------------+-----------+
   |               c |    EXPR$1 |
   +-----------------+-----------+
   | aaaaaaaaaaaaaaa |       0.5 |
   | aaaaaaaaaaaaaaa |       NaN |
   | aaaaaaaaaaaaaaa |       1.0 |
   | aaaaaaaaaaaaaaa |       NaN |
   | aaaaaaaaaaaaaaa |  Infinity |
   | aaaaaaaaaaaaaaa |       NaN |
   | aaaaaaaaaaaaaaa | -Infinity |
   | aaaaaaaaaaaaaaa |      -1.0 |
   | aaaaaaaaaaaaaaa |      -0.5 |
   +-----------------+-----------+
   9 rows in set
   
   Flink SQL> select * from S;
   +-----------------+-----------+
   |               a |         b |
   +-----------------+-----------+
   | aaaaaaaaaaaaaaa | -Infinity |
   | aaaaaaaaaaaaaaa | -Infinity |
   | aaaaaaaaaaaaaaa | -Infinity |
   | aaaaaaaaaaaaaaa | -Infinity |
   | aaaaaaaaaaaaaaa | -Infinity |
   | aaaaaaaaaaaaaaa | -Infinity |
   | aaaaaaaaaaaaaaa | -Infinity |
   | aaaaaaaaaaaaaaa |      -1.0 |
   | aaaaaaaaaaaaaaa |      -0.5 |
   +-----------------+-----------+
   9 rows in set
   Note that this issue may also affect FieldStatsCollector.
   
   ### What doesn't meet your expectations?
   
   Wrong result
   
   ### Anything else?
   
   _No response_
   
   ### Are you willing to submit a PR?
   
   - [ ] 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: issues-unsubscribe@paimon.apache.org.apache.org

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

[GitHub] [incubator-paimon] JingsongLi closed issue #736: [Bug] Table Store records and fetches incorrect results with NaN

["JingsongLi (via GitHub)" <gi...@apache.org>]

JingsongLi closed issue #736: [Bug] Table Store records and fetches incorrect results with NaN
URL: https://github.com/apache/incubator-paimon/issues/736


-- 
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: issues-unsubscribe@paimon.apache.org

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