[teiid-issues] [JBoss JIRA] (TEIID-2005) Source query for Oracle sequence adds an alias, which will return "sequence doesn't exist" errors
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-2005.
-----------------------------------
Resolution: Done
Updated the conversion visitor to strip aliases from DUAL. Also updated the javadocs for
the getSupportedMethods to be more explicit about the use of SourceSystemFunctions.
Source query for Oracle sequence adds an alias, which will return
"sequence doesn't exist" errors
-------------------------------------------------------------------------------------------------
Key: TEIID-2005
URL: https://issues.jboss.org/browse/TEIID-2005
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 7.4.1
Reporter: Debbie Steigner
Assignee: Steven Hawkins
Fix For: 7.7.1, 8.0
Per Documentation, setup an oracle sequence or use the EV.vdb on
slnttech04.mmx.gss.redhat.com:31100
run the below query:
select cpe_seq from Evolvecontrol.seq_gen
It will error with
[SELECT g_0.tid_cl_seq.nextval FROM dual g_0] [SQLException]ORA-02289: sequence does not
exist
--
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