Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add documentation for SQLITE_ALLOW_URI_AUTHORITY. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
cadb86b39894f41fcf1f851aa78c8377 |
User & Date: | drh 2013-08-07 23:38:42.510 |
Context
2013-08-08
| ||
02:54 | Fix typos in the partial index document. (check-in: 8bf9d71fd6 user: drh tags: trunk) | |
2013-08-07
| ||
23:38 | Add documentation for SQLITE_ALLOW_URI_AUTHORITY. (check-in: cadb86b398 user: drh tags: trunk) | |
15:39 | Merge the changes from the 3.7.17 branch into trunk. (check-in: 69c4153640 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
52 53 54 55 56 57 58 59 60 61 62 63 64 65 | <li>Cut-over to the [next generation query planner] for faster and better query plans. <li>The [EXPLAIN QUERY PLAN] output no longer shows an estimate of the number of rows generated by each loop in a join. <li>Added the [FTS4 notindexed option], allowing non-indexed columns in an FTS4 table. <li>Added the [SQLITE_STMTSTATUS_VM_STEP] option to [sqlite3_stmt_status()]. <li>Added the "percentile()" function as a [loadable extension] in the ext/misc subdirectory of the source tree. <li>Add the [sqlite3_cancel_auto_extension(X)] interface. <li>A running SELECT statement that lacks a FROM clause (or any other statement that never reads or writes from any database file) will not prevent a read transaction from closing. <li>Add the [SQLITE_DEFAULT_AUTOMATIC_INDEX] compile-time option. Setting this option to 0 disables automatic indices by default. <li>Issue an [SQLITE_WARNING_AUTOINDEX] warning on the [SQLITE_CONFIG_LOG] whenever | > | 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 | <li>Cut-over to the [next generation query planner] for faster and better query plans. <li>The [EXPLAIN QUERY PLAN] output no longer shows an estimate of the number of rows generated by each loop in a join. <li>Added the [FTS4 notindexed option], allowing non-indexed columns in an FTS4 table. <li>Added the [SQLITE_STMTSTATUS_VM_STEP] option to [sqlite3_stmt_status()]. <li>Added the "percentile()" function as a [loadable extension] in the ext/misc subdirectory of the source tree. <li>Added the [SQLITE_ALLOW_URI_AUTHORITY] compile-time option. <li>Add the [sqlite3_cancel_auto_extension(X)] interface. <li>A running SELECT statement that lacks a FROM clause (or any other statement that never reads or writes from any database file) will not prevent a read transaction from closing. <li>Add the [SQLITE_DEFAULT_AUTOMATIC_INDEX] compile-time option. Setting this option to 0 disables automatic indices by default. <li>Issue an [SQLITE_WARNING_AUTOINDEX] warning on the [SQLITE_CONFIG_LOG] whenever |
︙ | ︙ |
Changes to pages/compile.in.
︙ | ︙ | |||
378 379 380 381 382 383 384 385 386 387 388 389 390 391 | </tcl> <a name="enablefeatures"></a> <h2>1.4 Options To Enable Features Normally Turned Off</h2> <tcl> COMPILE_OPTION {SQLITE_ALLOW_COVERING_INDEX_SCAN=<i><0 or 1></i>} { This C-preprocess macro determines the default setting of the [SQLITE_CONFIG_COVERING_INDEX_SCAN] configuration setting. It defaults to 1 (on) which means that covering indices are used for full table scans where possible, in order to reduce I/O and improve performance. However, the use of a covering index for a full scan will cause results to appear in a different order from legacy, which could cause some | > > > > > > > > > > | 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 | </tcl> <a name="enablefeatures"></a> <h2>1.4 Options To Enable Features Normally Turned Off</h2> <tcl> COMPILE_OPTION {SQLITE_ALLOW_URI_AUTHORITY} { [URI filenames] normally throw an error is the authority section is not either empty or "localhost". However, if SQLite is compiled with the SQLITE_ALLOW_URI_AUTHORITY compile-time option, then the URI is is converted into a Uniform Naming Convention (UNC) filename and passed down to the underlying operating system that way. <p> Some future versions of SQLite may change to enable this feature by default. } COMPILE_OPTION {SQLITE_ALLOW_COVERING_INDEX_SCAN=<i><0 or 1></i>} { This C-preprocess macro determines the default setting of the [SQLITE_CONFIG_COVERING_INDEX_SCAN] configuration setting. It defaults to 1 (on) which means that covering indices are used for full table scans where possible, in order to reduce I/O and improve performance. However, the use of a covering index for a full scan will cause results to appear in a different order from legacy, which could cause some |
︙ | ︙ |
Changes to pages/uri.in.
︙ | ︙ | |||
77 78 79 80 81 82 83 84 85 86 87 88 89 90 | </p> <ul> <li> ^(The scheme of the URI must be "<tt>file:</tt>". Any other scheme results in the input being treated as an ordinary filename.)^ <li> ^(The authority may be omitted, may be blank, or may be "<tt>localhost</tt>". Any other authority results in an error.)^ <li> ^The path is optional if the authority is present. ^If the authority is omitted then the path is required. <li> ^The query string is optional. ^If the query string is present, then all query parameters are passed through into the xOpen method of the underlying [VFS]. <li> ^(The fragment is optional. If present, it is ignored.)^ </ul> | > > > | 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 | </p> <ul> <li> ^(The scheme of the URI must be "<tt>file:</tt>". Any other scheme results in the input being treated as an ordinary filename.)^ <li> ^(The authority may be omitted, may be blank, or may be "<tt>localhost</tt>". Any other authority results in an error.)^ Exception: If SQLite is compiled with [SQLITE_ALLOW_URI_AUTHORITY] then any authority value other than "localhost" is passed through to the underlying operating system as a UNC filename. <li> ^The path is optional if the authority is present. ^If the authority is omitted then the path is required. <li> ^The query string is optional. ^If the query string is present, then all query parameters are passed through into the xOpen method of the underlying [VFS]. <li> ^(The fragment is optional. If present, it is ignored.)^ </ul> |
︙ | ︙ |