Postgres Pro
Downloads
Home   >   mailing lists

Re: Failing test on 8.2-506 - Mailing list pgsql-jdbc

From Miroslav Šulc
Subject Re: Failing test on 8.2-506
Date
Msg-id 46B36B1D.8020107@startnet.cz
Whole thread Raw
In response to Failing test on 8.2-506  (Miroslav Šulc <miroslav.sulc@startnet.cz>)
Responses Re: Failing test on 8.2-506
List pgsql-jdbc
Tree view 
The result is the same for 8.1-410. With 8.0-320 I get even more errors:

runtest:
    [junit] Testsuite: org.postgresql.test.jdbc2.Jdbc2TestSuite
    [junit] Tests run: 198, Failures: 3, Errors: 5, Time elapsed: 12.199 sec
    [junit]
    [junit] Testcase:
testTables(org.postgresql.test.jdbc2.DatabaseMetaDataTest):       FAILED
    [junit] expected:<test[metadata]> but was:<test[index]>
    [junit] junit.framework.ComparisonFailure: expected:<test[metadata]>
but was:<test[index]>
    [junit]     at
org.postgresql.test.jdbc2.DatabaseMetaDataTest.testTables(DatabaseMetaDataTest.java:78)
    [junit]
    [junit]
    [junit] Testcase:
testCrossReference(org.postgresql.test.jdbc2.DatabaseMetaDataTest):
Caused an ERROR
    [junit] ERROR: function information_schema._pg_keypositions() does
not exist
    [junit] java.sql.SQLException: ERROR: function
information_schema._pg_keypositions() does not exist
    [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1501)
    [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1283)
    [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:186)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:392)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:221)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedExportedKeys(AbstractJdbc2DatabaseMetaData.java:3240)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getCrossReference(AbstractJdbc2DatabaseMetaData.java:3655)
    [junit]     at
org.postgresql.test.jdbc2.DatabaseMetaDataTest.testCrossReference(DatabaseMetaDataTest.java:105)
    [junit]
    [junit]
    [junit] Testcase:
testForeignKeyActions(org.postgresql.test.jdbc2.DatabaseMetaDataTest):
Caused an ERROR
    [junit] ERROR: function information_schema._pg_keypositions() does
not exist
    [junit] java.sql.SQLException: ERROR: function
information_schema._pg_keypositions() does not exist
    [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1501)
    [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1283)
    [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:186)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:392)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:221)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedExportedKeys(AbstractJdbc2DatabaseMetaData.java:3240)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedKeys(AbstractJdbc2DatabaseMetaData.java:3536)
    [junit]     at
org.postgresql.test.jdbc2.DatabaseMetaDataTest.testForeignKeyActions(DatabaseMetaDataTest.java:156)
    [junit]
    [junit]
    [junit] Testcase:
testForeignKeysToUniqueIndexes(org.postgresql.test.jdbc2.DatabaseMetaDataTest):
Caused an ERROR
    [junit] ERROR: function information_schema._pg_keypositions() does
not exist
    [junit] java.sql.SQLException: ERROR: function
information_schema._pg_keypositions() does not exist
    [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1501)
    [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1283)
    [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:186)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:392)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:221)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedExportedKeys(AbstractJdbc2DatabaseMetaData.java:3240)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedKeys(AbstractJdbc2DatabaseMetaData.java:3536)
    [junit]     at
org.postgresql.test.jdbc2.DatabaseMetaDataTest.testForeignKeysToUniqueIndexes(DatabaseMetaDataTest.java:183)
    [junit]
    [junit]
    [junit] Testcase:
testMultiColumnForeignKeys(org.postgresql.test.jdbc2.DatabaseMetaDataTest):
Caused an ERROR
    [junit] ERROR: function information_schema._pg_keypositions() does
not exist
    [junit] java.sql.SQLException: ERROR: function
information_schema._pg_keypositions() does not exist
    [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1501)
    [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1283)
    [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:186)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:392)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:221)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedExportedKeys(AbstractJdbc2DatabaseMetaData.java:3240)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedKeys(AbstractJdbc2DatabaseMetaData.java:3536)
    [junit]     at
org.postgresql.test.jdbc2.DatabaseMetaDataTest.testMultiColumnForeignKeys(DatabaseMetaDataTest.java:206)
    [junit]
    [junit]
    [junit] Testcase:
