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)
committerGalen Charlton <gmc@esilibrary.com>
Mon, 2 Mar 2015 14:08:46 +0000 (14:08 +0000)
commit73c869128467a55f63deeaba00482372ad4b9744
tree4b3bbdd5a8cee4ef3521df5ffe9326247745c7eb
parent38f3cfc0071e6664352b128e720bf18cd01496fd
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