-
Enhancement
-
Resolution: Unresolved
-
Major
-
None
-
None
-
False
-
None
-
False
DBZ-7920 dealt with +-infinity values from kafka per each destinaation database.
| Vendor | -INFINITY | +INFINITY |
|---|---|---|
| Oracle | `-4712-01-01T00:00:00+00:00` | `9999-12-31T23:59:59+00:00` |
| MySQL | `1970-01-01T00:00:01+00:00` | `2038-01-19T03:14:07+00:00` |
| SQL Server/Db2 | `0001/01/01 00:00:00` | `9999/12/31 23:59:59` |
Since negative infinity only exists in Oracle, I would like to propose that once a config is set, negative oracle timestamp values be treated the same way as -infinity would in DBZ-7920.
| Vendor | negative oracle timestamp |
|---|---|
| Oracle | `-4712-01-01T00:00:00+00:00` |
| MySQL | `1970-01-01T00:00:01+00:00` |
| SQL Server/Db2 | `0001/01/01 00:00:00` |
- is related to
-
DBZ-7920 Debezium postgres jdbc sink not handling infinity values
-
- Closed
-