maria-developers team mailing list archive

[Alexander Barkov <bar@xxxxxxxxxxx>]

On 04/12/2018 09:11 AM, Alexander Barkov wrote:
<cut>
>>
>>>
>>> Anyway you can't use anymore:
>>> SELECT c FROM t1 ORDER BY a
>>> UNION
>>> SELECT c FROM t2 ORDER BY b
>>> ORDER BY c.
>>>
>>> You have to put it so:
>>> (SELECT c FROM t1 ORDER BY a)
>>> UNION
>>> (SELECT c FROM t2 ORDER BY b)
>>> ORDER BY c.
>>>
>>> (see the standard).
>>
>> I like this change.

Sorry, I misread the query.

This was not actually not possible in 10.3:

SELECT c FROM t1 ORDER BY a
UNION
SELECT c FROM t2 ORDER BY b
ORDER BY c;


>>
<cut>