Skip to content

Prepared statement with IN clause: Passing array as of the parameters in values array does not work.  #142

Description

@mayurbangar

Query:
SELECT * FROM TABLE WHERE lastName=? and firstName IN (?)

Values:
['Smith', ['John', 'Joe', 'Jon']]

Final query that runs in db is -
SELECT * FROM TABLE WHERE lastName='Smith' and firstName in ('{{John,Joe,John}}')

Expected query -
SELECT * FROM TABLE WHERE lastName='Smith' and firstName in ('John', 'Joe', 'Jon')

There was a function Vertica.quote in the vertica driver (https://www.npmjs.com/package/vertica) which used to work as expected.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions