DETERMINISTIC top-level constant

int const DETERMINISTIC

The SQLITE_DETERMINISTIC flag means that the new function always gives the same output when the input parameters are the same.

The abs() function is deterministic, for example, but randomblob() is not. Functions must be deterministic in order to be used in certain contexts such as with the WHERE clause of partial indexes or in generated columns. SQLite might also optimize deterministic functions by factoring them out of inner loops.

Implementation

const DETERMINISTIC = 0x000000800;