Bug report #6990
pyspatialite: some spatialite functions not recognised
Status: | Closed | ||
---|---|---|---|
Priority: | Normal | ||
Assignee: | - | ||
Category: | - | ||
Affected QGIS version: | master | Regression?: | No |
Operating System: | Windows | Easy fix?: | No |
Pull Request or Patch supplied: | No | Resolution: | fixed/implemented |
Crashes QGIS or corrupts data: | No | Copied to github as #: | 16094 |
Description
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;
History
#1 Updated by Giovanni Manghi over 11 years ago
- Status changed from Open to Feedback
on qgis master, right?
#2 Updated by Giovanni Manghi over 11 years ago
and on what OS?
#3 Updated by Laurent Gasnier over 11 years ago
On qgis master and OS windows 7.
#4 Updated by Regis Haubourg over 11 years ago
Confimed here with Qspatialite too. A provider issue?
Everything works ok in spatialite_gui_v4
#5 Updated by Jürgen Fischer over 11 years ago
- Status changed from Feedback to Open
#6 Updated by Giuseppe Sucameli over 11 years ago
It depends on pyspatialite module.
#7 Updated by Giuseppe Sucameli over 11 years ago
- Category deleted (
DB Manager) - Operating System set to Windows
#8 Updated by Giuseppe Sucameli over 11 years ago
- Subject changed from DBManager : some spatialite functions not recognised to pyspatialite: some spatialite functions not recognised
#9 Updated by Paolo Cavallini over 11 years ago
Shouldn't this be moved upstream, on the pyspatialite bugtracker?
#10 Updated by Laurent Gasnier over 11 years ago
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...
#11 Updated by Paolo Cavallini over 11 years ago
- Priority changed from High to Normal
Please move this to the relevant library; if necessary, open a new ticket about the rest
#12 Updated by Médéric RIBREUX over 8 years ago
- Status changed from Open to Feedback
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 ?
#13 Updated by Laurent Gasnier over 8 years ago
Yes, I confirm. These functions work on QGis 2.12. This issue can be closed.
Thanks.
#14 Updated by Médéric RIBREUX over 8 years ago
- % Done changed from 0 to 100
- Status changed from Feedback to Closed
- Resolution set to fixed/implemented
Ok, I am closing this bug because it is fixed in QGIS 2.13 and 2.12!