The Samba-Bugzilla – Bug 8114
Top function doesn't work right after libDBI move
Last modified: 2011-05-02 13:48:32 UTC
This is an SQL problem, we don't count the total sum of the objects we are looking for. Robert, that was what I asked about recently in #smbta, and the proposed SQL statement doesn't work as it is not taking sum() into account.
This blocks 1.2.4
hope to fix this this week
select distinct filename, share, domain, sum(length) OVER (Partition by filename) from ( select * from read UNION select * from write) as subrequest where 1=1 and 1=1 and 1=1 order by sum(length) OVER (Partition by filename) desc limit 10;
Using the "over" SQL statement fixes this, committed as 6cb0e9e to the devel branch.