Comments - COLUMN_CREATE

7 years, 2 months ago Ján Regeš

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?

 
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.