What does the Deterministic flag in the functions editor do? #4839
-
I've turned the flag off and on for a scalar function with no apparent effect. Searching for "deterministic" returned the following among many instances in code: |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
It's a feature of SQLite. See https://sqlite.org/c3ref/c_deterministic.html#sqlitedeterministic |
Beta Was this translation helpful? Give feedback.
It's a feature of SQLite. See https://sqlite.org/c3ref/c_deterministic.html#sqlitedeterministic
Basically, if you want to use a function in
GENERATED
column constraint, such function has to be deterministic and should actually comply with being deterministic (again - see link above for details).