Documentation Source Text

Check-in [37b0c51a67]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Small update to deterministic.html to mention generated columns.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 37b0c51a67a4f1c2e22575856dadf231ca5b0630a3408c75867b59692a5a8110
User & Date: drh 2020-03-04 20:27:42.281
Context
2020-03-06
00:13
Update the NOCASE documentation to make it clear that it uses sqlite3_strnicmp() for comparison and thus stops at the first embedded zero character in the string. (check-in: e751b0c91a user: drh tags: trunk)
2020-03-04
20:27
Small update to deterministic.html to mention generated columns. (check-in: 37b0c51a67 user: drh tags: trunk)
2020-03-03
14:07
Update the althttpd documentation. (check-in: c7f0891d15 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/deterministic.in.
44
45
46
47
48
49
50

51
52
53
54
55
56
57
^(There are some contexts in SQLite that do not allow the use of
non-deterministic functions:

<ul>
<li>In the expression of a [CHECK constraint].
<li>In the WHERE clause of a [partial index].
<li>In an expression used as part of an [expression index].

</ul>)^

<p>
In the cases above, the values returned by the function affects the
information stored in the database file.  The values of functions
in CHECK constraints determines which entries are valid for a table,
and functions in the WHERE clause of a partial index or in an index on







>







44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
^(There are some contexts in SQLite that do not allow the use of
non-deterministic functions:

<ul>
<li>In the expression of a [CHECK constraint].
<li>In the WHERE clause of a [partial index].
<li>In an expression used as part of an [expression index].
<li>In the expression of a [generated column].
</ul>)^

<p>
In the cases above, the values returned by the function affects the
information stored in the database file.  The values of functions
in CHECK constraints determines which entries are valid for a table,
and functions in the WHERE clause of a partial index or in an index on