Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Rather than document goofy behavior, better to make the behavior less goofy. (Was: Clarify in the documentation that last_insert_rowid() does not work for virtual tables.) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | mistake |
| Files: | files | file ages | folders |
| SHA1: |
f102116e8ac302ccfb3b2dc3096f960b |
| User & Date: | drh 2011-05-13 16:57:54 |
| Original Comment: | Clarify in the documentation that last_insert_rowid() does not work for virtual tables. |
Context
|
2011-05-13
| ||
| 16:57 | Rather than document goofy behavior, better to make the behavior less goofy. (Was: Clarify in the documentation that last_insert_rowid() does not work for virtual tables.) (Closed-Leaf check-in: f102116e8a user: drh tags: mistake) | |
| 16:47 | Add a requirement that CHECK constraints cannot contain subqueries. (check-in: 1f3d321253 user: drh tags: trunk) | |
Changes
Changes to pages/lang.in.
2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081 2082 |
^The hex() function interprets its argument as a BLOB and returns
a string which is the upper-case hexadecimal rendering of the content of
that blob.
}
funcdef {last_insert_rowid()} {} {
^The last_insert_rowid() function returns the [ROWID]
of the last row insert from the database connection which invoked the
function.
^The last_insert_rowid() SQL function is a wrapper around the
[sqlite3_last_insert_rowid()] C/C++ interface function.
}
funcdef {length(X)} {} {
^The length(X) function returns the length of X in
characters if X is a string, or in bytes if X is a blob.
^If X is NULL then length(X) is NULL.
^If X is numeric then length(X) returns the length of a string
|
> | < > > > |
2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081 2082 2083 2084 2085 |
^The hex() function interprets its argument as a BLOB and returns
a string which is the upper-case hexadecimal rendering of the content of
that blob.
}
funcdef {last_insert_rowid()} {} {
^The last_insert_rowid() function returns the [ROWID]
of the last row inserted into a real (not a virtual) table
from the database connection which invoked the function.
^The last_insert_rowid() SQL function is a wrapper around the
[sqlite3_last_insert_rowid()] C/C++ interface function.
<p>Note that this function does not work for inserts into a
[virtual table] such as [FTS3] or [RTREE].
}
funcdef {length(X)} {} {
^The length(X) function returns the length of X in
characters if X is a string, or in bytes if X is a blob.
^If X is NULL then length(X) is NULL.
^If X is numeric then length(X) returns the length of a string
|