[BUG]: Migrations are not generated for new Indexes

[dead8309]

Report hasn't been filed before.

• I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.36.4

What version of drizzle-kit are you using?

0.30.1

Other packages

No response

Describe the Bug

Creating a new issue for #3857 as the op closed that one.

The new way of describing tables properties(i.e. returning an array of object) doesn't create migrations file If the constraints are added later

This does't work

export const pageChunks = pgTable(
  "page_chunks",
  {
    id: serial("id").primaryKey(),
    content: text("content").notNull(),
    embedding: vector("embedding", { dimensions: 1024 }),
    createdAt: timestamp("created_at").defaultNow().notNull(),
    updatedAt: timestamp("updated_at").defaultNow().notNull(),
  },
  (table) => [
    {
      embeddingIdx: index("embedding_idx").using(
        "hnsw",
        table.embedding.op("vector_cosine_ops")
      ),
    },
  ]
);

but if we use deprecated signature it works fine.

export const pageChunks = pgTable(
  "page_chunks",
  {
    id: serial("id").primaryKey(),
    content: text("content").notNull(),
    embedding: vector("embedding", { dimensions: 1024 }),
    createdAt: timestamp("created_at").defaultNow().notNull(),
    updatedAt: timestamp("updated_at").defaultNow().notNull(),
  },
  (table) => ({
    embeddingIdx: index("embedding_idx").using(
      "hnsw",
      table.embedding.op("vector_cosine_ops")
    ),
  })
);

[AdamAkiva]

I've encountered this issue in the past.
The issue that you have it that you return an array of objects.
It should return an array of indexes (In your case).
E.g, you should change:

(table) => [
    {
      embeddingIdx: index("embedding_idx").using(
        "hnsw",
        table.embedding.op("vector_cosine_ops")
      ),
    },
  ]

to:

(table) => [
       index("embedding_idx").using(
        "hnsw",
        table.embedding.op("vector_cosine_ops")
      ),
  ]

I've checked this locally with the same drizzle & drizzle-kit versions you've supplied and this is the generated SQL (attached only the index part):

CREATE INDEX "embedding_idx" ON "page_chunks" USING hnsw ("embedding" vector_cosine_ops);--> statement-breakpoint

Hope this resolves your issue

[dead8309]

Thanks @AdamAkiva that worked!

[jvandenaardweg]

Thanks

But holy crap this is so fucking stupid, hour wasted because the docs don't mention this: https://orm.drizzle.team/docs/indexes-constraints#indexes