March 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4830) Parsing Error when deploying VDB with "geometry" as column name

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4830?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4830: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1436306|https://bugzilla.redhat.com/show_bug.cgi?id=1436306] from CLOSED to ASSIGNED > Parsing Error when deploying VDB with "geometry" as column name > --------------------------------------------------------------- > > Key: TEIID-4830 > URL: https://issues.jboss.org/browse/TEIID-4830 > Project: Teiid > Issue Type: Bug > Components: Grammar, Query Engine > Affects Versions: 9.3, 8.12.9.6_3 > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Fix For: 9.3, 9.2.2 > > > The following query works correctly if run against a deployed VDB: > {code:sql} > SELECT 'a' as "geometry"; > {code} > However, the following VDB fails to deploy: > {code:xml} > <?xml version="1.0" encoding="UTF-8"?> > <vdb name="test-vdb" version="1"> > <model name="Test" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW test(c1 string) AS > SELECT 'a' as "geometry"; > > ]]></metadata> > </model> > </vdb> > {code} > with the error > {noformat} > TEIID31080 Test.test validation error: TEIID31100 Parsing error: Encountered "SELECT 'a' AS [*]geometry[*]" at line 1, column 15. > Was expecting: id > {noformat} > This seems to only happen when the name is "geometry", I could not find any other reserved word that would cause the same error. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4715) Google translator allows to be inserted larger value than defined for teiid datatype

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4715?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4715: --------------------------------------- More than likely it's the same situation. Leave the type as double and repeat to confirm that the scenario works. > Google translator allows to be inserted larger value than defined for teiid datatype > ------------------------------------------------------------------------------------ > > Key: TEIID-4715 > URL: https://issues.jboss.org/browse/TEIID-4715 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.2 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > > It is possible to insert larger value than defined by the teiid datatype, see query: > INSERT INTO SmallA (IntKey, BigIntegerValue) VALUES (100, 1234567890123456789012345) > But if I try to select the value, null is returned for BigIntegerValue: > SELECT IntKey, BigIntegerValue FROM SmallA WHERE IntKey=100 > (VDB is same as in TEIID-4714) -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4830) Parsing Error when deploying VDB with "geometry" as column name

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4830?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4830: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1436306|https://bugzilla.redhat.com/show_bug.cgi?id=1436306] from NEW to CLOSED > Parsing Error when deploying VDB with "geometry" as column name > --------------------------------------------------------------- > > Key: TEIID-4830 > URL: https://issues.jboss.org/browse/TEIID-4830 > Project: Teiid > Issue Type: Bug > Components: Grammar, Query Engine > Affects Versions: 9.3, 8.12.9.6_3 > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Fix For: 9.3, 9.2.2 > > > The following query works correctly if run against a deployed VDB: > {code:sql} > SELECT 'a' as "geometry"; > {code} > However, the following VDB fails to deploy: > {code:xml} > <?xml version="1.0" encoding="UTF-8"?> > <vdb name="test-vdb" version="1"> > <model name="Test" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW test(c1 string) AS > SELECT 'a' as "geometry"; > > ]]></metadata> > </model> > </vdb> > {code} > with the error > {noformat} > TEIID31080 Test.test validation error: TEIID31100 Parsing error: Encountered "SELECT 'a' AS [*]geometry[*]" at line 1, column 15. > Was expecting: id > {noformat} > This seems to only happen when the name is "geometry", I could not find any other reserved word that would cause the same error. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4715) Google translator allows to be inserted larger value than defined for teiid datatype

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4715?page=com.atlassian.jira.plugin... ] Lucie Fabrikova commented on TEIID-4715: ---------------------------------------- I observed similar issue with long, but inside teiid datatype range: I inserted value 28341791043587382 to longnum column, and it was inserted into google spreadsheet correctly. But select returned null value. If I select the value directly with google sheets api (e.g. ValueRange class) I get the inserted value. Does the explanation ^ apply also to Long? > Google translator allows to be inserted larger value than defined for teiid datatype > ------------------------------------------------------------------------------------ > > Key: TEIID-4715 > URL: https://issues.jboss.org/browse/TEIID-4715 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.2 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > > It is possible to insert larger value than defined by the teiid datatype, see query: > INSERT INTO SmallA (IntKey, BigIntegerValue) VALUES (100, 1234567890123456789012345) > But if I try to select the value, null is returned for BigIntegerValue: > SELECT IntKey, BigIntegerValue FROM SmallA WHERE IntKey=100 > (VDB is same as in TEIID-4714) -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4806) Infinispan DSL Resource Adapter: NullPointerException when Admin user/password not provided

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4806?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4806: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1430740|https://bugzilla.redhat.com/show_bug.cgi?id=1430740] from NEW to ASSIGNED > Infinispan DSL Resource Adapter: NullPointerException when Admin user/password not provided > ------------------------------------------------------------------------------------------- > > Key: TEIID-4806 > URL: https://issues.jboss.org/browse/TEIID-4806 > Project: Teiid > Issue Type: Bug > Components: JDG Connector > Affects Versions: 8.12.9.6_3 > Reporter: Jan Stastny > Assignee: Van Halbert > Fix For: 8.12.x-6.4 > > > Infinispan DSL Resource adapter properties AdminUserName and AdminPassword are not defined as required. If they are not configured it results in NullpointerException during metadata load of a vdb which uses the connector. > Creation of such resource-adapter shouldn't have succeeded, if the properties are required. > {code:xml} > <resource-adapter id="jdg-protobuf-customer-report"> > <module slot="main" id="org.jboss.teiid.resource-adapter.infinispan.dsl"/> > <transaction-support>LocalTransaction</transaction-support> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.infinispan.dsl.InfinispanManagedConnectionFactory" jndi-name="java:/teiid4709-pro-ds" enabled="true" use-java-context="true" pool-name="jdg-protobuf-customer-report"> > <config-property name="MessageDescriptor"> > org.jboss.qe.jdg.remote.protobuf.CustomerReport > </config-property> > <config-property name="AuthApplicationRealm"> > ApplicationRealm > </config-property> > <config-property name="MessageMarshallers"> > org.jboss.qe.jdg.pojo.CustomerReport:org.jboss.qe.jdg.remote.marshaller.CustomerReportMarshaller > </config-property> > <config-property name="AuthUserName"> > teiidUser > </config-property> > <config-property name="AuthServerName"> > hostsecured > </config-property> > <config-property name="AuthSASLMechanism"> > DIGEST-MD5 > </config-property> > <config-property name="AuthPassword"> > password > </config-property> > <config-property name="Module"> > org.jboss.qe.jdg.pojos > </config-property> > <config-property name="RemoteServerList"> > hostname:11323 > </config-property> > <config-property name="ProtobufDefinitionFile"> > /org/jboss/qe/jdg/remote/protobuf/CustomerReport.proto > </config-property> > <config-property name="CacheTypeMap"> > sec-cache:org.jboss.qe.jdg.pojo.CustomerReport;customerId > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter> > {code} > {code} > 13:34:21,156 WARN [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50036 VDB teiid4709-pro.1 model "Source" metadata failed to load. Reason:java.lang.NullPointerException: org.teiid.translator.TranslatorException: java.lang.NullPointerException > at org.teiid.resource.adapter.infinispan.dsl.InfinispanConnectionImpl.getCacheContainer(InfinispanConnectionImpl.java:363) > at org.teiid.resource.adapter.infinispan.dsl.InfinispanConnectionImpl.getDescriptor(InfinispanConnectionImpl.java:189) > at org.teiid.resource.adapter.infinispan.dsl.InfinispanConnectionImpl.getDescriptor(InfinispanConnectionImpl.java:180) > at org.teiid.translator.infinispan.dsl.metadata.ProtobufMetadataProcessor.process(ProtobufMetadataProcessor.java:103) > at org.teiid.translator.infinispan.dsl.metadata.ProtobufMetadataProcessor.process(ProtobufMetadataProcessor.java:77) > at org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:950) [teiid-api-8.12.10.6_3.jar:8.12.10.6_3] > at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96) [teiid-engine-8.12.10.6_3.jar:8.12.10.6_3] > at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62) [teiid-engine-8.12.10.6_3.jar:8.12.10.6_3] > at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.12.10.6_3.jar:8.12.10.6_3] > at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.12.10.6_3.jar:8.12.10.6_3] > at org.teiid.jboss.VDBService$7.run(VDBService.java:446) [teiid-jboss-integration-8.12.10.6_3.jar:8.12.10.6_3] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_111] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_111] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_111] > at org.jboss.threads.JBossThread.run(JBossThread.java:122) > Caused by: javax.resource.ResourceException: java.lang.NullPointerException > at org.teiid.resource.adapter.infinispan.dsl.InfinispanConnectionImpl.createRemoteCache(InfinispanConnectionImpl.java:537) > at org.teiid.resource.adapter.infinispan.dsl.InfinispanConnectionImpl.createRemoteCacheFromServerList(InfinispanConnectionImpl.java:477) > at org.teiid.resource.adapter.infinispan.dsl.InfinispanConnectionImpl.createCacheContainer(InfinispanConnectionImpl.java:390) > at org.teiid.resource.adapter.infinispan.dsl.InfinispanConnectionImpl.getCacheContainer(InfinispanConnectionImpl.java:361) > ... 14 more > Caused by: java.lang.NullPointerException > at org.teiid.resource.adapter.infinispan.dsl.InfinispanConnectionImpl.createRemoteCache(InfinispanConnectionImpl.java:500) > ... 17 more > {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4828) ST_GeomFromGeoJson fails for certain geometry types

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4828?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4828: ---------------------------------- Fix Version/s: 8.12.x-6.4 > ST_GeomFromGeoJson fails for certain geometry types > --------------------------------------------------- > > Key: TEIID-4828 > URL: https://issues.jboss.org/browse/TEIID-4828 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 9.3, 8.12.10.6_3 > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Fix For: 9.3, 8.12.x-6.4, 9.2.2 > > > ST_GeomFromGeoJson fails to decode GeoJSON with certain geometry types. The following queries work: > {code:sql|title=Working Queries} > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('POINT (30 10)'))) > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('POLYGON ((35 10, 45 45, 15 40, 10 20, 35 10),(20 30, 35 35, 30 20, 20 30))'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('MULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)),((15 5, 40 10, 10 20, 5 10, 15 5)))'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('MULTIPOLYGON (((40 40, 20 45, 45 30, 40 40)),((20 35, 10 30, 10 10, 30 5, 45 20, 20 35),(30 20, 20 15, 20 25, 30 20)))'))); > {code} > but these fail: > {code:sql|title=Failing Queries} > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('MULTIPOINT ((10 40), (40 30), (20 20), (30 10))'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('MULTIPOINT (10 40, 40 30, 20 20, 30 10)'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('MULTILINESTRING ((10 10, 20 20, 10 40),(40 40, 30 30, 40 20, 30 10))'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('LINESTRING (30 10, 10 30, 40 40)'))); > {code} > The server log when running with master says > {noformat} > TEIID30328 Unable to evaluate ST_GeomFromGeoJson(?): TEIID30384 Error while evaluating function st_geomfromgeojson'. Originally ExpressionEvaluationException 'Conflicting property-based creators: already had explicitly marked [constructor for org.wololo.geojson.MultiPoint, annotations: {interface com.fasterxml.jackson.annotation.JsonCreator=(a)com.fasterxml.jackson.annotation.JsonCreator(mode=DEFAULT)}], encountered [constructor for org.wololo.geojson.MultiPoint, annotations: {interface com.fasterxml.jackson.annotation.JsonCreator=(a)com.fasterxml.jackson.annotation.JsonCreator(mode=DEFAULT)}]' CreatorCollector.java:304. > {noformat} > When running with latest 6.3 patch, the server log says > {noformat} > TEIID30328 Unable to evaluate ST_GeomFromGeoJson(?): TEIID30384 Error while evaluating function st_geomfromgeojson'. Originally ExpressionEvaluationException '1' BasicDeserializerFactory.java:394. > {noformat} > The difference seems to be due to different versions of jackson-databind (which also seems to be the source of the problem). -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4842) testAnonSSLConnect taking too long to complete

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4842?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4842. ----------------------------------- Resolution: Done Set the SSLHandler to close on an ssl exception > testAnonSSLConnect taking too long to complete > ---------------------------------------------- > > Key: TEIID-4842 > URL: https://issues.jboss.org/browse/TEIID-4842 > Project: Teiid > Issue Type: Quality Risk > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12.x-6.4 > > > The netty version for 6.4 doesn't behave the same as older or newer branches. When a non-ssl connection attempt is made against an ssl jdbc server, it will wait for all handshake attempts to expire. It should give up after the first based upon the server response. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4518) Add support for JDG 7.1

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4518?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4518: ------------------------------------------------ Debi Rieden <drieden(a)redhat.com> changed the Status of [bug 1385628|https://bugzilla.redhat.com/show_bug.cgi?id=1385628] from ASSIGNED to CLOSED > Add support for JDG 7.1 > ----------------------- > > Key: TEIID-4518 > URL: https://issues.jboss.org/browse/TEIID-4518 > Project: Teiid > Issue Type: Enhancement > Components: JDG Connector > Affects Versions: 8.12.7.6_3 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.3, 8.12.10.6_3 > > > The JDG 7.1 modules need to be added as dependencies in the infinispan translator and connector module.xml files. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4842) testAnonSSLConnect taking too long to complete

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4842: ------------------------------------- Summary: testAnonSSLConnect taking too long to complete Key: TEIID-4842 URL: https://issues.jboss.org/browse/TEIID-4842 Project: Teiid Issue Type: Quality Risk Components: Server Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.12.x-6.4 The netty version for 6.4 doesn't behave the same as older or newer branches. When a non-ssl connection attempt is made against an ssl jdbc server, it will wait for all handshake attempts to expire. It should give up after the first based upon the server response. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4841) Remove jboss-logging-generator dependency

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4841?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4841: ------------------------------- Git Pull Request: https://github.com/teiid/teiid/pull/934 > Remove jboss-logging-generator dependency > ----------------------------------------- > > Key: TEIID-4841 > URL: https://issues.jboss.org/browse/TEIID-4841 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Affects Versions: 9.3, 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.3, 8.12.x-6.4 > > > Remove the jboss-logging-generator dependency, causing a missing maven artifact in QE's validation reporting. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 1 month

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2017