create table t (v vector(1) not null, vector(v) distance=cosine m=42);

show create table t;

set sql_mode=NO_KEY_OPTIONS;

show create table t;

# Cleanup

drop table t;

set sql_mode=NO_KEY_OPTIONS;

show create table t;

Table	Create Table

t	CREATE TABLE `t` (

  `v` vector(1) NOT NULL,

  VECTOR KEY `v` (`v`) `distance`=cosine `m`=42

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci