vertica / vertica-nodejs

Official native node.js client for the Vertica Analytics Database.
https://www.vertica.com/
Apache License 2.0
12 stars 14 forks source link

Prepared statement using LIKE operator #109

Open negreanucalin opened 1 year ago

negreanucalin commented 1 year ago

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