Empty dictionary value in SQL Table

You are viewing an old version of this question. View the current version here.

MariaDB (10.3.24) outputs Warning messages as shown below

[Warning] Aborted connection 29 to db: 'db' user: 'root' host: 'localhost' (Got an error reading communication packets)

due to a table (configuration) containing empty dictionary value for a field of type MediumText. INSERT INTO configuration VALUES (1,'{}');

Changing the '{}' to any other value, say, [] clears the message.

I am not an SQL expert and this is legacy code. Is there a better way to initialize with an empty dictionary value? We transitioned to MariaDB from MySQL recently.

Thanks

Comments

Comments loading...
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.