I've encountered an issue: when I try to execute in Spatialite_GUI query that contains
WITH clause I get
SQL error: near "with": syntax error. Also
SELECT and other keywords is not highlighted inside SQL-querry window. The same query in SQLite Manager works just fine. Found no treads on this issue. Is this my local problem?
Spatialite_GUI 1.7.1-1.5, SQLite Manager 0.8.1, OpenSUSE 13.1.
Actually the issue is deeper. DB Manager in QGIS 2.4 also throws the same error for the
WITH clause (
WHITH in sql window is highlighted in this case).
SQLite version: 3.7.17
Library: 4.1.1 GEOS: 3.4.2-CAPI-1.8.2 r3921 Proj: Rel. 4.8.0, 6 March 2012