Wrong results with =ANY subquery

ANY/SOME subqueries are rewritten using MAX/MIN and cross-join. This is wrong transformation for =ANY and <>ANY (and therefore =ALL and <>ALL).

Query

select * from "scott".emp where empno = any (select empno from "scott".emp);

Expected output for above query is all rows from scott.emp but actual is only one row

Test case: e.g. https://github.com/apache/calcite/compare/master...vineetgarg02:CALCITE-2986