]> git.evergreen-ils.org Git - working/Evergreen.git/commit
projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: c1e03c0) | patch
LP#1277731: Disambiguate parameter/column names collab/miker/lp1277731-hold-test-failure-pg_93
authorMike Rylander <mrylander@gmail.com>
Tue, 4 Mar 2014 20:47:12 +0000 (15:47 -0500)
committerMike Rylander <mrylander@gmail.com>
Tue, 4 Mar 2014 20:47:12 +0000 (15:47 -0500)
commit23ad24ce7e8900e7b298258e9b14811876ac0e56
tree52b85a44a011a3367791fbb2bfc18fc524420e9dtree
parentc1e03c02216ed8a5916e44714d621a55b0b95fc7commit | diff
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>
Open-ILS/src/sql/Pg/110.hold_matrix.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.function.hold_test_params.sql [new file with mode: 0644] blob
Evergreen ILS