Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a bug in matrix generation. Relax a restriction on the use of VALUES clauses - a restriction that did not actually apply. Fix a formatting problem in the FTS5 docs. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
f61b2a7935bf9b73947056b4c3744c3c |
| User & Date: | drh 2015-03-05 01:22:17 |
Context
|
2015-03-05
| ||
| 15:35 | Fix the documentation of PRAGMA index_info to omit the three extra files that were reverted. Improve the documentation of PRAGMA index_list to detail the output fields. (check-in: 8b3cf7e669 user: drh tags: trunk) | |
| 01:22 | Fix a bug in matrix generation. Relax a restriction on the use of VALUES clauses - a restriction that did not actually apply. Fix a formatting problem in the FTS5 docs. (check-in: f61b2a7935 user: drh tags: trunk) | |
| 00:17 | Only count duplicate requirements once when scoring, but show every usage in the matrix reports. (check-in: 61f2878145 user: drh tags: trunk) | |
Changes
Changes to matrix.tcl.
14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
# Initialize the database connection.
#
sqlite3 db docinfo.db
db eval {
BEGIN;
DELETE FROM requirement;
}
# Extract requirement text from all of the HTML files in $filelist
#
# Requirements text is text between "^" and "." or between "^(" and ")^".
# Requirement text is normalized by removing all HTML markup, removing
# all whitespace from the beginning and end, and converting all internal
|
> |
14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
# Initialize the database connection.
#
sqlite3 db docinfo.db
db eval {
BEGIN;
DELETE FROM requirement;
DELETE FROM reqsrc;
}
# Extract requirement text from all of the HTML files in $filelist
#
# Requirements text is text between "^" and "." or between "^(" and ")^".
# Requirement text is normalized by removing all HTML markup, removing
# all whitespace from the beginning and end, and converting all internal
|
Changes to pages/fts5.in.
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
....
1026
1027
1028
1029
1030
1031
1032
1033
1034
|
double quote characters may be escaped SQL-style - by adding a second
double-quote character.
<li> <p>As a bareword that includes no whitespace or reserved characters,
and is not "AND", "OR" or "NOT" (case sensitive). Reserved characters
are:
<pre>
: ~ ! @ # $ % ^ & * ( ) + , =
</pre>
In other words, the top row of a regular US keyboard, the plus sign,
comma and colon characters. Strings that include any of these
characters must be quoted.
</ul>
<p>
................................................................................
<tclscript>
set res ""
unset -nocomplain ::extract_api_docs_mode
catch { set res [source [file join $::SRC ext/fts5/extract_api_docs.tcl]] }
set res
</tclscript>
|
|
<
<
|
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
....
1026
1027
1028
1029
1030
1031
1032
|
double quote characters may be escaped SQL-style - by adding a second
double-quote character.
<li> <p>As a bareword that includes no whitespace or reserved characters,
and is not "AND", "OR" or "NOT" (case sensitive). Reserved characters
are:
<pre>
: ~ ! @ # $ % ^ & * ( ) + , =
</pre>
In other words, the top row of a regular US keyboard, the plus sign,
comma and colon characters. Strings that include any of these
characters must be quoted.
</ul>
<p>
................................................................................
<tclscript>
set res ""
unset -nocomplain ::extract_api_docs_mode
catch { set res [source [file join $::SRC ext/fts5/extract_api_docs.tcl]] }
set res
</tclscript>
|
Changes to pages/lang.in.
4336 4337 4338 4339 4340 4341 4342 4343 4344 4345 4346 4347 4348 4349 4350 4351 4352 4353 4354 |
VALUES clause has no arbitrary limit. <p>There are some restrictions on the use of a VALUES clause that are not shown on the syntax diagrams: <ul> <li><p> ^A VALUES clause cannot be followed by [ORDER BY] or [LIMIT]. <li><p> ^A VALUES clause cannot be used together with a [WITH] clause in a [simple SELECT]. </ul> <h3>The WITH Clause</h3> <p>^SELECT statements may be optionally preceded by a single [WITH clause] that defines one or more [common table expressions] |
| | < |
4336 4337 4338 4339 4340 4341 4342 4343 4344 4345 4346 4347 4348 4349 4350 4351 4352 4353 |
VALUES clause has no arbitrary limit.
<p>There are some restrictions on the use of a VALUES clause that are
not shown on the syntax diagrams:
<ul>
<li><p>
^A VALUES clause cannot be followed by [ORDER BY].
<li><p>
^A VALUES clause cannot be followed by [LIMIT].
</ul>
<h3>The WITH Clause</h3>
<p>^SELECT statements may be optionally preceded by a single
[WITH clause] that defines one or more [common table expressions]
|