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?