[BUG]: Drizzle Studio not showing some relation

[TheGrinch00]

What version of drizzle-orm are you using?

0.30.10

What version of drizzle-kit are you using?

0.20.17

Describe the Bug

I have a MySQL schema with many to many relations and there are some that are not shown at all in Drizzle Studio, even if in TypeScript I can join them using the with parameter as shown here:

This is a relations saying that a Product can have many ItemCategory and a single ItemCategory can be assigned to many Products.

In my schema, here is how I defined them:

export const ProductTable = mysqlTable("products", {
  id: int("id").primaryKey().autoincrement().notNull(),
  name: varchar("name", { length: 127 }).notNull(),
  disabled: tinyint("disabled").default(0).notNull(),
});

export const ProductTableRelations = relations(ProductTable, ({ many }) => ({
  productsMedias: many(ProductMediaTable),
  productsVisits: many(VisitProductTable),
  productsCategories: many(ProductCategoryTable),
}));

export const ItemCategoryTable = mysqlTable("item_categories", {
  id: int("id").primaryKey().autoincrement().notNull(),
  name: varchar("name", { length: 256 }).notNull(),
  disabled: tinyint("disabled").default(0).notNull(),
});

export const ItemCategoryTableRelations = relations(
  ItemCategoryTable,
  ({ many }) => ({
    productsCategories: many(ProductCategoryTable),
  }),
);

export const ProductCategoryTable = mysqlTable(
  "products_categories",
  {
    id: int("id").primaryKey().autoincrement().notNull(),
    productId: int("productId")
      .notNull()
      .references(() => ProductTable.id, {
        onDelete: "restrict",
        onUpdate: "cascade",
      }),
    categoryId: int("categoryId")
      .notNull()
      .references(() => ItemCategoryTable.id, {
        onDelete: "restrict",
        onUpdate: "cascade",
      }),
  },
  (table) => {
    return {
      productIdIdx: index("productId_idx").on(table.productId),
      categoryIdIdx: index("categoryId_idx").on(table.categoryId),
    };
  },
);

export const ProductCategoryTableRelations = relations(
  ProductCategoryTable,
  ({ one }) => ({
    product: one(ProductTable, {
      fields: [ProductCategoryTable.productId],
      references: [ProductTable.id],
    }),
    itemCategory: one(ItemCategoryTable, {
      fields: [ProductCategoryTable.categoryId],
      references: [ItemCategoryTable.id],
    }),
  }),
);

However, when I open the ProductCategoryTable on Drizzle Studio, I only see the relation to the products and not to the categories:

Also, the ItemCategoryTable does not show relation to ProductCategoryTable as shown here:

I already other many to many relations without any issue, but this one and some other just wont work

Expected behavior

I expect the relations to be shown in Drizzle Studio just like in the TS code

Environment & setup

I'm using Node 18.19.1

[RomanNabukhotnyi]

@TheGrinch00 Hey! Try updating drizzle-kit to the latest version

[TheGrinch00]

@RomanNabukhotnyi I updated it to version 0.21.1 and now it gave me some errors that, with previous versions, went unspotted.

After solving all the errors I can confirm that now all my relations are correctly picked up and shown in Drizzle Studio, thanks!