It feels like the vector distance sorting somehow happens after join and limit, which wasn’t expected. I can try to create a gist with examples if that helps?