Anomalie #16406
Mis à jour par Ludovic ARAUJO il y a environ 3 ans
Lors de la migration les documents principal sont dupliqué.
En effet, les document principale que l'on trouve dans res_letterbox se trouvent doublé dans res_attachments :
Fingerprint de référence : 877e045a3e996f874f7a23b0026d8348c201c7cd6dc909564c1e2527df3ee8e9142a798e69a1195e50773516eedc447a4847e8466be90a129346ab65f01ff5e1
res_letterbox:
~~~sql
select res_id,filename from res_attachments res_letterbox where fingerprint = '877e045a3e996f874f7a23b0026d8348c201c7cd6dc909564c1e2527df3ee8e9142a798e69a1195e50773516eedc447a4847e8466be90a129346ab65f01ff5e1'
res_id|filename |
------|--------------------|
2613|0303_1661759406.docx|
~~~
res_attachments :
~~~sql
select res_id,filename from res_letterbox where fingerprint = '877e045a3e996f874f7a23b0026d8348c201c7cd6dc909564c1e2527df3ee8e9142a798e69a1195e50773516eedc447a4847e8466be90a129346ab65f01ff5e1'
res_id|filename |
------|-------------------|
3768|0304_478338975.docx|
~~~
En effet, les document principale que l'on trouve dans res_letterbox se trouvent doublé dans res_attachments :
Fingerprint de référence : 877e045a3e996f874f7a23b0026d8348c201c7cd6dc909564c1e2527df3ee8e9142a798e69a1195e50773516eedc447a4847e8466be90a129346ab65f01ff5e1
res_letterbox:
~~~sql
select res_id,filename from res_attachments res_letterbox where fingerprint = '877e045a3e996f874f7a23b0026d8348c201c7cd6dc909564c1e2527df3ee8e9142a798e69a1195e50773516eedc447a4847e8466be90a129346ab65f01ff5e1'
res_id|filename |
------|--------------------|
2613|0303_1661759406.docx|
~~~
res_attachments :
~~~sql
select res_id,filename from res_letterbox where fingerprint = '877e045a3e996f874f7a23b0026d8348c201c7cd6dc909564c1e2527df3ee8e9142a798e69a1195e50773516eedc447a4847e8466be90a129346ab65f01ff5e1'
res_id|filename |
------|-------------------|
3768|0304_478338975.docx|
~~~