#30188: Aggregate annotation, Case() - When(): AssertionError No exception
message
supplied
-------------------------------------+-------------------------------------
Reporter: Lukas Klement | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 2.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: query, aggregate, | Triage Stage: Accepted
case/when |
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Can Sarıgöl):
Query like this:
{{{
SELECT COALESCE(
SUM(CASE WHEN (SELECT U0."cost"
FROM "t30188_ingredientdetail"
U0
WHERE U0."ingredient_id" =
(subquery."ingredient_id") LIMIT 1) IS NULL THEN 1 ELSE 1 END), 1)
FROM (SELECT "t30188_recipeingredient"."id" AS Col1,
(SELECT U0."cost"
FROM "t30188_ingredientdetail" U0
WHERE U0."ingredient_id" =
("t30188_recipeingredient"."ingredient_id") LIMIT 1) AS "cost_value",
"U0"."ingredient_id" AS "__col1"
FROM "t30188_recipeingredient"
GROUP BY "t30188_recipeingredient"."id",
(SELECT U0."cost"
FROM "t30188_ingredientdetail" U0
WHERE U0."ingredient_id" =
("t30188_recipeingredient"."ingredient_id") LIMIT 1),
"U0"."ingredient_id") subquery
}}}
the problem is {{{"U0"."ingredient_id" AS "__col1"}}}, It should have been
{{{"t30188_recipeingredient"."ingredient_id"}}}. to solve this, I will
also check your point @Simon Charette thanks.
--
Ticket URL: <https://code.djangoproject.com/ticket/30188#comment:15>
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 [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/070.c86fe689ee500e1413152c382e07ddf5%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
