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

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13384812#comment-13384812 ] 

Steven Hawkins commented on TEIID-4828:
---------------------------------------

I see that we have the wrong databind version in the master pom.  It should be 2.5.4, not 2.4.5.  With that version or even the 2.6.3 required by geojson results in the same exception, so I'll have to look at this more to see if it goes beyond just a simple dependency issue.

> 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
>
>
> 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=@com.fasterxml.jackson.annotation.JsonCreator(mode=DEFAULT)}], encountered [constructor for org.wololo.geojson.MultiPoint, annotations: {interface com.fasterxml.jackson.annotation.JsonCreator=@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)