| 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 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) | ||
[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?
Comments
[2005-03-07 03: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 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.