MSSQL adds a redundant ORDER BY clause when with subquery with ORDER BY

[trusek]

Bug Report

Q	A
BC Break	no
Version	2.12

Summary

I have a query where in the ORDER BY clause I have a subquery with an ORDER BY clause, when I limit the query I get an incorrect query with redundant ORDER BY clause

Current behaviour

Input sql

SELECT col1 FROM test ORDER BY ( SELECT col2 from test ORDER BY col2 )

Output sql

SELECT col1 FROM test ORDER BY ( SELECT col2 from test ORDER BY col2 ) ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY

How to reproduce

/** @var SQLServerPlatform */
$platform;
$querySql = 'SELECT col1 FROM test ORDER BY ( SELECT col2 from test ORDER BY col2 )';
$sql = $platform->modifyLimitQuery($querySql, 10);

Expected behaviour

SELECT col1 FROM test ORDER BY ( SELECT col2 from test ORDER BY col2 ) OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY

[github-actions]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.