3210688 - tds protocol error on SELECT ROWS LIMIT query with compatibility mode enabled - SAP ASE

• From ASE 16.0 SP03, ASE supports ROWS LIMIT clause for SELECT statements which allow to query a specified number (limit) of rows from a specified (offset) row.
• However, when a SELECT...ROWS LIMIT query runs, a tds protocol error occurs as below if compatibility mode is enabled.

1> select * from testcompat1 rows limit 5 offset 5
2> go

 col1        col2                 
 ----------- -------------------- 
           1 TEST1                
CT-LIBRARY error:
 ct_fetch(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received.
1>

SAP Adaptive Server Enterprise 16.0 SP03 and above

826668, CR#826668, CR826668 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem