From jira-events at lists.jboss.org Mon Jun 11 15:56:04 2012
Content-Type: multipart/mixed; boundary="===============4745634866931352107=="
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: Mon, 11 Jun 2012 15:56:04 -0400
Message-ID: <1511287114.2184.1339444564748.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com>
In-Reply-To: 1590827691.148096.1339172117987.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com

--===============4745634866931352107==
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=3D12700574#c=
omment-12700574 ] =


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

jolee(a)redhat.com made a comment on [bug 830970|https://bugzilla.redhat.co=
m/show_bug.cgi?id=3D830970]

Description of problem:
Please refer to TEIID-2069

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.
  =

Actual results:


Expected results:


Additional info:
                =

> 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

--===============4745634866931352107==--