YQL: Cross join results depends on input order

[mxkovalev]

The attached request has cross join over table and window function. Different input order leads to different result. Seems window function doesn't work correctly.

P.S. Roman asked to assign this ticket to you as the main professional in this sphere.

test1_bad_sql.txt
test2_good_sql.txt
trace_opt_1_bad.txt
trace_opt_2_good.txt

[Tony-Romanov]

According to SQL standard, if there is no ORDER BY, the database is free to return the rows in any order it thinks is most efficient.

[mxkovalev]

The question is not about order, Cross Join(a,b) returns 2 rows, Cross Join (b,a) return 30 rows. It looks incorrect.

[mxkovalev]

There is an issue with hang request (internal ticket is YQL-18858). That's why changes were reverted.