Hi Greg,
I have not seen this behaviour at all. Are you performing this query in the Azure portal/Data Explorer or via the DocumentClient in code? * Glav From: ozdotnet-boun...@ozdotnet.com <ozdotnet-boun...@ozdotnet.com> On Behalf Of Greg Keogh Sent: Sunday, 16 September 2018 8:33 AM To: ozDotNet <ozdotnet@ozdotnet.com> Subject: Comos DB random query results I thought I had a bug in my program which runs Cosmos DB queries, so I went to the Azure portal data explorer and ran the same query directly against the data: SELECT * FROM c WHERE CONTAINS(UPPER(c.title), "LOVER") I know the data contains exactly 6 matches for this query. Sometimes I get the 6 correct results, but I also randomly get anything up to 16 results with titles that are obvious mismatches. For example, I just got titles "Sahara" and "I Feel The Earth Move" in 11 results. If I remove the UPPER and run this query I always get exactly 5 correct results: WHERE CONTAINS(c.title, "Lover") Is there a bug in the query engine with UPPER? A quick search reveals no hints on this matter. I just noticed using LOWER produces the same symptoms. Greg K
