[wp-trac] [WordPress Trac] #17065: Independent ASC/DESC in multiple ORDER BY statement.

[WordPress Trac]

#17065: Independent ASC/DESC in multiple ORDER BY statement.
-------------------------------------------------+-------------------------
 Reporter:  ericmann                             |       Owner:  ericmann
     Type:  enhancement                          |      Status:  new
 Priority:  normal                               |   Milestone:  Awaiting
Component:  Query                                |  Review
 Severity:  normal                               |     Version:  trunk
 Keywords:  has-patch needs-testing needs-unit-  |  Resolution:
  tests                                          |
-------------------------------------------------+-------------------------
Changes (by andy):

 * version:  3.1 => trunk


Comment:

 This discussion stalled over how many tests to add and whether it needs to
 support the full SQL syntax. An improvement as simple and obvious as this
 should never have descended into such fruitless areas of debate.

 ORDER BY is such a simple part of MySQL that it doesn't even get its own
 page for documentation. Its use is fully described in a few bullet points
 under SELECT Syntax. There is no reason to introduce array types.

 Newly attached patch provides a human-readable, single-string, backwards-
 compatible solution.

--
Ticket URL: <http://core.trac.wordpress.org/ticket/17065#comment:42>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software