MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Is the query order guaranteed using Btree indexes and no ORDER BY
Posted by: Peter Brawley
Date: May 29, 2019 03:00PM

Quote

From the literature the below query rows/results should be ordered by columns c1, c2, c10 where c10 may have 1 or more distinct values.

Eh? What literature is that?

A fundamental rule of relational databases (eg EF Codd's rule 8) is that query order is undefined unless specified.

If you want to specify order, add an Order By clause.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Is the query order guaranteed using Btree indexes and no ORDER BY
966
Ted Johnson
May 29, 2019 02:12PM
Re: Is the query order guaranteed using Btree indexes and no ORDER BY
466
Peter Brawley
May 29, 2019 03:00PM
Re: Is the query order guaranteed using Btree indexes and no ORDER BY
445
Ted Johnson
May 29, 2019 04:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.