View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006214 | SymmetricDS | Bug | public | 2024-01-29 19:46 | 2024-02-15 20:28 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.3 | Fixed in Version | 3.15.3 | ||
| Summary | 0006214: SQLite sync error on sym_table_reload_request when db.treat.date.time.as.varchar.enabled | ||||
| Description | If db.treat.date.time.as.varchar.enabled is set to true for SQLite, it will load timestamps using the format and precision from the remote node. An error will happen if the format is not yyyy-MM-dd HH:mm:ss.SSS for SYM tables that have a timestamp in their primary key, like sym_table_reload_request. The database is actually storing the timestamp as a varchar data type. The code reads in the varchar and converts it into a java.util.Date for the model object. The SQL template for SQLite expects to convert a Date into a String with format of yyyy-MM-dd HH:mm:ss.SSS. The String may not match exactly. | ||||
| Tags | dialect: sqlite | ||||
|
SymmetricDS: 3.15 58449606 2024-01-29 19:49:11 Details Diff |
0006214: SQLite sync error on sym_table_reload_request when db.treat.date.time.as.varchar.enabled |
Affected Issues 0006214 |
|
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java | Diff File | ||
|
SymmetricDS: 3.15 c7752c6a 2024-01-30 14:29:12 Details Diff |
0006214: SQLite sync error on sym_table_reload_request when db.treat.date.time.as.varchar.enabled |
Affected Issues 0006214 |
|
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/IoConstants.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-01-29 19:46 | elong | New Issue | |
| 2024-01-29 19:46 | elong | Status | new => assigned |
| 2024-01-29 19:46 | elong | Assigned To | => elong |
| 2024-01-29 19:46 | elong | Tag Attached: dialect: sqlite | |
| 2024-01-29 19:49 | elong | Status | assigned => resolved |
| 2024-01-29 19:49 | elong | Resolution | open => fixed |
| 2024-01-29 19:49 | elong | Fixed in Version | => 3.15.3 |
| 2024-02-05 18:58 | admin | Status | resolved => closed |
| 2024-02-15 20:28 | admin | Changeset attached | => SymmetricDS 3.15 c7752c6a |
| 2024-02-15 20:28 | admin | Changeset attached | => SymmetricDS 3.15 58449606 |