Dbal: Both PostgreSQL 9.5 and PostgreSQL 9.6 are currently failing on Travis

Created on 30 Nov 2016  路  5Comments  路  Source: doctrine/dbal

Both PostgreSQL 9.5 and PostgreSQL 9.6 are currently failing the unit tests on Travis CI with the following error

There was 1 failure:
1) Doctrine\Tests\DBAL\Functional\Schema\PostgreSqlSchemaManagerTest::testPartialIndexes
Failed asserting that Doctrine\DBAL\Schema\TableDiff Object &000000003d9650fb000000004f24ac8c (
    'name' => 'person'
    'newName' => false
    'addedColumns' => Array &0 ()
    'changedColumns' => Array &1 ()
    'removedColumns' => Array &2 ()
    'renamedColumns' => Array &3 ()
    'addedIndexes' => Array &4 ()
    'changedIndexes' => Array &5 (
        'complex_partial_index' => Doctrine\DBAL\Schema\Index Object &000000003d965f73000000004f24ac8c (
            '_columns' => Array &6 (
                'id' => Doctrine\DBAL\Schema\Identifier Object &000000003d965f17000000004f24ac8c (
                    '_name' => 'id'
                    '_namespace' => null
                    '_quoted' => false
                )
                'name' => Doctrine\DBAL\Schema\Identifier Object &000000003d96514b000000004f24ac8c (
                    '_name' => 'name'
                    '_namespace' => null
                    '_quoted' => false
                )
            )
            '_isUnique' => false
            '_isPrimary' => false
            '_flags' => Array &7 ()
            'options' => Array &8 (
                'where' => '((id IS NOT NULL) AND (name IS NULL) AND (email IS NULL))'
            )
            '_name' => 'complex_partial_index'
            '_namespace' => null
            '_quoted' => false
        )
    )
    'removedIndexes' => Array &9 ()
    'renamedIndexes' => Array &10 ()
    'addedForeignKeys' => Array &11 ()
    'changedForeignKeys' => Array &12 ()
    'removedForeignKeys' => Array &13 ()
    'fromTable' => Doctrine\DBAL\Schema\Table Object &000000003d965f05000000004f24ac8c (
        '_name' => 'person'
        '_columns' => Array &14 (
            'id' => Doctrine\DBAL\Schema\Column Object &000000003d964d46000000004f24ac8c (
                '_type' => Doctrine\DBAL\Types\IntegerType Object &000000003d964c05000000004f24ac8c ()
                '_length' => null
                '_precision' => 10
                '_scale' => 0
                '_unsigned' => false
                '_fixed' => false
                '_notnull' => true
                '_default' => null
                '_autoincrement' => false
                '_platformOptions' => Array &15 ()
                '_columnDefinition' => null
                '_comment' => null
                '_customSchemaOptions' => Array &16 ()
                '_name' => 'id'
                '_namespace' => null
                '_quoted' => false
            )
            'name' => Doctrine\DBAL\Schema\Column Object &000000003d964ca5000000004f24ac8c (
                '_type' => Doctrine\DBAL\Types\StringType Object &000000003d964c07000000004f24ac8c ()
                '_length' => null
                '_precision' => 10
                '_scale' => 0
                '_unsigned' => false
                '_fixed' => false
                '_notnull' => true
                '_default' => null
                '_autoincrement' => false
                '_platformOptions' => Array &17 ()
                '_columnDefinition' => null
                '_comment' => null
                '_customSchemaOptions' => Array &18 ()
                '_name' => 'name'
                '_namespace' => null
                '_quoted' => false
            )
            'email' => Doctrine\DBAL\Schema\Column Object &000000003d965d51000000004f24ac8c (
                '_type' => Doctrine\DBAL\Types\StringType Object &000000003d964c07000000004f24ac8c
                '_length' => null
                '_precision' => 10
                '_scale' => 0
                '_unsigned' => false
                '_fixed' => false
                '_notnull' => true
                '_default' => null
                '_autoincrement' => false
                '_platformOptions' => Array &19 ()
                '_columnDefinition' => null
                '_comment' => null
                '_customSchemaOptions' => Array &20 ()
                '_name' => 'email'
                '_namespace' => null
                '_quoted' => false
            )
        )
        'implicitIndexes' => Array &21 ()
        '_indexes' => Array &22 (
            'simple_partial_index' => Doctrine\DBAL\Schema\Index Object &000000003d965c59000000004f24ac8c (
                '_columns' => Array &23 (
                    'id' => Doctrine\DBAL\Schema\Identifier Object &000000003d965c98000000004f24ac8c (
                        '_name' => 'id'
                        '_namespace' => null
                        '_quoted' => false
                    )
                    'name' => Doctrine\DBAL\Schema\Identifier Object &000000003d9650e0000000004f24ac8c (
                        '_name' => 'name'
                        '_namespace' => null
                        '_quoted' => false
                    )
                )
                '_isUnique' => true
                '_isPrimary' => false
                '_flags' => Array &24 ()
                'options' => Array &25 (
                    'where' => '(id IS NULL)'
                )
                '_name' => 'simple_partial_index'
                '_namespace' => null
                '_quoted' => false
            )
            'complex_partial_index' => Doctrine\DBAL\Schema\Index Object &000000003d965b83000000004f24ac8c (
                '_columns' => Array &26 (
                    'id' => Doctrine\DBAL\Schema\Identifier Object &000000003d965cb7000000004f24ac8c (
                        '_name' => 'id'
                        '_namespace' => null
                        '_quoted' => false
                    )
                    'name' => Doctrine\DBAL\Schema\Identifier Object &000000003d965c2c000000004f24ac8c (
                        '_name' => 'name'
                        '_namespace' => null
                        '_quoted' => false
                    )
                )
                '_isUnique' => false
                '_isPrimary' => false
                '_flags' => Array &27 ()
                'options' => Array &28 (
                    'where' => '(((id IS NOT NULL) AND (name IS NULL)) AND (email IS NULL))'
                )
                '_name' => 'complex_partial_index'
                '_namespace' => null
                '_quoted' => false
            )
        )
        '_primaryKeyName' => false
        '_fkConstraints' => Array &29 ()
        '_options' => Array &30 ()
        '_schemaConfig' => null
        '_namespace' => null
        '_quoted' => false
    )
) is false.
/tests/Doctrine/Tests/DBAL/Functional/Schema/PostgreSqlSchemaManagerTest.php:364
Bug Indexes PR Created PostgreSQL Schema Comparison Schema Introspection Test Suite

All 5 comments

Failing test removed in #2607

Hiding this under the carpet. Handled in #2607

That's the price to pay for highly vendor specific things to support ^^

Yeah, this should probably not have landed before :-\

Was this page helpful?
0 / 5 - 0 ratings

Related issues

ghost picture ghost  路  6Comments

ndoulgeridis picture ndoulgeridis  路  6Comments

spaceemotion picture spaceemotion  路  4Comments

DuckThom picture DuckThom  路  6Comments

photodude picture photodude  路  3Comments