Bug/improvement: Null last with varchar

[royduin]

For MySQL nulls_last_sql should be set to -%s %s according the docs, but that only works with numeric values. I'd like to use the solution for varchar values: ISNULL(field), field ASC but that requires the column name 2 times which isn't possible with sprintf(); ISNULL(%s), %s %s. It results in: sprintf(): Too few arguments

[yajra]

Thanks for reporting. Does it really need a two column? It seems to work too with SELECT * FROM table ORDER BY ISNULL(field) ASC;

[royduin]

With that query it's only sorted on null / not-null, but the not-null result are not sorted ascending or descending.