Hey ! just wanted to report a bug i can reproduce : 1/ create table with wrangler `CREATE TABLE foob
Hey ! just wanted to report a bug i can reproduce :
1/ create table with wrangler
2/ Start adding rows without specifying id column (since
3/ Go to the D1 dashboard and drill down to your table
4/ You'll observe that for each record
5/ Try to delete a row through the web interface ("..." > "Delete")
6/ BOOM! The totality of your rows are gone
1/ create table with wrangler
CREATE TABLE foobar (
id SERIAL PRIMARY KEY,
email VARCHAR(255) NOT NULL
);2/ Start adding rows without specifying id column (since
SERIAL should be autoincrementing right ?) (in my case i created rows through a cloudflare worker but i think it doesnt matter)3/ Go to the D1 dashboard and drill down to your table
4/ You'll observe that for each record
<null> is set on id column.5/ Try to delete a row through the web interface ("..." > "Delete")
6/ BOOM! The totality of your rows are gone
