Timeline for User defined function can only have select statements
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 27, 2018 at 15:48 | comment | added | Andriy M | Oh, you don't need to tell me, because my position on this is exactly the same as yours. It's shaping it into words that I have trouble with, otherwise I would've posted my own answer or edited yours :) | |
| Apr 27, 2018 at 15:13 | comment | added | Balazs Papp | @AndriyM I find it a very bad idea to create code with unexpected side effects. If I run a query to just read data, I expect it to query data, and not modify something else in the background. Yes, I know, auditing, block cleanout and other mechanisnms can cause unexcpected writes on reads as well... | |
| Apr 27, 2018 at 14:26 | comment | added | Andriy M | Your last statement still begs another "Why?". And I think the answer to that "why" would work as the answer to the OP's "why" too, even though the OP was incorrect about permissibility of DML in functions. Just saying. I like the answer anyway, learned something new. | |
| Apr 27, 2018 at 14:15 | vote | accept | ghostrider | ||
| Apr 27, 2018 at 14:13 | history | answered | Balazs Papp | CC BY-SA 3.0 |