Open JackAtOmenApps opened 2 years ago
This is due to new Django versions allowing a default auto field of various types. In the past it was only an AutoField (::integer), but now the user can set it as a BigAutoField (::bigint), or UUIDField (::uuid).
https://docs.djangoproject.com/en/3.2/topics/db/models/#automatic-primary-key-fields
Additionally, the pkid
type may be set manually per-model. Need to be able to account for this in the query.
When performing path queries, the path is cast as
bigint
while the array of ids is cast asinteger
Example query explain from our codebase:
Result: