search

electric-sql / electric

Sync little subsets of your Postgres data into local apps and services.
https://electric-sql.com
Apache License 2.0
6.21k stars 146 forks source link

Client doesn't receive rows if those rows existed on the table prior to electrification #1106

Closed ondrej closed 6 months ago

ondrej commented 6 months ago

Setup:

  1. Create a simple table (no FK, etc.)
  2. Add a row to the table
  3. Electrify the table
  4. Sync the table on the client (const shape = await db.{table}.sync(); await shape.synced;)
  5. Query the table on the client (const { results } = useLiveQuery(db.{table}.liveMany());)

Expected results: results contains the row.

Actual results: results doesn't. If you modify the row in any way, it will.

Also in Discord https://discordapp.com/channels/933657521581858818/1221983203812835328

linear[bot] commented 6 months ago

VAX-1768 Client doesn't receive rows if those rows existed on the table prior to electrification

alco commented 6 months ago

@ondrej Thanks for the report.

We've identified the root cause of the bug and are working on a fix.