framework/resources/Functional/joins/join/drill_5051_q.q

select * from (select col_int from typeall_l ORDER BY col_int LIMIT 64 OFFSET 32) subqry LIMIT 16 OFFSET 8;