郗君

**Describe the bug** Using group_by causes an error when two tables have the same field **To Reproduce** `class Message(BaseModelMixin): createtime=fields.DatetimeField(auto_now_add=True) from_user=fields.ForeignKeyField('models.User',null=True,on_delete=fields.SET_NULL,related_name='from_user') ... class User(BaseModelMixin): createtime=fields.DatetimeField(auto_now_add=True) ... await Message.filter(to_user=request.user,is_read=0).annotate(count=Count("id"))\ .group_by('from_user__id','from_user__nickname','content','createtime').order_by('-createtime')\ .values('from_user__id','from_user__nickname','content','createtime')`...

pgsql delete left join error

4

`await Objectives.filter(student__user_id=request.user.id).filter(reward_id__isnull=True).delete()` the query is: `DELETE FROM "objectives" LEFT OUTER JOIN "student" "objectives__student" ON "objectives__student"."id"="objectives"."student_id" WHERE "objectives__student"."user_id"=1 AND "objectives"."reward_id" IS NULL` It doesn't work I copy the sql into navicat,return...