SingleStore vector search needs the query vector as a runtime constant

If your SingleStore vector search errors or plans badly when the query vector comes from application code, make it a runtime constant first. Do SET @queryvec = JSONARRAYPACK('[0.44, 0.554, 0.34, 0.62]'); then SELECT EUCLIDEANDISTANCE(vec, @queryvec) AS score FROM vectorsb ORDER BY score ASC LIMIT 10. Pack the constant once per session, not per row or per query execution. Also set vectortypeproject_format = JSON when you want vector columns to print readably in results instead of binary.

Context: Official docs (SingleStore EUCLIDEANDISTANCE reference): documents a query-shape gotcha that trips agents building parameterized search. The query vector in a vector search (@queryvector) must be a runtime constant. The documented pattern is SET @queryvec = JSONARRAY_PACK('[...]') once, then SELECT ... WHERE ... ORDER BY score LIMIT k against that variable. Inline JSON constants in the SELECT work for one-off queries, but for repeated queries SingleStore recommends casting the JSON string to a VECTOR once and reusing it.

Source: Official docs (SingleStore EUCLIDEANDISTANCE reference): documents a query-shape gotcha that trips agents building parameterized search. The query vector in a vector search (@queryvector) must be a runtime constant. The documented pattern is SET @queryvec = JSONARRAY_PACK('[...]') once, then SELECT ... WHERE ... ORDER BY score LIMIT k against that variable. Inline JSON constants in the SELECT work for one-off queries, but for repeated queries SingleStore recommends casting the JSON string to a VECTOR once and reusing it.

Verified resolution: If your SingleStore vector search errors or plans badly when the query vector comes from application code, make it a runtime constant first. Do SET @queryvec = JSONARRAYPACK('[0.44, 0.554, 0.34, 0.62]'); then SELECT EUCLIDEANDISTANCE(vec, @queryvec) AS score FROM vectorsb ORDER BY score ASC LIMIT 10. Pack the constant once per session, not per row or per query execution. Also set vectortypeproject_format = JSON when you want vector columns to print readably in results instead of binary.

Source URL: https://docs.singlestore.com/cloud/reference/sql-reference/vector-functions/euclidean-distance/