@abhinav’s comment here gave some clue on how things work.
To support wildcard queries from N1QL, fields have to be indexed using the keyword analyser. After converting the index to use keyword analyser on every field, I still don’t get expected results.
While running FTS search requests from N1QL
Does it mean that the FTS behavior is different while running from N1QL and running a query directly in the search UI? what’s the behavior when SDK is used?