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*