testForeignKeys(org.postgresql.test.jdbc2.DatabaseMetaDataTest):  Caused
an ERROR
    [junit] ERROR: function information_schema._pg_keypositions() does
not exist
    [junit] java.sql.SQLException: ERROR: function
information_schema._pg_keypositions() does not exist
    [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1501)
    [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1283)
    [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:186)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:392)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:221)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedExportedKeys(AbstractJdbc2DatabaseMetaData.java:3240)
    [junit]     at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedKeys(AbstractJdbc2DatabaseMetaData.java:3536)
    [junit]     at
org.postgresql.test.jdbc2.DatabaseMetaDataTest.testForeignKeys(DatabaseMetaDataTest.java:245)
    [junit]
    [junit]
    [junit] Testcase:
testValues(org.postgresql.test.jdbc2.DatabaseMetaDataPropertiesTest):
FAILED
    [junit] expected:<32> but was:<0>
    [junit] junit.framework.AssertionFailedError: expected:<32> but was:<0>
    [junit]     at
org.postgresql.test.jdbc2.DatabaseMetaDataPropertiesTest.testValues(DatabaseMetaDataPropertiesTest.java:114)
    [junit]
    [junit]
    [junit] Testcase: testSetTime(org.postgresql.test.jdbc2.TimeTest):
FAILED
    [junit] expected:<09:01:02> but was:<05:01:02>
    [junit] junit.framework.AssertionFailedError: expected:<09:01:02>
but was:<05:01:02>
    [junit]     at
org.postgresql.test.jdbc2.TimeTest.timeTest(TimeTest.java:275)
    [junit]     at
org.postgresql.test.jdbc2.TimeTest.testSetTime(TimeTest.java:201)
    [junit]
    [junit]
    [junit] Test org.postgresql.test.jdbc2.Jdbc2TestSuite FAILED
    [junit] Testsuite: org.postgresql.test.jdbc2.optional.OptionalTestSuite
    [junit] Tests run: 38, Failures: 0, Errors: 0, Time elapsed: 2.517 sec
    [junit]
    [junit] Testsuite: org.postgresql.test.jdbc3.Jdbc3TestSuite
    [junit] Tests run: 16, Failures: 0, Errors: 0, Time elapsed: 0.721 sec
    [junit]

I am running all the tests against postgresql-8.2.4. Is that the cause
why 8.0 driver fails that much?

--
Miroslav Šulc


Miroslav Šulc napsal(a):
> Hi,
>
> I just wanted to package jdbc driver 8.2-506 for gentoo linux distro
> but came across this bug in the tests:
>
> runtest:
>    [junit] Testsuite: org.postgresql.test.jdbc2.Jdbc2TestSuite
>    [junit] Tests run: 243, Failures: 1, Errors: 0, Time elapsed:
> 52.261 sec
>    [junit]
>    [junit] Testcase:
> testTables(org.postgresql.test.jdbc2.DatabaseMetaDataTest):       FAILED
>    [junit] expected:<test[metadata]> but was:<test[index]>
>    [junit] junit.framework.ComparisonFailure:
> expected:<test[metadata]> but was:<test[index]>
>    [junit]     at
> org.postgresql.test.jdbc2.DatabaseMetaDataTest.testTables(DatabaseMetaDataTest.java:78)
>
>    [junit]
>    [junit]
>    [junit] Test org.postgresql.test.jdbc2.Jdbc2TestSuite FAILED
>    [junit] Testsuite:
> org.postgresql.test.jdbc2.optional.OptionalTestSuite
>    [junit] Tests run: 38, Failures: 0, Errors: 0, Time elapsed: 2.085 sec
>    [junit]
>    [junit] Testsuite: org.postgresql.test.jdbc3.Jdbc3TestSuite
>    [junit] Tests run: 50, Failures: 0, Errors: 0, Time elapsed: 1.479 sec
>    [junit]
>    [junit] Testsuite: org.postgresql.test.xa.XATestSuite
>    [junit] Tests run: 8, Failures: 0, Errors: 0, Time elapsed: 0.306 sec
>    [junit]
>
> --
> Miroslav Šulc

pgsql-jdbc by date:

Previous
From: Miroslav Šulc
Date:
Subject: Failing test on 8.2-506
Next
From: Kris Jurka
Date:
Subject: Re: Failing test on 8.2-506