Drizzle TeamDT
Drizzle Team•2y ago
Gabriel

left join make the types never

Hi guys, im now sure if this is the expected behavior or not but i have this query 

    const reminders = await db.select({
      reminderId: reminderTable.id,
    })
      .from(reminderTable);

where the type of reminders is 
const reminders: {
    reminderId: number;
}[]

so that is ok but when i add a left join all the types are never 
    const reminders = await db.select({
      reminderId: reminderTable.id,
    })
      .from(reminderTable)
      .leftJoin(sentReminderTable, eq(reminderTable.id, sentReminderTable.reminderId));

this is the left join and now the types are
{
    reminderId: never;
}[]

I'm not sure why is never i was expecting something like 
  {
    reminderId: number | null;
}[]

Im doing something wrong or it is correct this way?

Im using
"drizzle-orm": "^0.29.2"
Thanks so much in advance for the time
Was this page helpful?