February 2013 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2354) Inherent insert using WHERE partitioning is incomplete

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2354?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2354: ------------------------------------------- Bugzilla Update: (was: Perform) Bugzilla References: (was: https://bugzilla.redhat.com/show_bug.cgi?id=907640) > Inherent insert using WHERE partitioning is incomplete > ------------------------------------------------------ > > Key: TEIID-2354 > URL: https://issues.jboss.org/browse/TEIID-2354 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.3 > > > Using a metadata structure such as: > create foreign table b (custid integer, field1 varchar) options updatable true) > create view c options (updatable true) as select * from b where custid = 1 union all select * from b where custid = 2; > will fail to process INSERT into c (custid, field1) values (1, 'foo') > because a null value will be inserted into be for the custid field. The logic is treating the WHERE partitioning as if it were projected literals from the SELECT cause inappropriately. -- 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

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2374) OracleExecutionFactory should indicate support of common table expressions for 9.2 or later

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2374?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2374: ------------------------------------------- Bugzilla Update: (was: Perform) Bugzilla References: (was: https://bugzilla.redhat.com/show_bug.cgi?id=907640) > OracleExecutionFactory should indicate support of common table expressions for 9.2 or later > ------------------------------------------------------------------------------------------- > > Key: TEIID-2374 > URL: https://issues.jboss.org/browse/TEIID-2374 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.2, 7.7.4 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 8.3 > > > OracleExecutionFactory is not marked as supporting common table expressions. It should be returning as supported for a database version of 9.2 or later. -- 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

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2374) OracleExecutionFactory should indicate support of common table expressions for 9.2 or later

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2374?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2374: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=907640 > OracleExecutionFactory should indicate support of common table expressions for 9.2 or later > ------------------------------------------------------------------------------------------- > > Key: TEIID-2374 > URL: https://issues.jboss.org/browse/TEIID-2374 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.2, 7.7.4 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 8.3 > > > OracleExecutionFactory is not marked as supporting common table expressions. It should be returning as supported for a database version of 9.2 or later. -- 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

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2354) Inherent insert using WHERE partitioning is incomplete

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2354?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2354: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=907640 > Inherent insert using WHERE partitioning is incomplete > ------------------------------------------------------ > > Key: TEIID-2354 > URL: https://issues.jboss.org/browse/TEIID-2354 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.3 > > > Using a metadata structure such as: > create foreign table b (custid integer, field1 varchar) options updatable true) > create view c options (updatable true) as select * from b where custid = 1 union all select * from b where custid = 2; > will fail to process INSERT into c (custid, field1) values (1, 'foo') > because a null value will be inserted into be for the custid field. The logic is treating the WHERE partitioning as if it were projected literals from the SELECT cause inappropriately. -- 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

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2363) proactive buffering not occurring for the inner side of an outer join on "MERGE JOIN (SORT/ALREADY_SORTED)"

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2363?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2363: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=907640 > proactive buffering not occurring for the inner side of an outer join on "MERGE JOIN (SORT/ALREADY_SORTED)" > ----------------------------------------------------------------------------------------------------------- > > Key: TEIID-2363 > URL: https://issues.jboss.org/browse/TEIID-2363 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 7.7.2 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 8.3 > > > The issue here is this is an outer join and the inner side (the already sorted side) will be buffered regardless. Current logic does not catch blocked exceptions from one side and pro-actively buffer the other - rather we are serially performing the sort and then continue with the loading of the inner side > For inner joins there is a clear trade-off between execution speed and buffering so this behavior may have to be hint or config driven for non-dependent non-outer joins. -- 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

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2375) NPE during execution of query

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2375?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2375. ----------------------------------- Resolution: Duplicate Issue Dup of TEIID-2342 > NPE during execution of query > ----------------------------- > > Key: TEIID-2375 > URL: https://issues.jboss.org/browse/TEIID-2375 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.1 > Reporter: Vineela Gampa > Assignee: Steven Hawkins > Attachments: stackTrace.txt > > > Hi Steve/Ramesh > We are seeing NPE from teiid during execution of query. This is some query which ran well in the previous exeuction but when executed again fetched such results. > Attached the error stack trace. -- 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

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2375) NPE during execution of query

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2375?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2375: ---------------------------------- Issue Type: Bug (was: Feature Request) > NPE during execution of query > ----------------------------- > > Key: TEIID-2375 > URL: https://issues.jboss.org/browse/TEIID-2375 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.1 > Reporter: Vineela Gampa > Assignee: Steven Hawkins > Attachments: stackTrace.txt > > > Hi Steve/Ramesh > We are seeing NPE from teiid during execution of query. This is some query which ran well in the previous exeuction but when executed again fetched such results. > Attached the error stack trace. -- 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

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2375) NPE during execution of query

by Vineela Gampa (JIRA)

[ https://issues.jboss.org/browse/TEIID-2375?page=com.atlassian.jira.plugin... ] Vineela Gampa updated TEIID-2375: --------------------------------- Attachment: stackTrace.txt > NPE during execution of query > ----------------------------- > > Key: TEIID-2375 > URL: https://issues.jboss.org/browse/TEIID-2375 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.1 > Reporter: Vineela Gampa > Assignee: Steven Hawkins > Attachments: stackTrace.txt > > > Hi Steve/Ramesh > We are seeing NPE from teiid during execution of query. This is some query which ran well in the previous exeuction but when executed again fetched such results. > Attached the error stack trace. -- 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

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2375) NPE during execution of query

by Vineela Gampa (JIRA)

Vineela Gampa created TEIID-2375: ------------------------------------ Summary: NPE during execution of query Key: TEIID-2375 URL: https://issues.jboss.org/browse/TEIID-2375 Project: Teiid Issue Type: Feature Request Affects Versions: 8.1 Reporter: Vineela Gampa Assignee: Steven Hawkins Hi Steve/Ramesh We are seeing NPE from teiid during execution of query. This is some query which ran well in the previous exeuction but when executed again fetched such results. Attached the error stack trace. -- 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

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2374) OracleExecutionFactory should indicate support of common table expressions for 9.2 or later

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2374?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2374. ----------------------------------- Fix Version/s: 8.3 Resolution: Done Added support based upon the databaseVersion setting starting with 9.2. > OracleExecutionFactory should indicate support of common table expressions for 9.2 or later > ------------------------------------------------------------------------------------------- > > Key: TEIID-2374 > URL: https://issues.jboss.org/browse/TEIID-2374 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.2, 7.7.4 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 8.3 > > > OracleExecutionFactory is not marked as supporting common table expressions. It should be returning as supported for a database version of 9.2 or later. -- 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

11 years, 11 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2013