Skip to content

[Bug]: zlib compressed columns return inproper prefilled edit form, structure export incomplete #20332

Description

@Frankman-DE

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

Image Image Image

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    BugA problem or regression with an existing feature

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions