comparison using 7 columns

Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: comparison using 7 columns

Post by dzhanhira » Thu 11 Feb 2021 18:29

Our assumptions were not confirmed. The problem does not arise when generating a unique index. The metadata on your server is correct, as shown by the results of scripts executed on your server. Comparison options do not affect the comparison result, this was shown by the * .dcom file you sent, which differs from "our" options in IgnoreSerialColumns and IsIgnoreTime. Because There are no serial and datetime columns in the source and target tables, these differences in options do not affect anything.

Probably the problem is that you have collate cp273.UTF-8 set for your database, which affects the result of ORDER BY in the SPT-2609 Select source table.sql and SPT-2609 Select target table.sql scripts that are used by Data Compare in the comparison process data. It is known that on the databases on which we tried to reproduce the collate en_US.utf8 problem.

To verify that the problem is in collate cp273.UTF-8, we want to ask to execute two scripts SPT-2609 Select source table.sql and SPT-2609 Select target table.sql and send the results of their execution.

Scripts are available via https://drive.google.com/drive/folders/ ... sp=sharing

talalhallaj
Posts: 10
Joined: Tue 08 Dec 2020 06:52
Location: Hamburg
Contact:

Re: comparison using 7 columns

Post by talalhallaj » Fri 12 Feb 2021 10:11

SPT-2609 Select source table.sql
"f235_cg";"f235_ci";"f235_ch";"svs_schluesselart";"svs_mandant";"svs_gueltig_von";"svs_gueltig_bis";"svs_text";"svs_sprache"
"ZQZ-KARL-ART-STRG ";"0020";"1 ";"C";"01";"19000101";"29991231";"Txt-Sarlehen ";"D"
"ZQZ-KARL-ART-STRG ";"0020";"2 ";"C";"01";"19000101";"29991231";"Bakward-Sarlehen ";"D"

SPT-2609 Select target table.sql
"f235_cg";"f235_ci";"f235_ch";"svs_schluesselart";"svs_mandant";"svs_gueltig_von";"svs_gueltig_bis";"svs_text";"svs_sprache"
"ZQZ-KARL-ART-STRG ";"0020";"L ";"C";"01";"20200304";"29991231";"Texte Freiheit ";"D"
"ZQZ-KARL-ART-STRG ";"0020";"1 ";"C";"01";"19000101";"29991231";"Txt-Sarlehen ";"D"
"ZQZ-KARL-ART-STRG ";"0020";"2 ";"C";"01";"19000101";"29991231";"Bakward-Sarlehen ";"D"

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: comparison using 7 columns

Post by dzhanhira » Wed 17 Feb 2021 06:11

Thank you. We will investigate it.

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: comparison using 7 columns

Post by dzhanhira » Wed 10 Mar 2021 07:10

We have localized the problem, it is associated with the use of a specific collation: cp273.UTF-8. Using more standard collation options does not reproduce the problem. We will investigate this behavior and fix it in one of the next releases,

Post Reply