[Bug]: drizzle-kit push not working when changing the schema

[davidaragundy]

This error occurred in drizzle-kit@0.20.1.

I have this table

export const users = sqliteTable("users", {
  id: text("id").notNull().primaryKey(),
  firstName: text("first_name").notNull(),
  lastName: text("last_name").notNull(),
  username: text("username").notNull().unique(),
  email: text("email").notNull().unique(),
  password: text("password").notNull(),
  avatarUrl: text("avatar_url").notNull(),
  postsCount: integer("posts_count").notNull().default(0),
  followersCount: integer("followers_count").notNull().default(0),
  followingsCount: integer("followings_count").notNull().default(0),
  createdAt: integer("created_at").notNull(),
});

and everything was working but when I change it to this one (deleting the postsCount field)

export const users = sqliteTable("users", {
  id: text("id").notNull().primaryKey(),
  firstName: text("first_name").notNull(),
  lastName: text("last_name").notNull(),
  username: text("username").notNull().unique(),
  email: text("email").notNull().unique(),
  password: text("password").notNull(),
  avatarUrl: text("avatar_url").notNull(),
  followersCount: integer("followers_count").notNull().default(0),
  followingsCount: integer("followings_count").notNull().default(0),
  createdAt: integer("created_at").notNull(),
});

throws this error:

the table is empty tho

[AndriiSherman]

This should be fixed in drizzle-kit@0.21.3. If the issue persists, feel free to reopen it!