I'm not seeing this failure on SQLite, Postgres or MySQL. However, I
was testing using my own test models, not your models - it's possible
that the problem could be caused by the interaction of some other
property of your model on the aggregate query.
Can you provide the full definition of the TaggedItem model you are
using? It would also be helpful to know the database version and
operating system you are using.
Yours,
Russ Magee %-)
I can now confirm I am seeing the same problem. It appears that the
table names aren't being correctly promoted in the GROUP BY clause for
the inner query.
If you could open a ticket providing all the detail you have provided
here, I will ensure this bug gets fixed before we release v1.1
Many Thanks,
Russ Magee %-)