Describe the bug
DbGate shows Infinity and NaN floating point values as NULL, both when they are scalar, and when they are in a (multidimensional) array type.
To Reproduce
Steps to reproduce the behavior:
Launch the following queries to create and populate an example table:
CREATE TABLE example(
id SERIAL PRIMARY KEY,
scalar1 float8 not null,
scalar2 float8 not null,
scalar3 float8 not null,
arr1 float4[][] not null,
arr2 float8[][] not null
);
2. Infinity and NaN values are shown as NULL, as shown in the following screenshots:
3. Even when performing a Copy Without Headers command, values are shown as NULL
4. SQL Generator for INSERT statements partially works (special values are correctly shown, but only if they are in scalar fields, not in arrays):
5. Other clients (e.g. DBeaver and pgAdmin) correctly show special values:
**Version Information:**
- OS: Manjaro Linux x64
- App Version: 5.2.10-beta.4 (Linux x64 AppImage)
- Database engine: PostgreSQL 16.2
Describe the bug DbGate shows Infinity and NaN floating point values as NULL, both when they are scalar, and when they are in a (multidimensional) array type.
To Reproduce Steps to reproduce the behavior:
INSERT INTO example(scalar1, scalar2, scalar3, arr1, arr2) VALUES ( 'Infinity'::float8, -'Infinity'::float8, 'NaN'::float8, ARRAY[['Infinity'::float4, 1.0, 2.0], [3.0, -'Infinity'::float4, 4.0], [5.0, 6.0, 'NaN'::float4]], ARRAY[['Infinity'::float8, 1.1, 2.1], [3.1, -'Infinity'::float8, 4.1], [5.1, 6.1, 'NaN'::float8]] );