July 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3054) The Object and Infinispan translators do not support negation (">" or "<") properly

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3054?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-3054: ------------------------------- Fix Version/s: 8.9 Git Pull Request: https://github.com/teiid/teiid/pull/282 > The Object and Infinispan translators do not support negation (">" or "<") properly > ----------------------------------------------------------------------------------- > > Key: TEIID-3054 > URL: https://issues.jboss.org/browse/TEIID-3054 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.7.1, 8.9 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.9 > > > The Infinispan translators where lucene index querying can be performed (i.e., infinispan-cache and infinispan-cache-dsl) do not support negation (">" or "<") properly. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3054) The Object and Infinispan translators do not support negation (">" or "<") properly

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3054?page=com.atlassian.jira.plugin... ] Work on TEIID-3054 started by Van Halbert. > The Object and Infinispan translators do not support negation (">" or "<") properly > ----------------------------------------------------------------------------------- > > Key: TEIID-3054 > URL: https://issues.jboss.org/browse/TEIID-3054 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.7.1, 8.9 > Reporter: Van Halbert > Assignee: Van Halbert > > The Infinispan translators where lucene index querying can be performed (i.e., infinispan-cache and infinispan-cache-dsl) do not support negation (">" or "<") properly. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3054) The Object and Infinispan translators do not support negation (">" or "<") properly

by Van Halbert (JIRA)

Van Halbert created TEIID-3054: ---------------------------------- Summary: The Object and Infinispan translators do not support negation (">" or "<") properly Key: TEIID-3054 URL: https://issues.jboss.org/browse/TEIID-3054 Project: Teiid Issue Type: Bug Security Level: Public (Everyone can see) Components: Misc. Connectors Affects Versions: 8.7.1, 8.9 Reporter: Van Halbert Assignee: Steven Hawkins The Infinispan translators where lucene index querying can be performed (i.e., infinispan-cache and infinispan-cache-dsl) do not support negation (">" or "<") properly. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3054) The Object and Infinispan translators do not support negation (">" or "<") properly

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3054?page=com.atlassian.jira.plugin... ] Van Halbert reassigned TEIID-3054: ---------------------------------- Assignee: Van Halbert (was: Steven Hawkins) > The Object and Infinispan translators do not support negation (">" or "<") properly > ----------------------------------------------------------------------------------- > > Key: TEIID-3054 > URL: https://issues.jboss.org/browse/TEIID-3054 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.7.1, 8.9 > Reporter: Van Halbert > Assignee: Van Halbert > > The Infinispan translators where lucene index querying can be performed (i.e., infinispan-cache and infinispan-cache-dsl) do not support negation (">" or "<") properly. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

9 years, 9 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3052?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3052. ----------------------------------- Fix Version/s: 8.9 Resolution: Done Added logic to pre-process the results, which is already done when catching exceptions or in transactional scenarios. Also logged TEIID-3053 to improve the performance of the fix. > 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 > Fix For: 8.9 > > > 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)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3053) Detect when returnable procedure results need to be processed in the procedure

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3053: ------------------------------------- Summary: Detect when returnable procedure results need to be processed in the procedure Key: TEIID-3053 URL: https://issues.jboss.org/browse/TEIID-3053 Project: Teiid Issue Type: Enhancement Security Level: Public (Everyone can see) Components: Query Engine Affects Versions: 8.9 Reporter: Steven Hawkins Assignee: Steven Hawkins With TEIID-3052 we are now fully processing almost all results in the originating procedure scope whereas before we were effective performing pipelining in that the results were created off of the tuple source on demand. With some upfront or processing time detection we could see when the processorplan is relying upon resources from the program scope and if not go ahead and pop/return the results as before. We could also develop a better strategy for dealing with the case when resources are needed. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

9 years, 9 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3052?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3052: ---------------------------------- Workaround Description: Use an exception handling block to force the full execution within the procedure scope: BEGIN ... EXCEPTION e RAISE e.exception; END Workaround: Workaround Exists > 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)

9 years, 9 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3052?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3052: --------------------------------------- Yes this is an issue with the dependent join being fed from the temporary tables. We are simply setting up, but not fully processing the last instruction in the procedure than effectively ending the procedure execution early with the idea that the results can be streamed afterwards without holding onto the procedure resources. I should have a fix shortly. > 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)

9 years, 9 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 commented on TEIID-3045: ------------------------------------- We are keeping two sets of properties, one as attachment in VDBTranslatorMetadata in the form of ExtendedMetadataProperties (import+override+translator) and another simple map of only translator properties for admin operations. The designer uses the attached ExtendedMetadataProperties form, but when they are being injected into the translator instance, Teiid combines both defaults and what came from initialization. > 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)

9 years, 9 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3045?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3045: --------------------------------------- The defaults are there for designer usage correct? Is designer expecting to get the defaults for import properties as well? > 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)

9 years, 9 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2014