node-gdal icon indicating copy to clipboard operation
node-gdal copied to clipboard

dataset.executeSQL() doesn't work with SQLITE dialect

Open tsemerad opened this issue 5 years ago • 0 comments

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?

tsemerad avatar Mar 07 '19 03:03 tsemerad