[JBoss JIRA] (TEIID-2069) Optimze add LIMIT clause to SELECT within a Virtual Procedure using Oracle
11:15 a.m.
Johnathon Lee created TEIID-2069:
------------------------------------
Summary: 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.7, 7.4.1
Reporter: Johnathon Lee
Assignee: Steven Hawkins
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:25 a.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2069:
---------------------------------------
We add an implicit limit with scalar/exists subqueries (the issue would also exist if an
explicit limit were used). This should be handled by the oracle translator.
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
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:02 p.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-2069.
-----------------------------------
Fix Version/s: 8.1
Resolution: Done
Modified the OracleExecutionFactory to remove the limit clause in queries against dual.
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:56 p.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-2069:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=830970
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:56 p.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-2069:
-------------------------------------------
Bugzilla Update: Perform
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:56 p.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2069:
------------------------------------------------
jolee(a)redhat.com made a comment on [bug
830970|https://bugzilla.redhat.com/show_bug.cgi?id=830970]
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 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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
3 p.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2069:
------------------------------------------------
jolee(a)redhat.com changed the Status of [bug
830970|https://bugzilla.redhat.com/show_bug.cgi?id=830970] from NEW to MODIFIED
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
3 p.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2069:
------------------------------------------------
jolee(a)redhat.com made a private comment on [bug
830970|https://bugzilla.redhat.com/show_bug.cgi?id=830970]
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:02 p.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2069:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> made a private comment on [bug
830970|https://bugzilla.redhat.com/show_bug.cgi?id=830970]
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:08 p.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2069:
------------------------------------------------
jolee(a)redhat.com made a private comment on [bug
830970|https://bugzilla.redhat.com/show_bug.cgi?id=830970]
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:25 p.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2069:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> made a private comment on [bug
830970|https://bugzilla.redhat.com/show_bug.cgi?id=830970]
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:27 p.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2069:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> made a private comment on [bug
830970|https://bugzilla.redhat.com/show_bug.cgi?id=830970]
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:08 a.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-2069:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=830970 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=830970)
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:08 a.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-2069:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=830970,
https://bugzilla.redhat.com/show_bug.cgi?id=830980 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=830970)
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:08 a.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2069:
------------------------------------------------
jolee(a)redhat.com changed the Status of [bug
830980|https://bugzilla.redhat.com/show_bug.cgi?id=830980] from NEW to MODIFIED
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:10 a.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2069:
------------------------------------------------
jolee(a)redhat.com made a private comment on [bug
830980|https://bugzilla.redhat.com/show_bug.cgi?id=830980]
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:40 a.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2069:
------------------------------------------------
wgibson(a)redhat.com made a comment on [bug
830980|https://bugzilla.redhat.com/show_bug.cgi?id=830980]
Change verified.
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:40 a.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2069:
------------------------------------------------
wgibson(a)redhat.com changed the Status of [bug
830980|https://bugzilla.redhat.com/show_bug.cgi?id=830980] from ON_QA to VERIFIED
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:50 a.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2069:
------------------------------------------------
jolee(a)redhat.com changed the Status of [bug
830970|https://bugzilla.redhat.com/show_bug.cgi?id=830970] from MODIFIED to CLOSED
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:50 a.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-2069:
------------------------------------------------
jolee(a)redhat.com made a private comment on [bug
830970|https://bugzilla.redhat.com/show_bug.cgi?id=830970]
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:42 a.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
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 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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:12 p.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
Steven Hawkins reopened 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 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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:14 p.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-2069:
----------------------------------
Fix Version/s: 7.7.2
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, 7.7.2
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:14 p.m.
[
https://issues.jboss.org/browse/TEIID-2069?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-2069.
-----------------------------------
Resolution: Done
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: 7.7.2, 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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
4409
days inactive
4580
days old
25 comments
3 participants
participants (3)
-
Johnathon Lee (JIRA) -
RH Bugzilla Integration (JIRA)
-
Steven Hawkins (JIRA)