Skip to content

CREATE TABLE ... CHECK() . support #2

Description

@igorky

Expected behavior

Please add support of CHECK section in create table statement.

Current behavior

No information on UI.
No information about CHECK section in the "CREATE code" tab.

Failure information (for bugs)

Steps to reproduce

CREATE TABLE test_json (
test_col LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin'
)
ENGINE=InnoDB;

ALTER TABLE test_json
ADD CHECK(JSON_VALID(test_col));

Context

Please provide any relevant information about your setup. This is important in case the issue is not reproducible except for under certain conditions.

  • HeidiSQL version: r5184
  • Database system + version: MariaDB 10.2.10
  • Operating system: Win10

Failure Logs

Please include any relevant log snippets or files here.

Metadata

Metadata

Assignees

No one assigned

    Labels

    featureA new feature to implementneeds-infoReport needs and waits for additional feedbacknettype-mysqlMySQL and/or MariaDB specific issue

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions