yashmayya opened a new issue, #15629:
URL: https://github.com/apache/pinot/issues/15629
- Consider a query like:
```
with t1(x, y) AS (
select null, 1
union
select 'b', 2
), t2(x, y) AS (
select 'b', 3
union
select null, 4
)
select * from t1 join t2 on t1.x = t2.x;
```
- The output in a standard database like Postgres is:
```
x | y | x | y
---+---+---+---
b | 2 | b | 3
```
- This is because the condition `null = null` does *NOT* evaluate to `true`.
- However, the output in Pinot is:
```
x | y | x0 | y0
-------------
-- | 1 | -- | 4
b | 2 | b | 3
```
- Pinot and Calcite also don't evaluate predicates like `null = null` to
`true`, however, the physical hash join operator implementation doesn't take
this into account while comparing join keys. This is a bug and should be fixed.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
