[
https://issues.apache.org/jira/browse/IGNITE-24894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17937331#comment-17937331
]
Aleksey Plekhanov commented on IGNITE-24894:
--------------------------------------------
Query
{code:java}
select * from part where p_brand = 'Brand#23' and p_container = 'MED BOX' {code}
Returns 0 rows for scale 0.01.
Aggregates for 0 rows return null - it's a correct behaviour.
> Calcite. TPC-H query #17: incorrectly returns NULL as a result for scale=0.01
> -----------------------------------------------------------------------------
>
> Key: IGNITE-24894
> URL: https://issues.apache.org/jira/browse/IGNITE-24894
> Project: Ignite
> Issue Type: Bug
> Reporter: Sergey Korotkov
> Priority: Major
> Labels: ise, tpch
> Attachments: TpchQ17Test.java
>
>
> For scale=0.01 query #17 returns a single row (which is correct) but it
> contains NULL value.
> For scales 0.1 and 1.0 returns non-null value.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
