Bug #87939 | Combining CTE and Window Function gives wrong result | ||
---|---|---|---|
Submitted: | 2 Oct 2017 9:00 | Modified: | 5 Oct 2017 16:40 |
Reporter: | Bernt Marius Johnsen | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S2 (Serious) |
Version: | 8.0.3 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[2 Oct 2017 9:00]
Bernt Marius Johnsen
[5 Oct 2017 16:40]
Paul DuBois
Posted by developer: Fixed in 8.0.4. Queries with a common table expression and a derived table or view that contained a window function produced incorrect results.
[10 Oct 2018 12:57]
Jimy MARCHAND
I have this problem on 8.0.11