View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001279 | SymmetricDS | Bug | public | 2013-06-14 13:45 | 2019-05-08 14:56 |
| Reporter | Sektat | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.4.6 | ||||
| Target Version | 3.10.2 | Fixed in Version | 3.10.2 | ||
| Summary | 0001279: Derby - clob - primary key (date) | ||||
| Description | If I want to replicate a (derby 10.9.1.0) store transaction data table like this (removed non-important columns): create table pos_journal_transaction ( evt_day date not null, receipt_data clob(64K)); Primary key = EVT_DAY I receive this error as soon as I insert data into the table java.sql.SQLException: The syntax of the string representation of a datetime value is incorrect. After logging all SQL statements I found this statement generated by the symetrics code: select RECEIPT_DATA from pos_journal_transaction where "EVT_DAY"={ts '2013-06-14'} This seems to be the cause for the errormessage (reproducable), since evt_day is a date and therefore the jdbc escape syntax for date must be used, which is a "d". Correct would be: select RECEIPT_DATA from pos_journal_transaction where "EVT_DAY"={d '2013-06-14'} If I ignore the receipt_data column (sym_trigger.exclude_column='receipt_data'), everything works fine, as expected. | ||||
| Steps To Reproduce | see above. | ||||
| Tags | data sync, dialect: derby | ||||
|
|
Confirmed that I get the error after installing the SymmetricDS trigger. create table pos_journal_transaction (evt_day date not null primary key, receipt_data clob(64K)); insert into pos_journal_transaction values ({d '2019-04-01'}, null); SQL Message: The exception 'java.sql.SQLDataException: The syntax of the string representation of a date/time value is incorrect.' was thrown while evaluating an expression. SQL State: 38000 Error Code: 20000 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-06-14 13:45 | Sektat | New Issue | |
| 2019-04-22 13:17 | elong | Tag Attached: data sync | |
| 2019-04-22 13:18 | elong | Tag Attached: Apache Derby | |
| 2019-04-23 20:43 | admin | Tag Renamed | Apache Derby => dialect: derby |
| 2019-04-26 20:17 | elong | Assigned To | => elong |
| 2019-04-26 20:17 | elong | Status | new => confirmed |
| 2019-04-26 20:17 | elong | Note Added: 0001450 | |
| 2019-04-26 20:20 | elong | Status | confirmed => resolved |
| 2019-04-26 20:20 | elong | Resolution | open => fixed |
| 2019-04-26 20:20 | elong | Fixed in Version | => 3.10.2 |
| 2019-04-26 21:00 | admin | Changeset attached | => SymmetricDS 3.10 85a80d66 |
| 2019-05-08 14:56 | admin | Status | resolved => closed |