[BUG]: drizzle kit does not push compound keys

[da1z]

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.38.4

What version of drizzle-kit are you using?

^0.30.2

Other packages

No response

Describe the Bug

pushed table does not have compound key.
i am using this schema:

export const verificationTokens = pgTable(
  "verificationToken",
  {
    identifier: text("identifier").notNull(),
    token: text("token").notNull(),
    expires: timestamp("expires", { mode: "date" }).notNull(),
  },
  (vt) => [
    {
      compositePk: primaryKey({
        columns: [vt.identifier, vt.token],
      }),
    },
  ],
);

this is table pushed with latest drizzle-kit

this is table with same schema from my other project pushed with kit version ^0.21.1

[da1z]

the issue is in my schema i am returning array instead of object. missed this broken changes

[da1z]

sorry. reopening the issue. using object throws at me a deprecation warning. what is correct approach here?

[da1z]

aha. closing it again. the correct way is to return array of keys:

  (vt) => [
    primaryKey({
      columns: [vt.identifier, vt.token],
    }),
  ],

[tysonzero]

Ran into this issue as well, unless I'm crazy it seems the current docs specifically use the incorrect non-working syntax you described in the original comment.

https://orm.drizzle.team/docs/indexes-constraints

e.g.

import { sql } from "drizzle-orm";
import { check, integer, pgTable, text, uuid } from "drizzle-orm/pg-core";
export const users = pgTable(
  "users",
  {
    id: uuid().defaultRandom().primaryKey(),
    username: text().notNull(),
    age: integer(),
  },
  (table) => [{
    checkConstraint: check("age_check1", sql`${table.age} > 21`),
  }]
);