[JBoss JIRA] Created: (TEIID-755) Oracle Connector is not honouring metadata when rewriting ORDER BY clause
by Larry O'Leary (JIRA)
Oracle Connector is not honouring metadata when rewriting ORDER BY clause
-------------------------------------------------------------------------
Key: TEIID-755
URL: https://jira.jboss.org/jira/browse/TEIID-755
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 6.1.0, 6.0.0, 6.2.0
Reporter: Larry O'Leary
Assignee: Steven Hawkins
Priority: Minor
Fix For: 6.2.0
When executing a query that contains an ORDER BY clause, the Oracle Connector is rewriting the query using the column name given by the MM query rather than the source name as specified in the source model. What this means is that column name case is not being enforced.
For example:
MM User Command:
SELECT INTKEY FROM BQT1.SMALLA UNION SELECT INTKEY FROM BQT1.SMALLB ORDER BY INTKEY
Model represents INTKEY as IntKey for source name. Currently we rewrite as:
SELECT SmallA.IntKey FROM SmallA UNION SELECT SmallB.IntKey FROM SmallB ORDER BY INTKEY
This should actually be:
SELECT SmallA.IntKey FROM SmallA UNION SELECT SmallB.IntKey FROM SmallB ORDER BY IntKey
Although this does not trigger a failure with the current implementation, if the column names were qualified is SQL identifiers, the query would fail as Oracle is expecting a column name of "IntKey" and would not know what "INTKEY" was.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 10 months
[JBoss JIRA] Commented: (TEIID-974) XML-Relational connectors have trouble with reponse XMLs that contain DTD reference
by John Doyle (JIRA)
[ https://jira.jboss.org/browse/TEIID-974?page=com.atlassian.jira.plugin.sy... ]
John Doyle commented on TEIID-974:
----------------------------------
I don't know of any specific test for this, the original hasn't been resolved yet. When JChoate was initially developing the connectors he used a servlet that took a file name as an input param and returned that file from the server's filesystem as the XML response. A servlet like that could be used for lots of different tests.
> XML-Relational connectors have trouble with reponse XMLs that contain DTD reference
> -----------------------------------------------------------------------------------
>
> Key: TEIID-974
> URL: https://jira.jboss.org/browse/TEIID-974
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 7.1
> Reporter: John Doyle
> Assignee: John Doyle
> Fix For: 7.0
>
>
> Whenever we tried to query the document with the XML-Relational HTTP Connector, the following error occured:
> java.io.FileNotFoundException: <designer_home>/<docname>_XML.dtd (No such file or directory).
> What it looks like is happening is that this XML document contains a relative reference to a DTD, but instead we look for it in the working directory.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 10 months