node-gdal
node-gdal copied to clipboard
dataset.executeSQL() doesn't work with SQLITE dialect
I'm trying to run the executeSQL
method using the sqlite dialect. I've tested a number of queries that each work using the default dialect but fail when I set the dialect to "SQLITE".
const query = 'SELECT my_field FROM my_table'
// This succeeds
const normalQueriedLayer = dataset.executeSQL(query)
// This fails
const sqliteQueriedLayer = dataset.executeSQL(query, null, 'SQLITE')
The error simply states:
Error executing SQL
at Error (native)
Does node-gdal support the SQLITE dialect out of the box? I noticed that the SQLite driver isn't one of the bundled drivers, so does that mean that the SQLITE dialect isn't supported?