Bug #5235 Connector/J reurns wrong type for Date

Description:
I have set the option zeroDateTimeBehavior to convertToNull.
My database table contains a Date field with value 0000-00-00
When I use getObject() on the ResultSet object a value of type String ("0000-00-00") is returned. This should be null.

How to repeat:
Obvious

Suggested fix:
Adding

         if (field.getSQLType() == Types.DATE) {
            return getDate(columnIndex);
         }

after the special case for type BIT in ResultSet.getObject() solves the problem, but maybe there is a better solution?

The following testcase doesn't demonstrate this behavior, am I doing something different than you are? You don't happen to have the field actually defined as a character type, do you?

public void testBug5235() throws Exception {
    	try {
    		this.stmt.executeUpdate("DROP TABLE IF EXISTS testBug5235");
    		this.stmt.executeUpdate("CREATE TABLE testBug5235(field1 DATE)");
    		this.stmt.executeUpdate("INSERT INTO testBug5235 (field1) VALUES ('0000-00-00')");
    		
    		Properties props = new Properties();
    		props.setProperty("zeroDateTimeBehavior", "convertToNull");
    		
    		Connection nullConn = getConnectionWithProps(props);
    		
    		this.rs = nullConn.createStatement().executeQuery("SELECT field1 FROM testBug5235");
    		this.rs.next();
    		assertTrue(null == this.rs.getObject(1));
    	} finally {
    		this.stmt.executeUpdate("DROP TABLE IF EXISTS testBug5235");
    	}
    }

The problem is with the SELECT query. If I use a PreparedStatement, the system generates a ClassCastException.

If you can't produce the error, I can send you my test program.

Regards Marten

Please attach your testcase on the 'Files' tab, and mark it as private. 

Make sure it is a _standalone_ testcase, i.e. it creates/drops and populates the tables.

I added a tescase on september the first.

The fix to this is already on my local drive. I will be doing some more testing and comitting the change on Monday.