> Should we treat them equally?
>
>
>
>
> Sent from my iPhone
>
> On Oct 20, 2021, at 9:55 AM, Yingyi Bu wrote:
>
>
> Per SQL spec, I think your join query can only be run as a NestedLoopJoin
> or CartesianProduct. See page 241 in SQL-99 (
> http://web.cecs
Per SQL spec, I think your join query can only be run as a NestedLoopJoin
or CartesianProduct. See page 241 in SQL-99 (
http://web.cecs.pdx.edu/~len/sql1999.pdf).
In other words, it might be a correctness bug in other systems if they run
your query as a hash join.
> Here the purpose of adding a r
