July 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3052) Error on using MAKEDEP hint within union

by Mark Addleman (JIRA)

[ https://issues.jboss.org/browse/TEIID-3052?page=com.atlassian.jira.plugin... ] Mark Addleman updated TEIID-3052: --------------------------------- Description: The following anon proc block fails with error TEIID30226 Remote org.teiid.api.exception.query.QueryProcessingException: TEIID30226 Temporary table "table_spaces_v6" does not exist BEGIN create local temporary table ssid_version (sysplex varchar, lpar varchar, ssid varchar, version varchar); insert into ssid_version(sysplex, lpar, ssid, version) values ('plex1', 'ca11', 'd91a', 'v5'); insert into ssid_version(sysplex, lpar, ssid, version) values ('plex1', 'ca11', 'd91b', 'v6'); create local temporary table table_spaces_v5 (sysplex varchar, lpar varchar, ssid varchar, table_space_id varchar); insert into table_spaces_v5 (sysplex, lpar, ssid, table_space_id) values ('plex1', 'ca11', 'd91a', 'ts1'); create local temporary table table_spaces_v6 (sysplex varchar, lpar varchar, ssid varchar, table_space_id varchar); insert into table_spaces_v6 (sysplex, lpar, ssid, table_space_id) values ('plex1', 'ca11', 'd91b', 'ts2'); select table_space_id from ( select * from (select v.sysplex, v.lpar, v.ssid, t.table_space_id from ssid_version v join table_spaces_v5 t on t.sysplex=v.sysplex and t.lpar=v.lpar and t.ssid=v.ssid option makedep table_spaces_v5) t union all select * from (select v.sysplex, v.lpar, v.ssid, t.table_space_id from ssid_version v join table_spaces_v6 t on t.sysplex=v.sysplex and t.lpar=v.lpar and t.ssid=v.ssid option makedep table_spaces_v6) t ) t where ssid='d91a'; END It also fails when the /*+ MAKEDEP */ form is used instead of "option makedep" I don't believe there should be any failure Affects Version/s: 8.7 Component/s: Query Engine > Error on using MAKEDEP hint within union > ---------------------------------------- > > Key: TEIID-3052 > URL: https://issues.jboss.org/browse/TEIID-3052 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Query Engine > Affects Versions: 8.7 > Reporter: Mark Addleman > Assignee: Steven Hawkins > > The following anon proc block fails with error TEIID30226 Remote org.teiid.api.exception.query.QueryProcessingException: TEIID30226 Temporary table "table_spaces_v6" does not exist > BEGIN > create local temporary table ssid_version (sysplex varchar, lpar varchar, ssid varchar, version varchar); > insert into ssid_version(sysplex, lpar, ssid, version) values ('plex1', 'ca11', 'd91a', 'v5'); > insert into ssid_version(sysplex, lpar, ssid, version) values ('plex1', 'ca11', 'd91b', 'v6'); > > > create local temporary table table_spaces_v5 (sysplex varchar, lpar varchar, ssid varchar, table_space_id varchar); > insert into table_spaces_v5 (sysplex, lpar, ssid, table_space_id) values ('plex1', 'ca11', 'd91a', 'ts1'); > > > create local temporary table table_spaces_v6 (sysplex varchar, lpar varchar, ssid varchar, table_space_id varchar); > insert into table_spaces_v6 (sysplex, lpar, ssid, table_space_id) values ('plex1', 'ca11', 'd91b', 'ts2'); > > > select table_space_id from > ( > select * from (select v.sysplex, v.lpar, v.ssid, t.table_space_id from ssid_version v join table_spaces_v5 t on t.sysplex=v.sysplex and t.lpar=v.lpar and t.ssid=v.ssid option makedep table_spaces_v5) t > union all > select * from (select v.sysplex, v.lpar, v.ssid, t.table_space_id from ssid_version v join table_spaces_v6 t on t.sysplex=v.sysplex and t.lpar=v.lpar and t.ssid=v.ssid option makedep table_spaces_v6) t > ) t > where ssid='d91a'; > END > It also fails when the /*+ MAKEDEP */ form is used instead of "option makedep" > I don't believe there should be any failure -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3052) Error on using MAKEDEP hint within union

by Mark Addleman (JIRA)

Mark Addleman created TEIID-3052: ------------------------------------ Summary: Error on using MAKEDEP hint within union Key: TEIID-3052 URL: https://issues.jboss.org/browse/TEIID-3052 Project: Teiid Issue Type: Bug Security Level: Public (Everyone can see) Reporter: Mark Addleman Assignee: Steven Hawkins -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3051) grant all should not be transitive to importing vdbs

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3051: ------------------------------------- Summary: grant all should not be transitive to importing vdbs Key: TEIID-3051 URL: https://issues.jboss.org/browse/TEIID-3051 Project: Teiid Issue Type: Bug Security Level: Public (Everyone can see) Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins If the grant all option is in an imported vdb it will not only grant all permissions in the imported vdb, but the importing vdb as well. We should ensure that the scope is narrower - however there are some permissions that are currently not schema scoped (such as temp table support) that would still be picked up from the imported vdb. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3045) warning with translator usage

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3045?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-3045. --------------------------------- Fix Version/s: 8.7.1 Resolution: Done The issue was the import and translator properties both were being added VDBTranslatorMedata class, where only translator properties should have been added. > warning with translator usage > ----------------------------- > > Key: TEIID-3045 > URL: https://issues.jboss.org/browse/TEIID-3045 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: 8.7.1, 8.9 > > > With TEIID-2904 the set of default properties - including import properties - is being added to the vdbtranslatormetadata property set, so that when we create the translator instances the import properties are being seen as unused and result in a warning. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3048) Conflicting CXF versions being used in Embedded kit

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3048?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-3048. --------------------------------- Fix Version/s: (was: 8.7.1) Resolution: Done By removing them as transitive dependencies and adding them back as explicit dependencies resolves the version issue > Conflicting CXF versions being used in Embedded kit > --------------------------------------------------- > > Key: TEIID-3048 > URL: https://issues.jboss.org/browse/TEIID-3048 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Build/Kits > Affects Versions: 8.8 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.9 > > > There are conflicting 2.6.8 and 2.6.6 versions of CXF in kit, this needs to be fixed to use same versions -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3023) records lost when query by hiernate

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3023?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3023. ----------------------------------- Resolution: Incomplete Description Marking as incomplete description / out of date. If you can reproduce your scenario on a later version and produce a query plan, please reopen this issue. > records lost when query by hiernate > ----------------------------------- > > Key: TEIID-3023 > URL: https://issues.jboss.org/browse/TEIID-3023 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Affects Versions: 7.3 > Environment: window7,eclipse Helios Service Release 2, Teiid v7.3.0 > Reporter: Lai Chao > Priority: Minor > > Recently, I get an issue when retrieve data from vdb that some records lost in the list. Fox example, from source table we can get 12100 records, but from vdb query(projects with hibernate) can only get 10800+ records. > Meanwhile, there's a set on maxSetSize = 1000, is there any affects? > Please advise. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3050) allow for more incremental insert with iterator

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3050: ------------------------------------- Summary: allow for more incremental insert with iterator Key: TEIID-3050 URL: https://issues.jboss.org/browse/TEIID-3050 Project: Teiid Issue Type: Enhancement Security Level: Public (Everyone can see) Components: Misc. Connectors, Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.9 The current bulk insert logic assumes that it is avoiding a global transactions by fully reading the results before sending the tuplebuffer iterator to the source for processing, which can then just use a local transaction. However if we are already operating under a transaction or the user doesn't want a transaction (such as with a staging materialized view load) then the insert should happen more incrementally. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3049) odbc still commits with disableLocalTxn

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3049?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3049. ----------------------------------- Fix Version/s: 8.7.1 Resolution: Done Added a check for disableLocalTxn to the asynch commit > odbc still commits with disableLocalTxn > --------------------------------------- > > Key: TEIID-3049 > URL: https://issues.jboss.org/browse/TEIID-3049 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: ODBC > Affects Versions: 8.8 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > With TEIID-2945 disableLocalTxn is now valid against odbc, but it is using an asynch invocation to commit which is not aware of disableLocalTxn which results in an exception that a transaction for the given session cannot be found. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3049) odbc still commits with disableLocalTxn

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3049?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3049: ---------------------------------- SourceForge Reference: https://c.na7.visual.force.com/apex/Case_View?id=500A000000J3hmk > odbc still commits with disableLocalTxn > --------------------------------------- > > Key: TEIID-3049 > URL: https://issues.jboss.org/browse/TEIID-3049 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: ODBC > Affects Versions: 8.8 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > With TEIID-2945 disableLocalTxn is now valid against odbc, but it is using an asynch invocation to commit which is not aware of disableLocalTxn which results in an exception that a transaction for the given session cannot be found. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3049) odbc still commits with disableLocalTxn

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3049: ------------------------------------- Summary: odbc still commits with disableLocalTxn Key: TEIID-3049 URL: https://issues.jboss.org/browse/TEIID-3049 Project: Teiid Issue Type: Bug Security Level: Public (Everyone can see) Components: ODBC Affects Versions: 8.8 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.9 With TEIID-2945 disableLocalTxn is now valid against odbc, but it is using an asynch invocation to commit which is not aware of disableLocalTxn which results in an exception that a transaction for the given session cannot be found. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 2 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2014