WHERE Clause not working on enum type

[ihsanmohamad]

Hey there, I'm running into an issue with the Electric-sql, and I've put together a minimal reproduction using Next.js to help illustrate the problem. I've included the schema for reference.

For some context, my main project is built with SvelteKit, and I initially thought the issue might be related to my Svelte implementation of the electric-sql TypeScript client. However, after creating this Next.js example, it seems the problem might be on enum columns.

Basically, any column defined as an enum in the schema is causing issues, while other column types are working just fine. I'm not entirely sure what's going on, but I wanted to provide this reproduction to see if anyone has encountered a similar problem or has any insights to share.

https://github.com/ihsanmohamad/react-electric-repro

[KyleAMathews]

Hey, sorry you're running into issues. Could you modify your README with instructions on how to run the reproduction? Ideally a single command can e.g. start a docker compose file and run the migration. I don't know how to run your app as is.

[ihsanmohamad]

ok, will do tomorrow.

[ihsanmohamad]

hi I updated the repo. I also add the README with instructions. I'm sorry I am unable to make fully docker compose as I'm not familiar with docker and nextjs. I'll try to work on docker compose again if you have issues with the steps.

[KyleAMathews]

Hey thanks for creating the nice reproduction! I followed the steps and did see the bug. It does seem indeed that we're for some reason not handling enums correctly. I'll mark this as a bug and raise it internally.

I'll note too that our error for a where clause to a missing column isn't great. It'd be nice if the error directly says something along the lines of "the where clause is referencing an unknown column event_id" or something along those lines.

[kevin-dp]

We got a similar bug report on Discord yesterday. Could this be related?

[ihsanmohamad]

We got a similar bug report on Discord yesterday. Could this be related?

that was me 😁

[kevin-dp]

I'm closing this issue in favor of this follow-up issue for adding support for enumerations: #1709