[teiid-issues] [JBoss JIRA] Commented: (TEIID-1645) SELECT COUNT(*) FROM VQT.Agg3 is expecting a result of 1 but 50 is being returned
[
https://issues.jboss.org/browse/TEIID-1645?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1645:
---------------------------------------
I would have thought that Designer would not allow a column without a proper name (a
contant/expression/aggregate without an as clause) to be used for a view definition. The
names of these columns are not guaranteed to be consistent. Also Designer does not use
allow positional definitions - it expects the names to match up. Seems like they need a
validation (or to in general rely on being positional - not name based).
I'll see what's changed on the Teiid side.
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