I think this is a SQL feature they sort list to use binary search in the index for the table for efficiency).
On May 13, 6:57 am, Francisco Costa <m...@franciscocosta.com> wrote: > is this a SQL Bug/feature? how can I change it? > > On May 13, 11:53 am, Francisco Costa <m...@franciscocosta.com> wrote: > > > I have this query db(db.space.id.belongs(result_id)).select() > > the result id is an unsorted array of ids > > I don't want the query results to be order by id > > > The SQL list this > > SELECT space.id, space.name FROM space WHERE space.id IN > > (1,6,136,2,18,119,122) > > > i want the result to be in the order of the ids array
