After a failed attempt to create vector index temporary file remains and prevents further operation

--source include/have_innodb.inc

--let $datadir= `select @@datadir`

CREATE TABLE t (a INT) ENGINE=InnoDB;

INSERT INTO t VALUES (1);

--error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD

ALTER TABLE t ADD v BLOB NOT NULL, ADD VECTOR INDEX (v);

--list_files $datadir/test/ #*

ALTER TABLE t ADD v BLOB NOT NULL DEFAULT x'00000000', ADD VECTOR INDEX (v);

# Cleanup

DROP TABLE t;

ALTER TABLE t ADD v BLOB NOT NULL, ADD VECTOR INDEX (v);

ERROR 22007: Incorrect vector value: '...' for column `test`.`t`.`v` at row 1

#sql-alter-26b5e1-4#i#00.ibd

ALTER TABLE t ADD v BLOB NOT NULL DEFAULT x'00000000', ADD VECTOR INDEX (v);

bug.vec2                                 [ fail ]

        Test ended at 2024-09-27 01:23:14

CURRENT_TEST: bug.vec2

mysqltest: At line 11: query 'ALTER TABLE t ADD v BLOB NOT NULL DEFAULT x'00000000', ADD VECTOR INDEX (v)' failed: ER_TABLE_EXISTS_ERROR (1050): Table '`test`.`#sql-alter-26b5e1-4#i#00`' already exists