"The supplied SQL string contains more than one statement" after running "generate:sqlite"

I just updated one of my schemas with a few columns and now my project is broken. This is the generated SQL

ALTER TABLE projects ADD `project_id` integer;
ALTER TABLE projects ADD `icon` text;
ALTER TABLE projects ADD `last_updated_at` text;
ALTER TABLE projects ADD `created_at` text;
ALTER TABLE projects ADD `archived` integer;

ALTER TABLE projects ADD `project_id` integer;
ALTER TABLE projects ADD `icon` text;
ALTER TABLE projects ADD `last_updated_at` text;
ALTER TABLE projects ADD `created_at` text;
ALTER TABLE projects ADD `archived` integer;

3 Replies

MeexaOP•2y ago

adding the columns one-by-one works.

Dan•2y ago

add breakpoints: true to your drizzle config file and regenerate the migration

alexblokh•2y ago

we will make an opt out breakpoints in next release, both SQLite and MySQL do not support multiple DDL statements in one transaction, so we have to split statements on the client side prior to running migrations

Gaming

Programming

"The supplied SQL string contains more than one statement" after running "generate:sqlite"