Re: 1+1+16 = 18 failures

I've sort of eluded to this before. testSupportsStoredProcedures is allowed to return false.
The test suite is quite arbitrary, I'd sooner see your (and others) efforts going towards beefing up our internal test suite.

Dave

Vadim Nasardinov wrote:

On Wednesday 17 November 2004 15:25, Oliver Jowett wrote: 

Did you get any useful test results from the non-EJB modes? Anything
the driver does wrong there?   

No, I didn't see any cases where the blame could be pegged squarely on
the driver, except the testSupportsStoredProcedures test.

If I run the test with this exclusion list:
http://java.sun.com/products/jdbc/exclude.1.2.1.txt?button=Download

I get 18 failures out of 548 tests.  One of them is
 testSupportsStoredProcedures

This fails because in
org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData.java, we have
    public boolean supportsStoredProcedures() throws SQLException    {        return false;    }

whereas the test harness expects this method to return true.

One other failure looks like a bug in the harness.  Specifically,  testGetSQLState
fails because this condition b.getSQLState() instanceof java.lang.String

tests false, where b is a SQLException.  Now, the only way this can
possibly happen is if getSQLState() returns null.  Looking at the
javadoc
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/SQLException.html#getSQLState%28%29

I don't see anything that says the method is not allowed to return
null.  Looks like a bug in the CTS.


The remaining 16 failures are all due to the same reason.  The backend
chokes on the following query (or some variation thereof):
 | DB1=> select substring(version(), 1, 20) as version; |        version         | ---------------------- |  PostgreSQL 7.3.4-RH  | (1 row) | DB1=> create table Real_Tab (MAX_VAL REAL, MIN_VAL REAL,NULL_VAL REAL); | CREATE TABLE | DB1=> insert into Real_Tab values(3.4E38,1.4E-45, null); | ERROR:  Bad float4 input format -- underflow


The funny part is that I can do
 | DB1=> select 1.4E-45; |                      ?column?                      | -------------------------------------------------- |  0.0000000000000000000000000000000000000000000014 | (1 row) | DB1=> select 3.4E38; |                 ?column?                  | ----------------------------------------- |  340000000000000000000000000000000000000 | (1 row)

But I would have to test this against a more recent version of the
backend.  In any case, these 16 failures don't be seem to be caused
by the driver.



Vadim


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org

 

-- 
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561