Interesting that this paper by Kent shows an couple of examples of a
function reading a table that I'd call NOT DETERMINISTIC but that Kent
has used DETERMINISTIC on...
On Thu, Sep 6, 2012 at 8:51 AM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:
Given the original description of the UDF, I'd consider it NOT DETERMINISTIC.
I used to use DETERMINISTIC as more of an "it's ok to cache this", but
after discussions with Kent...I quit doing so. Now the only thing I
use DETERMINISTIC on are functions that just look at the input
parameters; date conversion for example.
If James really wants to define this as DETERMINISTIC, I'd suggest
passing in the user ID as well...but I'd guess that he's also looking
at a DB table or something....which in my book automatically makes it