Drizzle Team•7mo ago

Updated Drizzle Kit and now all indexes were updated to use Btree? Why?

Today I generated a migration after updating drizzle-kit to ^0.22.1 It seems to have dropped all my previous indexes: Such as one that I created before the updated which generated:

CREATE INDEX IF NOT EXISTS "idx_product_description" ON "product" ("description");--> statement-breakpoint

CREATE INDEX IF NOT EXISTS "idx_product_description" ON "product" ("description");--> statement-breakpoint

The new migration file did:

DROP INDEX IF EXISTS "product_description_key";--> statement-breakpoint

CREATE UNIQUE INDEX IF NOT EXISTS "product_description_key" ON "product" USING btree (description);--> statement-breakpoint

DROP INDEX IF EXISTS "product_description_key";--> statement-breakpoint

CREATE UNIQUE INDEX IF NOT EXISTS "product_description_key" ON "product" USING btree (description);--> statement-breakpoint

Here's how that table with the index is defined in case that's useful

export const product = createTable(
  "product",
  {
    id: varchar("id", { length: 21 }).primaryKey().notNull(),
    weightByFoot: numeric("weight_by_foot").notNull(),
    description: text("description").notNull(),
  },
  (table) => {
    return {
      idxProductDescription: index("idx_product_description").on(
        table.description,
      ),
    };
  },
);

export const product = createTable(
  "product",
  {
    id: varchar("id", { length: 21 }).primaryKey().notNull(),
    weightByFoot: numeric("weight_by_foot").notNull(),
    description: text("description").notNull(),
  },
  (table) => {
    return {
      idxProductDescription: index("idx_product_description").on(
        table.description,
      ),
    };
  },
);

Why did this happen?

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

Updated Drizzle Kit and now all indexes were updated to use Btree? Why?