5 replies

Cannot read properties of undefined (reading '0')

What is the expected behavior when using

get()

get()

when there would be no matching results for a given select query? Does it return

null

null

or would this be an error? At present it's giving an error. I'm new to discord, but I guess I expected it to return a

null

null

. For example, the following query works and returns an empty array:

db.select().from(users).where(eq(users.email, email)).all();

db.select().from(users).where(eq(users.email, email)).all();

whereas changing

all()

all()

get()

get()

results in error trying to access first element of an empty array (

drizzle-orm/utils.js:40:37

drizzle-orm/utils.js:40:37

db.select().from(users).where(eq(users.email, email)).get();

db.select().from(users).where(eq(users.email, email)).get();