You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Julian Hyde (Jira)" <ji...@apache.org> on 2022/10/02 22:42:00 UTC

[jira] [Resolved] (CALCITE-5276) Implicitly convert strings to geometries

     [ https://issues.apache.org/jira/browse/CALCITE-5276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde resolved CALCITE-5276.
----------------------------------
    Resolution: Fixed

Fixed in [765bec45|https://github.com/apache/calcite/commit/765bec45f8f311a72b846224fe37c9e836220a3a]; thanks for the PR, [~bchapuis]!

> Implicitly convert strings to geometries
> ----------------------------------------
>
>                 Key: CALCITE-5276
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5276
>             Project: Calcite
>          Issue Type: Improvement
>          Components: spatial
>            Reporter: Bertil Chapuis
>            Assignee: Bertil Chapuis
>            Priority: Minor
>             Fix For: 1.33.0
>
>
> Postgis and H2GIS implicitly transform strings into a geometries so that one can write the following query:
> {{SELECT ST_AsText('POINT(-71.064544 42.28787)');}}
> Instead of:
> {{SELECT ST_AsText(ST_GeomFromText('POINT(-71.064544 42.28787)'));}}
>  supports this kind of conversion. Should I introduce a new SqlTypeTranform (TO_GEOMETRY)? Thanks a lot for your help, I'm still discovering the internals of calcite. 
> The idea would be to introduce a SqlTypeTransform, change the SqlTypeAssignmentRule (see CALCITE-3550), add tests in TypeCoercionTest, and update the doc. 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)