This content has been marked as final.
Show 2 replies
-
1. Re: Usage of 'Order by' and 'Offset' in teiid query together with offset other than 0
rareddy Jun 20, 2017 8:56 AM (in response to cm.kumar)what is the error?
-
2. Re: Usage of 'Order by' and 'Offset' in teiid query together with offset other than 0
shawkins Jun 20, 2017 9:24 AM (in response to rareddy)This is probably related to [TEIID-4021] MSSQL Pagination - JBoss Issue Tracker
Which had issues addressed by [TEIID-4654] MSSQL pagination with select distinct - JBoss Issue Tracker and [TEIID-4816] SQL Server 2012+ offset order by issue - JBoss Issue Tracker
So 9.2.2+ should have all known issues addressed. Can you retry your scenario with a later version to see if it is addressed?