September 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3111) Function with multi-part names not resolving correctly

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3111?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3111: ---------------------------------- Summary: Function with multi-part names not resolving correctly (was: Expose group name, defined for functions, in the exposed metadata) Issue Type: Bug (was: Enhancement) Fix Version/s: 8.9 8.7 Description: When a function has multi-part name, like JCR for the modeshape functions, it won't resolve without the JCR prefix. That is SYS.JCR.function works JCR.function works but just function doesn't work. was:When a function has a defined group, like JCR for the modeshape functions, it should be exposed somehow in the metadata. Otherwise, user will never know to use the group name (i.e., JCR.JCR_ISCHILDNODE(rc."jcr:path", rt."jcr:path") ) unless they goto the documentation. Affects Version/s: 7.3 (was: 8.9) Component/s: Query Engine (was: Server) > Function with multi-part names not resolving correctly > ------------------------------------------------------ > > Key: TEIID-3111 > URL: https://issues.jboss.org/browse/TEIID-3111 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Query Engine > Affects Versions: 7.3 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.7, 8.9 > > > When a function has multi-part name, like JCR for the modeshape functions, it won't resolve without the JCR prefix. That is > SYS.JCR.function works > JCR.function works > but just function doesn't work. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3111) Expose group name, defined for functions, in the exposed metadata

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3111?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3111: --------------------------------------- That's not the intention of the logic, but it looks like the FunctionTree code will only create resolving entries for the top level and n-1 levels of the function name. So we see SYS.JCR.JCR* JCR.JCR* but no JCR* > Expose group name, defined for functions, in the exposed metadata > ----------------------------------------------------------------- > > Key: TEIID-3111 > URL: https://issues.jboss.org/browse/TEIID-3111 > Project: Teiid > Issue Type: Enhancement > Security Level: Public(Everyone can see) > Components: Server > Affects Versions: 8.9 > Reporter: Van Halbert > Assignee: Steven Hawkins > > When a function has a defined group, like JCR for the modeshape functions, it should be exposed somehow in the metadata. Otherwise, user will never know to use the group name (i.e., JCR.JCR_ISCHILDNODE(rc."jcr:path", rt."jcr:path") ) unless they goto the documentation. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3038) Add spatial query support to the Teiid MongoDB translator

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3038?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-3038. --------------------------------- Labels: Beta1 (was: ) Resolution: Done Changed the function parameter types on all $geo functions to "double" from big integer. So to issue a query user needs to use format like {code} SELECT * FROM tracks WHERE mongo.geoIntersects(loc, 'Polygon', ((cast(-77.800884 as double), cast(43.300259 as double)), (cast(-77.794790 as double), cast(43.300259 as double)), (cast(-77.794790 as double), cast(43.297886 as double)), (cast(-77.800884 as double), cast(43.297886 as double)), (cast(-77.800884 as double), cast(43.300259 as double)))) {code} > Add spatial query support to the Teiid MongoDB translator > --------------------------------------------------------- > > Key: TEIID-3038 > URL: https://issues.jboss.org/browse/TEIID-3038 > Project: Teiid > Issue Type: Feature Request > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.8 > Reporter: Michael Farwell > Assignee: Ramesh Reddy > Labels: Beta1 > Fix For: 8.7.1, 8.9 > > > We'd like to be able to issue geoIntersects and geoWithin queries through the MongoDB translator. See comment below on a proposed approach. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3111) Expose group name, defined for functions, in the exposed metadata

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3111?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3111: ------------------------------------ And TEIID-3098 is about exposing the procedures in the metadata so that they show up in the model when its imported. > Expose group name, defined for functions, in the exposed metadata > ----------------------------------------------------------------- > > Key: TEIID-3111 > URL: https://issues.jboss.org/browse/TEIID-3111 > Project: Teiid > Issue Type: Enhancement > Security Level: Public(Everyone can see) > Components: Server > Affects Versions: 8.9 > Reporter: Van Halbert > Assignee: Steven Hawkins > > When a function has a defined group, like JCR for the modeshape functions, it should be exposed somehow in the metadata. Otherwise, user will never know to use the group name (i.e., JCR.JCR_ISCHILDNODE(rc."jcr:path", rt."jcr:path") ) unless they goto the documentation. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3110) name in source should not be omitted in ddl

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3110?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3110: --------------------------------------- Looking at this further it seems the only safe change is to not omit the name in source and update all of the appropriate logic to optionally use the name in source. We'll then leave the ldap logic as is. > name in source should not be omitted in ddl > ------------------------------------------- > > Key: TEIID-3110 > URL: https://issues.jboss.org/browse/TEIID-3110 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Query Engine > Affects Versions: 8.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > When creating the ddl string we'll omit the name in source if it matches the table name. While this is valid for several translators (jdbc, object, mongodb, and others), it is not valid for all - salesforce, ldap, odata, and others. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3111) Expose group name, defined for functions, in the exposed metadata

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3111?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3111: ------------------------------------ I think its different, and applies to all pushdown functions with a defined group. In the factory, define the pushdown function: addPushDownFunction(JCR, JCR_ISCHILDNODE, BOOLEAN, STRING, STRING); As indicated, it has "JCR" group defined. And in order to execute the function, it has to be qualified with the group. Example: JCR.JCR_ISCHILDNODE(rc."jcr:path", rt."jcr:path") It will not execute without the "JCR." prefix. > Expose group name, defined for functions, in the exposed metadata > ----------------------------------------------------------------- > > Key: TEIID-3111 > URL: https://issues.jboss.org/browse/TEIID-3111 > Project: Teiid > Issue Type: Enhancement > Security Level: Public(Everyone can see) > Components: Server > Affects Versions: 8.9 > Reporter: Van Halbert > Assignee: Steven Hawkins > > When a function has a defined group, like JCR for the modeshape functions, it should be exposed somehow in the metadata. Otherwise, user will never know to use the group name (i.e., JCR.JCR_ISCHILDNODE(rc."jcr:path", rt."jcr:path") ) unless they goto the documentation. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3111) Expose group name, defined for functions, in the exposed metadata

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3111?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3111: --------------------------------------- Is this somehow related to TEIID-3098? > Expose group name, defined for functions, in the exposed metadata > ----------------------------------------------------------------- > > Key: TEIID-3111 > URL: https://issues.jboss.org/browse/TEIID-3111 > Project: Teiid > Issue Type: Enhancement > Security Level: Public(Everyone can see) > Components: Server > Affects Versions: 8.9 > Reporter: Van Halbert > Assignee: Steven Hawkins > > When a function has a defined group, like JCR for the modeshape functions, it should be exposed somehow in the metadata. Otherwise, user will never know to use the group name (i.e., JCR.JCR_ISCHILDNODE(rc."jcr:path", rt."jcr:path") ) unless they goto the documentation. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3098) Expose the ModeShape JCR functions in the modeshape translator metadata

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3098?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3098: --------------------------------------- Just to clarify we have two types of source functions: -those that are schema scoped and exposed via the native metadata load -pushdown functions that are exposed for all instances of the translator under as pseudo system function The differentiation is so that we know that the definitions of the pushdown functions are shared. So what are you looking to expose here? > Expose the ModeShape JCR functions in the modeshape translator metadata > ------------------------------------------------------------------------ > > Key: TEIID-3098 > URL: https://issues.jboss.org/browse/TEIID-3098 > Project: Teiid > Issue Type: Enhancement > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > > Expose the ModeShape JCR functions in the metadata in the modeshape translator. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3111) Expose group name, defined for functions, in the exposed metadata

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3111?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3111: ------------------------------------- So JCR is group, and "JCR_ISCHILDNODE" is function name? what does "JCR.JCR_ISCHILDNODE" account to? > Expose group name, defined for functions, in the exposed metadata > ----------------------------------------------------------------- > > Key: TEIID-3111 > URL: https://issues.jboss.org/browse/TEIID-3111 > Project: Teiid > Issue Type: Enhancement > Security Level: Public(Everyone can see) > Components: Server > Affects Versions: 8.9 > Reporter: Van Halbert > Assignee: Steven Hawkins > > When a function has a defined group, like JCR for the modeshape functions, it should be exposed somehow in the metadata. Otherwise, user will never know to use the group name (i.e., JCR.JCR_ISCHILDNODE(rc."jcr:path", rt."jcr:path") ) unless they goto the documentation. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3111) Expose group name, defined for functions, in the exposed metadata

by Van Halbert (JIRA)

Van Halbert created TEIID-3111: ---------------------------------- Summary: Expose group name, defined for functions, in the exposed metadata Key: TEIID-3111 URL: https://issues.jboss.org/browse/TEIID-3111 Project: Teiid Issue Type: Enhancement Security Level: Public (Everyone can see) Components: Server Affects Versions: 8.9 Reporter: Van Halbert Assignee: Steven Hawkins When a function has a defined group, like JCR for the modeshape functions, it should be exposed somehow in the metadata. Otherwise, user will never know to use the group name (i.e., JCR.JCR_ISCHILDNODE(rc."jcr:path", rt."jcr:path") ) unless they goto the documentation. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 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 2014