ramsql icon indicating copy to clipboard operation
ramsql copied to clipboard

like operator doesnt seem to work.

Open haggerty-william opened this issue 8 years ago • 2 comments

I don't know if this is an issue or just user error. I have been trying to get the following query to execute: select message from logs where message like $1

This is the table schema: CREATE TABLE logs (id BIGSERIAL PRIMARY KEY, logTime timestamp, ip text, machine text, agent text, name text, level text, code SMALLINT, message text);

The query parameter is "%Ack complete%". The error message is: table "like" does not exist

haggerty-william avatar Feb 24 '17 18:02 haggerty-william

FYI: The finalQuery variable before being written to the db connection in stmt.go Query() is: select message from logs where message like $$%Ack complete%$$

haggerty-william avatar Feb 24 '17 19:02 haggerty-william

I looked through some code and it doesn't look like the 'like' operator is implemented. Ill try to set aside some time and take a crack at implementing it when I get a chance.

haggerty-william avatar Feb 24 '17 19:02 haggerty-william