"select from t,t2 where knn" crashes

[sanikolaev]

Bug Description:

mysql> drop table if exists t; create table t(f text, v float_vector knn_type='hnsw' HNSW_SIMILARITY='l2' MODEL_NAME='sentence-transformers/all-MiniLM-L6-v2' from='f'); drop table if exists t2; create table t2(f text, v float_vector knn_type='hnsw' HNSW_SIMILARITY='l2' MODEL_NAME='sentence-transformers/all-MiniLM-L6-v2' from='f'); insert into t(id, f) values(1, 'dog'); insert into t2(id, f) values(2, 'cat'); select f from t,t2 where knn(v, 'puppy');
--------------
drop table if exists t
--------------

Query OK, 0 rows affected (0.003 sec)

--------------
create table t(f text, v float_vector knn_type='hnsw' HNSW_SIMILARITY='l2' MODEL_NAME='sentence-transformers/all-MiniLM-L6-v2' from='f')
--------------

Query OK, 0 rows affected (0.002 sec)

--------------
drop table if exists t2
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
create table t2(f text, v float_vector knn_type='hnsw' HNSW_SIMILARITY='l2' MODEL_NAME='sentence-transformers/all-MiniLM-L6-v2' from='f')
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
insert into t(id, f) values(1, 'dog')
--------------

Query OK, 1 row affected (0.015 sec)

--------------
insert into t2(id, f) values(2, 'cat')
--------------

Query OK, 1 row affected (0.005 sec)

--------------
select f from t,t2 where knn(v, 'puppy')
--------------

ERROR 2013 (HY000): Lost connection to MySQL server during query

Manticore Search Version:

Manticore 25.11.2 f5d9cecd5@26051001 dev (columnar 13.2.6 0b37507@26042817) (secondary 13.2.6 0b37507@26042817) (knn 13.2.6 0b37507@26042817) (embeddings 1.1.1 0b37507@26042817)

Operating System Version:

macos

Have you tried the latest development version?

No

Internal Checklist:

^{To be completed by the assignee. Check off tasks that have been completed or are not applicable.}

Details

• Implementation completed
• Tests developed
• Documentation updated
• Documentation reviewed