#25507: Can't count when using annotate(field=RawSQL(sql)) when sql is a constant -------------------------------------+------------------------------------- Reporter: acatton | Owner: nobody Type: Bug | Status: new Component: Database layer | Version: 1.8 (models, ORM) | Severity: Normal | Resolution: Keywords: RawSQL filter ORM | Triage Stage: Accepted sql | Has patch: 0 | Needs documentation: 0 Needs tests: 0 | Patch needs improvement: 0 Easy pickings: 0 | UI/UX: 0 -------------------------------------+-------------------------------------
Comment (by jarshwah): I agree, this doesn't need to be a release blocker. The rationale behind the query not working on postgres is that non-integer constants in a group by do not actually affect the query at all. It'd arguably be a warning "are you sure you meant.." but I really don't think this should blow up. That's a postgres issue though, so not much point debating the merits. I think documenting the limitation is enough as akaariai suggested. Will a parameterised constant `Value()` not blow up like the static RawSQL? If so, then that's the obvious solution to document. -- Ticket URL: <https://code.djangoproject.com/ticket/25507#comment:5> Django <https://code.djangoproject.com/> The Web framework for perfectionists with deadlines. -- You received this message because you are subscribed to the Google Groups "Django updates" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-updates+unsubscr...@googlegroups.com. To post to this group, send email to django-updates@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/065.ef0fcdaba35b404d374ad5797ffe9dc9%40djangoproject.com. For more options, visit https://groups.google.com/d/optout.