Database enum breaks built in filter all columns, all views including Builder

[JohnnyMarnell]

Checklist

• I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Cloud
  • Tenant ID: partsorder.budibase.app

Describe the bug
In custom Budibase views built as well as built in Datasource table view pages in Data, clicking on magnifying glass and typing anything yields:

There was a problem loading your grid
Table updated externally, please re-fetch - operator does not exist: <any enum type> ~~* unknown

To Reproduce
Steps to reproduce the behavior:

1. Create or use any existing Postgres SQL datasource and table with an ENUM type, e.g. CREATE TYPE public.fruit_enum AS ENUM ('APPLE', 'BANANA');
2. Re-fetch
3. Click on Magnifying glass in column header in Data -> Postgres SQL -> table view (or any custom page using this) and type.
4. See error

Expected behavior
Filtering works, as for text fields (maybe casting ::text would fix?). Would also be great if these quick filters defaulted to matching substring anywhere, as opposed to prefix / start.

Screenshots

App Export
If possible - please attach an export of your budibase application for debugging/reproduction purposes.

Desktop (please complete the following information):

• OS: Mac Sonoma 14.16
• Chrome
• Tried multiple Budibase app versions, e.g. latest + 3.2.11

[linear]

BUDI-8889 Database enum breaks built in filter all columns, all views including Builder

[ConorWebb96]

Hey @JohnnyMarnell,

Do you have the table create scripts? I wasn't able to replicate this myself.

Can you also include the version of Postgres you are using?