Documentation Source Text

Check-in [f61b2a7935]
Login

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.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: f61b2a7935bf9b73947056b4c3744c3c588f66c8
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
Hide Diffs Unified Diffs Ignore Whitespace Patch

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>
    : ~ ! @ # $ % &#94; &amp; * ( ) + , =
</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]