Bug #100162 Rank function
Submitted: 8 Jul 2020 19:30 Modified: 9 Aug 2020 4:15
Reporter: Amrit Shrestha Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.20 OS:Windows
Assigned to: Assigned Account CPU Architecture:Any
Tags: Rank windows function

[8 Jul 2020 19:30] Amrit Shrestha 
Description:
Rank and dense_rank windows functions used to work on MySQL Workbench 8.0.18 version but now with latest community version 8.0.19 and 8.0.20, these rank functions are not available.

How to repeat:
sample code:

SELECT X, Y,
	RANK() OVER (ORDER BY X) AS rank_number
FROM Table_A
;

Suggested fix:
need windows rank functions like in older versions.
[8 Jul 2020 22:00] MySQL Verification Team 
Thank you for the bug report. Please provide a complete test case, create table, insert data and the query which doesn't works for you, print the actual result and expected result.
[10 Aug 2020 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".