2012/3/30 Richard Huxton <dev@archonet.com>:
> On 29/03/12 23:28, Pavel Stehule wrote:
>>
>> select anum from t1 where anum = 4
>> union all select 100 limit 1;
>
>
> I'm not sure the ordering here is guaranteed by the standard though, is it?
> You could end up with the 4 being discarded.
A order is random for only "UNION", "UNION ALL" should to respect
order. But I didn't check it in standard.
Pavel
>
> --
> Richard Huxton
> Archonet Ltd
