MySQL order_by=['?'] throws ProgrammingError

[mattycakes@…]

When attempting to get a list in random order with MySQL as the backend, this error is thrown:

book_list = books.get_list(slug__ne=kwargs['book'], order_by=['?'])
...
ProgrammingError: (1064, "You have an error in your SQL syntax near '()' at line 1")

I would guess it's a db abstraction issue. MySQL uses ORDER BY RAND() for random ordering, I believe.

Revision 545, MySQL 3.23, Mac OS X.3.9

[mattycakes@…]

In django/core/meta/init.py:

58:  elif f == '?':
59:      output.append('RANDOM()')

needs to be

58:  elif f == '?':
59:      output.append('RAND()')

for MySQL, but I'm guessing that would then break postgres and/or sqlite. Is there an easy way to abstract it?

[Adrian Holovaty]

Added a unit test in [614].

[Adrian Holovaty]

Fixed in [615].