View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004947 | SymmetricDS | Bug | public | 2021-04-12 22:48 | 2021-04-28 19:10 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.0 | ||||
| Target Version | 3.12.9 | Fixed in Version | 3.12.9 | ||
| Summary | 0004947: Sybase ASE null byte with data type of TIME | ||||
| Description | On Sybase ASE database, a column of type of TIME results in a null byte in the capture log. The column template uses convert(x, 102) like it would for a datetime column to get the YYYY-MM-DD part of the date, but for a time column it gets a null byte. Normally, a null value concatenated with a string would result in null, but this is actually a null byte embedded in a string. It's hard to see the null byte, but if you try to copy-paste the value from the capture log into a text file, it will only copy the string before the null byte. | ||||
| Tags | dialect: sybase | ||||
|
SymmetricDS: 3.12 e575de60 2021-04-13 12:18:08 Details Diff |
0004947: Sybase ASE null byte with data type of TIME |
Affected Issues 0004947 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/ase/AseTriggerTemplate.java | Diff File | ||
|
SymmetricDS: 3.9 ab5883d5 2021-04-28 13:20:51 Details Diff |
0004947: Sybase ASE null byte with data type of TIME |
Affected Issues 0004947 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/ase/AseTriggerTemplate.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-04-12 22:48 | elong | New Issue | |
| 2021-04-12 22:48 | elong | Status | new => assigned |
| 2021-04-12 22:48 | elong | Assigned To | => elong |
| 2021-04-12 22:48 | elong | Tag Attached: dialect: sybase | |
| 2021-04-13 12:18 | elong | Status | assigned => resolved |
| 2021-04-13 12:18 | elong | Resolution | open => fixed |
| 2021-04-13 12:18 | elong | Fixed in Version | => 3.12.9 |
| 2021-04-13 13:00 | admin | Changeset attached | => SymmetricDS 3.12 e575de60 |
| 2021-04-28 11:44 | pmarzullo | Note Added: 0001928 | |
| 2021-04-28 14:00 | pmarzullo | Changeset attached | => SymmetricDS 3.9 ab5883d5 |
| 2021-04-28 19:10 | admin | Status | resolved => closed |