[teiid-issues] [JBoss JIRA] (TEIID-2069) Optimze add LIMIT clause to SELECT within a Virtual Procedure using Oracle

[Johnathon Lee (JIRA)]

Johnathon Lee created TEIID-2069:
------------------------------------

             Summary: 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.7, 7.4.1
            Reporter: Johnathon Lee
            Assignee: Steven Hawkins


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