Bug #65893 Index Field Order allways is ASC

• Submitted: 13 Jul 2012 13:57
• Modified: 13 Jul 2012 19:38
• Reporter: Sebastião Relson Reis da Luz
• Status: Not a Bug
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: mysqlserver version 5.1.57-1~dotdeb.1-log
• OS: Linux (Debian GNU/Linux 6.0.1 Kernel 2.6.32-5-amd64)
• CPU Architecture: Any
• Tags: editing, INDEX, table

[13 Jul 2012 13:57] Sebastião Relson Reis da Luz

Description:
When I define a Index and then chose order to DESC and come back on this definition in other session the order of field is ASC

How to repeat:
see the description :)

Suggested fix:
see the description too

[13 Jul 2012 14:01] Sebastião Relson Reis da Luz

Server version

[13 Jul 2012 14:19] Sebastião Relson Reis da Luz

I think this is bug is about the server intead MySQL Workbench, be couse when a run show index from table command its gave me Collation equals A for all feed

[13 Jul 2012 14:55] Sebastião Relson Reis da Luz

Server version

[13 Jul 2012 15:41] Valeriy Kravchuk

Please, send the exact CREATE TABLE statement for the table used and exact SELECT you are trying to execute (or more detailed description of your actions in Workbench).

[13 Jul 2012 15:44] Valeriy Kravchuk

Our manual, http://dev.mysql.com/doc/refman/5.5/en/create-index.html, says:

"An index_col_name specification can end with ASC or DESC. These keywords are permitted 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."

So, probably this is the reason for what you see in Workbench: it allows to add that DESC option, but server itself ignores it.

[13 Jul 2012 17:47] Sebastião Relson Reis da Luz

Sorry,
I Should have done a better Investigation.

best regards