LP#1155313: Repair generation of label_sortkey for monograph_part entries
authorDan Pearl <dpearl@cwmars.org>
Fri, 15 Mar 2013 19:04:37 +0000 (15:04 -0400)
committerDan Scott <dscott@laurentian.ca>
Thu, 5 Mar 2015 17:43:14 +0000 (12:43 -0500)
commit551262d5360a14240a5e22c0b5d5cd5d2717cdfd
tree0f8ff6e232821d5c64fd9936fc65acea81cee939
parent0b15ee71722d2080bfd20825282ccba3430f412d
LP#1155313: Repair generation of label_sortkey for monograph_part entries

The evergreen.lpad_number_substrings function attempts to codify numeric
fields within labels.  It does this by finding the strings, padding them
to a given size, and replacing them in the source string.  For instance:
       3 => 0000000003
    15.4 => 00000000150000000004

The algorithm was fooled by repeated characters, like in 15.1:
    15.1 => 00000000000000000150000000001  INCORRECT

This change will result in the correct value.

Signed-off-by: Dan Pearl <dpearl@cwmars.org>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Open-ILS/src/sql/Pg/002.functions.config.sql