Timeline for Non-deterministic functions and row-based binary logging (MySQL)
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 12, 2020 at 2:51 | vote | accept | Mike Blyth | ||
| Jun 10, 2020 at 1:57 | comment | added | mustaccio |
Your addition should probably be a separate question, but: that function is certainly non-deterministic. Whether misdeclaring it is a big deal or not depends on how frequently the column in question is updated and what isolation level is in use. For example, if last_enc_date is updated nightly by a batch job, workloads running during the day won't be sensitive to that at all.
|
|
| Jun 10, 2020 at 1:03 | history | edited | Mike Blyth | CC BY-SA 4.0 |
added 676 characters in body
|
| Jun 8, 2020 at 21:10 | answer | added | mustaccio | timeline score: 1 | |
| Jun 8, 2020 at 20:59 | history | edited | mustaccio | CC BY-SA 4.0 |
removed fluff
|
| Jun 8, 2020 at 18:51 | answer | added | Gordan Bobić | timeline score: 1 | |
| Jun 8, 2020 at 18:47 | review | First posts | |||
| Jun 9, 2020 at 17:08 | |||||
| Jun 8, 2020 at 18:41 | history | asked | Mike Blyth | CC BY-SA 4.0 |