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

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