Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 2.5.0b5

Bug #3710 Manager mysql doesn't handle added_indexes
Submitted: 2005-03-05 02:45 UTC Modified: 2006-12-24 16:10 UTC
From: ceefour at gauldong dot net Assigned: lsmith
Status: Closed Package: MDB2
PHP Version: 5.0.3 OS: All
Roadmaps: (Not assigned)    
Subscription  


 [2005-03-05 02: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?

Comments

 [2005-03-06 22:34 UTC] dufuz
I guess you're talking about this: <index> <name><variable>auth_user_id</variable></name> <unique>1</unique> <field> <name><variable>auth_user_id</variable></name> </field> </index> If so it should already be in the package.
 [2005-03-07 01: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 11: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.