search

giuseppefutia / geranium

Empowering open publications using Semantics and Deep Learning
GNU General Public License v3.0
3 stars 1 forks source link

Discordance between authors page and single author page #81

Open CosmaVergari opened 4 years ago

CosmaVergari commented 4 years ago

The number of written papers showed in the authors page does not correspond to the real number of papers that is showed in the single author modal. This should not be a problem of the web app but instead a problem of the API as the received JSON contains the same errors but only with different offset numbers .

discordance

Moreover, in the "all authors" view there are several cases of duplications of the same author.
Maybe the duplication error is caused by a the OFFSET working on queries that return different results due to their lack of the ORDER BY? duplicate

Observation: when running the "all authors" query with a big number of lines (LIMIT 100000 OFFSET 0) the results are correct: each authors contains the number of effective papers he wrote and there are no author duplicates. It seems like the problem comes from a combination of LIMIT, OFFSET and the lack of ORDER BY.

mehdikhrichfa commented 4 years ago

Possibly fixed with the latest commit. It still needs to be tested.