How do you create a temporary table with geometry column in spatialite?
I have tried:
CREATE TEMP TABLE rivers (code INTEGER, id INTEGER, name TEXT);
SELECT AddGeometryColumn('temp.rivers','geom', 27700, LINESTRING');
The first query succesfully creates the table, but the second query does not create the geometry column. I have tried running the queries in spatialite-gui, and in python with the sqlite3 module, with the same results.