At 15:30 -0400 on 06/23/2004, Michael Stassen wrote about Re: INDEX DESC:
The manual <http://dev.mysql.com/doc/mysql/en/CREATE_INDEX.html> says "An index_col_name specification can end with ASC or DESC. These keywords are allowed for future extensions for specifying ascending or descending index value storage. Currently they are parsed but ignored; index values are always stored in ascending order."
Something that is VERY easy to fix and implement. So long as you KNOW that the Index is being defined as DESC, just STORE the Index value as Field XOR xFF..FF (FF..FF being the length of the Keyed Field). The Index is then AUTOMATICALLY in Descending order and you just need to XOR to recover the actual key value if/when you need it.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
