View Issue Details

IDProjectCategoryView StatusLast Update
0001132SymmetricDSImprovementpublic2024-05-08 18:01
Reportergwilmer Assigned To 
Status closedResolutionfixed 
Target Version3.15.0Fixed in Version3.15.0 
Summary0001132: Support Postgres Special Floating Point Values Infinity, -Infinity, NaN
DescriptionPostgres allows special values of Infinity, -Infinity and NaN for all floating point types. Symmetric fails with numeric conversions on these.
Tagsdata type, dialect: postgresql


related to 0002530 closedJishLong postgresql infinity timestamp 



2016-02-05 19:44

reporter   ~0000759

This is still an issue with the following types:

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.

UPDATE table SET x = 'Infinity'

Issue History

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