Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
64knl opened this issue Feb 6, 2024 · 1 comment
Assignees
Labels
bug 🪲 Something isn't working MySQL/MariaDB🐬

Comments

@64knl
Copy link
Contributor

64knl commented Feb 6, 2024

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 64knl changed the title Cannot change schema of MariaDB table that contains 'NULL CHECK (json_valid(properties))' Cannot change schema of MariaDB table that contains 'NULL CHECK (json_valid(example))' Feb 6, 2024
@Fabio286 Fabio286 added bug 🪲 Something isn't working MySQL/MariaDB🐬 labels Feb 6, 2024
@Fabio286
Copy link
Member

Fabio286 commented Feb 7, 2024

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug 🪲 Something isn't working MySQL/MariaDB🐬
Projects
Status: 📌 To do
Development

No branches or pull requests

2 participants