[teiid-issues] [JBoss JIRA] (TEIID-2069) Optimze add LIMIT clause to SELECT within a Virtual Procedure using Oracle
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2069:
------------------------------------------------
jolee(a)redhat.com made a comment on [bug
830970|https://bugzilla.redhat.com/show_bug.cgi?id=830970]
Description of problem:
Please refer to TEIID-2069
Version-Release number of selected component (if applicable):
How reproducible:
Steps to Reproduce:
1.
2.
3.
Actual results:
Expected results:
Additional info:
Optimze add LIMIT clause to SELECT within a Virtual Procedure using
Oracle
--------------------------------------------------------------------------
Key: TEIID-2069
URL: https://issues.jboss.org/browse/TEIID-2069
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1, 7.7
Reporter: Johnathon Lee
Assignee: Steven Hawkins
Fix For: 8.1
LIMIT clause is added to Statement being optimized which fails the operation on Oracle
OPTIMIZE:
CREATE VIRTUAL PROCEDURE
BEGIN
DECLARE biginteger VARIABLES.t_pk;
VARIABLES.t_pk = (SELECT <table>.seq_gen.cpe_seq FROM <table>.seq_gen);
SELECT VARIABLES.t_pk AS result;
END
####################################################
PROCEDURE COMMAND: CREATE VIRTUAL PROCEDURE
BEGIN
DECLARE biginteger VARIABLES.t_pk;
VARIABLES.t_pk = (SELECT <table>.seq_gen.cpe_seq FROM <table>.seq_gen LIMIT
2);
SELECT VARIABLES.t_pk AS result;
END
--
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