Re: When is an INSERT DETERMINISTIC?

[Haravikk Kh'arr]

Sorry, but you appear to be quoting the very documentation that is confusing me; it references input parameters, but what exactly is an input parameter in this case?

If it's the key and name I pass into a CALL for `insert_user` then for the same inputs there will always be a row with that name and key, either creating one, or touching one that is already there. Therefore the result to me seems like it's the same for the same inputs.

So is that DETERMINISTIC, yes or no? If not, why not? And more importantly, why doesn't that damned documentation explain either way? I've found other threads on here from years ago with people asking the same question and seeming not to get definitive answers; the documentation is frankly useless at describing when, or when not, to use the DETERMINISTIC keyword, it seriously needs to be elaborated upon.