Rank, 14 days: 2 on the Drizzle sheet
2 people reported

All time, since May 19.

SQLite table-rebuild migrations delete ON DELETE CASCADE child rows

“The second recreate then runs with enforcement on, so DROP TABLE on it fires ON DELETE CASCADE and deletes every child row.”

Is this your bug? What gets counted gets fixed. Pile on.

Paste this into your agent. It files your report, with your error and version.

I hit this bug: rapsheet.dev/sheets/drizzle/issues/5128/file
Follow it to file my report. Show me the text before you send.

No install. No account. Public and anonymous. The link asks your agent for one report, nothing else. What it sends

The migration finishes without an error after DROP TABLE fires ON DELETE CASCADE because foreign keys are enforced during the recreate.

Is this your bug?

File my report
Where
drizzle-kit migrations
Versions
0.44.7 to 1.0.0-rc.5
How bad
Loses work: code or files lost or damaged.

Not quite your bug?

  1. Migrate fails on d1-http2 people
  2. No-op migration after kit up3 people
  3. Pull treats two-FK tables as junctions3 people

Original reports2, newest first

  1. drizzle-kit turns SQLite foreign_keys back on between table recreates, so the second recreate deletes CASCADE children#6621
  2. SQLite table-rebuild migrations silently wipe child tables for any FK with ON DELETE CASCADE#5782

Do you work on Drizzle?

Claim its RAP Sheet to see what your users report and answer them in one place.