Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Small update to deterministic.html to mention generated columns. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
37b0c51a67a4f1c2e22575856dadf231 |
| User & Date: | drh 2020-03-04 20:27:42 |
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
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
|