create table t (v vector(800), key(v));

show create table t;

--exec $MYSQL_DUMP test --tables t | $MYSQL test

drop table t;

create table t (v vector(800), key(v));

Warnings:

Note	1071	Specified key was too long; max key length is 1000 bytes

show create table t;

Table	Create Table

t	CREATE TABLE `t` (

  `v` vector(800) DEFAULT NULL,

  KEY `v` (`v`(1000))

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci

bug.tlc                                  [ fail ]

        Test ended at 2025-01-07 14:59:14

CURRENT_TEST: bug.tlc

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

CREATE TABLE `t` (

  `v` vector(800) DEFAULT NULL,

  KEY `v` (`v`(1000))

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci

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

ERROR 1089 (HY000) at line 26: Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys