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".

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.