]> git.evergreen-ils.org Git - Evergreen.git/commit
LP#1277731: Disambiguate parameter/column names
authorMike Rylander <mrylander@gmail.com>
Tue, 4 Mar 2014 20:47:12 +0000 (15:47 -0500)
committerDan Wells <dbw2@calvin.edu>
Tue, 11 Mar 2014 18:27:59 +0000 (14:27 -0400)
commit2542c713ea4a0d686d7b7ceae352929b60a80806
tree210bda89e05fc9d1b25cc1c13a298bfdb85a2f7e
parentfcd7de207a1c6f97f53f8fbade62ab9385c9e113
LP#1277731: Disambiguate parameter/column names

Due to slightly different and more strict disabiguation rules
for parameters and column names in PLPGSQL in modern versions
of Postgres, our hold matrix functions were failing in 9.3.

This commit attempts to address that by declaring and using
aliases for parameters that share names with columns used in
in-line SQL.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Dan Wells <dbw2@calvin.edu>
Open-ILS/src/sql/Pg/110.hold_matrix.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.function.hold_test_params.sql [new file with mode: 0644]