Hello @Kishore Nallan @Jason Bosco, I am facing an issue in JOINs in v28.0 of Typesense. I have 2 collections, which have "One-to-Many" relationship between them. It was working file till I updated schema of one of the collections and then Upsert the same data in it. After that I can't get the Joined data in search at all. I use Typesense in Docker. So, I tried docker compose down and up and still the issue persist. Updated: I only introduced one more field in the collection, which is not used as foreign key.

Did you happen to update the collection having the reference field?

With reference to the simple-example given on typesense documentation, https://typesense.org/docs/28.0/api/joins.html#simple-example I added a field in "customers" table.

Okay. I'll try to reproduce the issue.

Yes

I used these commands but the join is working fine after alter and upsert operation.

Okay, Let me try it again. If I find it happen again, then I'll let you know.