antares icon indicating copy to clipboard operation
antares copied to clipboard

Cannot change schema of MariaDB table that contains SET

Open 64knl opened this issue 1 year ago • 1 comments

Describe the bug When updating any change to the schema of a SQL table that contains a SET, the update fails.

To Reproduce Steps to reproduce the behavior:

  1. Create a table with a set:
CREATE TABLE `test` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `status` set('PUBLISHED','DELETED')  NOT NULL DEFAULT 'PUBLISHED',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
  1. Try to change a column in Antares
  2. Click save.
  3. See error

Application (please complete the following information):

  • App client: MariaDB
  • App version: 0.7.21

Environment (please complete the following information):

  • OS name: Ubuntu 23.10

64knl avatar Feb 06 '24 13:02 64knl

For this problem I should have a commit ready in the next few hours.

Fabio286 avatar Feb 06 '24 15:02 Fabio286