What is the 'natural order' of a select?

#11

On 24-02-11 21:32, Peter H. Coffin wrote:

Quote:

On Thu, 24 Feb 2011 15:06:12 +0000, The Natural Philosopher wrote:
Peter H. Coffin wrote:
Which might be in oder written, which might be tempered by reuse of
rows, which might be altered by whatever results are lying around in a
cache.

In short, there is no "natural order".

well obviously there IS, but it is not something that is reliably the
same ..

Okay then, "whatever order it comes out". The problem with sticking a
"natural order" on that concept is that it leads people to think that
this order is derivable, predictable, or even repeatable. And that's
unreliable to the point of "IT'S A TRAP! RUN!" levels of unreliable.
It's not an order at all like ORDER BY is an order.

it is, and remains, the unpredictable order.....

--
Luuk

#12

Luuk wrote:

Quote:

On 24-02-11 21:32, Peter H. Coffin wrote:
On Thu, 24 Feb 2011 15:06:12 +0000, The Natural Philosopher wrote:
Peter H. Coffin wrote:
Which might be in oder written, which might be tempered by reuse of
rows, which might be altered by whatever results are lying around in a
cache.

In short, there is no "natural order".

well obviously there IS, but it is not something that is reliably the
same ..
Okay then, "whatever order it comes out". The problem with sticking a
"natural order" on that concept is that it leads people to think that
this order is derivable, predictable, or even repeatable. And that's
unreliable to the point of "IT'S A TRAP! RUN!" levels of unreliable.
It's not an order at all like ORDER BY is an order.

it is, and remains, the unpredictable order.....

And what is more natural than that?
:-)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

What is the 'natural order' of a select?

comp.databases.mysql comp.databases.mysql

Re: What is the 'natural order' of a select? - 02-24-2011 , 03:17 PM

Re: What is the 'natural order' of a select? - 02-25-2011 , 06:57 AM