Skip to content

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

Open
@64knl

Description

@64knl

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

Metadata

Metadata

Assignees

Type

No type

Projects

Status

⏳ In progress

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions