Hi guys, I’ve noticed that when you submit a query like this one: SELECT * FROM bucket WHERE type = ‘voip_call’ and sender = ‘foreign-key’ LIMIT 10 that there’s no default ORDER BY sorting in place and the results I’m getting are randomly selected, which means that the result set changes every ti…

Random result order when not using order by clause

geraldss May 24, 2016, 4:25am 4

There is no issue to be fixed. With N1QL, ORDER BY is required if a specific result order is desired.

Gerald

Topic		Replies	Views
N1QL is not ordering the query Couchbase Server query	2	632	March 5, 2020
Default ordering of resultset using secondary index SQL++ n1ql	6	1833	July 12, 2018
Ordering in select statement SQL++	3	640	November 29, 2019
Issues With Sort Ordering On GROUP BY values SQL++	7	2168	October 25, 2016
N1QL performance reduces drastically on using ORDER BY SQL++	4	2687	January 19, 2016