From jira-events at lists.jboss.org Tue Jun 12 10:10:04 2012
Content-Type: multipart/mixed; boundary="===============2251366004603600304=="
MIME-Version: 1.0
From: RH Bugzilla Integration (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: Tue, 12 Jun 2012 10:10:04 -0400
Message-ID: <1454924929.4263.1339510204487.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com>
In-Reply-To: 1590827691.148096.1339172117987.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com

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


    [ https://issues.jboss.org/browse/TEIID-2069?page=3Dcom.atlassian.jira.=
plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D12700786#c=
omment-12700786 ] =


RH Bugzilla Integration commented on TEIID-2069:
------------------------------------------------

jolee(a)redhat.com made a private comment on [bug 830980|https://bugzilla.r=
edhat.com/show_bug.cgi?id=3D830980]
                =

> 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 operat=
ion 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 L=
IMIT 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

--===============2251366004603600304==--