[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...
]
RH Bugzilla Integration commented on TEIID-2005:
------------------------------------------------
Rick Wagner <rwagner(a)redhat.com> made a comment on [bug
813932|https://bugzilla.redhat.com/show_bug.cgi?id=813932]
This bug is important to GSS because it's been repaired under EDS 5.2 via BZ 816602.
If we don't get it put in EDS 5.3, a customer on patched 5.2 would notice a
regression. Can we please put this in EDS 5.3 to prevent this?
Thanks,
Rick
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