3431040 - SQL functions 'LIMIT' and 'OFFSET' work incorrectly with thousands - SAP IQ

SAP IQ queries partially failing while using LIMIT with OFFSET with thousands of rows.

This problem will be reproduced when you set a certain large value to OFFSET.

(dba)> SELECT  col1, col2, col3  from tableA ORDER BY col1  LIMIT 5 OFFSET 1980
col1                       col2 col3
-------------------------------------------------------------------------
2024-02-02 13:24:01.050534 2201 AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
2024-02-02 13:24:01.055847 2202 AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
2024-02-02 13:24:01.059824 2203 AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
2024-02-02 13:24:01.064062 2204 AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
...
...
2024-02-02 13:24:06.752255 2999 AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

(First 500 rows)

(dba)> SELECT  col1, col2, col3  from tableA ORDER BY col1  LIMIT 5 OFFSET 1979
col1                       col2 col3
-------------------------------------------------------------------------
2024-02-06 14:21:13.595528 1980 AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
2024-02-06 14:21:13.597416 1981 AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
2024-02-06 14:21:13.599269 1982 AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
2024-02-06 14:21:13.601198 1983 AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
2024-02-06 14:21:13.603053 1984 AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

(5 rows)

• SAP IQ 16.1

LIMIT, OFFSET, Force_No_Scroll_Cursors, 829077, 16.1, IQ , KBA , BC-SYB-IQ , Sybase IQ , Problem