[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
[JBoss JIRA] (TEIID-1975) Failure description is incomplete
by Van Halbert (JIRA)
Van Halbert created TEIID-1975:
----------------------------------
Summary: Failure description is incomplete
Key: TEIID-1975
URL: https://issues.jboss.org/browse/TEIID-1975
Project: Teiid
Issue Type: Bug
Components: Server
Affects Versions: 8.0
Reporter: Van Halbert
Assignee: Steven Hawkins
Priority: Minor
Trying to add a translator to be loaded by the AS 7 server, and getting this error:
13:51:24,836 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 46) Operation ("add") failed - address: ([
("subsystem" => "teiid"),
("translator" => "object")
]) - failure description: "Translator \"TEIID50009\" not found in the module \"object\" "
The "TEIID50009", based on the description, looks like it should have been the name of translator not found? I'm not sure, but the sentence is confusing.
--
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-1968) NPE in GoupingNod
by Mark Addleman (JIRA)
Mark Addleman created TEIID-1968:
------------------------------------
Summary: NPE in GoupingNod
Key: TEIID-1968
URL: https://issues.jboss.org/browse/TEIID-1968
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.7
Reporter: Mark Addleman
Assignee: Steven Hawkins
I get an NPE within Teiid's GroupingNode.initialize when executing the following SQL
SELECT XMLELEMENT(NAME metadata,
XMLFOREST(objectName as objectName),
(SELECT XMLAGG(XMLELEMENT(name subTypes,
XMLFOREST(subType)))
FROM chorus_metadata.property_filtered b
WHERE a.objectName=b.objectName
GROUP BY subType)
)
FROM chorus_metadata.property_filtered a
GROUP BY objectName
LIMIT 1
chorus_metadata.property_filtered is an internal materialized view.
--
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-1974) Function RAND() should be RANDOM(int, int) for Teradata
by Paul Nittel (JIRA)
Paul Nittel created TEIID-1974:
----------------------------------
Summary: Function RAND() should be RANDOM(int, int) for Teradata
Key: TEIID-1974
URL: https://issues.jboss.org/browse/TEIID-1974
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.6
Reporter: Paul Nittel
Assignee: Steven Hawkins
This query: SELECT INTKEY, RAND() FROM SmallA works for all source except Teradata. With TD it get this exception:
[Teradata Database] [TeraJDBC 13.00.00.06] [Error 3706] [SQLState 42000] Syntax error: expected something between '(' and ')'.
After looking at the TD Web site, I found it expects the RANDOM function with low and high limits (integers). It expects something like: SELECT INTKEY, RANDOM(2,6) FROM SmallA
It would appear we need to be able to pass the function in that form to the source.
If I try to query (through a VDB) SELECT INTKEY, RANDOM(2,6) FROM SmallA or SELECT INTKEY, RAND(2,6) FROM SmallA, Teiid reports the function is in an unknown form. (This wasn't a surprise.)
--
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