drizzle-kit: push wants to change column type that hasn't changed

just updated my dependencies:

dependencies:
- drizzle-orm 0.25.4
+ drizzle-orm 0.26.0
devDependencies:
- drizzle-kit 0.17.6-76e73f3
+ drizzle-kit 0.18.0

dependencies:
- drizzle-orm 0.25.4
+ drizzle-orm 0.26.0
devDependencies:
- drizzle-kit 0.17.6-76e73f3
+ drizzle-kit 0.18.0

here's my truncated schema

export const artists = mysqlTable("artists", {
  id: serial("id").primaryKey(),
  name: varchar("name", { length: 50 }).notNull(),
  isGroup: boolean("is_group").notNull().default(true),
})

export const artists = mysqlTable("artists", {
  id: serial("id").primaryKey(),
  name: varchar("name", { length: 50 }).notNull(),
  isGroup: boolean("is_group").notNull().default(true),
})

push:mysql results in: You're about to change is_group column type from alter_table_alter_column_set_type to boolean with 1 items is_group has always been a boolean, it hasn't been touched in a while, let alone just now between dependency changes. and unless it's some kind of internal thing, alter_table_alter_column_set_type doesn't sound like a valid column type. downgrading kit back down to 0.17.6-76e73f3 works (i have no changes right now)

3 Replies

nutellaplox•14mo ago

This is also happening to me ^

Kairu•14mo ago

ah i see someone posted an issue like 20 min after i posted this https://github.com/drizzle-team/drizzle-kit-mirror/issues/59

GitHub

[BUG]: push:mysql trying to truncate table with boolean · Issue #5...

I've been playing around a bit with the new push:mysql command and noticed that it's trying to wipe my table any time i run it because it's supposedly trying to change the type to '...

Andrii Sherman•14mo ago

Yeah, will fix it, thanks!

Gaming

Programming

drizzle-kit: push wants to change column type that hasn't changed