DT
Drizzle Team•16mo ago
Meexa

"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
Meexa
Meexa•16mo ago
adding the columns one-by-one works.
bloberenober
bloberenober•16mo ago
add breakpoints: true to your drizzle config file and regenerate the migration
alexblokh
alexblokh•16mo 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
Want results from more Discord servers?
Add your server
More Posts
[bug] Some sql statement looks broken when bulk insert```ts await db.insert(users) .values( { name: 'Andrew', createdAt: new Date(), Return first or throwI have a hard time believing this hasn't been asked yet, but my search results have yet to yield anyCan't find meta/_journal.json file when running migrateTrying to run `migrate()` from a lambda function and I can't figure out why it's unable to find the Wrong type on decimalsHello, I have encountered something interesting. The first screenshot shows what I'm inserting into CheckHello there, from this discussion: https://discord.com/channels/1043890932593987624/1090486363251544cascadesI know you can add `.references()` to set up foreign keys in a table definition, but how do you set jsonb field definition.What's the right way to define a jsonb field? I have a type `type MetaData = {keywords?: string[];}"Extend" tables by other tablesHey all, first of all great work with drizzle. Haven't had the time to play around with it so far. Bmaximum call stack exceededWeird bug where whenever I add a `where` `eq` clause getting maximum call stack exceededDrizzle recommended way to migrate resetApologies if this is a stupid question, I just recently migrated out of prisma and into drizzle. One