Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add the matchinfo(..,'y') option addition to the change log. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
0cd02758ec3236bf32b01ecea0e55045 |
User & Date: | drh 2015-05-04 12:16:15.248 |
Context
2015-05-04
| ||
13:26 | Add support for the --lib option on sqldiff.exe. (check-in: 2924043d8c user: drh tags: trunk) | |
12:16 | Add the matchinfo(..,'y') option addition to the change log. (check-in: 0cd02758ec user: drh tags: trunk) | |
12:03 | Minor tweaks to documentation hyperlinks. (check-in: eefff25d55 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
17 18 19 20 21 22 23 24 25 26 27 28 29 30 | set aChng($nChng) [list $date $desc $options] incr nChng } chng {2015-06-00 (3.8.10)} { <li>Added the [sqldiff.exe] utility program for computing the differences between two SQLite database files. <li>Performance optimizations for [ORDER BY], [VACUUM], [CREATE INDEX], [PRAGMA integrity_check], and [PRAGMA quick_check]. <li>Fix many obscure problems discovered while [SQL fuzzing]. <li>Identify all methods for important objects in the interface documentation. ([sqlite3_context|example]) <li>Made the [American Fuzzy Lop fuzzer] a standard part of SQLite's [testing|testing strategy]. | > > | 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | set aChng($nChng) [list $date $desc $options] incr nChng } chng {2015-06-00 (3.8.10)} { <li>Added the [sqldiff.exe] utility program for computing the differences between two SQLite database files. <li>Added the <a href="fts3.html#matchinfo-y">y format string</a> to the [matchinfo()] function of [FTS3]. <li>Performance optimizations for [ORDER BY], [VACUUM], [CREATE INDEX], [PRAGMA integrity_check], and [PRAGMA quick_check]. <li>Fix many obscure problems discovered while [SQL fuzzing]. <li>Identify all methods for important objects in the interface documentation. ([sqlite3_context|example]) <li>Made the [American Fuzzy Lop fuzzer] a standard part of SQLite's [testing|testing strategy]. |
︙ | ︙ |
Changes to pages/fts3.in.
︙ | ︙ | |||
1085 1086 1087 1088 1089 1090 1091 | of integers in the returned array depends on both the query and the value of the second argument (if any) passed to the matchinfo function. <p> The matchinfo function is called with either one or two arguments. As for all auxiliary functions, the first argument must be the special [FTS hidden column]. The second argument, if it is specified, must be a text value | | | 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 | of integers in the returned array depends on both the query and the value of the second argument (if any) passed to the matchinfo function. <p> The matchinfo function is called with either one or two arguments. As for all auxiliary functions, the first argument must be the special [FTS hidden column]. The second argument, if it is specified, must be a text value comprised only of the characters 'p', 'c', 'n', 'a', 'l', 's', 'x', and 'y'. If no second argument is explicitly supplied, it defaults to "pcx". The second argument is referred to as the "format string" below. <p> Characters in the matchinfo format string are processed from left to right. Each character in the format string causes one or more 32-bit unsigned integer values to be added to the returned array. The "values" column in |
︙ | ︙ | |||
1129 1130 1131 1132 1133 1134 1135 | etc. In other words, the data for occurrences of phrase <i>p</i> in column <i>c</i> may be found using the following formula: <pre> hits_this_row = array[3 * (c + p*cols) + 0] hits_all_rows = array[3 * (c + p*cols) + 1] docs_with_hits = array[3 * (c + p*cols) + 2] </pre> | | | 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 | etc. In other words, the data for occurrences of phrase <i>p</i> in column <i>c</i> may be found using the following formula: <pre> hits_this_row = array[3 * (c + p*cols) + 0] hits_all_rows = array[3 * (c + p*cols) + 1] docs_with_hits = array[3 * (c + p*cols) + 2] </pre> <tr><td><a name="matchinfo-y">y</a> <td style="white-space:nowrap"><i>cols</i> * <i>phrases</i> <td> For each distinct combination of a phrase and table column, the number of usable phrase matches that appear in the column. This is usually identical to the first value in each set of three returned by the 'x' directive (see above). However, the number of hits reported by the 'y' directive is zero for any phrase that is part of a sub-expression that does not match the current row. This makes a difference for |
︙ | ︙ |