upsert generates some SQL with a buggy returning clause #4382

BrannJoly · 2023-05-23T13:52:17Z

BrannJoly
May 23, 2023

I have a dbEntity with a ManyToMany relationship defined :

@Entity({ tableName: 'projects' })
 {
  @PrimaryKey()
  id: string = uuidv4();

  @Property()
  name: string;

  @ManyToMany(() => UserGroupDbEntity, (group) => group.projects)
  userGroups = new Collection<UserGroupDbEntity>(this);
}

And this is UserGroupDbEntity:

@entity({ tableName: 'user_groups' })
{
export class UserGroupDbEntity extends UserEditableDbEntity {
@manytomany(() => UserDbEntity, (user) => user.userGroups, { owner: true })
users = new Collection(this);

@manytomany(() => ProjectDbEntity, (project) => project.userGroups, { owner: true })
projects = new Collection(this);
}

When trying to insert a new project in the database with upsert, mikroorm adds an erroneous returning clause for userGroups in the sql it executes eg.

insert into "public"."projects" 
( "id", "name") 
values ('02fa9e98-9634-4bb7-be16-6f5afe82b58b', 'test ' ) 
on conflict ("id") 
do update set "name" = excluded."name"
returning "userGroups"

Of course this fails with an error because "column "userGroups" does not exist"

I've made sure that my db schema is up to date using mikro-orm migration:create

What could be causing such an issue ?

Thank you
Brann