1 reply

Shifted properties in join

I'm getting some very strange join behavior. This query:

  const foreignExchangeTransactions = await db
    .select()
    .from(transactions)
    .innerJoin(inboxes, eq(transactions.inboxId, inboxes.id))

  const foreignExchangeTransactions = await db
    .select()
    .from(transactions)
    .innerJoin(inboxes, eq(transactions.inboxId, inboxes.id))

Returns a proper transaction, but the

inboxes

inboxes

object is completely out of whack, missing some properties but also a lot of the properties are shifted:

inboxes: {
    id: 'ayrmg4fy63',
    createdAt: 'Budget',
    cuid: 'CAD',
    name: 'America/Toronto',
    currencyCode: 1
  }

inboxes: {
    id: 'ayrmg4fy63',
    createdAt: 'Budget',
    cuid: 'CAD',
    name: 'America/Toronto',
    currencyCode: 1
  }

It should be:

`
id: 1,
createdAt: '2024-01-09',
name: 'Budget',
cuid: 'ayrmg4fy63',
timezone: 'America/Toronto',
currencyCode: 'CAD'

`
id: 1,
createdAt: '2024-01-09',
name: 'Budget',
cuid: 'ayrmg4fy63',
timezone: 'America/Toronto',
currencyCode: 'CAD'

Tried with one other table and same result as well, weird shifted properties in the joiend table