Relational with return an error

[shishamo]

After pulling the schema with introspect, I am trying to use relation with in the query as below

const results = await db.query.table1.findFirst({
    with: {
      table2: true,
    },
});

But i am the error message as following, does anyone has an idea of why?

file:///usr/src/app/node_modules/drizzle-orm/relations.js:212
const referencedTableTsName = tableNamesMap[relation.referencedTable[Table.Symbol.Name]];
^

TypeError: Cannot read properties of undefined (reading 'referencedTable')
at normalizeRelation (file:///usr/src/app/node_modules/drizzle-orm/relations.js:212:56)
at PgDialect.buildRelationalQueryWithoutPK (file:///usr/src/app/node_modules/drizzle-orm/pg-core/dialect.js:972:36)
at QueryPromise._getQuery (file:///usr/src/app/node_modules/drizzle-orm/pg-core/query-builders/query.js:84:25)
at QueryPromise._toSQL (file:///usr/src/app/node_modules/drizzle-orm/pg-core/query-builders/query.js:99:24)
at file:///usr/src/app/node_modules/drizzle-orm/pg-core/query-builders/query.js:62:42
at Object.startActiveSpan (file:///usr/src/app/node_modules/drizzle-orm/tracing.js:8:14)
at QueryPromise._prepare (file:///usr/src/app/node_modules/drizzle-orm/pg-core/query-builders/query.js:61:19)
at file:///usr/src/app/node_modules/drizzle-orm/pg-core/query-builders/query.js:108:19
at Object.startActiveSpan (file:///usr/src/app/node_modules/drizzle-orm/tracing.js:8:14)
at QueryPromise.execute (file:///usr/src/app/node_modules/drizzle-orm/pg-core/query-builders/query.js:107:19)

[DawidRubch]

Struggiling with the same thing....

[DawidRubch]

@shishamo I've figured it out, you need to have the relations in the same file as your schema, or import it there.

[shishamo]

thanks~

[Disorrder]

Thanks, and also relation should be included into initial function too. I used to have them in different files, so import * as schema didn't work for me.
Like this:

export const schema = {
  companies,
  users,
  clients,
  products,
  orders,
  orderProducts,
  ordersRelations,
  orderProductsRelations,
} as const;
const queryClient = postgres(connectionString);
return drizzle(queryClient, { schema });

[sk-shoyeb-01]

It worked for me thanks.