Opened 12 hours ago
Last modified 5 hours ago
#36134 assigned New feature
Add "ABSENT ON NULL" to JsonArray — at Initial Version
| 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
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.
Note:
See TracTickets
for help on using tickets.