DDC-91: Oracle, Pgsql and Sqlite SchemaManager::listTableIndexes() currently can't return corresponding columns #112

New Issue

admin · 2026-01-22T12:27:23+01:00

admin commented

2026-01-22 12:27:23 +01:00

Originally created by @doctrinebot on GitHub (Nov 1, 2009).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user @beberlei:

Currently only the Mysql Platform can return the corresponding columns of an index, the others only return index-name and a boolean isUnique.

The Mysql platform also returns the data in an unaggregated way, that means an index "Foo" with two columns "bar", "baz" is returned as.

row 1 Foo bar
row 2 Foo baz

It is possible to retrieve the column names of indexes, for example ezcDatabaseSchema does it perfectly easy.

I propose to change the API of SchemaManager::listTableIndexes() to the following:

array(
    array('name' => 'Foo', 'unique' => false, 'columns' => array('bar', 'baz'),
    array('name' => 'Bar', 'unique' => true, 'columns' => array('foo', 'baz'),
);

This might be related to Import/Export Schema of Doctrine 1.x, how are indexes handled in this version?

This issue is related to DDC-90, which can't be implemented without proper index column support..

Originally created by @doctrinebot on GitHub (Nov 1, 2009). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user @beberlei: Currently only the Mysql Platform can return the corresponding columns of an index, the others only return index-name and a boolean isUnique. The Mysql platform also returns the data in an unaggregated way, that means an index "Foo" with two columns "bar", "baz" is returned as. ``` row 1 Foo bar row 2 Foo baz ``` It is possible to retrieve the column names of indexes, for example ezcDatabaseSchema does it perfectly easy. I propose to change the API of SchemaManager::listTableIndexes() to the following: ``` array( array('name' => 'Foo', 'unique' => false, 'columns' => array('bar', 'baz'), array('name' => 'Bar', 'unique' => true, 'columns' => array('foo', 'baz'), ); ``` This might be related to Import/Export Schema of Doctrine 1.x, how are indexes handled in this version? This issue is related to [DDC-90](http://www.doctrine-project.org/jira/browse/DDC-90), which can't be implemented without proper index column support..

admin added the Bug label 2026-01-22 12:27:23 +01:00

admin closed this issue

2026-01-22 12:27:24 +01:00

admin commented

2026-01-22 12:27:25 +01:00

@doctrinebot commented on GitHub (Nov 4, 2009):

Comment created by @beberlei:

Fixed for all platforms.

@doctrinebot commented on GitHub (Nov 4, 2009): Comment created by @beberlei: Fixed for all platforms.

admin commented

2026-01-22 12:27:25 +01:00

@doctrinebot commented on GitHub (Nov 4, 2009):