cike
7 years agoChampion
Different results for SELECT count(*) and SELECT * ... list size
Hi guys,
I'm a bit confused using APIv2, during some inconsistent results. I execute the following queries to build a custom component and I already tested the query in Studio's API Browser:
SELECT count(*) FROM messages WHERE board.id = 'tech-experts-blog' AND depth = 0 AND labels.text IN ('Sicherheit')
SELECT * FROM messages WHERE board.id = 'tech-experts-blog' AND depth = 0 AND labels.text IN ('Sicherheit')
The first query (selecting the count) returns a list size of 8, whereas the second query returns only a list size of 7.
The default label widget shows the correct count for each label (7 in this case).
Does anyone have any idea where these difference is coming from? Could it be a bug in Lihtium's API or a data issue?
Best regards,
Christian