TiDB: ERROR 1105 vectors have different dimensions

TL;DR

The two vectors in VECL2DISTANCE, VECCOSINEDISTANCE, and the other vector functions must have the same dimension, otherwise an error is returned, for example ERROR 1105 (HY000): vectors have different dimensions.

The error

ERROR 1105 vectors have different dimensions

Fix

1. The two vectors in VECL2DISTANCE, VECCOSINEDISTANCE, and the other vector functions must have the same dimension, otherwise an error is returned, for example ERROR 1105 (HY000): vectors have different dimensions. Expected: you can confirm this matches your situation.

2. Re-run the original operation and confirm the error is gone. Expected: no error, normal output.

When to use

• You hit this exact error with TiDB.
• The symptom matches: ERROR 1105 vectors have different dimensions.

When NOT to use

• A different error message from TiDB; the cause here is specific to this error.
• Unrelated TiDB issues (different feature, different failure).
• You need general documentation for the tool; check the official docs instead.

Compatibility

Reported against TiDB. Source: https://docs-archive.pingcap.com/tidb/v8.4/vector-search-data-types/.

Variant phrasings

ERROR 1105 vectors have different dimensions

Why it happens

Vector functions require both operands to have the same dimension. A mismatch is a hard error, not a silent cast.

Edge cases

• If your error message differs even slightly, this is probably a different issue; search the exact text.
• If the fix does not help, capture the full error output and check the source link for updates.

Source

https://docs-archive.pingcap.com/tidb/v8.4/vector-search-data-types/

Source: Vector functions require both operands to have the same dimension. A mismatch is a hard error, not a silent cast.

Verified resolution: [TiDB docs]: the two vectors in VECL2DISTANCE, VECCOSINEDISTANCE, and the other vector functions must have the same dimension, otherwise an error is returned, for example ERROR 1105 (HY000): vectors have different dimensions. Convert strings with VECFROMTEXT or CAST(... AS VECTOR); TiDB performs an implicit cast when a format-compliant string is passed to a vector-only function. Use VEC_DIMS to check a vector's dimension before combining operands from different sources.

Source URL: https://docs-archive.pingcap.com/tidb/v8.4/vector-search-data-types/