Symptom
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)
Read more...
Environment
- SAP IQ 16.1
Product
Keywords
LIMIT, OFFSET, Force_No_Scroll_Cursors, 829077, 16.1, IQ , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.