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

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