[Koha-bugs] [Bug 14861] Accession date comparison does not work in advanced search

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14861

--- Comment #5 from David Cook <dcook at prosentient.com.au> ---
You might notice different tokenizing behaviours depending on your searches,
and that's down to default.idx and using different "charmap" files for
different index types (ie registers). 

We've already observed that "acqdate,st-date-normalized" with double quotes
uses the value as a single token.

Z> f acqdate,st-date-normalized="2010-01-01 - 2015-01-01"
Sent searchRequest.
Received SearchResponse.
Search was a success.
Number of hits: 0, setno 38
SearchResult-1: term=2010-01-01 - 2015-01-01 cnt=0
records returned: 0
Elapsed: 0.000856

Z> f acqdate,st-date-normalized=2010-01-01 - 2015-01-01
Sent searchRequest.
Received SearchResponse.
Search was a success.
Number of hits: 9644, setno 39
SearchResult-1: term=2010-01-01 cnt=11758, term=2015-01-01 cnt=36059
records returned: 0
Elapsed: 0.029800

However, "pubdate,st-numeric" tokenizes everything when using double quotes.

Z> f pubdate,st-numeric="2010 - 2015"
Sent searchRequest.
Received SearchResponse.
Search was a success.
Number of hits: 0, setno 36
SearchResult-1: term=2010 cnt=1059, term=- cnt=167, term=2015 cnt=730
records returned: 0
Elapsed: 0.033589

Z> f pubdate,st-numeric=2010 - 2015
Sent searchRequest.
Received SearchResponse.
Search was a success.
Number of hits: 5066, setno 37
SearchResult-1: term=2010 cnt=5068, term=2015 cnt=24660
records returned: 0
Elapsed: 0.093974

--

In the first two searches, we're using the date register:

# Date
# Used if structure=date (@attr 4=5)
index d
completeness 0
charmap @

Whereas with the second one, we're using the numeric register:

# Numeric index
# Used if structure=numeric (@attr 4=109)
index n
completeness 0
charmap numeric.chr

As per the docs at http://www.indexdata.com/zebra/doc/character-map-files.html,
"charmap @" means no normalization and no tokenization.

This isn't just specific to the date register. It's also the case for "y" and
"0".

-- 
You are receiving this mail because:
You are watching all bug changes.