mysql8索引与顺序无关,在MySQL 8.0.11上不正确使用空间/全文/哈希索引和显式索引顺序...

I run Forward Engineer of sakila_full.mwb on MySQL Workbench 6.3.10.

MySQL Server version is 8.0.11.

-- -----------------------------------------------------

-- Table `sakila`.`film_text`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `sakila`.`film_text` (

`film_id` SMALLINT UNSIGNED NOT NULL,

`title` VARCHAR(255) NOT NULL,

`description` TEXT NULL,

PRIMARY KEY (`film_id`),

FULLTEXT INDEX `idx_title_description` (`title` ASC, `description` ASC))

ENGINE = InnoDB

I got following error.

ERROR: Error 1221: Incorrect usage of spatial/fulltext/hash index and explicit index order

Why?

Update1

I tried a fulltext index is only for TEXT type columns.following this.

-- -----------------------------------------------------

-- Table `sakila`.`film_text`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `sakila`.`film_text` (

`film_id` SMALLINT UNSIGNED NOT NULL,

`title` VARCHAR(255) NOT NULL,

`description` TEXT NULL,

PRIMARY KEY (`film_id`),

FULLTEXT INDEX `idx_title_description` (`description` ASC))

ENGINE = InnoDB

But i got same error.

Error Code: 1221. Incorrect usage of spatial/fulltext/hash index and explicit index order

解决方案

That's already been self-settled.

I removed ASC.

-- -----------------------------------------------------

-- Table `sakila`.`film_text`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `sakila`.`film_text` (

`film_id` SMALLINT UNSIGNED NOT NULL,

`title` VARCHAR(255) NOT NULL,

`description` TEXT NULL,

PRIMARY KEY (`film_id`),

FULLTEXT INDEX `idx_title_description` (`title`, `description`))

ENGINE = InnoDB

Thank you.

Update1

MySQL Workbench 8.0.11 fixed.