IssueTracker

This will create a public issue which anybody can view and comment on.

Please provide as much information as possible. At least, this should include a description of your issue and steps to reproduce the problem. If possible please provide a summary of what steps or workarounds you have already tried, and any docs or articles you found (un)helpful.

Problem you have encountered:

When trying to do a vector search query using the COSINE_DISTANCE function, I kept getting null even though the column I was doing it on was an array of float64 embeddings with 1408 values. My query embedding was also 1408 values.

If you do the query in the Spanner query UI with an array of 1408 values, you'll see that the value is grayed out in the query. If you remove values until it's 1356 elements long, the array will suddenly turn orange in the query editor.

So it seems that 1356 elements is the limit for an argument passed to COSINE_DISTANCE.

What you expected to happen:

There should be a value and the result should not be null.

Steps to reproduce:

1. Create a table with a ARRAY<FLOAT64> column, e.g. embedding
2. Store an array with 1408 floats.
3. Create an array of 1408 floats and query the table using SELECT COSINE_DISTANCE(embedding, <query_embedding>) as distance;

Other information (workarounds you have tried, documentation consulted, etc):

The workaround is to not use COSINE_DISTANCE and to use DOT_PRODUCT instead.