Documentation Source Text

Check-in [65df8fdcfa]
Login

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

Overview
Comment:Remove an incorrect statement about sessions and WITHOUT ROWID from the WITHOUT ROWID documentation.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 65df8fdcfa1436ba34e40a4269145e16405525fde3fddb5c67aadac2196e86f6
User & Date: drh 2017-06-02 11:24:32.954
Context
2017-06-02
11:27
Fix a typo in the session documentation. (check-in: acfc24126f user: drh tags: trunk)
11:24
Remove an incorrect statement about sessions and WITHOUT ROWID from the WITHOUT ROWID documentation. (check-in: 65df8fdcfa user: drh tags: trunk)
2017-05-25
16:56
Version 3.19.2 (check-in: 27e87090c9 user: drh tags: trunk, release, version-3.19.2)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/withoutrowid.in.
︙︙
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146


<li><p>
<b>^The [sqlite3_update_hook()] interface does not fire callbacks for changes
to a WITHOUT ROWID table.</b>
Part of the callback from [sqlite3_update_hook()] is the rowid of the table
row that has changed.  However, WITHOUT ROWID tables do not have a rowid.
Hence, the update hook is not invoked when a WITHOUT ROWID table changes.
<p>Note that since the [session] extension uses the update hook, that means
that the session extension will not work correctly on a database that includes
WITHOUT ROWID tables.
</ol>

<tcl>hd_fragment bene {benefits of using WITHOUT ROWID}</tcl>
<h1>Benefits Of WITHOUT ROWID Tables</h1>

<p>A WITHOUT ROWID table is an optimization that can reduce storage and
processing requirements.








<
<
<








130
131
132
133
134
135
136



137
138
139
140
141
142
143


<li><p>
<b>^The [sqlite3_update_hook()] interface does not fire callbacks for changes
to a WITHOUT ROWID table.</b>
Part of the callback from [sqlite3_update_hook()] is the rowid of the table
row that has changed.  However, WITHOUT ROWID tables do not have a rowid.
Hence, the update hook is not invoked when a WITHOUT ROWID table changes.



</ol>

<tcl>hd_fragment bene {benefits of using WITHOUT ROWID}</tcl>
<h1>Benefits Of WITHOUT ROWID Tables</h1>

<p>A WITHOUT ROWID table is an optimization that can reduce storage and
processing requirements.
︙︙