CREATE code tab doesn't show COMPRESSED attribute of column for MariaDB

[Rinze-Smits]

Preconditions

• HeidiSQL version: 11.1.0.6141
• Database type and version: MariaDB 10.5.8
• OS: Windows 10 20H2 for HeidiSQL, MariaDB running on Ubuntu 20.04 in WSL 2 docker

Describe the bug

The CREATE code tab doesn't show the COMPRESSED attribute for fields that have it.

To Reproduce

CREATE TABLE `compr_demo` ( `id` INT NOT NULL AUTO_INCREMENT, `a` TEXT NULL, `b` TEXT NULL, PRIMARY KEY (`id`));
ALTER TABLE `compr_demo` MODIFY COLUMN `a` TEXT COMPRESSED;

The CREATE code tab shows:

CREATE TABLE `compr_demo` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`a` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_520_nopad_ci',
	`b` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_520_nopad_ci',
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_unicode_520_nopad_ci'
ENGINE=InnoDB

While

SHOW CREATE TABLE `compr_demo`;

shows the following, including the compressed attribute for column a.

CREATE TABLE `compr_demo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `a` text /*!100301 COMPRESSED*/ COLLATE utf8mb4_unicode_520_nopad_ci DEFAULT NULL,
  `b` text COLLATE utf8mb4_unicode_520_nopad_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_nopad_ci

Screenshots or Crash reports

[ansgarbecker]

Is that COMPRESSED attribute new in MariaDB 10.5?

[antoniopaisfernandes]

Hi,

It was added in 10.3.2: https://mariadb.com/kb/en/storage-engine-independent-column-compression/

Best regards

[pluk77]

Would be great if this could be added as there is currently no indication to show a column is compressed or not. When looking into this, perhaps also see how one could use the table tab to add compression to a field? Unless I missed it.

[pluk77]

Perhaps an 'easy' way to add this is to add compressed data-types for MariaDB as compression can only be added to a small set of data-types. That way the UI is not affected.

[msz5]

At least the CREATE code tab should properly support that. Without that it is dangerous to use it, as you loose information. Is there a reason why the source data of this are not coming from SHOW CREATE TABLE, which would be future proof? Of course the best would be to see that in the column list properly.
The export DB command already includes that info 👍.

[ansgarbecker]

Next builds support that compressed attribute on MariaDB table columns: