Exporting table structure with COMPRESSED column - corrupt SQL

[nunoperalta]

As per phpmyadmin/phpmyadmin#14956, if we create a Table that contains one column that is "TEXT COMPRESSED", in MariaDB,
and then we do an Export, the CREATE TABLE statement will be corrupt, starting from the compressed column:

And the "ALTER TABLE ADD KEY" statement that follows also didn't appear.

[shucon]

It's an issue in the parser. I'm unable to fix it but the problem's here: https://github.com/phpmyadmin/phpmyadmin/blob/8d460568f33069fcb3bf30e39b074085d9adec1e/libraries/classes/Plugins/Export/ExportSql.php#L2203

[linaspasv]

Any plans to fix this?

[williamdes]

Any plans to fix this?

Hi @iifawzi
Do you want to contribute to this one?

[iifawzi]

Hi @williamdes, i’m a little bit busy now days, I might be able to look on it after the mid of July

[williamdes]

Hi @williamdes, i’m a little bit busy now days, I might be able to look on it after the mid of July

Sure, no worries
You should apply for GitHub sponsors so I can sponsor you ;)

[iifawzi]

Hi @williamdes, i’m a little bit busy now days, I might be able to look on it after the mid of July

Sure, no worries You should apply for GitHub sponsors so I can sponsor you ;)

Thank you, unfortunately, it’s not supported in Egypt yet.

I might consider applying as a contractor, if there’s a fit, later in September :”)

[williamdes]

Hi @williamdes, i’m a little bit busy now days, I might be able to look on it after the mid of July

Sure, no worries You should apply for GitHub sponsors so I can sponsor you ;)

Thank you, unfortunately, it’s not supported in Egypt yet.

I might consider applying as a contractor, if there’s a fit, later in September :”)

Thank you for the PR!
I advise you to apply 2-3 months ahead ;)