View Issue Details

IDProjectCategoryView StatusLast Update
0004311SymmetricDSBugpublic2020-03-17 14:43
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.11.6 
Target Version3.11.7Fixed in Version3.11.7 
Summary0004311: DataExtractorService: Stream row query with null values does not deal with the null values correctly
DescriptionWhen a data capture is configured with stream row, and the Sync Key Names entry is configured with nullable columns, and a null value is specified during data capture, the query that is generated to extract the data adds " and nullablecolumn = '' " instead of " and nullablecolumn is null ".
Steps To Reproduce1. Define a trigger for a table without a primary key using Stream Row.
2. Configure trigger to specify Sync Key Names using columns that are nullable.
3. Insert a record, and specify a null value for one of the Sync Key Names columns.
4. Record will not be sent to target.
Tagsextract

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.11 bffef0e7

2020-03-12 13:32:17

Philip Marzullo

Details Diff
0004311: DataExtractorService: Stream row query with null values does
not deal with the null values correctly
Affected Issues
0004311
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File

Issue History

Date Modified Username Field Change
2020-03-12 12:20 pmarzullo New Issue
2020-03-12 12:20 pmarzullo Status new => assigned
2020-03-12 12:20 pmarzullo Assigned To => pmarzullo
2020-03-12 12:20 pmarzullo Tag Attached: extract
2020-03-12 13:32 pmarzullo Status assigned => resolved
2020-03-12 13:32 pmarzullo Resolution open => fixed
2020-03-12 13:32 pmarzullo Fixed in Version => 3.11.7
2020-03-12 14:00 Changeset attached => SymmetricDS 3.11 bffef0e7
2020-03-17 14:43 admin Status resolved => closed