[MYSQL] Text type columns with default value don't export properly

[shubham-yb]

If we have a default value for text type columns in MYSQL, it does not export properly and thus fails during import.

Sample source schema:

drop table if exists text_types;

CREATE TABLE text_types (
                                               id int, 
                                               tt TINYTEXT DEFAULT ('c'), 
                                               te TEXT DEFAULT ('abc'), 
                                               mt MEDIUMTEXT DEFAULT ('abc'), 
                                               lt LONGTEXT DEFAULT ('abc')
                                              );

insert into text_types(id) values(1);

desc text_types;

Exported schema:

CREATE TABLE text_types (
        id numeric(10),
        tt text DEFAULT _utf8mb4\'c\',
        te text DEFAULT _utf8mb4\'abc\',
        mt text DEFAULT _utf8mb4\'abc\',
        lt text DEFAULT _utf8mb4\'abc\'
) ;

Corresponding error: