Skip to content

Prepared statement using LIKE operator #109

Description

@negreanucalin

I am unable to use LIKE operator with prepared statements, ex:

let result = await this.vertica.getPool().query({
    name: 'getByCallId',
    text: 'SELECT * FROM test_calls WHERE call_id LIKE ?,
    values: [ '%b452657-f7cf-123b-849c-288023acae0%' ] // Tried to see if removing start and end char works
});

Expected:
As in the SQL editor to retrieve results

image

Actual:
No results

Versions
Node v16.19.0
Vertica 11

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    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