Opened 12 hours ago

Last modified 5 hours ago

#36134 assigned New feature

Add "ABSENT ON NULL" to JsonArray — at Version 1

Reported by: john-parton Owned by:
Component: Database layer (models, ORM) Version: dev
Severity: Normal Keywords:
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description (last modified by john-parton)

On all backends except Sqlite and Postgres version 15 and earlier, there is an additional clause to the JSON_ARRAY SQL which controls whether SQL NULL values are mapped to JSON null values or whether they are omitted.

In sqlite and postgres 15 and earlier, the default behavior is to map them, so my initial feature for JsonArray just had that as the only behavior without any ability to customize on the richer backends.

It would be nice if there was a simple on_null parameter to JSON ARRAY to control the behavior.

Pull request here: ​https://github.com/django/django/pull/19097

Change History (1)

comment:1 by john-parton, 12 hours ago

Description: modified (diff)

Pull Request here: ​​https://github.com/django/django/pull/19097

Last edited 12 hours ago by john-parton (previous) (diff)
Note: See TracTickets for help on using tickets.
Back to Top