MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: When can a procedure/function be considered deterministic
Posted by: Jeremie Grund
Date: July 15, 2013 10:07AM

Peter Brawley Wrote:
-------------------------------------------------------
> Yes I've seen that opinion. But if that were
> correct, DETERMINISTIC would entail NO SQL, which
> would be nonsensical.
>
> UUID(), Rand(), Now() &c are non-deterministic.

So then you are saying a function that selects data from a table is Deterministic unless it calls a non deterministic function?

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.