Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Not a Bug
-
10.3.25
-
Server version: 10.3.25-MariaDB-0ubuntu0.20.04.1 Ubuntu 20.04
Description
In MySQL Workbench, I created a data model. That model has a table where I set two columns to take unique values. The script part is the following:
bq. CREATE TABLE IF NOT EXISTS `tennisMath`.`Court` (
|
bq. `idCourt` INT NOT NULL AUTO_INCREMENT,
|
bq. `letterNumber` CHAR(2) NOT NULL,
|
bq. `surface` ENUM('grass', 'clay') NOT NULL,
|
bq. PRIMARY KEY (`idCourt`),
|
bq. UNIQUE INDEX `idCourt_UNIQUE` (`idCourt` ASC) VISIBLE,
|
bq. UNIQUE INDEX `letterNumber_UNIQUE` (`letterNumber` ASC) VISIBLE)
|
bq. ENGINE = InnoDB;
|
Once I forward-engineer the script, I get the following error message:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '
UNIQUE INDEX `letterNumber_UNIQUE` (`letterNumber` ASC) VISIBLE)