Bug report #5640
QGIS says "Spatialite 3.0.1", but Functions that are new in Spatialite 3 not available
|Affected QGIS version:||master||Regression?:||No|
|Operating System:||Windows||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||15203|
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.