Searching by referenced entity ID doesn't work

[alpharder]

Hello there,

Account has many LedgerRecords
LedgerRecord has one Account

Prerequisites

@Entity({ tableName: 'accounts' })
export class Accounts {
  @PrimaryKey()
  id!: number;

  @OneToMany({ entity: () => LedgerRecords, mappedBy: lr => lr.account })
  ledgerRecords = new Collection<LedgerRecords>(this);
}

@Entity({ tableName: 'ledger_records' })
export class LedgerRecords {

  @PrimaryKey()
  id!: number;

  @ManyToOne({
    entity: () => Accounts,
    inversedBy: acc => acc.ledgerRecords,
    cascade: [Cascade.MERGE],
    fieldName: 'account_id',
  })
  account!: Accounts;
}

I did this type of call:

accountsRepo.findOne({
      ledgerRecords: {
        id: 18,
      }
});

Actual behavior:

select "e0".* from "accounts" as "e0" where "undefined"."id" = 18 limit 1 

Expected behavior

 select "e0".* from "accounts" as "e0" left join "ledger_records" as "e1" on "e0"."id" = "e1"."account_id" where "e1"."id" = 18 limit 1 

Additional details

• Using any other field of LedgerRecords does the job correctly (i.e. not the "id" field)
• Filtering using nested relationship fields does the job correctly (i.e. using this approach: https://mikro-orm.io/docs/entity-manager#searching-by-referenced-entity-fields)

Environment

node -v
v12.18.0

@mikro-orm/core @ 4.0.5
@mikro-orm/nestjs @ 4.0.0
@mikro-orm/postgresql @ 4.0.5
typescript @ 3.9.7

Workaround

accountsRepo.findOne({
      ledgerRecords: {
        $and: [
          { id: { $eq: 18 } },
          { id: { $ne: null } }
        ]
      }
    })

Thank you for the great library, have a good day!

[alpharder]

@B4nan thanks, you're awesome!