[TASK] Fix MySQL errors in functional tests with sql_mode=STRICT_TRANS_TABLES

* Set empty values for text columns without a default value