Vector store supabase doesn´t work

Hi! I’ve been using the vector store node in SupaBase and I’m having a problem. I randomly have to change the limit list because if I set it too low (for example, 5), with 4 vectors in my SupaBase database (it should return all of them), it gives me “no output data”.

However, if I raise it to 22, it returns all 4 items, but it doesn’t if I set the limit to 21, for example.

It’s completely random. Sometimes the number is even higher and it doesn’t work, even with a limit of 50.

I don’t know why this is happening. Could it have something to do with my SupaBase function? I would say it’s an n8n bug. It has nothing to do with the score limit; the SupaBase function returns the n most similar vectors, even if they don’t resemble each other at all, and I haven’t set anything like that in n8n.

I’m also ruling out this possibility because simply changing the limit on the number of items I can bring in doesn’t solve the problem.

If anyone knows anything, I’d appreciate it.

This might be related as you suspect to the function. Supabase is more advanced with setting up RAG agents, and it could be because its only finding similar items and the 4/the 22 are the only ones that match the query.