Bug #5640
QGIS says "Spatialite 3.0.1", but Functions that are new in Spatialite 3 not available
| Status: | New | Start Date: | 05/25/2012 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assigned to: | - | % Done: | 0% |
|
| Category: | - | |||
| Target version: | Version 2.0.0 | |||
| Platform: | Windows | Patch supplied: | No | |
| Platform version: | 7 | Affected version: | master | |
| Status info: | Causes crash or corruption: | No | ||
| Resolution: |
Description
I have some triggers using ST_Line_Locate_Point and ST_Line_Interpolate_Point.
It works great when I manually do any insertions in Spatialite-GUI, but QGIS refuses to write to the layer. I installed the qgis-dev build, which from the Help menu claims Spatialite 3.0.1,
but when it refuses to write, I get this message in the Log Window:
SQLite error: no such function: ST_Line_Locate_Point
SQL: INSERT INTO "Sections"("ID","Geometry","ConnectionID","Primary") VALUES (NULL,GeomFromWKB(?, 4326),?,?)
(tangentially related issue: once this happens, QGIS doesn't release its lock on the database even if I leave edit mode and cancel changes - have to shut QGIS down)
Latest test: Windows 7 64-bit, QGIS version 1.8.0-Lisboa rev a442b89
Attached: Script to make a lines layer "Connections" and a points layer "Sections", with the triggers to force Sections to snap to Connections.
Also .sqlite & .qgs files with the script already run and a few lines drawn.
History
Updated by Paolo Cavallini 9 months ago
- Target version changed from Version 1.8.0 to Version 2.0.0