Talend 4.2.3 taddCRCrow same CRC value for 2 different data set

[Anonymous]

Hi,
We are currently encountering some issues with the taddCRCrow component.
The component is configured to calculate the CRC value based on 2 fields : ID_SHOP and ID_PRODUCT (screenshot 1).
But with several values like in the example (screenshot 2) it generates the same CRC value for 2 different combination of id_shop and id_product.
Do you have any explanation for this problem ?
Regards

[Anonymous]

Hi,
We have seen this jira issue: https://jira.talendforge.org/browse/TDI-35136 and will keep you posted.
Best regards
Sabrina

[Anonymous]

I know, it's mine. . . but i'm a little bit disappointed. . . no solution because it's normal. . .
i only works on 24 millions adresses so 24 millions different CRC.
I calculate 1.6 millions CRC and compare it to the existing values to know if it is a insert or an update.
4374 CRC are found but they are not the same!
i can take some other examples. Do you think 4300 is little?

[Anonymous]

new Datas to inject
NULL 1010 rue de la pomme NULL 1010 Commune1010 NULL 532135616
NULL 2376 rue de la pomme NULL 2376 Commune2376 NULL 2259114405
NULL 3498 rue de la pomme NULL 3498 Commune3498 NULL 278186796
NULL 3638 rue de la pomme NULL 3638 Commune3638 NULL 1579150529
NULL 3648 rue de la pomme NULL 3648 Commune3648 NULL 1937392661
NULL 3654 rue de la pomme NULL 3654 Commune3654 NULL 2640442085
NULL 3814 rue de la pomme NULL 3814 Commune3814 NULL 1014668805
NULL 3892 rue de la pomme NULL 3892 Commune3892 NULL 4218793342
NULL 4640 rue de la pomme NULL 4640 Commune4640 NULL 3040598754
NULL 5196 rue de la pomme NULL 5196 Commune5196 NULL 2352608391
Existing dtas
7 Rue PELISSIER 63000 CLERMONT-FERRAND FR 532135616
18 RUE DES CITES 70250 RONCHAMP FR 2259114405
924 CHEMIN DE PEYROT 31620 BOULOC FRANCE 278186796
25 rue st pierre 57935 LUTTANGE FRANCE 1579150529

Result when i calculate the CRC
.-----------+--------------------+---------------+-----------+----------------+------+----------.
|                                           tLogRow_4                                           |
|=----------+--------------------+---------------+-----------+----------------+------+---------=|
|NUMERO_VOIE|ADRESSE_LIGNE_1     |ADRESSE_LIGNE_2|CODE_POSTAL|COMMUNE         |PAYS  |CRC       |
|=----------+--------------------+---------------+-----------+----------------+------+---------=|
|null       |1010 rue de la pomme|null           |1010       |Commune1010     |null  |532135616 |
|7          |Rue PELISSIER       |null           |63000      |CLERMONT-FERRAND|null  |532135616 |
|null       |3498 rue de la pomme|null           |3498       |Commune3498     |null  |278186796 |
|924        |CHEMIN DE PEYROT    |null           |31620      |BOULOC          |FRANCE|278186796 |
|null       |3638 rue de la pomme|null           |3638       |Commune3638     |null  |1579150529|
|25         |rue st pierre       |null           |57935      |LUTTANGE        |FRANCE|1579150529|
'-----------+--------------------+---------------+-----------+----------------+------+----------'

[Anonymous]

Hi,
Our component developer has updated this jira issue: https://jira.talendforge.org/browse/TDI-35136, could you please take a look at it?
Feel free to add your comment in this jira issue.
Best regards
Sabrina