Title:
Bug 84068:With Verity collections the CFSEARCH attribute maxRows limits the resulting query to the specified number of rows, regardless of how how many collections are specified in the collection attribute
| View in TrackerStatus/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Julian Halliwell / Julian Halliwell (cfSimplicity)
Created: 09/07/2010
Components: Text Search, Solr
Versions: 9.0.1
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 / 275179
Priority/Frequency: Major / Unknown
Locale/System: English / Platforms All
Vote Count: 1
Problem:
With Verity collections the CFSEARCH attribute maxRows limits the resulting query to the specified number of rows, regardless of how how many collections are specified in the collection attribute. This allows me to limit the number of rows returned regardless of the number of records searched.With Solr, the maxRows number seems to be interpreted as *per collection searched*, so that if I set maxRows to 5, and list more than one collection in the collection attribute of cfsearch, I may get more than 5 rows in my result query. This means I cannot reliably limit my results if searching more than one collection.Also I have found that when *omitting* the MaxRows attribute I sometimes get *fewer* results than when adding the attribute, which should never happen (since the default is to search "all" records). The results returned using the MaxRows attribute do not appear to contain duplicates, which suggests the default search omitting the MaxRows attribute is failing to match relevant results.NOTE: the data I am indexing is only from a database, not file based.
Method:
1) Create 2 Solr collections each with indexed database content containing more than 5 instances of the same keyword2) Execute CFSEARCH for the keyword on just one collection with MaxRows = 5. The result is limited to 5 rows as expected3) Execute a second CFSEARCH on both collections together with MaxRows=5. The result is 10 (ie 5 each). It should be 5 not 10.
Result:
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3042125
External Customer Info:
External Company:
External Customer Name: Julian Halliwell
External Customer Email: 2D5C74634456F5BE992016E5
External Test Config: 09/07/2010Attachments:
Comments: