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.
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_colLONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin')
ENGINE=InnoDB;
ALTER TABLE
test_jsonADD 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.
Failure Logs
Please include any relevant log snippets or files here.