MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

using window functions with "partition by" can give incorrect results
Posted by: Witek Oleksiewicz
Date: July 03, 2018 02:42PM

I have a problem with window functions in MySQL8 - they give incorrect results when applied to large tables (either: large number of rows or large number of columns).

Example: Table: bureau.csv (1.7 mln rows) from https://www.kaggle.com/c/home-credit-default-risk/data

I run 3 simple queries changing only the number of rows of the table to be used and number of columns to be outputed. You can clearly see that the combination of large amount of rows and many outputed columns gives incorrect results of "count(*) over()" - the last column.

More: https://stackoverflow.com/questions/51161778/mysql-8-window-function-wrong-results

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
using window functions with "partition by" can give incorrect results
1475
Witek Oleksiewicz
July 03, 2018 02:42PM


Sorry, you can't reply to this topic. It has been closed.

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.