Missing from clause entry in version 8.3.1

[Alsdrouf]

Missing from clause entry in version 8.3.1

[vsamofal]

@Alsdrouf

I will take a look; looks like something with loadEagerRelations

if you can create a test case that fails it will help a lot, or at least share more details like entities

[Alsdrouf]

it('should work', async () => {
    const config: PaginateConfig<CatToyEntity> = {
        sortableColumns: ['id'],
        where: {cat: {name: cats[0].name}}
    }
    const query: PaginateQuery = {
        path: '',
    }

    const result = await paginate<CatToyEntity>(query, catToyRepo, config)

    expect(result.data.length).toStrictEqual(3)
})

Found it

Error is when where contain a not loaded relations

Exemple that really work

it('should work', async () => {
    const config: PaginateConfig<CatToyEntity> = {
        relations: ['cat']
        sortableColumns: ['id'],
        where: {cat: {name: cats[0].name}}
    }
    const query: PaginateQuery = {
        path: '',
    }

    const result = await paginate<CatToyEntity>(query, catToyRepo, config)

    expect(result.data.length).toStrictEqual(3)
})

@vsamofal

[vsamofal]

#770 fix is ready

[Alsdrouf]

Fleet entity

@Entity()
export class Fleet implements IFleet {
  @PrimaryGeneratedColumn('uuid')
  readonly id: string;

  @Column('varchar', { length: 255 })
  name: string;

  @Column('varchar', { length: 7 })
  color: string;

  @Column('int', { default: 0 })
  caution: number;

  @Column('jsonb', { nullable: true, default: null })
  geoJson: any;

  @ManyToOne(() => Operator, (operator) => operator.fleets)
  readonly operator?: Operator

  @CreateDateColumn()
  readonly createdAt: Date;

  @UpdateDateColumn()
  readonly updatedAt: Date;

  @DeleteDateColumn()
  readonly deletedAt: Date | null;
}

Operator entity

@Entity()
export class Operator {
  @PrimaryGeneratedColumn('uuid')
  readonly id: string;

  @Column('varchar', { length: 128, unique: true })
  name: string;

  @Column('varchar', { length: 128 })
  logoUrl: string;

  @Column('jsonb')
  theme: any;

  @Column('varchar', {
    length: 1024,
    nullable: true,
    transformer: {
      from: (value: string) => (value && value.length > 0 ? value.split(',') : null),
      to: (value: string[]) => (value && value.length > 0 ? value.join(',') : null),
    },
  })
  mailingList: string[];

  @OneToMany(() => Fleet, (fleet) => fleet.operator)
  readonly fleets?: Fleet[];

  @CreateDateColumn()
  readonly createdAt: Date;

  @UpdateDateColumn()
  readonly updatedAt: Date;

  @DeleteDateColumn()
  readonly deletedAt: Date | null;
}

It's really simplified entity, note that I am using postgres

I am not using any eager relation in all my entity

[Alsdrouf]

I will try to write a test