View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004163 | SymmetricDS | Bug | public | 2019-11-24 17:20 | 2019-12-02 20:12 |
| Reporter | elong | Assigned To | elong | ||
| Priority | high | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.0 | ||||
| Target Version | 3.11.1 | Fixed in Version | 3.11.1 | ||
| Summary | 0004163: MySQL ignore zeroDateTimeBehavior=convertToNull if server is set to NO_ZERO_DATE | ||||
| Description | The settings of db.url with zeroDateTimeBehavior=convertToNull and server set to sql_mode of NO_ZERO_DATE are not compatible. SymmetricDS will try to compare dates with 0000-00-00 to convert them, but MySQL will return a syntax error, which causes queries and triggers to break. | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-11-24 17:20 | elong | New Issue | |
| 2019-11-24 17:20 | elong | Status | new => assigned |
| 2019-11-24 17:20 | elong | Assigned To | => elong |
| 2019-11-24 17:20 | elong | Issue generated from: 0004161 | |
| 2019-11-24 17:20 | elong | Relationship added | related to 0004161 |
| 2019-11-24 17:23 | elong | Status | assigned => resolved |
| 2019-11-24 17:23 | elong | Resolution | open => fixed |
| 2019-11-24 17:23 | elong | Fixed in Version | => 3.11.1 |
| 2019-12-02 20:12 | admin | Status | resolved => closed |