Outer ORDER BY clause has no effect [CORE2871]

[firebird-issue-importer]

Submitted by: @dyemanov

Is related to CORE1089
Is related to QA254

If a derived table (or a view) contains both a left/right join and an ORDER BY clause and the outer query also contains an ORDER BY clause, the latter one gets ignored.

Test query against the EMPLOYEE sample database:

select *
from (
select
emp_no, first_name, last_name, country, currency
from employee
left join country on employee.job_country = country.country
order by last_name
)
order by emp_no desc

The result is ordered by "last_name".

Commits: 3aaa3d1 98e83cd 99ccecb f815326

[firebird-issue-importer]

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

[firebird-issue-importer]

Modified by: @dyemanov

Link: This issue is related to CORE1089 [ CORE1089 ]

[firebird-issue-importer]

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.0.6 [ 10303 ]

Fix Version: 2.5 RC3 [ 10381 ]

Fix Version: 2.1.4 [ 10361 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

[firebird-issue-importer]

Modified by: @pcisar

Link: This issue is related to QA254 [ QA254 ]

[firebird-issue-importer]

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-issue-importer]

Commented by: @pcisar

Test added.

[firebird-issue-importer]

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Done successfully