Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Query Stopped Working with Version 1.2.0 #9

Open
KimberleeDArmstrong opened this issue Mar 26, 2018 · 2 comments
Open

Query Stopped Working with Version 1.2.0 #9

KimberleeDArmstrong opened this issue Mar 26, 2018 · 2 comments

Comments

@KimberleeDArmstrong
Copy link

SELECT transform(MakePoint(-97.895904,26.322807,4326),26914) as my_geom FROM <any_table>

This query works in the spatiality GUI and it worked with version 1.1.0 of this plugin, but starting with version 1.2.0 it returns an empty object for every row. results.rows.item(0) is an empty object.

@Cultrarius
Copy link

Interoperability with the spatialite GUI is not the goal of this plugin. The change from 1.1.0 to 1.2.0 only changed the native libraries, so there is no problem with the plugin code, but with the binaries itself.

Which version of the spatialite GUI do you use? Maybe try an older/newer version.

@KimberleeDArmstrong
Copy link
Author

KimberleeDArmstrong commented Mar 28, 2018

screen shot 2018-03-28 at 10 38 55 am

I am not worried about the interoperability with the spatialite GUI but I am pretty sure that is valid sql.
The latest version of the plugin won't return the my_geom column. If I add a * ...

"SELECT *, transform(MakePoint(-97.895904,26.322807,4326),26914) as my_geom FROM <any_table>"

It will return all the rows and columns from the table but not the my_geom column. In version 1.1.0 it will return the my_geom column.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants