#34449: ProgrammingError: non-integer constant in GROUP BY with Case When and
annotate Count
-------------------------------------+-------------------------------------
Reporter: Guillaume LEBRETON | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 4.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Guillaume LEBRETON):
* status: closed => new
* resolution: invalid =>
Comment:
Replying to [comment:2 David Sanders]:
> Marking invalid. Please reopen if more information comes to light :)
Hello, you're right, on main the issue is not there, but seems to be in
4.1.7, which appear to be the lastest version available via pip. So maybe
that's a bug that was corrected recently ?
I made this branch from a fork, that i derived from the 4.1.7 tag.
https://github.com/Guilouf/django/tree/4.1.7-bug
I you launch the the command ` python runtests.py z_bug` the test should
fail like in my first example. You will aslo need to configure
user/password in the test_sqlite.py file (which is juste a setting file
from what i understood.)
I am running with python 3.11 and postgres 15, and here is my pip freeze
output.
{{{
aiohttp==3.8.4
aiosignal==1.3.1
aiosmtpd==1.4.4.post2
argon2-cffi==21.3.0
argon2-cffi-bindings==21.2.0
asgiref==3.6.0
async-generator==1.10
async-timeout==4.0.2
atpublic==3.1.1
attrs==22.2.0
bcrypt==4.0.1
black==23.3.0
certifi==2022.12.7
cffi==1.15.1
charset-normalizer==3.1.0
click==8.1.3
colorama==0.4.6
-e
git+https://github.com/Guilouf/django.git@8029f2c03a94cab7c3525bdfaa66c2025722d2ec#egg=Django
docutils==0.19
exceptiongroup==1.1.1
frozenlist==1.3.3
geoip2==4.6.0
h11==0.14.0
idna==3.4
Jinja2==3.1.2
MarkupSafe==2.1.2
maxminddb==2.2.0
multidict==6.0.4
mypy-extensions==1.0.0
numpy==1.24.2
outcome==1.2.0
packaging==23.0
pathspec==0.11.1
Pillow==9.4.0
platformdirs==3.2.0
psycopg2==2.9.5
pycparser==2.21
pymemcache==4.0.0
PySocks==1.7.1
pytz==2023.3
PyYAML==6.0
redis==4.5.4
requests==2.28.2
selenium==4.8.3
sniffio==1.3.0
sortedcontainers==2.4.0
sqlparse==0.4.3
tblib==1.7.0
trio==0.22.0
trio-websocket==0.10.2
tzdata==2023.3
urllib3==1.26.15
wsproto==1.2.0
yarl==1.8.2
}}}
As it should now totally reproducible i re open the ticket
--
Ticket URL: <https://code.djangoproject.com/ticket/34449#comment:4>
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 view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/0107018737d9af95-a4e016e9-140d-46d3-80ca-cdfdbd379a85-000000%40eu-central-1.amazonses.com.
