Nested join inside facet_by causes request to hang and time out

[kawad852]

Describe the bug

When using nested joins in facetBy that reference a second-level nested field ($variantPricing) inside $productVariants, the request consistently times out, even though the same nested structure works correctly in filterBy and includeFields.

This occurs on Typesense v30.0.rca37 and results in a client-side timeout (Future not completed) instead of a server-side validation or error response.

Working query params

{ "collection": "products", "filterBy": "$productVariants(" "$variantPricing(countryCode:=JO) && " "$variantAttributeValues(" "$attributeValues(" "$attributes(id:)" ")" ")" ")", "includeFields": ", " "$productVariants(" ", " "$variantPricing(, strategy: nest_array) as pricing, " "$variantAttributeValues(" ", " "$attributeValues(, $attributes(*)) as attribute, " "strategy: nest_array" ") as attributes, " "strategy: nest_array" ") as variants", "facetBy": "$productVariants(status)", }

Not working query params (times out):

{ "collection": "products", "filterBy": "$productVariants(" "$variantPricing(countryCode:=JO) && " "$variantAttributeValues(" "$attributeValues(" "$attributes(id:)" ")" ")" ")", "includeFields": ", " "$productVariants(" ", " "$variantPricing(, strategy: nest_array) as pricing, " "$variantAttributeValues(" ", " "$attributeValues(, $attributes(*)) as attribute, " "strategy: nest_array" ") as attributes, " "strategy: nest_array" ") as variants", "facetBy": "$productVariants(status, $variantPricing(pricing.totalPrice))", }

Steps to reproduce the behavior:

1. Use Typesense v30.0.rca37
2. Create a collection with nested relationships similar to: products, productVariants, variantPricing
3. Run a search query where: filterBy uses nested joins on $productVariants → $variantPricing includeFields includes the same nested joins
4. Add a facetBy clause referencing a nested field inside $variantPricing, for example: facetBy: "$productVariants(status, $variantPricing(pricing.totalPrice))"
5. Execute the query

Expected behavior

The query succeeds and returns facets for productVariants.status and variantPricing.pricing.totalPrice

Actual behavior

TimeoutException after 0:00:10.000000: Future not completed

Additional context

The exact same nested structure works correctly in: • filterBy • includeFields The issue appears specific to nested joins inside facetBy