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

Closed
doctrinebot opened this Issue Nov 1, 2009 · 2 comments

2 participants

@doctrinebot

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..

@doctrinebot

Comment created by @beberlei:

Fixed for all platforms.

@doctrinebot

Issue was closed with resolution "Fixed"

@beberlei beberlei was assigned by doctrinebot Dec 6, 2015
@doctrinebot doctrinebot added this to the 2.0-ALPHA3 milestone Dec 6, 2015
@doctrinebot doctrinebot closed this Dec 6, 2015
@doctrinebot doctrinebot added the Bug label Dec 7, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment