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: |
37b0c51a67a4f1c2e22575856dadf231 |
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
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 |
︙ | ︙ |