CREATE TABLE t (v VECTOR(1) NOT NULL, VECTOR(v)) ENGINE=MyISAM;

INSERT INTO t (v) VALUES (0x30303030),(0x31313131);

--let $shutdown_timeout=0

--source include/restart_mysqld.inc

CHECK TABLE t EXTENDED;

REPAIR TABLE t EXTENDED;

CHECK TABLE t EXTENDED;

SELECT v FROM t ORDER BY VEC_DISTANCE_EUCLIDEAN(0x323233232,v) LIMIT 1;

# Cleanup

DROP TABLE t;

CHECK TABLE t EXTENDED;

Table	Op	Msg_type	Msg_text

test.t	check	warning	1 client is using or hasn't closed the table properly

test.t	check	status	OK

REPAIR TABLE t EXTENDED;

Table	Op	Msg_type	Msg_text

test.t	repair	status	OK

CHECK TABLE t EXTENDED;

Table	Op	Msg_type	Msg_text

test.t	check	status	OK

SELECT v FROM t ORDER BY VEC_DISTANCE_EUCLIDEAN(0x323233232,v) LIMIT 1;

bug.w2                                   [ fail ]

        Test ended at 2024-10-21 18:28:29

CURRENT_TEST: bug.w2

mysqltest: At line 8: query 'SELECT v FROM t ORDER BY VEC_DISTANCE_EUCLIDEAN(0x323233232,v) LIMIT 1' failed: HA_ERR_CRASHED_ON_USAGE (145): Table './test/t#i#00' is marked as crashed and should be repaired

2024-10-21 18:28:29 3 [ERROR] mariadbd: Table './test/t#i#00' is marked as crashed and should be repaired

2024-10-21 18:28:29 3 [ERROR] Got error 126 when reading table './test/t'

2024-10-21 18:28:29 3 [ERROR] mariadbd: Index for table 't' is corrupt; try to repair it