`findMany` returns an empty array if the number of rows is +500 approx.

Hi, Could someone tell me why the following query works if I have less than 500 nodes in the DB, but fails otherwise?

await this.db.query.nodes.findMany({
  where: eq(nodes.docId, docId),
});

await this.db.query.nodes.findMany({
  where: eq(nodes.docId, docId),
});

I tried limit: 100000; and nothing changed. Is there some kind of timeout?

3 Replies

clarification: the query does not "fail" in the sense that it gives an error, but rather it returns an empty array

TOSL•5d ago

Pretty sure this is not a Drizzle limitation. Got to be some limitation imposed by db/db provider. I'd look into that.

Beck•3d ago

Did you try to run raw SQL query that drizzle generates for you in debug mode? What your db returns if you run that (raw) query?