The developer rewrote one C program. So I need to replace the current
library, drop and recreate the UDFs. I don't want to restart the db server,
I just terminate all the sessions which might call this UDF. The strange
thing is my query:
select udf(column) from mytbl
still gave me the result from the old library. But,
values(udf(column) show me the new result.
If they all get the old result. Then I can understand.
BTW, both sql stmts I submitted in one session. We defined the UDF as fenced
& not threadsafe, no SCRATCHPAD and keepfenced = yes (I know this might
cause problem, but again why VALUES is ok)