View Issue Details

IDProjectCategoryView StatusLast Update
0006170SymmetricDSBugpublic2024-04-19 15:46
Reporterjvanmeter Assigned Tojvanmeter  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.0 
Target Version3.15.4Fixed in Version3.15.4 
Summary0006170: DB Compare incorrectly comparing values
DescriptionDB Compare is incorrectly comparing Uni type values with their non-unitype counterpart when using JTDS. The JTDS Driver handles how the data is read in from the database differently compared to the JDBC Driver, which is causing the comparisons to be handled incorrectly. Characters such as 軽 are read in as 8efd with the JDBC Driver which is the correct utf-16 interpretation, however using the JTDS Driver, these are read in as 3f which is ?. This is making the conversion from utf-16 to utf-8 inconsistent, resulting in incorrect comparisons using DB Compare.
Tagsdbcompare, dialect: sybase

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 3607838c

2024-02-16 18:32:55

jakobvanmeter

Details Diff
0006170: DB Compare incorrectly comparing values Affected Issues
0006170
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/DbCompare.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/DbCompareDiffWriter.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/DbValueComparator.java Diff File

SymmetricDS: 3.15 76693881

2024-02-22 16:39:40

jakobvanmeter

Details Diff
0006170: DB Compare incorrectly comparing values Affected Issues
0006170
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/DbCompare.java Diff File

SymmetricDS: 3.15 b7e8649c

2024-02-27 15:34:01

jakobvanmeter

Details Diff
0006170: DB Compare incorrectly comparing values Affected Issues
0006170
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/DbCompare.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/DbCompareDiffWriter.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/DbValueComparator.java Diff File

Issue History

Date Modified Username Field Change
2024-01-02 15:41 jvanmeter New Issue
2024-01-02 15:41 jvanmeter Status new => assigned
2024-01-02 15:41 jvanmeter Assigned To => jvanmeter
2024-01-02 15:41 jvanmeter Tag Attached: dbcompare
2024-01-02 15:41 jvanmeter Tag Attached: dialect: sybase
2024-02-01 15:31 jvanmeter Priority low => normal
2024-02-01 15:31 jvanmeter Target Version 3.15.3 => 3.15.4
2024-02-16 18:33 jvanmeter Status assigned => resolved
2024-02-16 18:33 jvanmeter Resolution open => fixed
2024-02-16 18:33 jvanmeter Fixed in Version => 3.15.4
2024-03-19 16:20 admin Status resolved => closed
2024-04-19 15:46 Changeset attached => SymmetricDS 3.15 b7e8649c
2024-04-19 15:46 Changeset attached => SymmetricDS 3.15 76693881
2024-04-19 15:46 Changeset attached => SymmetricDS 3.15 3607838c