Bug 15331 - Sort order breaks at offset=1000 (both OPAC and Intranet)
Summary: Sort order breaks at offset=1000 (both OPAC and Intranet)
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Searching (show other bugs)
Version: master
Hardware: All All
: P5 - low enhancement with 30 votes (vote)
Target Milestone: ---
Assignee: Galen Charlton
QA Contact: Testopia
Depends on: 7041
  Show dependency treegraph
Reported: 2015-12-08 16:48 UTC by Barton Chittenden
Modified: 2019-03-28 14:43 UTC (History)
5 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Bot Control: ---
When did the bot last check this:
Who signed the patch off:
Text to go in the release notes:
Version(s) released in:


Note You need to log in before you can comment on or make changes to this bug.
Description Barton Chittenden 2015-12-08 16:48:02 UTC
To re-create:

1) Go to the advanced search page, in either Staff Client or OPAC.
2) Run a search which will return many thousands of results, sort by A-Z
3) Go to the page prior to offset=1000 (i.e. page 50 if you have 20 results/page or 40 if you have 25 results/page). This page will be properly sorted alphabetically.
5) Go to the next page. This will *not* be sorted alphabetically.



The results are

Amazing armored animals / 
Amazing bats / 
Amazing birds / 
The amazing bone / 
The amazing book of bird records : the largest, the smallest, the fastest, and many more! / 
Amazing buildings / 
Amazing buildings / 
Amazing dinosaur facts / 
Amazing flying machines / 
Amazing grace / 
Amazing grace / 
The amazing impossible Erie Canal / 
Amazing Leonardo da Vinci inventions you can build yourself : learn some hands-on history! / 
The amazing life of Benjamin Franklin / 
The amazing life of birds : (the twenty-day puberty journal of Duane Homer Leech) / 
An amazing machine / 
Amazing magic tricks : apprentice level / 
Amazing magic tricks : master level / 
Amazing mammals / 
The Amazing Maurice and his educated rodents / 

The next titles in the catalog should be

Amazing mazes : mind bending mazes for ages 6-60 /
The amazing Mrs. Pollifax 
The amazing odorous adventures of Stinky Dog /

Instead, we get


The history of Herodotus Thucydides. 
Hippocratic writings. 
The day after Roswell / 
The demon-haunted world : science as a candle in the dark / 
The UFO phenomenon / 
Champ, beyond the legend (updated edition) / 
Area 51 : the dreamland chronicles / 
UFO crash at Roswell : the genesis of a modern myth /  
Chaos : making a new science / 
The black swan : the impact of the highly improbable / 
PC annoyances : how to fix the most annoying things about your personal computer / 
PC help desk in a book : the do-it- yourself guide to PC troubleshooting and repair /  
The little Mac book / 
Where wizards stay up late : the origins of the Internet / 
Web design tools and techniques / 
Degunking your email, spam, and viruses / 
IPhone and iPad apps marketing : secrets to selling your iPhone and iPad apps / 
Office 2007 all-in-one desk reference for dummies / 
Windows 95 secrets /
Comment 1 Frédéric Demians 2015-12-08 17:22:10 UTC
Take a look at bug 7041
Comment 2 David Cook 2015-12-08 22:17:07 UTC
(In reply to Frédéric Demians from comment #1)
> Take a look at bug 7041

You might also take a look at "sortmax" at http://www.indexdata.com/zebra/doc/zebra-cfg.html
Comment 3 Nick Clemens 2016-03-09 02:06:26 UTC
Is this valid then, or does sortmax/bug 7041 solve this?
Comment 4 David Cook 2016-04-11 04:00:14 UTC
(In reply to Nick Clemens from comment #3)
> Is this valid then, or does sortmax/bug 7041 solve this?

sortmax would allow you to sort more records, but it'll always be a limitation, I think. I wonder if there's a way to specify sort all...