September 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3703) Cannot make references to view columns in view update

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3703?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3703. ----------------------------------- Resolution: Done Updated the evaluator to have a reference to the current tuple/elements. > Cannot make references to view columns in view update > ----------------------------------------------------- > > Key: TEIID-3703 > URL: https://issues.jboss.org/browse/TEIID-3703 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12 > > > Issuing an update against an updatable view with an instead of trigger that uses a view column in a set expression will fail at runtime saying that a reference to the value cannot be found. > for example with a gx view: update gx set x = x || 'a' where y = 2 > would result in: > org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate x: No value was available > at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:501) > at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:696) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3703) Cannot make references to view columns in view update

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3703: ------------------------------------- Summary: Cannot make references to view columns in view update Key: TEIID-3703 URL: https://issues.jboss.org/browse/TEIID-3703 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.7 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.12 Issuing an update against an updatable view with an instead of trigger that uses a view column in a set expression will fail at runtime saying that a reference to the value cannot be found. for example with a gx view: update gx set x = x || 'a' where y = 2 would result in: org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate x: No value was available at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:501) at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:696) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3671) filter on child table not working

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-3671?page=com.atlassian.jira.plugin... ] Johnathon Lee reassigned TEIID-3671: ------------------------------------ Assignee: Johnathon Lee (was: Steven Hawkins) > filter on child table not working > --------------------------------- > > Key: TEIID-3671 > URL: https://issues.jboss.org/browse/TEIID-3671 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Prashanthi Kairuppala > Assignee: Johnathon Lee > Priority: Critical > Fix For: 8.12, 8.11.4 > > Attachments: parent_childTables.PNG > > > > Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json, i get the results from sales_uk table which are having id=13. > > Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22' > -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3702) dependency and validation logic incorrect

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3702: ------------------------------------- Summary: dependency and validation logic incorrect Key: TEIID-3702 URL: https://issues.jboss.org/browse/TEIID-3702 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.9 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.12, 8.11.4 With TEIID-3042 validation of triggers was added, but does not properly account for the parsing/resolving - however it is only being run in the case where there are no columns defined on the view and they are instead inferred from the definition. Similarly dependencies are only being determined on view with no columns defined. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3698) non-selectable columns will cause OData failures

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3698?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3698: ------------------------------------------------ jolee(a)redhat.com changed the Status of [bug 1262827|https://bugzilla.redhat.com/show_bug.cgi?id=1262827] from NEW to ASSIGNED > non-selectable columns will cause OData failures > ------------------------------------------------ > > Key: TEIID-3698 > URL: https://issues.jboss.org/browse/TEIID-3698 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: 8.12 > > > An odata table/view with a non-selectable column will return an error if it is returned as an odata entity without the $select option to exclude the non-selectable column. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3701) In the JDBC Importer properties, should support "%" wildcard pattern to include/exclude

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3701?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3701. ----------------------------------- Resolution: Rejected Include/exclude are regular expressions, which are much more powerful. > In the JDBC Importer properties, should support "%" wildcard pattern to include/exclude > --------------------------------------------------------------------------------------- > > Key: TEIID-3701 > URL: https://issues.jboss.org/browse/TEIID-3701 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver > Reporter: Van Halbert > Assignee: Steven Hawkins > > When specifying the JDBC importer properties, should support the use of the jdbc pattern (%) wildcard to include/exclude tables/columns. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3701) In the JDBC Importer properties, should support "%" wildcard pattern to include/exclude

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3701?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3701: ------------------------------------ In a dynamic vdb, when specifying the importer.tableNamePattern in a dynamic vdb. Would like to use something like: "ENG%", or when using importer.excludeTables also be able to exclude a whole group of tables using the wild card, like: "ENG%". > In the JDBC Importer properties, should support "%" wildcard pattern to include/exclude > --------------------------------------------------------------------------------------- > > Key: TEIID-3701 > URL: https://issues.jboss.org/browse/TEIID-3701 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver > Reporter: Van Halbert > Assignee: Steven Hawkins > > When specifying the JDBC importer properties, should support the use of the jdbc pattern (%) wildcard to include/exclude tables/columns. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3546) Add distinct from syntax in for each row procedures

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3546?page=com.atlassian.jira.plugin... ] Work on TEIID-3546 started by Steven Hawkins. --------------------------------------------- > Add distinct from syntax in for each row procedures > --------------------------------------------------- > > Key: TEIID-3546 > URL: https://issues.jboss.org/browse/TEIID-3546 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Minor > Fix For: 8.12 > > > Similar to postgresql, it would be good to allow for a quick comparison of new/old values to determine if row processing is needed. Something like: > IF new IS DISTINCT FROM old THEN > ... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3701) In the JDBC Importer properties, should support "%" wildcard pattern to include/exclude

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3701?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3701: --------------------------------------- I'm still confused. Can you give an example of what you are talking about? Are you talking about Designer? > In the JDBC Importer properties, should support "%" wildcard pattern to include/exclude > --------------------------------------------------------------------------------------- > > Key: TEIID-3701 > URL: https://issues.jboss.org/browse/TEIID-3701 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver > Reporter: Van Halbert > Assignee: Steven Hawkins > > When specifying the JDBC importer properties, should support the use of the jdbc pattern (%) wildcard to include/exclude tables/columns. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3701) In the JDBC Importer properties, should support "%" wildcard pattern to include/exclude

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3701?page=com.atlassian.jira.plugin... ] Van Halbert reopened TEIID-3701: -------------------------------- I stated it wrong, The Teiid importer properties don't support it. This would be beneficial when setting this option in the dynamic VDB. > In the JDBC Importer properties, should support "%" wildcard pattern to include/exclude > --------------------------------------------------------------------------------------- > > Key: TEIID-3701 > URL: https://issues.jboss.org/browse/TEIID-3701 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver > Reporter: Van Halbert > Assignee: Steven Hawkins > > When specifying the JDBC importer properties, should support the use of the jdbc pattern (%) wildcard to include/exclude tables/columns. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2015