It works except subqueries. Main table's order is added to subquery and vice versa. SQL query looks like this:
SELECT t.id AS t_id FROM ticket_d_c9999_record t WHERE (t.id = (SELECT MAX(t2.id) AS t20 FROM ticket_d_c9999__record t2 ORDER BY t.id ASC, t2.id ASC)) ORDER BY t.id ASC, t2.id ASC
Query fails because there is >>no such column "t.id"<<.
I include a testcase when it is all visible.
BTW. there is nothing about that feature (and relation orderBy) in docs. It is only in UPGRADE file.