QGIS says "Spatialite 3.0.1", but Functions that are new in Spatialite 3 not available
|Assigned to:||-||% Done:||
|Target version:||Version 2.0.0|
|Platform version:||7||Affected version:||master|
|Status info:||Causes crash or corruption:||No|
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.