Documentation Source Text

Check-in [586df7805b]
Login

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

Overview
Comment:Fix typo on the quirks.in page.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | branch-3.32
Files: files | file ages | folders
SHA3-256: 586df7805b3f65a9ff786237e033b0ef93784428ba4aae8c26cfba56a28b7d48
User & Date: drh 2020-07-20 17:18:44
Context
2020-07-26
16:08
On the download page, use sha3 instead of sha1. And deemphasize the text. (Leaf check-in: 0de47c19a5 user: drh tags: branch-3.32)
2020-07-20
17:18
Fix typo on the quirks.in page. (check-in: 586df7805b user: drh tags: branch-3.32)
2020-07-11
00:03
Fix hyperlink problem in the lang.html page. (check-in: afb2b13396 user: drh tags: branch-3.32)
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/quirks.in.

214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
<p>
In the query above, the values for the first_name and last_name columns
will correspond to the row that satisfied the max(salary) condition.

<li><p>
If a query contains no aggregate functions at all, then a GROUP BY
clause can be added as a substitute for the DISTINCT ON clause.  In other words,
output rows are filtered so that only one row is shows for each distinct
set of values in the GROUP BY clause.  If two or more output rows would
have otherwise had the same set of values for the GROUP BY columns, then
one of the rows is chosen arbitrarily.  (SQLite supports DISTINCT but not
DISTINCT ON, whose functionality is provided instead by GROUP BY.)
</ol>

<h1>Does Not Do Full Unicode Case Folding By Default</h1>







|







214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
<p>
In the query above, the values for the first_name and last_name columns
will correspond to the row that satisfied the max(salary) condition.

<li><p>
If a query contains no aggregate functions at all, then a GROUP BY
clause can be added as a substitute for the DISTINCT ON clause.  In other words,
output rows are filtered so that only one row is shown for each distinct
set of values in the GROUP BY clause.  If two or more output rows would
have otherwise had the same set of values for the GROUP BY columns, then
one of the rows is chosen arbitrarily.  (SQLite supports DISTINCT but not
DISTINCT ON, whose functionality is provided instead by GROUP BY.)
</ol>

<h1>Does Not Do Full Unicode Case Folding By Default</h1>