anchor.diff:  
       member __.``Searching using lower on the LHS of the operation is supported``() =
           let result =
  -            getQuery (index.IndexName, "lower(et1) = 'aa'")
  +            getQuery (index.IndexName, "allof(lower(et1) , 'aa')")
               |> withColumns [| "_id" |]
               |> searchAndExtract searchService
           result |> assertReturnedDocsCount 4
   
       member __.``Searching using upper on the LHS of the operation is supported``() =
           let result =
  -            getQuery (index.IndexName, "upper(et1) = 'AA'")
  +            getQuery (index.IndexName, "allof(upper(et1), 'AA')")
               |> withColumns [| "_id" |]
               |> searchAndExtract searchService
           result |> assertReturnedDocsCount 4
   
       member __.``Searching using upper on the LHS of a 'regex' operation is supported``() =
           let result =
  -            getQuery (index.IndexName, "upper(et1) regex 'A.'")
  +            getQuery (index.IndexName, "regex(upper(et1), 'A.')")
               |> withColumns [| "_id" |]
               |> searchAndExtract searchService
           result |> assertReturnedDocsCount 4
  
positive.code: type ``DistinctBy Tests``(index : Index, searchService : ISearchService, indexService : IIndexService, documentService : IDocumentService) = 
      let testData = """
  id,et1,t1,i1,s1
  1,a,jhonson,1,test1
  2,a,hewitt,1,test2
  3,b,Garner,1,test3
  4,b,Garner,1,test4
  5,c,jhonson,1,test5"""
      do indexTestData (testData, index, indexService, documentService)
      member __.``Setting distinctby removes duplicates from the serach results``() = 
          let result = 
              getQuery (index.IndexName, "_id matchall '*'")
              |> withDistinctBy "et1"
              |> searchAndExtract searchService
          // The document returned count will still be 5 as we are filtering records
  
negative.code: type ``Sorting Tests``(index : Index, searchService : ISearchService, indexService : IIndexService, documentService : IDocumentService) = 
      let testData = """
  id,et1,t2,i1,i2
  1,a,johnson,1,1
  2,c,hewitt,1,3
  3,b,Garner,1,2
  4,e,Garner,1,4
  5,d,johnson,1,5"""
      do indexTestData (testData, index, indexService, documentService)
  
      member __.``Searching for 'i1 = 1' with orderby _lastmodified should return 5 records``() = 
          let result = 
              getQuery (index.IndexName, "allof(i1, '1')")
              |> withColumns [| "_id" |]
              |> withOrderBy TimeStampField.Name
              |> searchAndExtract searchService
  