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
See: https://github.com/doctrine/dbal/pull/600#issuecomment-273343134
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 :-\