ORDER BY in subquery does not work as expected (wrong results)

From: https://groups.google.com/forum/#!topic/mariadb-columnstore/xEWtv_bWlwI

Hi all,

while testing I found that the following query type produces unexpected (I'd say wrong) results.

SELECT .. FROM (SELECT .. FROM .. ORDER BY 1) LIMIT 10

That is, if an inner query has an ORDER BY clause and the outer query a LIMIT clause then the ordering is not preserved. This behavior is different from say the InnoDB storage engine. Is that intentional?

Regards,
Arno