[teiid-issues] [JBoss JIRA] (TEIID-1645) SELECT COUNT(*) FROM VQT.Agg3 is expecting a result of 1 but 50 is being returned
Steven Hawkins (Closed) (JIRA)
jira-events at lists.jboss.org
Wed Nov 30 17:24:42 EST 2011
[ https://issues.jboss.org/browse/TEIID-1645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins closed TEIID-1645.
---------------------------------
> 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, 7.5
>
> 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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the teiid-issues
mailing list