Describe the bug
Hi,
not sure if this is a bug report or a feature request, please decide by yourself.
Everytime that I work on compressed columns PMA confuses me a little bit.
Let's create a sample:
CREATE TABLE test.test (`sample_content` LONGTEXT COMPRESSED=zlib CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL ) ENGINE = MyISAM;
On showing the table structure the column type is shown as "longtext /*m!100301 compressed".
When I click on "edit" all params except "attribute" are prefilled correct, but "attribute" should show "compressed=zlib".
Worse:
Exporting the tables' structure ignores the compression at all:
CREATE TABLE test (
sample_content longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
How to Reproduce
No response
Expected behavior
No response
Screenshots
Operating System
No response
Web Server
No response
Database Server
MariaDB
Database version
11.8.8-MariaDB-deb13
PHP version
8.4.21
phpMyAdmin version
5.2.1
browser
No response
Additional context
No response
Describe the bug
Hi,
not sure if this is a bug report or a feature request, please decide by yourself.
Everytime that I work on compressed columns PMA confuses me a little bit.
Let's create a sample:
On showing the table structure the column type is shown as "longtext /*m!100301 compressed".
When I click on "edit" all params except "attribute" are prefilled correct, but "attribute" should show "compressed=zlib".
Worse:
Exporting the tables' structure ignores the compression at all:
CREATE TABLE
test(sample_contentlongtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '') ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
How to Reproduce
No response
Expected behavior
No response
Screenshots
Operating System
No response
Web Server
No response
Database Server
MariaDB
Database version
11.8.8-MariaDB-deb13
PHP version
8.4.21
phpMyAdmin version
5.2.1
browser
No response
Additional context
No response