July 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3055) Querying JDG local cache using greater than value cause exception

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3055?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-3055: ------------------------------- Assignee: Steven Hawkins (was: Van Halbert) > Querying JDG local cache using greater than value cause exception > ----------------------------------------------------------------- > > Key: TEIID-3055 > URL: https://issues.jboss.org/browse/TEIID-3055 > 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 > Fix For: 8.7.1, 8.9 > > > Issuing query: select nss, valor_inicial, valor_final from CacheView.Resumen where valor_inicial > 950.0 > produces the following in the query plan: > USER COMMAND: > SELECT nss, valor_inicial, valor_final FROM CacheView.Resumen WHERE nss > '950.0' > request=/1MuNPfoG76j.0.0.5: org.hibernate.search.SearchException: Cannot create numeric range query for field saldo.valorInicial, since values are not numeric (int,long, short or double) > at org.hibernate.search.bridge.util.impl.NumericFieldUtils.createNumericRangeQuery(NumericFieldUtils.java:69) > at org.hibernate.search.query.dsl.impl.ConnectedMultiFieldsRangeQueryBuilder.createQuery(ConnectedMultiFieldsRangeQueryBuilder.java:107) > at org.hibernate.search.query.dsl.impl.ConnectedMultiFieldsRangeQueryBuilder.createQuery(ConnectedMultiFieldsRangeQueryBuilder.java:83) > at org.teiid.translator.object.infinispan.LuceneSearch.createRangeAboveQuery(LuceneSearch.java:349) > at org.teiid.translator.object.infinispan.LuceneSearch.visit(LuceneSearch.java:217) > at org.teiid.translator.object.infinispan.LuceneSearch.buildQueryFromWhereClause(LuceneSearch.java:145) > at org.teiid.translator.object.infinispan.LuceneSearch.performSearch(LuceneSearch.java:66) > at org.teiid.translator.object.infinispan.InfinispanExecutionFactory.search(InfinispanExecutionFactory.java:119) > at org.teiid.translator.object.ObjectExecution.execute(ObjectExecution.java:102) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:312) [te -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3055) Querying JDG local cache using greater than value cause exception

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3055?page=com.atlassian.jira.plugin... ] Work on TEIID-3055 started by Van Halbert. > Querying JDG local cache using greater than value cause exception > ----------------------------------------------------------------- > > Key: TEIID-3055 > URL: https://issues.jboss.org/browse/TEIID-3055 > 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 > > Issuing query: select nss, valor_inicial, valor_final from CacheView.Resumen where valor_inicial > 950.0 > produces the following in the query plan: > USER COMMAND: > SELECT nss, valor_inicial, valor_final FROM CacheView.Resumen WHERE nss > '950.0' > request=/1MuNPfoG76j.0.0.5: org.hibernate.search.SearchException: Cannot create numeric range query for field saldo.valorInicial, since values are not numeric (int,long, short or double) > at org.hibernate.search.bridge.util.impl.NumericFieldUtils.createNumericRangeQuery(NumericFieldUtils.java:69) > at org.hibernate.search.query.dsl.impl.ConnectedMultiFieldsRangeQueryBuilder.createQuery(ConnectedMultiFieldsRangeQueryBuilder.java:107) > at org.hibernate.search.query.dsl.impl.ConnectedMultiFieldsRangeQueryBuilder.createQuery(ConnectedMultiFieldsRangeQueryBuilder.java:83) > at org.teiid.translator.object.infinispan.LuceneSearch.createRangeAboveQuery(LuceneSearch.java:349) > at org.teiid.translator.object.infinispan.LuceneSearch.visit(LuceneSearch.java:217) > at org.teiid.translator.object.infinispan.LuceneSearch.buildQueryFromWhereClause(LuceneSearch.java:145) > at org.teiid.translator.object.infinispan.LuceneSearch.performSearch(LuceneSearch.java:66) > at org.teiid.translator.object.infinispan.InfinispanExecutionFactory.search(InfinispanExecutionFactory.java:119) > at org.teiid.translator.object.ObjectExecution.execute(ObjectExecution.java:102) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:312) [te -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3055) Querying JDG local cache using greater than value cause exception

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3055?page=com.atlassian.jira.plugin... ] Work on TEIID-3055 stopped by Van Halbert. > Querying JDG local cache using greater than value cause exception > ----------------------------------------------------------------- > > Key: TEIID-3055 > URL: https://issues.jboss.org/browse/TEIID-3055 > 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 > > Issuing query: select nss, valor_inicial, valor_final from CacheView.Resumen where valor_inicial > 950.0 > produces the following in the query plan: > USER COMMAND: > SELECT nss, valor_inicial, valor_final FROM CacheView.Resumen WHERE nss > '950.0' > request=/1MuNPfoG76j.0.0.5: org.hibernate.search.SearchException: Cannot create numeric range query for field saldo.valorInicial, since values are not numeric (int,long, short or double) > at org.hibernate.search.bridge.util.impl.NumericFieldUtils.createNumericRangeQuery(NumericFieldUtils.java:69) > at org.hibernate.search.query.dsl.impl.ConnectedMultiFieldsRangeQueryBuilder.createQuery(ConnectedMultiFieldsRangeQueryBuilder.java:107) > at org.hibernate.search.query.dsl.impl.ConnectedMultiFieldsRangeQueryBuilder.createQuery(ConnectedMultiFieldsRangeQueryBuilder.java:83) > at org.teiid.translator.object.infinispan.LuceneSearch.createRangeAboveQuery(LuceneSearch.java:349) > at org.teiid.translator.object.infinispan.LuceneSearch.visit(LuceneSearch.java:217) > at org.teiid.translator.object.infinispan.LuceneSearch.buildQueryFromWhereClause(LuceneSearch.java:145) > at org.teiid.translator.object.infinispan.LuceneSearch.performSearch(LuceneSearch.java:66) > at org.teiid.translator.object.infinispan.InfinispanExecutionFactory.search(InfinispanExecutionFactory.java:119) > at org.teiid.translator.object.ObjectExecution.execute(ObjectExecution.java:102) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:312) [te -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3055) Querying JDG local cache using greater than value cause exception

by Van Halbert (JIRA)

Van Halbert created TEIID-3055: ---------------------------------- Summary: Querying JDG local cache using greater than value cause exception Key: TEIID-3055 URL: https://issues.jboss.org/browse/TEIID-3055 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 Issuing query: select nss, valor_inicial, valor_final from CacheView.Resumen where valor_inicial > 950.0 produces the following in the query plan: USER COMMAND: SELECT nss, valor_inicial, valor_final FROM CacheView.Resumen WHERE nss > '950.0' request=/1MuNPfoG76j.0.0.5: org.hibernate.search.SearchException: Cannot create numeric range query for field saldo.valorInicial, since values are not numeric (int,long, short or double) at org.hibernate.search.bridge.util.impl.NumericFieldUtils.createNumericRangeQuery(NumericFieldUtils.java:69) at org.hibernate.search.query.dsl.impl.ConnectedMultiFieldsRangeQueryBuilder.createQuery(ConnectedMultiFieldsRangeQueryBuilder.java:107) at org.hibernate.search.query.dsl.impl.ConnectedMultiFieldsRangeQueryBuilder.createQuery(ConnectedMultiFieldsRangeQueryBuilder.java:83) at org.teiid.translator.object.infinispan.LuceneSearch.createRangeAboveQuery(LuceneSearch.java:349) at org.teiid.translator.object.infinispan.LuceneSearch.visit(LuceneSearch.java:217) at org.teiid.translator.object.infinispan.LuceneSearch.buildQueryFromWhereClause(LuceneSearch.java:145) at org.teiid.translator.object.infinispan.LuceneSearch.performSearch(LuceneSearch.java:66) at org.teiid.translator.object.infinispan.InfinispanExecutionFactory.search(InfinispanExecutionFactory.java:119) at org.teiid.translator.object.ObjectExecution.execute(ObjectExecution.java:102) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:312) [te -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3055) Querying JDG local cache using greater than value cause exception

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3055?page=com.atlassian.jira.plugin... ] Van Halbert reassigned TEIID-3055: ---------------------------------- Assignee: Van Halbert (was: Steven Hawkins) > Querying JDG local cache using greater than value cause exception > ----------------------------------------------------------------- > > Key: TEIID-3055 > URL: https://issues.jboss.org/browse/TEIID-3055 > 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 > > Issuing query: select nss, valor_inicial, valor_final from CacheView.Resumen where valor_inicial > 950.0 > produces the following in the query plan: > USER COMMAND: > SELECT nss, valor_inicial, valor_final FROM CacheView.Resumen WHERE nss > '950.0' > request=/1MuNPfoG76j.0.0.5: org.hibernate.search.SearchException: Cannot create numeric range query for field saldo.valorInicial, since values are not numeric (int,long, short or double) > at org.hibernate.search.bridge.util.impl.NumericFieldUtils.createNumericRangeQuery(NumericFieldUtils.java:69) > at org.hibernate.search.query.dsl.impl.ConnectedMultiFieldsRangeQueryBuilder.createQuery(ConnectedMultiFieldsRangeQueryBuilder.java:107) > at org.hibernate.search.query.dsl.impl.ConnectedMultiFieldsRangeQueryBuilder.createQuery(ConnectedMultiFieldsRangeQueryBuilder.java:83) > at org.teiid.translator.object.infinispan.LuceneSearch.createRangeAboveQuery(LuceneSearch.java:349) > at org.teiid.translator.object.infinispan.LuceneSearch.visit(LuceneSearch.java:217) > at org.teiid.translator.object.infinispan.LuceneSearch.buildQueryFromWhereClause(LuceneSearch.java:145) > at org.teiid.translator.object.infinispan.LuceneSearch.performSearch(LuceneSearch.java:66) > at org.teiid.translator.object.infinispan.InfinispanExecutionFactory.search(InfinispanExecutionFactory.java:119) > at org.teiid.translator.object.ObjectExecution.execute(ObjectExecution.java:102) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:312) [te -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3054?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3054. ----------------------------------- Fix Version/s: 8.7.1 Resolution: Done Applied Van's commits and updated the doc. > 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 > Fix For: 8.7.1, 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)

10 years, 5 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3051?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3051. ----------------------------------- Resolution: Done Added the set of affected schemas to the role with grant all when it is imported. > 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 > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > 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)

10 years, 5 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3051?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3051: ---------------------------------- Fix Version/s: 8.7.1 8.9 Affects Version/s: 8.7 > 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 > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > 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)

10 years, 5 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 updated TEIID-3054: ------------------------------- Assignee: Steven Hawkins (was: 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: Steven Hawkins > 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)

10 years, 5 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 stopped 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 > 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)

10 years, 5 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