View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004676 | SymmetricDS | Bug | public | 2020-12-02 20:52 | 2021-01-11 13:47 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.5 | ||||
| Target Version | 3.12.6 | Fixed in Version | 3.12.6 | ||
| Summary | 0004676: Insert into sym_data replaces current_timestamp string with question mark to allow specified timestamp but fails sometimes | ||||
| Description | But, not all platforms/dialects use current_timestamp for the string. In the specific platforms, the platform can define sql replacement tokens for all of the *ServiceSqlMap classes as those classes are built up. One of the strings that are replaced across several platforms is the current_timestamp string. SQLite replaces current_timestamp with "strftime('%Y-%m-%d %H:%M:%f','now','localtime')". Sybase ASE replaces current_timestamp with "getdate()". There are several others. The replacement of the current_timestamp string in the method that inserts sym_data records should run the current_timestamp string through the platform.scrubSql("current_timestamp"), and use the returned value to allow any platform to use a different string. | ||||
| Steps To Reproduce | 1. Synch between two SQLite nodes. 2. Create the nodes. 3. Create a table on both nodes to synch. 4. Configure synchronization for the table. 5. Set the sym_node_security record for the client node such that initial_load_enabled=1 is set. 6. Exception inserting record into sym_data should occur. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.12 1d90d5f7 2020-12-02 20:54:01 Details Diff |
0004676: Insert into sym_data replaces current_timestamp string with question mark to allow specified timestamp but fails sometimes |
Affected Issues 0004676 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-12-02 20:52 | pmarzullo | New Issue | |
| 2020-12-02 20:52 | pmarzullo | Status | new => assigned |
| 2020-12-02 20:52 | pmarzullo | Assigned To | => pmarzullo |
| 2020-12-02 20:54 | pmarzullo | Summary | Insert into sym_data replaces current_timestamp string with question mark to allow specified timestamp => Insert into sym_data replaces current_timestamp string with question mark to allow specified timestamp but fails sometimes |
| 2020-12-02 21:00 | pmarzullo | Changeset attached | => SymmetricDS 3.12 1d90d5f7 |
| 2020-12-08 13:55 | pmarzullo | Status | assigned => resolved |
| 2020-12-08 13:55 | pmarzullo | Resolution | open => fixed |
| 2020-12-08 13:55 | pmarzullo | Fixed in Version | => 3.12.6 |
| 2021-01-11 13:47 | admin | Status | resolved => closed |