antares icon indicating copy to clipboard operation
antares copied to clipboard

Cannot change schema of MariaDB table that contains 'NULL CHECK (json_valid(`example`))'

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

Describe the bug Editing a table to contains the (valid) option 'NULL CHECK (json_valid(properties))' fails. The column cannot be renamed in Antares.

(This is the same kind of problem as: #755 )

To Reproduce Steps to reproduce the behavior:

  1. Create a new table
CREATE TABLE `test` (
  `example` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`properties`))
) ENGINE=InnoDB;
  1. Rename the column in Antares.
  2. 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 14:02 64knl

To fix this issue i need first implement the support to CHECKs from the GUI, in order to manage them at best. I will ensure that it will be one of the next features to be implemented.

Fabio286 avatar Feb 07 '24 08:02 Fabio286