[DDC-1271] Failing tests for PostgreSQL Created: 11/Jul/11  Updated: 31/Jul/11  Resolved: 31/Jul/11

Status: Resolved
Project: Doctrine 2 - ORM
Component/s: ORM
Affects Version/s: None
Fix Version/s: 2.2
Security Level: All

Type: Bug Priority: Major
Reporter: Eriksen Costa Assignee: Benjamin Eberlei
Resolution: Fixed Votes: 0
Labels: None
Environment:

Ubuntu 10.10 x86_64
PostgreSQL 8.4.4
PHP 5.3.3 & pdo_pgsql



 Description   

The pgsql.phpunit.xml file:

<php>
    <!-- "Real" test database -->
    <var name="db_type" value="pdo_pgsql"/>
    <var name="db_host" value="localhost" />
    <var name="db_username" value="root" />
    <var name="db_password" value="root" />
    <var name="db_name" value="doctrine_tests" />
    <var name="db_port" value="5432"/>

    <!-- Database for temporary connections (i.e. to drop/create the main database) -->
    <var name="tmpdb_type" value="pdo_pgsql"/>
    <var name="tmpdb_host" value="localhost" />
    <var name="tmpdb_username" value="root" />
    <var name="tmpdb_password" value="root" />
    <var name="tmpdb_name" value="doctrine_tests_tmp" />
    <var name="tmpdb_port" value="5432"/>
</php>

root is a user created by me, with SUPERUSER provileges:

ALTER ROLE root WITH SUPERUSER INHERIT NOCREATEROLE CREATEDB LOGIN PASSWORD 'root';

Test output:

PHPUnit 3.5.10 by Sebastian Bergmann.

.SSSSSS......................................F...............   61 / 1137 (  5%)
............................S................................  122 / 1137 ( 10%)
.............................................................  183 / 1137 ( 16%)
.............................................................  244 / 1137 ( 21%)
........................................F....................  305 / 1137 ( 26%)
..........................SSS................................  366 / 1137 ( 32%)
S............................................................  427 / 1137 ( 37%)
....................SS.......................................  488 / 1137 ( 42%)
.............................................................  549 / 1137 ( 48%)
............................................................S  610 / 1137 ( 53%)
..................S..........................................  671 / 1137 ( 59%)
.............................................................  732 / 1137 ( 64%)
.............................................................  793 / 1137 ( 69%)
.............................................................  854 / 1137 ( 75%)
.............................................................  915 / 1137 ( 80%)
.............................................................  976 / 1137 ( 85%)
............................................................. 1037 / 1137 ( 91%)
............................................................. 1098 / 1137 ( 96%)
.................

Time: 57 seconds, Memory: 145.25Mb

There were 2 failures:

1) Doctrine\Tests\ORM\Functional\BasicFunctionalTest::testRemove
Failed asserting that <integer:3> matches expected <integer:2>.

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Functional/BasicFunctionalTest.php:161

2) Doctrine\Tests\ORM\Functional\QueryDqlFunctionTest::testDateDiff
Should be roughly -10 (or -9)
Failed asserting that <string:-10 days> matches expected <integer:-10>.

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Functional/QueryDqlFunctionTest.php:280

--

Deprecated PHPUnit features are being used

47, ommited by me :)

--

There were 15 skipped tests:

1) Doctrine\Tests\ORM\Query\DqlGenerationTest::testSelect
Not yet implemented.

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Criteria/DqlGenerationTest.php:40

2) Doctrine\Tests\ORM\Query\DqlGenerationTest::testSelectDistinct
Not yet implemented.

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Criteria/DqlGenerationTest.php:40

3) Doctrine\Tests\ORM\Query\DqlGenerationTest::testSelectJoin
Not yet implemented.

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Criteria/DqlGenerationTest.php:40

4) Doctrine\Tests\ORM\Query\DqlGenerationTest::testSelectWhere
Not yet implemented.

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Criteria/DqlGenerationTest.php:40

5) Doctrine\Tests\ORM\Query\DqlGenerationTest::testSelectWhereIn
Not yet implemented.

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Criteria/DqlGenerationTest.php:40

6) Doctrine\Tests\ORM\Query\DqlGenerationTest::testDelete
Not yet implemented.

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Criteria/DqlGenerationTest.php:40

7) Doctrine\Tests\ORM\Functional\CompositePrimaryKeyTest::testCompositeCollectionMemberExpression
How to test this?

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Functional/CompositePrimaryKeyTest.php:83

8) Doctrine\Tests\ORM\Functional\SchemaTool\MySqlSchemaToolTest::testGetCreateSchemaSql
The Doctrine\Tests\ORM\Functional\SchemaTool\MySqlSchemaToolTest requires the use of mysql.

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Functional/SchemaTool/MySqlSchemaToolTest.php:15

9) Doctrine\Tests\ORM\Functional\SchemaTool\MySqlSchemaToolTest::testGetCreateSchemaSql2
The Doctrine\Tests\ORM\Functional\SchemaTool\MySqlSchemaToolTest requires the use of mysql.

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Functional/SchemaTool/MySqlSchemaToolTest.php:15

10) Doctrine\Tests\ORM\Functional\SchemaTool\MySqlSchemaToolTest::testGetCreateSchemaSql3
The Doctrine\Tests\ORM\Functional\SchemaTool\MySqlSchemaToolTest requires the use of mysql.

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Functional/SchemaTool/MySqlSchemaToolTest.php:15

11) Doctrine\Tests\ORM\Functional\Ticket\DDC1050Test::testPerformance
performance skipped

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Functional/Ticket/DDC1050Test.php:15

12) Doctrine\Tests\ORM\Functional\Ticket\DDC758Test::testManyToManyMergeAssociationAdds
Destroys testsuite

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Functional/Ticket/DDC758Test.php:17

13) Doctrine\Tests\ORM\Functional\Ticket\DDC758Test::testManyToManyMergeAssociationRemoves
Destroys testsuite

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Functional/Ticket/DDC758Test.php:17

14) Doctrine\Tests\ORM\Mapping\PHPMappingDriverTest::testDiscriminatorColumnDefaults
PHP Mapping Drivers have no defaults.

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Mapping/AbstractMappingDriverTest.php:284

15) Doctrine\Tests\ORM\Mapping\StaticPHPMappingDriverTest::testDiscriminatorColumnDefaults
PHP Mapping Drivers have no defaults.

/mnt/fs/doctrine/github/Infranology/doctrine2/tests/Doctrine/Tests/ORM/Mapping/AbstractMappingDriverTest.php:284


 Comments   
Comment by Benjamin Eberlei [ 31/Jul/11 ]

I don't get the first error, but the second is fixed now.

Generated at Thu Apr 17 21:39:07 UTC 2014 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.