Move columns with ENUM() & DEFAULT causes invalid SQL

[ChrisHSandN]

Describe the bug

Move columns fails to generate a valid ALTER TABLE statement when used on an ENUM field with a default value.

To Reproduce

Steps to reproduce the behavior:

CREATE TABLE `test` (
  `id` int(11) NOT NULL,
  `enum` enum('yes','no') NOT NULL DEFAULT 'no',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

1. Go to "Structure"
2. Click on "Move columns"
3. Drag enum above id
4. Click Go
5. Error:

# 1067 - Invalid default value for 'enum'

ALTER TABLE `test` 
CHANGE `enum` `enum` ENUM('yes','no') 
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL 
DEFAULT '\'no\'' FIRST

Note the extraneous double quoting of the DEFAULT 'no'

Expected behavior

The move columns feature should produce valid SQL for ENUM fields with a default value.

Screenshots

Server configuration

• Operating system: Rocky 8
• Web server: Apache
• Database version: 10.4.32-MariaDB-
• PHP version: 8.1.26
• phpMyAdmin version: 5.2.1-1

[hesammoosapour]

Same issue here.

[johnson361]

Can anyone please review my PR ?