multiple order by clauses with the sql handler

[radha krishnan]

Hi,

when i was trying out the SQL functionality, i realized that

multiple order by clauses work only when " select distinct " command is
used where as it does not work with a " select "command

Eg:

SELECT distinct name, salary, distance_from_office FROM "employees_core"
ORDER BY salary desc , name desc -- this one works

SELECT name, salary, distance_from_office FROM "employees_core" ORDER BY
salary desc , name desc -- this does not work and fails with the response,


{

  "result-set":{"docs":[

{

    "EXCEPTION":"java.util.concurrent.ExecutionException:
java.io.IOException: --> http://localhost:8983/solr/employees_core/:Can't
determine a Sort Order (asc or desc) in sort spec 'salary descname desc',
pos=6",

    "EOF":true,

    "RESPONSE_TIME":152}]}}



is it by design that multiple order by will work only with select distinct ?




Thanks,

Radhakrishnan D