[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