Opened 7 years ago
Last modified 5 years ago
#28439 closed Bug
When() [on MySQL] does not work with models using UUID as primary key — at Version 1
| Reported by: | Dominik Kozaczko | Owned by: | nobody |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | 2.2 |
| Severity: | Normal | Keywords: | when, |
| Cc: | Triage Stage: | Accepted | |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description (last modified by )
I have a strange issue with When() and models using UUID as their pk.
The DB is MySQL 5.6.23 but I've encountered it also on the newest 5.7 version (which is a pain but it's a different story).
I prepared example project here: https://github.com/dekoza/djanbug
The example.views.myview includes code ported from the app I'm currently developing - I have several models using UUIDs as their PK and I need to do some annotations an aggregations with some specific cases handled with Case()/When() combo.
Even though the db is empty on the example, the view crashes that '1' is not a valid UUID. and the only '1' is the one in When()
I've also encountered issues with Count('*', distinct=True) but right now I'm trying to reproduce it on the example and will post another ticket when I'm done.