Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| SHA1 Hash: | 4d3f01f58ba6e65107dd3d1ddf2f039e3c9cd2ec |
|---|---|
| Date: | 2010-02-26 15:39:55 |
| User: | drh |
| Comment: | Add documentation for sqlite3_compileoption_get() and related routines and pragmas. Fix up hyperlinks. |
Tags And Properties
- branch=trunk inherited from [b2e03e19ab]
- sym-trunk inherited from [b2e03e19ab]
Changes
Changes to pages/changes.in
42 } 42 } 43 } 43 } 44 44 45 chng {2010 March 08 (3.6.23)} { 45 chng {2010 March 08 (3.6.23)} { 46 <li> Added the [secure_delete pragma]. 46 <li> Added the [secure_delete pragma]. 47 <li> Added the [sqlite3_compileoption_used()] and 47 <li> Added the [sqlite3_compileoption_used()] and 48 [sqlite3_compileoption_get()] interfaces as well as the 48 [sqlite3_compileoption_get()] interfaces as well as the 49 [compile_options pragma] and the [sqlite_compile_option_used()] SQL | 49 [compile_options pragma] and the [sqlite_compileoption_used()] and 50 function. | 50 [sqlite_compileoption_get()] SQL functions. 51 <li> Added the [sqlite3_log()] interface together with the 51 <li> Added the [sqlite3_log()] interface together with the 52 [SQLITE_CONFIG_LOG] verb to [sqlite3_config()]. The ".log" command 52 [SQLITE_CONFIG_LOG] verb to [sqlite3_config()]. The ".log" command 53 is added to the [Command Line Interface]. 53 is added to the [Command Line Interface]. 54 <li> Improvements to [FTS3]. 54 <li> Improvements to [FTS3]. 55 <li> Improvements and bug-fixes in support for [SQLITE_OMIT_FLOATING_POINT]. 55 <li> Improvements and bug-fixes in support for [SQLITE_OMIT_FLOATING_POINT]. 56 <li> The [integrity_check pragma] is enhanced to detect out-of-order rowids. 56 <li> The [integrity_check pragma] is enhanced to detect out-of-order rowids. 57 <li> The ".genfkey" operator has been removed from the 57 <li> The ".genfkey" operator has been removed from the
Changes to pages/compile.in
592 they will just not be enforced. 592 they will just not be enforced. 593 } 593 } 594 594 595 COMPILE_OPTION {SQLITE_OMIT_COMPLETE} { 595 COMPILE_OPTION {SQLITE_OMIT_COMPLETE} { 596 This option causes the [sqlite3_complete()] and [sqlite3_complete16()] 596 This option causes the [sqlite3_complete()] and [sqlite3_complete16()] 597 interfaces to be omitted. 597 interfaces to be omitted. 598 } 598 } > 599 > 600 COMPILE_OPTION {SQLITE_OMIT_COMPILEOPTION_DIAGS} { > 601 This option is used to omit the compile-time option diagnostics available > 602 in SQLite, including the [sqlite3_compileoption_used()] and > 603 [sqlite3_compileoption_get()] C/C++ functions, the > 604 [sqlite_compileoption_used()] and [sqlite_compileoption_get()] SQL functions, > 605 and the [compile_options pragma]. > 606 } 599 607 600 COMPILE_OPTION {SQLITE_OMIT_COMPOUND_SELECT} { 608 COMPILE_OPTION {SQLITE_OMIT_COMPOUND_SELECT} { 601 This option is used to omit the compound [SELECT] functionality. 609 This option is used to omit the compound [SELECT] functionality. 602 [SELECT] statements that use the 610 [SELECT] statements that use the 603 UNION, UNION ALL, INTERSECT or EXCEPT compound SELECT operators will 611 UNION, UNION ALL, INTERSECT or EXCEPT compound SELECT operators will 604 cause a parse error. 612 cause a parse error. 605 } 613 }
Changes to pages/lang.in
1819 of the string X. 1819 of the string X. 1820 ^The string "?000" is returned if the argument is NULL or contains 1820 ^The string "?000" is returned if the argument is NULL or contains 1821 no ASCII alphabetic characters. 1821 no ASCII alphabetic characters. 1822 ^(This function is omitted from SQLite by default. 1822 ^(This function is omitted from SQLite by default. 1823 It is only available if the [SQLITE_SOUNDEX] compile-time option 1823 It is only available if the [SQLITE_SOUNDEX] compile-time option 1824 is used when SQLite is built.)^ 1824 is used when SQLite is built.)^ 1825 } 1825 } > 1826 > 1827 funcdef {sqlite_compileoption_get(N)} {} { > 1828 ^The sqlite_compileoption_get() SQL function is a wrapper around the > 1829 [sqlite3_compileoption_get()] C/C++ function. > 1830 ^This routine returns the N-th compile-time option used to build SQLite > 1831 or NULL if N is out of range. See also the [compile_options pragma]. > 1832 } > 1833 > 1834 funcdef {sqlite_compileoption_used(X)} {} { > 1835 ^The sqlite_compileoption_used() SQL function is a wrapper around the > 1836 [sqlite3_compileoption_used()] C/C++ function. > 1837 ^When the argument X to sqlite_compileoption_used(X) is a string which > 1838 is the name of a compile-time option, this routine returns true (1) or > 1839 false (0) depending on whether or not that option was used during the > 1840 build. > 1841 } 1826 1842 1827 funcdef {sqlite_source_id()} {} { 1843 funcdef {sqlite_source_id()} {} { 1828 ^The sqlite_source_id() function returns a string that identifies the 1844 ^The sqlite_source_id() function returns a string that identifies the 1829 specific version of the source code that was used to build the SQLite 1845 specific version of the source code that was used to build the SQLite 1830 library. ^The string returned by sqlite_source_id() begins with 1846 library. ^The string returned by sqlite_source_id() begins with 1831 the date and time that the source code was checked in and is follows by 1847 the date and time that the source code was checked in and is follows by 1832 an SHA1 hash that uniquely identifies the source tree. ^This function is 1848 an SHA1 hash that uniquely identifies the source tree. ^This function is
Changes to pages/news.in
19 hd_puts "<hr width=\"50%\">" 19 hd_puts "<hr width=\"50%\">" 20 } 20 } 21 21 22 newsitem {2010-Mar-09} {Version 3.6.23} { 22 newsitem {2010-Mar-09} {Version 3.6.23} { 23 SQLite [version 3.6.23] is a regular bimonthly release of SQLite. 23 SQLite [version 3.6.23] is a regular bimonthly release of SQLite. 24 Upgrading from the prior release is purely optional. 24 Upgrading from the prior release is purely optional. 25 25 26 This release contains new pragmas: the [secure_delete pragma], | 26 This release contains new pragmas: the [secure_delete pragma], and 27 the [compile_options pragma], and the [compile_option pragma]. | 27 the [compile_options pragma]. 28 There are a new SQL functions: [sqlite_compile_option_used()]. | 28 There are a new SQL functions: [sqlite_compileoption_used()] > 29 and [sqlite_compileoption_get()]. 29 New C/C++ interfaces: [sqlite3_compileoption_used()], 30 New C/C++ interfaces: [sqlite3_compileoption_used()], 30 [sqlite3_compileoption_get()], [SQLITE_CONFIG_LOG], and 31 [sqlite3_compileoption_get()], [SQLITE_CONFIG_LOG], and 31 [sqlite3_log()]. 32 [sqlite3_log()]. 32 33 33 This release also includes several minor bug fixes and performance 34 This release also includes several minor bug fixes and performance 34 improvements. Support for [SQLITE_OMIT_FLOATING_POINT] is enhanced. 35 improvements. Support for [SQLITE_OMIT_FLOATING_POINT] is enhanced. 35 There are on-going improvements to [FTS3]. 36 There are on-going improvements to [FTS3].
Changes to pages/pragma.in
870 applications for any purpose.</p> 870 applications for any purpose.</p> 871 </li> 871 </li> 872 </ul> 872 </ul> 873 873 874 <tcl>Section {Pragmas to debug the library} debug</tcl> 874 <tcl>Section {Pragmas to debug the library} debug</tcl> 875 875 876 <ul> 876 <ul> > 877 <tcl>Subsection compile_options</tcl> > 878 <li><p><b>PRAGMA compile_options;</b></p> > 879 <p>^This pragma returns the names of [compile-time options] used when > 880 building SQLite, one option per row. ^The "SQLITE_" prefix is omitted > 881 from the returned option names. See also the > 882 [sqlite3_compileoption_get()] C/C++ interface and the > 883 [sqlite_compileoption_get()] SQL functions.</p></li> > 884 877 <tcl>Subsection integrity_check</tcl> 885 <tcl>Subsection integrity_check</tcl> 878 <li><p><b>PRAGMA integrity_check; 886 <li><p><b>PRAGMA integrity_check; 879 <br>PRAGMA integrity_check(</b><i>integer</i><b>)</b></p> 887 <br>PRAGMA integrity_check(</b><i>integer</i><b>)</b></p> 880 <p>^This pragma does an integrity check of the entire database. ^It 888 <p>^This pragma does an integrity check of the entire database. ^It 881 looks for out-of-order records, missing pages, malformed records, and 889 looks for out-of-order records, missing pages, malformed records, and 882 corrupt indices. 890 corrupt indices. 883 ^If any problems are found, then strings are returned (as multiple 891 ^If any problems are found, then strings are returned (as multiple