Re: [Maria-developers] FOR UPDATE behavior change in 10.3-MDEV-11953

12 Apr 2018

      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>