Skip to content

Select IN not supported in SQLite #3

@leobelen

Description

@leobelen

Select statements with IN clause are not supported by SQLite as they have to include VALUES in this form:

WHERE (productKey, productIdentifier2) 
   IN (VALUES(23,'Master'),(28,'Local'),(18,'Local'),(19,'Local'))

An explanation can be found in https://stackoverflow.com/questions/45953553/what-is-the-syntax-for-select-in-statement-for-sqlite

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions