case when ix.is_unique_constraint = 1 then ' UNIQUE ' else '' END ,case when ix.is_primary_key = 1 then ' PRIMARY KEY ' else '' END , ix.type_desc, case when ix.is_padded=1 then 'PAD_INDEX = ON, ' ...
After creating a table in mysql, and getting the create sql string with SHOW CREATE TABLE, sqlglot is unable to parse the returned string. I expect that sqlglot to correctly parse valid MySQL strings.