43
43
.ne { background: url(images/ne.png) 100% 0% no-repeat }
44
44
.nw { background: url(images/nw.png) 0% 0% no-repeat }
46
/* Things for "fancyformat" documents start here. */
47
.fancy .codeblock i { color: darkblue; }
48
.fancy h1,.fancy h2,.fancy h3,.fancy h4 {font-weight:normal;color:#80a796}
49
.fancy h2 { margin-left: 10px }
50
.fancy h3 { margin-left: 20px }
51
.fancy h4 { margin-left: 30px }
52
.fancy th {white-space:nowrap;text-align:left;border-bottom:solid 1px #444}
53
.fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top}
54
.fancy #toc a { color: darkblue ; text-decoration: none }
55
.fancy .todo { color: #AA3333 ; font-style : italic }
56
.fancy .todo:before { content: 'TODO:' }
57
.fancy p.todo { border: solid #AA3333 1px; padding: 1ex }
58
.fancy img { display:block; }
59
.fancy :link:hover, .fancy :visited:hover { background: wheat }
60
.fancy p,.fancy ul,.fancy ol { margin: 1em 5ex }
61
.fancy li p { margin: 1em 0 }
62
/* End of "fancyformat" specific rules. */
47
65
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
65
83
<a href="download.html">Download</a>
66
84
<a href="copyright.html">License</a>
67
85
<a href="news.html">News</a>
68
<a href="http://www.sqlite.org/cvstrac/index">Developers</a>
86
<!-- <a href="dev.html">Developers</a> -->
69
87
<a href="support.html">Support</a>
70
88
</div></div></div></div></div>
189
207
<a name="controlfeatures"></a>
190
208
<h2>1.3 Options To Control Operating Characteristics</h2>
192
<a name="have_isnan"></a>
210
<a name="case_sensitive_like"></a>
211
<p><b>SQLITE_CASE_SENSITIVE_LIKE</b></p><blockquote><p>
212
If this option is present, then the built-in <a href="lang_expr.html#like">LIKE</a> operator will be
213
case sensitive. This same effect can be achieved at run-time using
214
the <a href="pragma.html#pragma_case_sensitive_like">case_sensitive_like pragma</a>.
215
</p></blockquote><a name="have_isnan"></a>
193
216
<p><b>SQLITE_HAVE_ISNAN</b></p><blockquote><p>
194
217
If this option is present, then SQLite will use the isnan() function from
195
218
the system math library. Without this option (the default behavior)
406
429
<p><b>SQLITE_ENABLE_RTREE</b></p><blockquote><p>
407
430
This option causes SQLite to include support for the
408
431
<a href="rtree.html">R*Tree index extension</a>.
432
</p></blockquote><a name="enable_stat2"></a>
433
<p><b>SQLITE_ENABLE_STAT2</b></p><blockquote><p>
434
This option adds additional logic to the <a href="lang_analyze.html">ANALYZE</a> command and to
435
the <a href="optoverview.html">query planner</a> that can help SQLite to chose a better query plan
436
under certain situations. The <a href="lang_analyze.html">ANALYZE</a> command is enhanced to collect
437
a 10-sample histogram of the data in each index and store that histogram
438
in the <b>sqlite_stat2</b> table. The query planner will then use the
439
histogram data to help it estimate how many rows will be selected by a
440
<a href="optoverview.html#rangequery">range constraint</a> in a WHERE clause.
409
441
</p></blockquote><a name="enable_update_delete_limit"></a>
410
442
<p><b>SQLITE_ENABLE_UPDATE_DELETE_LIMIT</b></p><blockquote><p>
411
443
This option enables an optional ORDER BY and LIMIT clause on
499
531
header file "sqlite3.h") can then be moved to a non-unix platform
500
532
for final compilation using a native compiler.</p>
503
The following SQLITE_OMIT_* options are available:
510
<li> <a href="compile.html#omit_authorization">SQLITE_OMIT_AUTHORIZATION</a> </li>
511
<li> <a href="compile.html#omit_autoinit">SQLITE_OMIT_AUTOINIT</a> </li>
512
<li> <a href="compile.html#omit_between_optimization">SQLITE_OMIT_BETWEEN_OPTIMIZATION</a> </li>
513
<li> <a href="compile.html#omit_blob_literal">SQLITE_OMIT_BLOB_LITERAL</a> </li>
514
<li> <a href="compile.html#omit_builtin_test">SQLITE_OMIT_BUILTIN_TEST</a> </li>
515
<li> <a href="compile.html#omit_check">SQLITE_OMIT_CHECK</a> </li>
516
<li> <a href="compile.html#omit_complete">SQLITE_OMIT_COMPLETE</a> </li>
517
<li> <a href="compile.html#omit_datetime_funcs">SQLITE_OMIT_DATETIME_FUNCS</a> </li>
518
<li> <a href="compile.html#omit_decltype">SQLITE_OMIT_DECLTYPE</a> </li>
519
<li> <a href="compile.html#omit_deprecated">SQLITE_OMIT_DEPRECATED</a> </li>
520
<li> <a href="compile.html#omit_diskio">SQLITE_OMIT_DISKIO</a> </li>
521
<li> <a href="compile.html#omit_flag_pragmas">SQLITE_OMIT_FLAG_PRAGMAS</a> </li>
522
<li> <a href="compile.html#omit_floating_point">SQLITE_OMIT_FLOATING_POINT</a> </li>
523
<li> <a href="compile.html#omit_get_table">SQLITE_OMIT_GET_TABLE</a> </li>
524
<li> <a href="compile.html#omit_incrblob">SQLITE_OMIT_INCRBLOB</a> </li>
525
<li> <a href="compile.html#omit_integrity_check">SQLITE_OMIT_INTEGRITY_CHECK</a> </li>
526
<li> <a href="compile.html#omit_like_optimization">SQLITE_OMIT_LIKE_OPTIMIZATION</a> </li>
531
<li> <a href="compile.html#omit_load_extension">SQLITE_OMIT_LOAD_EXTENSION</a> </li>
532
<li> <a href="compile.html#omit_localtime">SQLITE_OMIT_LOCALTIME</a> </li>
533
<li> <a href="compile.html#omit_memorydb">SQLITE_OMIT_MEMORYDB</a> </li>
534
<li> <a href="compile.html#omit_or_optimization">SQLITE_OMIT_OR_OPTIMIZATION</a> </li>
535
<li> <a href="compile.html#omit_pager_pragmas">SQLITE_OMIT_PAGER_PRAGMAS</a> </li>
536
<li> <a href="compile.html#omit_progress_callback">SQLITE_OMIT_PROGRESS_CALLBACK</a> </li>
537
<li> <a href="compile.html#omit_quickbalance">SQLITE_OMIT_QUICKBALANCE</a> </li>
538
<li> <a href="compile.html#omit_schema_pragmas">SQLITE_OMIT_SCHEMA_PRAGMAS</a> </li>
539
<li> <a href="compile.html#omit_schema_version_pragmas">SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS</a> </li>
540
<li> <a href="compile.html#omit_shared_cache">SQLITE_OMIT_SHARED_CACHE</a> </li>
541
<li> <a href="compile.html#omit_subquery">SQLITE_OMIT_SUBQUERY</a> </li>
542
<li> <a href="compile.html#omit_tcl_variable">SQLITE_OMIT_TCL_VARIABLE</a> </li>
543
<li> <a href="compile.html#omit_trace">SQLITE_OMIT_TRACE</a> </li>
544
<li> <a href="compile.html#omit_truncate_optimization">SQLITE_OMIT_TRUNCATE_OPTIMIZATION</a> </li>
545
<li> <a href="compile.html#omit_utf16">SQLITE_OMIT_UTF16</a> </li>
546
<li> <a href="compile.html#omit_wsd">SQLITE_OMIT_WSD</a> </li>
547
<li> <a href="compile.html#omit_xfer_opt">SQLITE_OMIT_XFER_OPT</a> </li>
555
534
<p>All of the SQLITE_OMIT_* options are unsupported.</p>
699
678
</p></blockquote><a name="omit_foreign_key"></a>
700
679
<p><b>SQLITE_OMIT_FOREIGN_KEY</b></p><blockquote><p>
701
If this option is defined, FOREIGN KEY clauses in column declarations are
680
If this option is defined, then <a href="foreignkeys.html">foreign key constraint</a> syntax is
703
682
</p></blockquote><a name="omit_get_table"></a>
704
683
<p><b>SQLITE_OMIT_GET_TABLE</b></p><blockquote><p>
705
684
This option causes support for <a href="c3ref/free_table.html">sqlite3_get_table()</a> and
798
777
Defining this option omits support for TRIGGER objects. Neither the
799
778
<a href="lang_createtrigger.html">CREATE TRIGGER</a> or <a href="lang_droptrigger.html">DROP TRIGGER</a>
800
779
commands are available in this case, and attempting to execute
801
either will result in a parse error.</p>
803
<p> WARNING: If this macro is defined, it will not be possible to open a database
804
for which the schema contains TRIGGER objects.
780
either will result in a parse error.
781
This option also disables enforcement of <a href="foreignkeys.html">foreign key constraints</a>,
782
since the code that implements triggers and which is omitted by this
783
option is also used to implement <a href="foreignkeys.html#fk_actions">foreign key actions</a>.
805
784
</p></blockquote><a name="omit_truncate_optimization"></a>
806
785
<p><b>SQLITE_OMIT_TRUNCATE_OPTIMIZATION</b></p><blockquote><p>
807
786
A default build of SQLite, if a <a href="lang_delete.html">DELETE</a> statement has no WHERE clause