I don't think I should have to say this, but Drizzle should be able to sort indexes in DESC order as well as ASC order, and have columns have a mixed sorting order.
For instance, ALTER TABLE tbl ADD INDEX (fld1 DESC); is valid syntax, but MySQL stores it as ASC, as it parses but ignores DESC. Drizzle should support DESC. As well: ALTER TABLE tbl ADD INDEX (fld1 DESC, fld2 ASC); Should be possible to store as an index (this is talking about BTREE indexes and similar indexes stored in some kind of lexical order....obviously it doesn't apply to HASH indexes). -- - Sheeri K. Cabral
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
