[BUGS] JDBC driver doesn't handle NaN values

#1

The JDBC driver that ships with PostgreSQL 7.4.1 doesn't insert floats
of value NaN. As it uses Float.toString(x) to convert the value for
insertion into the database, it tries to insert NaN instead of 'NaN' and
gets the error "Attribute 'nan' not found". The same bug occurs for
doubles and will probably occur for infinite values as well (i haven't
tested it). This bug also exists in 7.2.4 and in the 7.2.1 version
currently in Debian stable.

Here is a patch for the
"src/interfaces/jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java"
file. There may need to be other files changed (eg in the jdbc2 or
jdbc3 directories), but i don't know where.

1062c1062,1063
< bind(parameterIndex, Float.toString(x), PG_FLOAT);
---

Quote:

String value = Float.isNaN(x) ? "'NaN'" : Float.toString(x);
bind(parameterIndex, value, PG_FLOAT);
1075c1076,1077

< bind(parameterIndex, Double.toString(x), PG_DOUBLE);
---

Quote:

String value = Double.isNaN(x) ? "'NaN'" : Double.toString(x);
bind(parameterIndex, value, PG_DOUBLE);
1553a1556,1559
else if (x instanceof Float)
return ((Float) x).isNaN() ? "'NaN'" : x.toString();
else if (x instanceof Double)
return ((Double) x).isNaN() ? "'NaN'" : x.toString();
1555,1556c1561

< x instanceof Double || x instanceof Short ||
< x instanceof Number || x instanceof Float)
---

Quote:

x instanceof Number || x instanceof Short)

Regards,

Jon

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[BUGS] JDBC driver doesn't handle NaN values

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

[BUGS] JDBC driver doesn't handle NaN values - 01-08-2004 , 09:15 PM