|
PostgreSQL 8.3.7 running on FreeBSD. The following query: update tblksalerts set cleartime = x_cleartime, laststatusid = x_statusid, lastreplytext = x_replytxt, lasttesttime = x_testtime, lasteventsource = x_eventsource, lasteventid = x_eventid, replyval = x_replyval, trend = mytrend, alertoccurrence = testcount where ksalertssysid =
alertsrecord.ksalertssysid; being issued via a pl/pgsql stored procedure is being translated
by the backend as follows: update tblksalerts set cleartime = '2009-07-29
10:49:50'::TIMESTAMP, laststatusid = 7::INTEGER, lastreplytext = '0'::VARCHAR,
lasttesttime = '2009-07-29 10:49:50'::TIMESTAMP, lasteventsource is
NULL::VARCHAR, lasteventid is NULL::INTEGER, replyval = 0::REAL, trend =
''::varchar ( 1 ), alertoccurrence = 0::integer where ksalertssysid = 1737078 and is generating a syntax error: syntax error at or near
"is" at character 192 Please note the “lasteventsource is null”
instead of “lasteventsource = null” which is being generated when
the value of x_eventsource is null. We have implemented a workaround by setting the value to a blank
string, but I believe this is a problem nonetheless. |
