[JBoss JIRA] (TEIID-2005) Source query for Oracle sequence adds an alias, which will return "sequence doesn't exist" errors
12:59 p.m.
Debbie Steigner created TEIID-2005:
--------------------------------------
Summary: 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: Query Engine
Affects Versions: 7.4.1
Reporter: Debbie Steigner
Assignee: Steven Hawkins
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
1:05 p.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-2005:
----------------------------------
Fix Version/s: 7.7.1
8.0
Component/s: JDBC Connector
(was: Query Engine)
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
1:07 p.m.
[
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
2:32 p.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-2005:
-------------------------------------------
Bugzilla Update: Perform
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
2:32 p.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-2005:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=813932
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
7:18 a.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2005:
------------------------------------------------
jolee(a)redhat.com made a private comment on [bug
813932|https://bugzilla.redhat.com/show_bug.cgi?id=813932]
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
2:08 p.m.
[
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
2:17 p.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2005:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug
813932|https://bugzilla.redhat.com/show_bug.cgi?id=813932] from NEW to MODIFIED
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
2:17 p.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2005:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> made a private comment on [bug
813932|https://bugzilla.redhat.com/show_bug.cgi?id=813932]
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
10:41 a.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-2005:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=813932,
https://bugzilla.redhat.com/show_bug.cgi?id=816602 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=813932)
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
10:41 a.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-2005:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=813932 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=813932)
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
10:43 a.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2005:
------------------------------------------------
jolee(a)redhat.com made a private comment on [bug
816602|https://bugzilla.redhat.com/show_bug.cgi?id=816602]
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
10:43 a.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2005:
------------------------------------------------
jolee(a)redhat.com changed the Status of [bug
816602|https://bugzilla.redhat.com/show_bug.cgi?id=816602] from ASSIGNED to MODIFIED
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
7:46 a.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2005:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug
813932|https://bugzilla.redhat.com/show_bug.cgi?id=813932] from MODIFIED to ON_QA
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
10:22 a.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2005:
------------------------------------------------
jolee(a)redhat.com changed the Status of [bug
816602|https://bugzilla.redhat.com/show_bug.cgi?id=816602] from MODIFIED to CLOSED
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
10:22 a.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2005:
------------------------------------------------
jolee(a)redhat.com made a private comment on [bug
816602|https://bugzilla.redhat.com/show_bug.cgi?id=816602]
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
2:08 p.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2005:
------------------------------------------------
wgibson(a)redhat.com made a comment on [bug
813932|https://bugzilla.redhat.com/show_bug.cgi?id=813932]
Verified query returns results and does not return error.
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
2:08 p.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2005:
------------------------------------------------
wgibson(a)redhat.com changed the Status of [bug
813932|https://bugzilla.redhat.com/show_bug.cgi?id=813932] from ON_QA to VERIFIED
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
1:09 p.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2005:
------------------------------------------------
wgibson(a)redhat.com changed the Status of [bug
813932|https://bugzilla.redhat.com/show_bug.cgi?id=813932] from VERIFIED to CLOSED
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
7:42 a.m.
[
https://issues.jboss.org/browse/TEIID-2005?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-2005.
---------------------------------
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
4513
days inactive
4632
days old
19 comments
3 participants
participants (3)
-
Debbie Steigner (JIRA) -
RH Bugzilla Integration (JIRA)
-
Steven Hawkins (JIRA)