I run the following query against MySQL, PostgreSQL and Calcite and found
that Calcite returns 0 rows, while the other DBMSs return a single row of
two NULLs

SELECT * FROM (SELECT NULLIF(5, 5)) a, (SELECT NULLIF(5, 5)) b

Is this possibly a bug ? Is there a configuration or something to tweak to
return the same output MySQL and PostgreSQL without modifying the query ?

Thanks,
Gelbana

Reply via email to