antares
antares copied to clipboard
Cannot change schema of MariaDB table that contains 'NULL CHECK (json_valid(`example`))'
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:
- Create a new table
CREATE TABLE `test` (
`example` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`properties`))
) ENGINE=InnoDB;
- Rename the column in Antares.
- 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
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.