[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1645) SELECT COUNT(*) FROM VQT.Agg3 is expecting a result of 1 but 50 is being returned

SELECT COUNT(*) FROM VQT.Agg3 is expecting a result of 1 but 50 is being returned --------------------------------------------------------------------------------- Key: TEIID-1645 URL: https://issues.jboss.org/browse/TEIID-1645 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Warren Gibson Assignee: Steven Hawkins Fix For: 7.4.1 Attachments: QT_MySql50_Push.vdb The VQT.Agg3 transformation is: SELECT COUNT(*)FROM BQT1.SmallA. BQT is expecting 1 to be returned but is getting 50. VDB attached. The push down query in SOAP 5.1 is "SELECT COUNT(*) AS c_0 FROM (SELECT COUNT(*) AS c_0 FROM smalla AS g_0) AS v_0 LIMIT 100" and we get the expected results of 1 The push down query in Teiid 7.5Alpha is "SELECT COUNT(*) AS c_0 FROM (SELECT 1 AS c_0 FROM smalla AS g_0) AS v_0 LIMIT 100" and we get a result of 50