View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004311 | SymmetricDS | Bug | public | 2020-03-12 16:20 | 2020-03-17 18:43 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.6 | ||||
| Target Version | 3.11.7 | Fixed in Version | 3.11.7 | ||
| Summary | 0004311: DataExtractorService: Stream row query with null values does not deal with the null values correctly | ||||
| Description | When 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 Reproduce | 1. 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. | ||||
| Tags | extract | ||||
|
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 | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-03-12 16:20 | pmarzullo | New Issue | |
| 2020-03-12 16:20 | pmarzullo | Status | new => assigned |
| 2020-03-12 16:20 | pmarzullo | Assigned To | => pmarzullo |
| 2020-03-12 16:20 | pmarzullo | Tag Attached: extract | |
| 2020-03-12 17:32 | pmarzullo | Status | assigned => resolved |
| 2020-03-12 17:32 | pmarzullo | Resolution | open => fixed |
| 2020-03-12 17:32 | pmarzullo | Fixed in Version | => 3.11.7 |
| 2020-03-12 18:00 | Changeset attached | => SymmetricDS 3.11 bffef0e7 | |
| 2020-03-17 18:43 | admin | Status | resolved => closed |