TablePlus-Linux icon indicating copy to clipboard operation
TablePlus-Linux copied to clipboard

"Contains" filter not working on Postgres jsonb columns (not casted correctly)

Open matthiasdg opened this issue 5 years ago • 0 comments

1. Database version (Ex: PostgreSQL 10.0): Postgres 10 (actually timescaledb, but this is just a layer on top of postgres)

2. TablePlus version (the number on the welcome or about screen, Ex: build 81): Linux alpha build 54

3. Linux distro (Ex: Ubuntu 18.04): Ubuntu 20.04

4. The steps to reproduce this issue: If you have a jsonb column (e.g. payload) and use the filters to check if it contains a certain field, it doesn't work. (Error: operator does not exist: jsonb ~~ unknown LINE 1: SELECT * FROM "public"."events" WHERE "payload" LIKE ... HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.) If I do the same on the Mac client, I indeed get WHERE ("payload"::TEXT LIKE '... in the query, so it is casted to text.

(I hope TablePlus for Linux continues improving; just switched from Mac to Linux and like it)

matthiasdg avatar May 06 '20 15:05 matthiasdg