View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001132 | SymmetricDS | Improvement | public | 2013-03-21 22:12 | 2024-05-08 18:01 |
| Reporter | gwilmer | Assigned To | |||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Target Version | 3.15.0 | Fixed in Version | 3.15.0 | ||
| Summary | 0001132: Support Postgres Special Floating Point Values Infinity, -Infinity, NaN | ||||
| Description | Postgres allows special values of Infinity, -Infinity and NaN for all floating point types. Symmetric fails with numeric conversions on these. | ||||
| Tags | data type, dialect: postgresql | ||||
|
|
This is still an issue with the following types: - NUMERIC - REAL - DOUBLE PRECISION Looking at the error logs - it appears that it can extract the data fine, it just errors out when trying to reload it, as these values are special cases and need to be passed in as strings. E.g.: UPDATE table SET x = 'Infinity' |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-03-21 22:12 | gwilmer | New Issue | |
| 2016-02-05 19:44 | NathanClayton | Note Added: 0000759 | |
| 2019-04-23 12:39 | elong | Tag Attached: data type | |
| 2019-04-23 12:39 | elong | Tag Attached: postgresql | |
| 2019-04-23 20:50 | admin | Tag Renamed | postgresql => dialect: postgresql |
| 2023-06-20 20:10 | elong | Relationship added | related to 0002530 |
| 2024-05-08 18:01 | jvanmeter | Status | new => closed |
| 2024-05-08 18:01 | jvanmeter | Resolution | open => fixed |
| 2024-05-08 18:01 | jvanmeter | Fixed in Version | => 3.15.0 |