framework/resources/Functional/crossjoin/crossJoinThenFilter8.sql

set `planner.enable_nljoin_for_scalar_only` = false;
select c.c_custkey,o.o_orderkey from customer c cross join orders o where year(o.o_orderdate) = 1992 order by c.C_ACCTBAL,c.c_custkey,o.o_orderkey limit 10;
reset `planner.enable_nljoin_for_scalar_only`;