Comment 2 for bug 800478

I have determined that the bug is in the database function somewhere, I have the following OpenSRF call in the log:

NOTE: db (pg 8.4) and evergreen (2.0.5) are on separate servers, timestamps are slightly off for some reason atm.

osrf_http_translator 2011-07-29 11:05:36 [ACT:23750:./osrf_http_translator.c:293:13118865092375037] [1.1.1.1.1] [] open-ils.acq open-ils.acq.funds.transfer_money "authkey", 2, 500, "14", null, ""
osrf_http_translator 2011-07-29 11:05:36 [INFO:23750:./osrf_http_translator.c:293:13118865092375037] [1.1.1.1.1] [] open-ils.acq open-ils.acq.funds.transfer_money "authkey", 2, 500, "14", null, ""

HOWEVER:

training=# select * FROM acq.fund_allocation where (fund = 2 or fund = 14) and allocator = 136;
 id | funding_source | fund | amount | allocator | note | create_time
----+----------------+------+-----------+-----------+----------------------+-------------------------------
 68 | 1 | 2 | -22025.00 | 136 | Transfer to fund 14 | 2011-07-29 11:03:56.415816-07
 69 | 1 | 14 | 22025.00 | 136 | Transfer from fund 2 | 2011-07-29 11:03:56.415816-07
(2 rows)

AND:

training=# select * FROM acq.fund_transfer where src_fund = 2 and dest_fund = 14;
 id | src_fund | src_amount | dest_fund | dest_amount | transfer_time | transfer_user | note | funding_source_credit
----+----------+------------+-----------+-------------+-------------------------------+---------------+------+-----------------------
 26 | 2 | 100.00 | 14 | 100.00 | 2011-07-29 11:03:56.415816-07 | 136 | | 6
(1 row)