]> git.evergreen-ils.org Git - working/Evergreen.git/commit
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 13:59:07 +0000 (13:59 +0000)
commitaa682ee1aacb74369b2ccc1c753c87dd3e9d9825
tree6e498e63297c99a87d502008ec287d52c1f562b5
parent211acf9715d3f9ae8e5c870f0e953a28cde66b46
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