Handling of NaN > DevArt Connection Exception

Hi,

PostgreSQL DataAcess Components

if there is "NaN" in a Numeric column (that is allowed per default by postgres).

Devart will fail. The following easy example shows the problem, DevArt is unable to open this dataset. If there is one row in 1000000 rows, it is not possible to open/select data.

In some circumstances this happens automatically - so it is not possible to catch for 100% serverside (with triggers).

In complex querys it fails completely: --EPgError Error: Unexpected server response

You need a handling for NaN in Postgres. Or do i miss something?

https://www.postgresql.org/docs/17/datatype-numeric.html

Infinity
-Infinity
NaN

These are adapted from the IEEE 754 standard, and represent “infinity”, “negative infinity”, and “not-a-number”, respectively. When writing these values as constants in an SQL command, you must put quotes around them, for example UPDATE table SET x = '-Infinity'.

Easy Example:

DROP TABLE IF EXISTS NaN;
CREATE TEMP TABLE NaN (c_id serial, c_text text c_NaN numeric);
INSERT INTO NaN (c_NaN) VALUES ('NaN');
SELECT * FROM NaN

Here you also pointed out some sentences to this problem:

https://blog.devart.com/postgresql-14-support-in-dotconnect-for-postgresql.html

but with throwing a exception the user is unable to open the data as well as unable to locate the problem. I think it would be better to allow this situation and use Displaytext or sth like this to show it und internally hold "null"?

What are your thoughts to this how the user or developer has to handle this topic?