[ https://issues.jboss.org/browse/TEIID-4021?page=com.atlassian.jira.plugin... ] Mark Tawk edited comment on TEIID-4021 at 8/25/16 10:39 AM: ------------------------------------------------------------ I have implemented the fix, it works perfectly with SQL Server 2012. But with SQL Server 2008 and 2005, i'm getting an exception whenever i use pagination in Teiid query. org.teiid.jdbc.TeiidSQLException: TEIID30504 implify_dataModel_YfVDB: 102 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."DbTRX20112015LRed1006_Amoun" AS c_0, g_0."DbTRX20112015LRed1006_Creat" AS c_1, g_0."DbTRX20112015LRed1006_Lastt" AS c_2, g_0."DbTRX20112015LRed1006_RIM" AS c_3, g_0."DbTRX20112015LRed1006_TRX20" AS c_4, g_0."ID" AS c_5 FROM "implify_data"."dbo"."DbTRX20112015LRed1006" g_0 ORDER BY @@version OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY] Here is the query plan: <?xml version='1.0' encoding='UTF-8'?><node name="AccessNode"><property name="Relational Node ID"><value>0</value></property><property name="Output Columns"><value>DbTRX20112015LRed1006_DbTRX2 (double)</value><value>DbTRX20112015LRed1006_DbTRX21 (timestamp)</value><value>DbTRX20112015LRed1006_DbTRX22 (timestamp)</value><value>DbTRX20112015LRed1006_DbTRX23 (integer)</value><value>DbTRX20112015LRed1006_DbTRX24 (integer)</value><value>DbTRX20112015LRed1006_ID (integer)</value></property><property name="Statistics"><value>Node Output Rows: 0</value><value>Node Next Batch Process Time: 0</value><value>Node Cumulative Next Batch Process Time: 16</value><value>Node Cumulative Process Time: 0</value><value>Node Next Batch Calls: 1</value><value>Node Blocks: 1</value></property><property name="Cost Estimates"><value>Estimated Node Cardinality: 10.0</value></property><property name="Query"><value>SELECT g_0.DbTRX20112015LRed1006_Amoun AS c_0, g_0.DbTRX20112015LRed1006_Creat AS c_1, g_0.DbTRX20112015LRed1006_Lastt AS c_2, g_0.DbTRX20112015LRed1006_RIM AS c_3, g_0.DbTRX20112015LRed1006_TRX20 AS c_4, g_0.ID AS c_5 FROM implify_dataModel_Yf.implify_data.dbo.DbTRX20112015LRed1006 AS g_0 LIMIT 10</value></property><property name="Model Name"><value>implify_dataModel_Yf</value></property><property name="Data Bytes Sent"><value>0</value></property><property name="Planning Time"><value>0</value></property></node> was (Author: mtawk): I have implemented the fix, it works perfectly with SQL Server 2012. But with SQL Server 2008 and 2005, i'm getting an exception whenever i use pagination in Teiid query. org.teiid.jdbc.TeiidSQLException: TEIID30504 implify_dataModel_YfVDB: 102 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."DbTRX20112015LRed1006_Amoun" AS c_0, g_0."DbTRX20112015LRed1006_Creat" AS c_1, g_0."DbTRX20112015LRed1006_Lastt" AS c_2, g_0."DbTRX20112015LRed1006_RIM" AS c_3, g_0."DbTRX20112015LRed1006_TRX20" AS c_4, g_0."ID" AS c_5 FROM "implify_data"."dbo"."DbTRX20112015LRed1006" g_0 ORDER BY @@version OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY] -- This message was sent by Atlassian JIRA (v6.4.11#64026)