Bug #3710

Manager mysql doesn't handle added_indexes

Details

Submitted	2005-03-05 07:45 UTC
From	ceefour at gauldong dot net
Assigned	lsmith
Status	Closed
Package	MDB2
PHP Version	5.0.3
OS	All
Roadmaps	(Not assigned)

Comments

[2005-03-05 07:45 UTC] ceefour at gauldong dot net

Description:
------------
I've just noticed MDB2 Manager doesn't handle added_indexes or any indexes
operation overall. This makes it almost useless as indexes are very
critical.

Is there a plan when this will be supported?

[2005-03-07 06:00 UTC] ceefour at gauldong dot net

Hmm I guess I need to state the problem clearer.

Manager can create indexes, but only if you do it at the same time you create the table. If the table already exists, then you add an index, the MySQL *implementation* for Manager doesn't handle that. It doesn't handle all other index-related operations for ALTER TABLE, as far as I can see from the source.

Note that MDB 2.0.0 beta 2 had full functionality, the last (probably a week ago) CVS version doesn't have this functionality and therefore it is a "bug".

[2005-03-07 16:53 UTC] smith at backendmedia dot com

This bug has been fixed in CVS.

In case this was a documentation problem, the fix will show up at the
end of next Sunday (CET) on pear.php.net.

In case this was a pear.php.net website problem, the change will show
up on the website in short time.

Thank you for the report, and for helping us make PEAR better.