satch_boogie satch_boogie - 4 months ago 9
MySQL Question

why is select query showing unsorted result in mysql cluster?

the query

"select * from table_name; "
shows different row results when run multiple times. Is this default behaviour of mysql ndbcluster ? Im currently using group by to sort the results

Version:-MySQL-Cluster-server-gpl-7.4.11 on centos 6.7

Answer

If you want that the result is sorted by a column (or more) you must add the order by clause (the SQL for default don't order the result)

select * from table_name order by your_column_for_order;