8:35 a.m.
Van Halbert created TEIID-1899:
----------------------------------
Summary: Getting Assertion when running running Inner Merge Join
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE, ORDERS.O_CLERK,
CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) is added
--
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
8:37 a.m.
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
Van Halbert updated TEIID-1899:
-------------------------------
Attachment: server_with_error.log
Getting Assertion when running running Inner Merge Join
-------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) is added
--
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
8:37 a.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
Van Halbert updated TEIID-1899:
-------------------------------
Summary: Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on
top (was: Getting Assertion when running running Inner Merge Join)
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) is added
--
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
10:12 a.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
Van Halbert updated TEIID-1899:
-------------------------------
Description:
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE, ORDERS.O_CLERK,
CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
was:
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE, ORDERS.O_CLERK,
CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) is added
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
11:01 a.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
Van Halbert commented on TEIID-1899:
------------------------------------
Also seeing it with this query:
SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE, ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY,
CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL >
9514.5)
Each table, with its where clause, works. But combine the ASSERTION occurs:
10:58:11,842 ERROR [PROCESSOR] Unexpected exception for request LV4pMCDmToOE.11
java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
at org.teiid.core.util.Assertion.failed(Assertion.java:73)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:224)
at org.teiid.common.buffer.TupleBuffer$1.getBatch(TupleBuffer.java:335)
at
org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:61)
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
11:07 a.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1899:
---------------------------------------
Can you reproduce on 7.6.1/7.6?
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
11:34 a.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1899:
---------------------------------------
Nevermind, the issue exists there as well.
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
2:06 p.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1899.
-----------------------------------
Fix Version/s: 7.6.1
8.0
Resolution: Done
The issue is that distinct dependent tuple buffers are being removed (previously a new
tuplebuffer was always created regardless of whether the distinct operation was needed or
not).
Note that this issue was also partially due to the dependent join backoff logic, since
that was triggering a normal handling of the effective semi-join. 7.4.x may also benefit
from change r3780 that more narrowly applies the backoff logic to only when column ndv
values are known.
I noticed a TODO in that we could be doing a better value of sharing potentially distinct
sorted independent results with the dependent join logic. For a non-enhanced merge,
currently both the dependent join and the criteria handling logic will perform a sort.
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.6.1, 8.0
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
8:12 p.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-1899:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=807870
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.7, 8.0
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
8:12 p.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1899:
------------------------------------------------
Larry O'Leary <loleary(a)redhat.com> made a comment on [bug
807870|https://bugzilla.redhat.com/show_bug.cgi?id=807870]
The issue is that distinct dependent tuple buffers are being removed (previously a new
tuplebuffer was always created regardless of whether the distinct operation was needed or
not).
Note that this issue was also partially due to the dependent join backoff logic, since
that was triggering a normal handling of the effective semi-join. 7.4.x may also benefit
from change r3780 that more narrowly applies the backoff logic to only when column ndv
values are known.
This issue was fixed in upstream as TEIID-1899 and needs to be back-ported for inclusion
in the current release as a hot-fix patch or single-fix patch. As recommended by
TEIID-1899, TEIID-1868 and TEIID-1533 should also be back-ported.
Relevant changes in upstream:
Steven Hawkins submitted changeset 3803 to 7.6.x in Teiid (2 files) - 18/Jan/12 3:04 PM
TEIID-1899 fixing assertion error during join
*
branches/7.6.x/engine/src/main/java/org/teiid/query/processor/relational/DependentCriteriaProcessor.java
*
branches/7.6.x/engine/src/test/java/org/teiid/query/processor/TestDependentJoins.java
Steven Hawkins submitted changeset 3780 to 7.6.x in Teiid (2 files) - 06/Jan/12 3:04 PM
TEIID-1868 Internal Materialized View - Load/Refresh and Assertion Failed
TEIID-1533 additional controls for dependent joins
*
branches/7.6.x/engine/src/main/java/org/teiid/query/optimizer/relational/rules/NewCalculateCostUtil.java
*
branches/7.6.x/engine/src/test/java/org/teiid/query/processor/TestDependentJoins.java
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.7, 8.0
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
8:12 p.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-1899:
-------------------------------------------
Bugzilla Update: Perform
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.7, 8.0
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
6:20 a.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1899:
------------------------------------------------
Len DiMaggio <ldimaggi(a)redhat.com> made a private comment on [bug
807870|https://bugzilla.redhat.com/show_bug.cgi?id=807870]
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.7, 8.0
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
8:37 a.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1899:
------------------------------------------------
Larry O'Leary <loleary(a)redhat.com> made a private comment on [bug
807870|https://bugzilla.redhat.com/show_bug.cgi?id=807870]
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.7, 8.0
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
3 p.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1899:
------------------------------------------------
jolee(a)redhat.com made a private comment on [bug
807870|https://bugzilla.redhat.com/show_bug.cgi?id=807870]
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.7, 8.0
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
3:42 p.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1899:
------------------------------------------------
Rick Wagner <rwagner(a)redhat.com> made a comment on [bug
807870|https://bugzilla.redhat.com/show_bug.cgi?id=807870]
Changing privacy to 'Red Hat Employee' to try to make this visible to dependent BZ
808218.
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.7, 8.0
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
10:47 a.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1899:
------------------------------------------------
jolee(a)redhat.com changed the Status of [bug
807870|https://bugzilla.redhat.com/show_bug.cgi?id=807870] from NEW to MODIFIED
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.7, 8.0
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
10:47 a.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1899:
------------------------------------------------
jolee(a)redhat.com made a private comment on [bug
807870|https://bugzilla.redhat.com/show_bug.cgi?id=807870]
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.7, 8.0
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
9:56 a.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
Paul Nittel commented on TEIID-1899:
------------------------------------
Testing note: Should be able to use any project/VDB, because the problem failed when
select count() is wrapped a subquery.
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.7, 8.0
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
2:53 p.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
Warren Gibson commented on TEIID-1899:
--------------------------------------
Verified a SELECT COUNT wrapping a subselect works in Bug 808218 - Roll up patch
EDS_5.2_20120501.
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.7, 8.0
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
2:42 p.m.
New subject: [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1899.
---------------------------------
Getting Assertion when running Inner Merge Join query with SELECT
COUNT(*) on top
---------------------------------------------------------------------------------
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.7, 8.0
Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log,
TPC.vdb
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE,
ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY =
ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL <
9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) isn't used
--
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
4519
days inactive
4728
days old
19 comments
5 participants
participants (5)
-
Paul Nittel (JIRA) -
RH Bugzilla Integration (JIRA)
-
Steven Hawkins (JIRA)
-
Van Halbert (JIRA)
-
Warren Gibson (JIRA)