Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
tsemerad opened this issue Mar 7, 2019 · 0 comments
Open

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

tsemerad opened this issue Mar 7, 2019 · 0 comments

Comments

@tsemerad
Copy link

tsemerad commented Mar 7, 2019

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant