Bug #85530 MySql and SQL_CALC_FOUND_ROWS. It seems to be disabling the order by clause.
Submitted: 18 Mar 2017 5:22 Modified: 18 Apr 2017 20:11
Reporter: Phil Wilson Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:5.7.15-0ubuntu0.16.04.1 OS:Any
Assigned to: CPU Architecture:Any
Tags: order by, SELECT, sql_calc_found_rows

[18 Mar 2017 5:22] Phil Wilson 
Description:
I am using MySql and SQL_CALC_FOUND_ROWS. It seems to be disabling the order by clause.

MySql Server version: 5.7.15-0ubuntu0.16.04.1 (Ubuntu)

SELECT SQL_NO_CACHE SQL_CALC_FOUND_ROWS * FROM (

disables the ORDER BY clause

I see it was supposed to be fixed.

Anyone have an ideal on how I can fix this issue?

Thanks Phil

How to repeat:
when I take the SQL_CALC_FOUND_ROWS off the select it work fine.

Any help is great.

Thanks
Phil
[18 Mar 2017 20:11] MySQL Verification Team 
Thank you for the bug report. Please check with current released version 5.7.17 if still you get the same result please provide a complete test case printing the real result and the expected one. Thanks.
[19 Apr 2017 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".