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

pyspatialite: some spatialite functions not recognised #16094

Closed
qgib opened this issue Jan 14, 2013 · 14 comments
Closed

pyspatialite: some spatialite functions not recognised #16094

qgib opened this issue Jan 14, 2013 · 14 comments
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter!

Comments

@qgib
Copy link
Contributor

qgib commented Jan 14, 2013

Author Name: Laurent Gasnier (Laurent Gasnier)
Original Redmine Issue: 6990
Affected QGIS version: master


In DBManager, some spatialite functions known in V3.0.1 throw a database error "no such function".
Examples: ST_OffsetCurve, ST_Line_Interpolate_Point
SQL query used in SQL window:
SELECT PK_UID, textstring, ST_OffsetCurve(Geometry, 1000 , 0) as geom from Anno_T6;
SELECT PK_UID, textstring, ST_Line_Interpolate_Point(Geometry, 0.5) as geom from Anno_T6;

@qgib
Copy link
Contributor Author

qgib commented Jan 14, 2013

Author Name: Giovanni Manghi (@gioman)


on qgis master, right?


  • status_id was changed from Open to Feedback

@qgib
Copy link
Contributor Author

qgib commented Jan 14, 2013

Author Name: Giovanni Manghi (@gioman)


and on what OS?

@qgib
Copy link
Contributor Author

qgib commented Jan 14, 2013

Author Name: Laurent Gasnier (Laurent Gasnier)


On qgis master and OS windows 7.

@qgib
Copy link
Contributor Author

qgib commented Jan 16, 2013

Author Name: Regis Haubourg (@haubourg)


Confimed here with Qspatialite too. A provider issue?
Everything works ok in spatialite_gui_v4

@qgib
Copy link
Contributor Author

qgib commented Feb 17, 2013

Author Name: Jürgen Fischer (@jef-n)


  • status_id was changed from Feedback to Open

@qgib
Copy link
Contributor Author

qgib commented Apr 14, 2013

Author Name: Giuseppe Sucameli (@brushtyler)


It depends on pyspatialite module.

@qgib
Copy link
Contributor Author

qgib commented Apr 14, 2013

Author Name: Giuseppe Sucameli (@brushtyler)


  • category_id removed DB Manager
  • operating_system was changed from to Windows

@qgib
Copy link
Contributor Author

qgib commented Apr 14, 2013

Author Name: Giuseppe Sucameli (@brushtyler)


  • subject was changed from DBManager : some spatialite functions not recognised to pyspatialite: some spatialite functions not recognised

@qgib
Copy link
Contributor Author

qgib commented Apr 14, 2013

Author Name: Paolo Cavallini (@pcav)


Shouldn't this be moved upstream, on the pyspatialite bugtracker?

@qgib
Copy link
Contributor Author

qgib commented Apr 15, 2013

Author Name: Laurent Gasnier (Laurent Gasnier)


Is there a particular need of pyspatialite ?
For other GIS works on W7, I use pysqlite with Spatialite DDLs without such problems.
See https://groups.google.com/forum/?fromgroups=#!topic/spatialite-users/VawtWeN5t2Q
But I tested it only on W7...

@qgib
Copy link
Contributor Author

qgib commented May 29, 2013

Author Name: Paolo Cavallini (@pcav)


Please move this to the relevant library; if necessary, open a new ticket about the rest


  • priority_id was changed from High to Normal

@qgib
Copy link
Contributor Author

qgib commented Jan 31, 2016

Author Name: Médéric RIBREUX (Médéric RIBREUX)


Hello, bug triage...

it seems to be fixed in QGIS 2.13 master (and probably in earlier releases) because I can use ST_Line_Interpolate_Point and St_Offsetcurve in DBManager.
Can you confirm ?


  • status_id was changed from Open to Feedback

@qgib
Copy link
Contributor Author

qgib commented Feb 13, 2016

Author Name: Laurent Gasnier (Laurent Gasnier)


Yes, I confirm. These functions work on QGis 2.12. This issue can be closed.
Thanks.

@qgib
Copy link
Contributor Author

qgib commented Feb 13, 2016

Author Name: Médéric RIBREUX (Médéric RIBREUX)


Ok, I am closing this bug because it is fixed in QGIS 2.13 and 2.12!


  • done_ratio was changed from 0 to 100
  • status_id was changed from Feedback to Closed
  • resolution was changed from to fixed/implemented

@qgib qgib added the Bug Either a bug report, or a bug fix. Let's hope for the latter! label May 24, 2019
@qgib qgib closed this as completed May 24, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter!
Projects
None yet
Development

No branches or pull requests

1 participant