[MDEV-27651] Allow JSON_NORMALIZE before inserting values Created: 2022-01-27 Updated: 2022-01-27 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | JSON |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Trevor Gross | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Description |
|
Could the possibility be added to normalize any JSON that is inserted/updated by default? This saves a lot of space (if the JSON is formatted / space separated) and should theoretically speed up a handful of other JSON functions. Maybe a possible syntax could be something like `ON UPDATE JSON_NORMALIZE` This is of course possible with a trigger, but having it built in seems useful. |