DT
Drizzle Teamhachoter

Maximum call stack exceeded with relation to self

I have the following table 
export const category = pgTable('categories', {
    id: serial('id').primaryKey().notNull(),
    parentCategoryId: integer('parent_category_id').references((): AnyPgColumn => category.id)
});

// relation
export const categoryRelations = relations(category, ({ many, one }) => ({
    categories: many(category),
    parentCategory: one(category, {
        fields: [category.parentCategoryId],
        references: [category.id]
    })
}));
export const category = pgTable('categories', {
    id: serial('id').primaryKey().notNull(),
    parentCategoryId: integer('parent_category_id').references((): AnyPgColumn => category.id)
});

// relation
export const categoryRelations = relations(category, ({ many, one }) => ({
    categories: many(category),
    parentCategory: one(category, {
        fields: [category.parentCategoryId],
        references: [category.id]
    })
}));
I am running the following query 
db.select().from(category).where(isNull(category.parentCategoryId));
db.select().from(category).where(isNull(category.parentCategoryId));
and I am getting a maximum call stack exceeded error, here is the full log 
Maximum call stack size exceeded
RangeError: Maximum call stack size exceeded
    at file:///Users/john/Desktop/project/node_modules/.pnpm/drizzle-orm@0.26.1_postgres@3.3.4/node_modules/drizzle-orm/relations-c9e54a8f.mjs:517:17
    at Array.map (<anonymous>)
    at SQL.buildQueryFromSourceParams (file:///Users/john/Desktop/project/node_modules/.pnpm/drizzle-orm@0.26.1_postgres@3.3.4/node_modules/drizzle-orm/relations-c9e54a8f.mjs:515:36)
    at file:///Users/john/Desktop/project/node_modules/.pnpm/drizzle-orm@0.26.1_postgres@3.3.4/node_modules/drizzle-orm/relations-c9e54a8f.mjs:594:29
    at Array.map (<anonymous>)
    at SQL.buildQueryFromSourceParams (file:///Users/john/Desktop/project/node_modules/.pnpm/drizzle-orm@0.26.1_postgres@3.3.4/node_modules/drizzle-orm/relations-c9e54a8f.mjs:515:36)
    at file:///Users/john/Desktop/project/node_modules/.pnpm/drizzle-orm@0.26.1_postgres@3.3.4/node_modules/drizzle-orm/relations-c9e54a8f.mjs:594:29
    at Array.map (<anonymous>)
    at SQL.buildQueryFromSourceParams (file:///Users/john/Desktop/project/node_modules/.pnpm/drizzle-orm@0.26.1_postgres@3.3.4/node_modules/drizzle-orm/relations-c9e54a8f.mjs:515:36)
    at file:///Users/john/Desktop/project/node_modules/.pnpm/drizzle-orm@0.26.1_postgres@3.3.4/node_modules/drizzle-orm/relations-c9e54a8f.mjs:594:29
Maximum call stack size exceeded
RangeError: Maximum call stack size exceeded
    at file:///Users/john/Desktop/project/node_modules/.pnpm/drizzle-orm@0.26.1_postgres@3.3.4/node_modules/drizzle-orm/relations-c9e54a8f.mjs:517:17
    at Array.map (<anonymous>)
    at SQL.buildQueryFromSourceParams (file:///Users/john/Desktop/project/node_modules/.pnpm/drizzle-orm@0.26.1_postgres@3.3.4/node_modules/drizzle-orm/relations-c9e54a8f.mjs:515:36)
    at file:///Users/john/Desktop/project/node_modules/.pnpm/drizzle-orm@0.26.1_postgres@3.3.4/node_modules/drizzle-orm/relations-c9e54a8f.mjs:594:29
    at Array.map (<anonymous>)
    at SQL.buildQueryFromSourceParams (file:///Users/john/Desktop/project/node_modules/.pnpm/drizzle-orm@0.26.1_postgres@3.3.4/node_modules/drizzle-orm/relations-c9e54a8f.mjs:515:36)
    at file:///Users/john/Desktop/project/node_modules/.pnpm/drizzle-orm@0.26.1_postgres@3.3.4/node_modules/drizzle-orm/relations-c9e54a8f.mjs:594:29
    at Array.map (<anonymous>)
    at SQL.buildQueryFromSourceParams (file:///Users/john/Desktop/project/node_modules/.pnpm/drizzle-orm@0.26.1_postgres@3.3.4/node_modules/drizzle-orm/relations-c9e54a8f.mjs:515:36)
    at file:///Users/john/Desktop/project/node_modules/.pnpm/drizzle-orm@0.26.1_postgres@3.3.4/node_modules/drizzle-orm/relations-c9e54a8f.mjs:594:29
hachoter
hachoter•355d ago
I removed the relation and it's still not working, when I remove the where it is working
Siris
Siris•355d ago
are you in a monorepo? see #maximum call stack exceeded
Want results from more Discord servers?
Add your server
More Posts
importing into schema.ts fileHi, I am using turborepo and I have defined my schema in `packages/schema/user.ts` and in my main AWhat versions of MySQL are supported? I have JSON_ARRAYAGG issues with 5.7 and AWS Aurora ServerlessCan you confirm what versions of MySQL you intend on supporting? Relational queries with joins use J`$with` example in docs error "unsupported: with expression in select statement"I have a user with id of 42, just like the docs https://orm.drizzle.team/docs/crud#with-clause but Infer type for relational queryIs there anyway to infer the type of a relational queries result? For example if I have a user who in drizzle.config.ts: "Cannot use import statement outside a module"happens when I try to `push` ```ts import type { Config } from "drizzle-kit"; import { env } from "Error when using Drizzle (Non-abstract class 'PgSelect<TTableName, TSelection, TSelectMode, [...])I'm getting the following error when I try to use Drizzle: ```> graphql-server@1.0.0 start > npm runGenerate classes/interfaces from existing schemas?Messing around with drizzle, and I was wondering if there was any way to generate a class or interfaRelation Query - Get likes in postPlaying around with relational queries and I'm not quite getting how I'd retrieve the count of likes