subject:"\[Django\] #27849\: Add SQL 2003 FILTER syntax support with Case\(When\(\)\) fallback to aggregates"

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates

2022-11-07 Thread Django

#27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to 
aggregates
-+-
 Reporter:  Tom Forbes   |Owner:  Tom
 |  Forbes
 Type:  New feature  |   Status:  closed
Component:  Database layer   |  Version:  dev
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  fixed
 Keywords:   | Triage Stage:  Ready for
 |  checkin
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by Mariusz Felisiak ):

 In [changeset:"967f8750ab63f9ca74ce63ada580ccc5b10b3f3b" 967f875]:
 {{{
 #!CommitTicketReference repository=""
 revision="967f8750ab63f9ca74ce63ada580ccc5b10b3f3b"
 Refs #27849 -- Fixed filtered aggregates crash on filters that match
 everything.
 }}}

-- 
Ticket URL: 
Django 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/0107018451510c3e-7bb5e378-83b2-4d55-992e-1c274a5af2e6-00%40eu-central-1.amazonses.com.

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates

2022-11-07 Thread Django

#27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to 
aggregates
-+-
 Reporter:  Tom Forbes   |Owner:  Tom
 |  Forbes
 Type:  New feature  |   Status:  closed
Component:  Database layer   |  Version:  dev
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  fixed
 Keywords:   | Triage Stage:  Ready for
 |  checkin
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by Mariusz Felisiak ):

 In [changeset:"77cf70ea9699c3c4e74663955998753d70f65166" 77cf70ea]:
 {{{
 #!CommitTicketReference repository=""
 revision="77cf70ea9699c3c4e74663955998753d70f65166"
 Refs #27849 -- Added test for filtered aggregates with empty conditions.
 }}}

-- 
Ticket URL: 
Django 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/0107018451510c0a-c5c3d96f-1dac-43e0-a2d6-988a77bf9194-00%40eu-central-1.amazonses.com.

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates

2017-12-08 Thread Django

#27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to 
aggregates
-+-
 Reporter:  Tom Forbes   |Owner:  Tom
 |  Forbes
 Type:  New feature  |   Status:  closed
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  fixed
 Keywords:   | Triage Stage:  Ready for
 |  checkin
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by Tim Graham ):

 In [changeset:"b43acf22dfa59815a1f4db0558acd98816325f66" b43acf22]:
 {{{
 #!CommitTicketReference repository=""
 revision="b43acf22dfa59815a1f4db0558acd98816325f66"
 Refs #27849 -- Removed empty Q() hack in filtered Aggregate.as_sql().

 This required allowing WhereNode to be provided as When(condition).

 This was made possible by cf12257db23fa248c89a3da3f718aa01a50ca659.
 }}}

-- 
Ticket URL: 
Django 
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/061.b429e1c670fe3cad5d16df9f06e51f2c%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates

2017-08-12 Thread Django

#27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to 
aggregates
-+-
 Reporter:  Tom  |Owner:  Tom
 Type:  New feature  |   Status:  closed
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  fixed
 Keywords:   | Triage Stage:  Ready for
 |  checkin
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by Tim Graham ):

 * status:  assigned => closed
 * resolution:   => fixed


Comment:

 In [changeset:"b78d100fa62cd4fbbc70f2bae77c192cb36c1ccd" b78d100f]:
 {{{
 #!CommitTicketReference repository=""
 revision="b78d100fa62cd4fbbc70f2bae77c192cb36c1ccd"
 Fixed #27849 -- Added filtering support to aggregates.
 }}}

-- 
Ticket URL: 
Django 
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/061.25e3c66ebbe8e8fceeb9be7715832984%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates

2017-07-29 Thread Django

#27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to 
aggregates
-+-
 Reporter:  Tom  |Owner:  Tom
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:   | Triage Stage:  Ready for
 |  checkin
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by felixxm):

 * stage:  Accepted => Ready for checkin


-- 
Ticket URL: 
Django 
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/061.f2e6eee169ad4917f37cb4acf9615a1c%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates

2017-07-21 Thread Django

#27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to 
aggregates
-+-
 Reporter:  Tom  |Owner:  Tom
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:   | Triage Stage:  Accepted
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by Tom):

 * owner:  nobody => Tom
 * needs_better_patch:  1 => 0
 * status:  new => assigned


Comment:

 I've made the changes requested in the github ticket, any reviews would be
 appreciated.

-- 
Ticket URL: 
Django 
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/061.b3472ab3d1f297f6b2bbf727d7b325e9%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates

2017-07-20 Thread Django

#27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to 
aggregates
-+-
 Reporter:  Tom  |Owner:  nobody
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:   | Triage Stage:  Accepted
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  1
Easy pickings:  0|UI/UX:  0
-+-
Changes (by felixxm):

 * needs_better_patch:  0 => 1


-- 
Ticket URL: 
Django 
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/061.5121d37134174a5f23de2f2013e149cc%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates

2017-06-09 Thread Django

#27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to 
aggregates
-+-
 Reporter:  Tom  |Owner:  nobody
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:   | Triage Stage:  Accepted
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by Simon Charette):

 * needs_better_patch:  1 => 0


--
Ticket URL: 
Django 
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/061.801b07cd494b9b8eb9c903c1acbf913c%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates (was: Support Postgres FILTER WHERE conditions in ArrayAgg)

2017-05-02 Thread Django

#27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to 
aggregates
-+-
 Reporter:  Tom  |Owner:  nobody
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:   | Triage Stage:  Accepted
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  1
Easy pickings:  0|UI/UX:  0
-+-
Changes (by Simon Charette):

 * owner:  (none) => nobody
 * needs_better_patch:  0 => 1
 * has_patch:  0 => 1
 * component:  contrib.postgres => Database layer (models, ORM)


Comment:

 [https://github.com/django/django/pull/8352 PR]

--
Ticket URL: 
Django 
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/061.0292d21c378d16effcef80c9fc136c04%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates

Re: [Django] #27849: Add SQL 2003 FILTER syntax support with Case(When()) fallback to aggregates (was: Support Postgres FILTER WHERE conditions in ArrayAgg)

9 matches

Site Navigation

Mail list logo

Footer information