[JBoss JIRA] (TEIID-1988) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
by Johnathon Lee (JIRA)
Johnathon Lee created TEIID-1988:
------------------------------------
Summary: Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
Key: TEIID-1988
URL: https://issues.jboss.org/browse/TEIID-1988
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Johnathon Lee
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
12 years, 4 months
[JBoss JIRA] (TEIID-1991) GROUP BY pushdown into subselect of UNIONs
by Mark Addleman (JIRA)
Mark Addleman created TEIID-1991:
------------------------------------
Summary: GROUP BY pushdown into subselect of UNIONs
Key: TEIID-1991
URL: https://issues.jboss.org/browse/TEIID-1991
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.7
Reporter: Mark Addleman
Assignee: Steven Hawkins
Attachments: plan.txt
If have a query of the form
SELECT a FROM (
SELECT a FROM (
SELECT a FROM ds.t1
) u
) t GROUP BY a
Teiid correctly optimizes the inner SELECT to SELECT 1 FROM ds.t1. However, if the inner subselect is a union:
SELECT a FROM (
SELECT a FROM (
SELECT a FROM ds.t1 UNION
SELECT a FROM ds.t2
) u
) t GROUP BY a
Teiid does not optimize to
SELECT 1 FROM ds.t1 UNION
SELECT 1 FROM ds.t2
as I would expect.
See attached plan
--
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
12 years, 4 months
[JBoss JIRA] (TEIID-1953) Greenplum DB - BQT correlated subquery failures
by Warren Gibson (JIRA)
Warren Gibson created TEIID-1953:
------------------------------------
Summary: Greenplum DB - BQT correlated subquery failures
Key: TEIID-1953
URL: https://issues.jboss.org/browse/TEIID-1953
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 7.6
Reporter: Warren Gibson
Assignee: Steven Hawkins
Testing Greenplum DB against Teiid 7.6.0 Final. Greenplum DB is returning the following on 59 BQT queries: Remote org.postgresql.util.PSQLException: ERROR: Greenplum Database does not yet support that query. Detail: The query contains a correlated subquery. I am using the postgresql Translator.
A couple example queries are listed below:
SELECT INTKEY, STRINGNUM FROM BQT1.SmallA AS A WHERE NOT (EXISTS (SELECT STRINGNUM FROM BQT1.SmallA AS B WHERE B.INTKEY = A.INTKEY))
SELECT INTKEY, STRINGKEY FROM BQT1.SMALLA AS A WHERE STRINGKEY = (SELECT MASTRINGKEY) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY, STRINGKEY
--
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
12 years, 4 months
[JBoss JIRA] (TEIID-1966) supportsInCriteria is ignored
by Michal Navrkal (JIRA)
Michal Navrkal created TEIID-1966:
-------------------------------------
Summary: supportsInCriteria is ignored
Key: TEIID-1966
URL: https://issues.jboss.org/browse/TEIID-1966
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Environment: Win7
Reporter: Michal Navrkal
Assignee: Steven Hawkins
SQL query whose WHERE clause contains ORed conditions is sent down to custom translator as IN clause even when the custom translator doesn' support IN clause.
public class EWSExecutionFactory extends
ExecutionFactory<ConnectionFactory, EWSConnection> {
...
@Override
public boolean supportsInCriteria()
{
return false;
}
@Override
public boolean supportsInCriteriaSubquery()
{
return false;
}
}
SELECT COUNT(*) FROM Storage.MVDETAIL WHERE Storage.MVDETAIL.CUA = '2D03' OR Storage.MVDETAIL.CUA = '2D07'
is translated to
SELECT COUNT(*) FROM Storage.MVDETAIL WHERE Storage.MVDETAIL.CUA IN ('2D03', '2D07')
--
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
12 years, 4 months