From jira-events at lists.jboss.org Fri Jun  8 12:15:18 2012
Content-Type: multipart/mixed; boundary="===============7454905214475265562=="
MIME-Version: 1.0
From: Johnathon Lee (JIRA) <jira-events at lists.jboss.org>
To: teiid-issues at lists.jboss.org
Subject: [teiid-issues] [JBoss JIRA] (TEIID-2069) Optimze add LIMIT clause to
 SELECT within a Virtual Procedure using Oracle
Date: Fri, 08 Jun 2012 12:15:17 -0400
Message-ID: <1590827691.148096.1339172117987.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com>

--===============7454905214475265562==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

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

             Summary: Optimze add LIMIT clause to SELECT within a Virtual P=
rocedure 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 operatio=
n on Oracle

OPTIMIZE: =

CREATE VIRTUAL PROCEDURE
BEGIN
DECLARE biginteger VARIABLES.t_pk;
VARIABLES.t_pk =3D (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 =3D (SELECT <table>.seq_gen.cpe_seq FROM <table>.seq_gen LIM=
IT 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 administrato=
rs: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

       =20

--===============7454905214475265562==--