Comments - COLUMN_CREATE
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Hi,
if I created column with value NULL, it is removed.
For example:
SELECT CONVERT(COLUMN_LIST(COLUMN_CREATE('id', 1, 'txt', NULL)) USING utf8) AS json_data```
returns only "id", without "txt", because its value is NULL.
This is unwanted in some our scenarios, when we define virtuals columns for COLUMN_JSON(). We need to have all columns in JSON, included nullable.
Is there any way, how to keep columns with NULL value?