Skip to content

[Bug]: mysql8 copy table with DESC index #20276

@AucT

Description

@AucT

Describe the bug

  1. create table dummy_table
  2. create composite index on 3 tables using sql with second index DESC
ALTER TABLE dummy_table
ADD INDEX (column1, column2 DESC, column3);
  1. try copy table (structure + data) with phpmyadmin
  2. See error

How to Reproduce

No response

Expected behavior

should copy it

Screenshots

No response

Operating System

Linux

Web Server

No response

Database Server

No response

Database version

No response

PHP version

7.4.3-4

phpMyAdmin version

5.2.3

browser

No response

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    BugA problem or regression with an existing featureaffects/5.2This issue or pull-request affects 5.2.x releases (and maybe further versions)affects/6.0This issue or pull-request affects 6.0.x releases (and maybe further versions)confirmed/5.2This issue is confirmed to be reproduced on 5.2 at the time this label was setwaiting on upstreamIssues blocked by a third-party

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions