[JBoss JIRA] Created: (TEIID-1645) SELECT COUNT(*) FROM VQT.Agg3 is expecting a result of 1 but 50 is being returned
10:04 p.m.
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.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:04 p.m.
New subject: [JBoss JIRA] Updated: (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...
]
Warren Gibson updated TEIID-1645:
---------------------------------
Attachment: QT_MySql50_Push.vdb
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.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 p.m.
New subject: [JBoss JIRA] Updated: (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...
]
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
10:43 p.m.
New subject: [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
2:09 p.m.
New subject: [JBoss JIRA] Updated: (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 updated TEIID-1645:
----------------------------------
Fix Version/s: 7.4.1
Affects Version/s: 7.4
(was: 7.5)
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
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:34 p.m.
New subject: [JBoss JIRA] Resolved: (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 resolved TEIID-1645.
-----------------------------------
Resolution: Done
fixed output element assignment with nested implicit grouping. also fixed a rewrite
optimization that could incorrectly remove implicit grouping.
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
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:12 p.m.
New subject: [JBoss JIRA] Updated: (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 updated TEIID-1645:
----------------------------------
Fix Version/s: 7.5
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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:24 p.m.
New subject: [JBoss JIRA] (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 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
4592
days inactive
4755
days old
7 comments
3 participants
participants (3)
-
Steven Hawkins (Closed) (JIRA) -
Steven Hawkins (JIRA)
-
Warren Gibson (JIRA)