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