From jira-events at lists.jboss.org Wed Aug 15 08:42:21 2012
Content-Type: multipart/mixed; boundary="===============7260538220153064800=="
MIME-Version: 1.0
From: Steven Hawkins (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: Wed, 15 Aug 2012 08:42:21 -0400
Message-ID: <2013764091.5959.1345034541571.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com>
In-Reply-To: 1590827691.148096.1339172117987.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com

--===============7260538220153064800==
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:all-tabpanel ]

Steven Hawkins closed TEIID-2069.
---------------------------------


    =

> 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

--===============7260538220153064800==--