Re: [Django] #34967: Queries not generating GROUP BY clause with static annotation crashes on SQLite

2023-11-13 Thread Django 
#34967: Queries not generating GROUP BY clause with static annotation crashes on
SQLite
-+-
 Reporter:  Simon Legtenborg |Owner:  David
 |  Sanders
 Type:  Bug  |   Status:  closed
Component:  Database layer   |  Version:  4.2
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  fixed
 Keywords:  sqlite   | 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 Mariusz Felisiak ):

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


Comment:

 In [changeset:"b863c5ffde0bafa5eaa9f262103eaeb71877787c" b863c5ff]:
 {{{
 #!CommitTicketReference repository=""
 revision="b863c5ffde0bafa5eaa9f262103eaeb71877787c"
 Fixed #34967 -- Fixed queryset crash when grouping by constants on SQLite
 < 3.39.

 On SQLite < 3.39, this forces a GROUP BY clause with a HAVING clause
 when no grouping is specified.

 Co-authored-by: Simon Charette 
 }}}

-- 
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/0107018bc8978dc2-03943ed4-5956-4a3f-bca3-79d33b01f10f-00%40eu-central-1.amazonses.com.

Re: [Django] #34967: Queries not generating GROUP BY clause with static annotation crashes on SQLite

2023-11-13 Thread Django 
#34967: Queries not generating GROUP BY clause with static annotation crashes on
SQLite
-+-
 Reporter:  Simon Legtenborg |Owner:  David
 |  Sanders
 Type:  Bug  |   Status:  assigned
Component:  Database layer   |  Version:  4.2
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:  sqlite   | 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 Mariusz Felisiak):

 * 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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/0107018bc8604b57-ca212d41-2625-48a7-bbd6-05c9859bbddd-00%40eu-central-1.amazonses.com.

Re: [Django] #34967: Queries not generating GROUP BY clause with static annotation crashes on SQLite

2023-11-12 Thread Django 
#34967: Queries not generating GROUP BY clause with static annotation crashes on
SQLite
-+-
 Reporter:  Simon Legtenborg |Owner:  David
 |  Sanders
 Type:  Bug  |   Status:  assigned
Component:  Database layer   |  Version:  4.2
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:  sqlite   | Triage Stage:  Accepted
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by David Sanders):

 Jacob & Simon discovered this is only for SQLite <= 3.39.0 which allowed a
 HAVING clause without a GROUP BY:
 https://www.sqlite.org/releaselog/3_39_0.html

-- 
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/0107018bc6965601-a0320d82-9b87-4dc5-9454-4920b8bc85d7-00%40eu-central-1.amazonses.com.

Re: [Django] #34967: Queries not generating GROUP BY clause with static annotation crashes on SQLite

2023-11-12 Thread Django 
#34967: Queries not generating GROUP BY clause with static annotation crashes on
SQLite
-+-
 Reporter:  Simon Legtenborg |Owner:  David
 |  Sanders
 Type:  Bug  |   Status:  assigned
Component:  Database layer   |  Version:  4.2
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:  sqlite   | Triage Stage:  Accepted
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by David Sanders):

 * owner:  nobody => David Sanders
 * status:  new => assigned
 * has_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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/0107018bc3d1d6c4-0f10c259-6d03-4e2b-ac1d-7a016fd242ab-00%40eu-central-1.amazonses.com.

Re: [Django] #34967: Queries not generating GROUP BY clause with static annotation crashes on SQLite (was: Django ORM not generating GROUP BY clause with static annotation)

2023-11-12 Thread Django 
#34967: Queries not generating GROUP BY clause with static annotation crashes on
SQLite
-+-
 Reporter:  Simon Legtenborg |Owner:  nobody
 Type:  Bug  |   Status:  new
Component:  Database layer   |  Version:  4.2
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:  sqlite   | Triage Stage:  Accepted
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by David Sanders):

 * keywords:   => sqlite


Comment:

 This appears to only affect SQLite.

 I haven't tested on Oracle.

-- 
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/0107018bc3a84958-461de9ad-3486-4f77-a6a5-8679808a6f58-00%40eu-central-1.amazonses.com.