Hybrid search ranks results randomly when OpenAI is not used

[MustafaSabur]

Add WHERE cosine_distance IS NOT NULL on a new line after line 52.

[yorek]

Can you bit a more specific? I guess you are referring to the case when @e is null? If that's the case I think it would be enough to fix the first part of the sample to properly generate an error if no embedding is available

DECLARE @r INT, @e VECTOR(1536);

EXEC @r = dbo.get_embedding 'embeddings', @q, @e OUTPUT;
IF (@r != 0) BEGIN 
    SELECT @r; 
    THROW 50000, 'Unable to get embedding', 1 ;
END

that would make VECTOR_DISTANCE return only NULL VALUES

[MustafaSabur]

Yes, you are right yorek. That's what I was referring to. Your sample code makes sense.