advanced patterns with JSON_ARRAY when inserting into MySQL 8.0.26
I'm deploying to production and I'm learning this framework and I'm collaborating on a project where I'm working with an scenario while trying to insert data into a JSON column in MySQL 8.0.26 using the `JSON_ARRAY` function. I have a table `my_table` with a column `data` defined as `JSON`. When I attempt to insert a record using the following query: ```sql INSERT INTO my_table (data) VALUES (JSON_ARRAY('value1', NULL, 'value3')); ``` I expect the `NULL` in the array to be represented as `NULL` in the JSON object. However, after executing the query, I notice that the inserted JSON value appears as `[ "value1", "value3" ]` with the `NULL` entry completely omitted from the array. I thought that using the `JSON_ARRAY` function would retain the `NULL` values as part of the array. To verify this, I also tried inserting directly using: ```sql INSERT INTO my_table (data) VALUES ('["value1", null, "value3"]'); ``` This too resulted in the same output, where `null` was ignored. I have also checked the MySQL documentation, which suggests that `NULL` entries in `JSON_ARRAY` should be maintained. Is there a specific syntax or setting that I might be missing that could cause MySQL to discard the NULL value? I'm currently running a local instance without any specific configurations that might impact JSON handling. Any insights or workarounds would be greatly appreciated. My team is using Sql for this CLI tool.