[15.0][mail]Duplicated entry in update mail_group_moderation_rel

[dansanti]

If 2 mail channels haves the same moderator, and when is migrated to mail_group, the group id could by the same of channel, then when update is performed , could cause unique constraint error

Module

mail

Describe the bug

current 14.0 table mail_channel_moderator_rel:
mail_channel_id, res_users_id
7, 2
1, 2

when migration is performed , may create mail_channel 7 with mail_group id 1, then the table will be renamed to mail_group_moderator_rel and mail_channel_id will be renamed to mail_group_id, so, in the SQL update mail_group_id 7 will be updated according old channel_id 1 . This cause unique error, because already exists that tuple 1, 2 ( not update yet)

here the update line:

OpenUpgrade/openupgrade_scripts/scripts/mail/15.0.1.5/pre-migration.py

Line 231 in 9af4744

openupgrade.logged_query(

[pedrobaeza]

Please propose a patch to fix this.