Follow up to Conditional SELECT returns incorrect results.

Hello,

This is a follow up to the bug report filed earlier today.

As reported earlier:

I am receiving incorrect result from a query that is issued via the JDBC
driver. I am running Windows XP, Java version 1.6.0_02, PostgresSQL version
8.2 and using the postgresql-8.2-507-jdbc4.jar. I have also used the
postgresql-8.2-506-jdbc4.jar with the same results.

Java code with try/catch./finally and resource cleanup all left out for
brevity,

String sel = "SELECT testing_table.rec_no, testing_table.test_number FROM
testing_table WHERE test_number >= ? AND test_number <= ? ORDER BY rec_no";

Connection conn = xxx.getConnection();

PreparedStatement ps1 = conn.prepareStatement(sel);

ps1,setString(1, "10.0");

ps1,setString(2, "50.0");

ResultSet rs = ps1.executeQuery();

while (rs.hasNext())

{

// process a row.

}

After further testing I have determined that if the ps1.setString(1, "10.0")
and ps1.setString(2, "50.0") are replaced by ps1.setDouble(1, 10.0) and
ps1.setDouble(2, 50.0) the query executes correctly. I still believe this is
a bug as the database column definition should determine the comparison type
NOT the PreparedStatement parameter type. It would appear that the parameter
type of String is causing a String comparison to be used. Also, using the
same SELECT statement, with or without quotes around the parameters, in the
PostgresSQL query tool returns the correct results.

Regards,

Gary Gesmundo

ggesmundo(at)tds(dot)net