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

[Warren Gibson (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Warren Gibson updated TEIID-1645:
---------------------------------

    Description: 
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

  was:

The VQT.Agg3 transformation is:  SELECT COUNT(*)FROM BQT1.SmallA.  BQT is expecting 1 to be returned but is getting 50.  VDB attached.



> 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.5
>            Reporter: Warren Gibson
>            Assignee: Steven Hawkins
>         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.
For more information on JIRA, see: http://www.atlassian.com/software/jira