[MXS-2265] Timestamp value '0000-00-00 00:00:00' conversion issue Created: 2019-01-15 Updated: 2019-02-06 Resolved: 2019-02-06 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | avrorouter, cdc |
| Affects Version/s: | 2.2.17 |
| Fix Version/s: | 2.3.4 |
| Type: | Bug | Priority: | Major |
| Reporter: | Sergiy Kyrychenko | Assignee: | markus makela |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Timestamp value '0000-00-00 00:00:00' comes across in CDC JSON as '1969-12-31 17:00:00' |
| Comments |
| Comment by Sergiy Kyrychenko [ 2019-02-01 ] |
|
It's been 2 weeks since this issue has been filed. Is it possible to confirm and set proper priority on this? |
| Comment by markus makela [ 2019-02-04 ] |
|
If you could check whether this also happens for DATETIME it would speed up fixing this issue. If it is only for TIMESTAMP, it should be relatively straightforward to detect as they are stored as UNIX timestamps. |
| Comment by markus makela [ 2019-02-05 ] |
|
Implemented missing test case for zero date and it works for DATE and DATETIME. |