Limit pushdown with offset generate wrong results

With `hive.optimize.limittranspose` in CBO, Hive can generate incorrect results.

For example, I'd say this case should generate 1 row.
https://github.com/apache/hive/blob/rel/release-4.0.0-alpha-2/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out#L1328-L1341