diff options
Diffstat (limited to 'www/doc_backlink_crossref.html')
| -rw-r--r-- | www/doc_backlink_crossref.html | 164 |
1 files changed, 120 insertions, 44 deletions
diff --git a/www/doc_backlink_crossref.html b/www/doc_backlink_crossref.html index 10a2e62..8abf1fd 100644 --- a/www/doc_backlink_crossref.html +++ b/www/doc_backlink_crossref.html @@ -367,6 +367,7 @@ antiRobotDefense(); <a href="lang_createtable.html#tablecoldef">lang_createtable.html#tablecoldef</a> <a href="lang_select.html#fromclause">lang_select.html#fromclause</a> <a href="oldnews.html">oldnews.html</a> + <a href="optoverview.html#flattening">optoverview.html#flattening</a> <a href="optoverview.html#like_opt">optoverview.html#like_opt</a> <a href="withoutrowid.html">withoutrowid.html</a> <li>affshort → <a href="appfileformat.html">appfileformat.html</a> @@ -411,7 +412,7 @@ antiRobotDefense(); <a href="fileformat2.html#serialtype">fileformat2.html#serialtype</a> <a href="foreignkeys.html#fk_actions">foreignkeys.html#fk_actions</a> <a href="lang.html">lang.html</a> - <a href="lang_analyze.html#req">lang_analyze.html#req</a> + <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> <a href="lang_createtable.html#notnullconst">lang_createtable.html#notnullconst</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_naming.html">lang_naming.html</a> @@ -513,12 +514,15 @@ antiRobotDefense(); <a href="howtocompile.html#cli">howtocompile.html#cli</a> <a href="releaselog/3_11_0.html">releaselog/3_11_0.html</a> <a href="releaselog/3_11_1.html">releaselog/3_11_1.html</a> +<li>ambiguous dates → <a href="changes.html#version_3_46_0">changes.html#version_3_46_0</a> + <a href="releaselog/3_46_0.html">releaselog/3_46_0.html</a> <li>American Fuzzy Lop fuzzer → <a href="changes.html#version_3_8_10">changes.html#version_3_8_10</a> <a href="releaselog/3_8_10.html">releaselog/3_8_10.html</a> <a href="releaselog/3_8_10_1.html">releaselog/3_8_10_1.html</a> <a href="releaselog/3_8_10_2.html">releaselog/3_8_10_2.html</a> <li>analysis_limit → <a href="lang_analyze.html#approx">lang_analyze.html#approx</a> -<li>analysis_limit pragma → <a href="lang_analyze.html#req">lang_analyze.html#req</a> +<li>analysis_limit pragma → <a href="changes.html#version_3_46_0">changes.html#version_3_46_0</a> + <a href="releaselog/3_46_0.html">releaselog/3_46_0.html</a> <li>ANALYZE → <a href="appfileformat.html">appfileformat.html</a> <a href="c3ref/stmt_scanstatus.html">c3ref/stmt_scanstatus.html</a> <a href="capi3ref.html#sqlite3_stmt_scanstatus">capi3ref.html#sqlite3_stmt_scanstatus</a> @@ -543,12 +547,12 @@ antiRobotDefense(); <a href="news.html">news.html</a> <a href="oldnews.html">oldnews.html</a> <a href="optoverview.html#autoindex">optoverview.html#autoindex</a> + <a href="optoverview.html#joins">optoverview.html#joins</a> <a href="optoverview.html#manctrl">optoverview.html#manctrl</a> <a href="optoverview.html#multi_index">optoverview.html#multi_index</a> <a href="optoverview.html#option2">optoverview.html#option2</a> <a href="optoverview.html#rangequery">optoverview.html#rangequery</a> <a href="optoverview.html#skipscan">optoverview.html#skipscan</a> - <a href="optoverview.html#table_order">optoverview.html#table_order</a> <a href="pragma.html#pragma_analysis_limit">pragma.html#pragma_analysis_limit</a> <a href="pragma.html#pragma_optimize">pragma.html#pragma_optimize</a> <a href="queryplanner-ng.html#fossilcasestudy">queryplanner-ng.html#fossilcasestudy</a> @@ -657,6 +661,7 @@ antiRobotDefense(); <a href="releaselog/3_32_1.html">releaselog/3_32_1.html</a> <a href="releaselog/3_32_2.html">releaselog/3_32_2.html</a> <a href="releaselog/3_32_3.html">releaselog/3_32_3.html</a> +<li>Approximate ANALYZE For Large Databases → <a href="lang_analyze.html#pragopt">lang_analyze.html#pragopt</a> <li>asin → <a href="lang_mathfunc.html">lang_mathfunc.html</a> <li>asinh → <a href="lang_mathfunc.html">lang_mathfunc.html</a> <li>asynchronous I/O backend → <a href="oldnews.html">oldnews.html</a> @@ -751,6 +756,8 @@ antiRobotDefense(); <a href="releaselog/3_19_2.html">releaselog/3_19_2.html</a> <a href="releaselog/3_19_3.html">releaselog/3_19_3.html</a> <li>auto modifier → <a href="changes.html#version_3_38_0">changes.html#version_3_38_0</a> + <a href="lang_datefunc.html">lang_datefunc.html</a> + <a href="lang_datefunc.html#tmval">lang_datefunc.html#tmval</a> <a href="releaselog/3_38_0.html">releaselog/3_38_0.html</a> <a href="releaselog/3_38_1.html">releaselog/3_38_1.html</a> <a href="releaselog/3_38_2.html">releaselog/3_38_2.html</a> @@ -822,6 +829,7 @@ antiRobotDefense(); <a href="releaselog/3_9_3.html">releaselog/3_9_3.html</a> <a href="rescode.html#warning_autoindex">rescode.html#warning_autoindex</a> <li>automatic_index pragma → <a href="optoverview.html#autoindex">optoverview.html#autoindex</a> +<li>Automatically Running ANALYZE → <a href="lang_analyze.html#pragopt">lang_analyze.html#pragopt</a> <li>automerge command → <a href="changes.html#version_3_8_5">changes.html#version_3_8_5</a> <a href="releaselog/3_8_5.html">releaselog/3_8_5.html</a> <li>auxiliary columns → <a href="rtree.html#xshadow">rtree.html#xshadow</a> @@ -965,6 +973,7 @@ antiRobotDefense(); <a href="releaselog/3_37_2.html">releaselog/3_37_2.html</a> <a href="rowvalue.html#rvinop">rowvalue.html#rvinop</a> <a href="vtab.html#colUsed">vtab.html#colUsed</a> + <a href="whybytecode.html">whybytecode.html</a> <li>bytecode and tables_used virtual tables → <a href="compile.html#enable_bytecode_vtab">compile.html#enable_bytecode_vtab</a> <li>bytecode engine → <a href="changes.html#version_3_35_3">changes.html#version_3_35_3</a> <a href="changes.html#version_3_45_1">changes.html#version_3_45_1</a> @@ -1309,6 +1318,7 @@ antiRobotDefense(); <a href="releaselog/3_45_1.html">releaselog/3_45_1.html</a> <a href="releaselog/3_45_2.html">releaselog/3_45_2.html</a> <a href="releaselog/3_45_3.html">releaselog/3_45_3.html</a> + <a href="releaselog/3_46_0.html">releaselog/3_46_0.html</a> <a href="releaselog/3_4_0.html">releaselog/3_4_0.html</a> <a href="releaselog/3_4_1.html">releaselog/3_4_1.html</a> <a href="releaselog/3_4_2.html">releaselog/3_4_2.html</a> @@ -1633,6 +1643,7 @@ antiRobotDefense(); <a href="releaselog/3_6_21.html">releaselog/3_6_21.html</a> <a href="releaselog/3_6_23.html">releaselog/3_6_23.html</a> <li>command-line interface → <a href="features.html">features.html</a> + <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> <li>command-line shell → <a href="changes.html#version_3_10_0">changes.html#version_3_10_0</a> <a href="changes.html#version_3_11_0">changes.html#version_3_11_0</a> <a href="changes.html#version_3_12_0">changes.html#version_3_12_0</a> @@ -1982,6 +1993,7 @@ antiRobotDefense(); <a href="releaselog/3_45_1.html">releaselog/3_45_1.html</a> <a href="releaselog/3_45_2.html">releaselog/3_45_2.html</a> <a href="releaselog/3_45_3.html">releaselog/3_45_3.html</a> + <a href="releaselog/3_46_0.html">releaselog/3_46_0.html</a> <a href="releaselog/3_4_0.html">releaselog/3_4_0.html</a> <a href="releaselog/3_4_1.html">releaselog/3_4_1.html</a> <a href="releaselog/3_4_2.html">releaselog/3_4_2.html</a> @@ -2230,6 +2242,7 @@ antiRobotDefense(); <a href="fullsql.html">fullsql.html</a> <a href="lang.html">lang.html</a> <a href="lang_altertable.html#otheralter">lang_altertable.html#otheralter</a> + <a href="lang_analyze.html#pragopt">lang_analyze.html#pragopt</a> <a href="lang_dropindex.html">lang_dropindex.html</a> <a href="limits.html#max_page_count">limits.html#max_page_count</a> <a href="oldnews.html">oldnews.html</a> @@ -2240,6 +2253,7 @@ antiRobotDefense(); <a href="pragma.html#pragma_index_xinfo">pragma.html#pragma_index_xinfo</a> <a href="pragma.html#pragma_journal_mode">pragma.html#pragma_journal_mode</a> <a href="pragma.html#pragma_legacy_alter_table">pragma.html#pragma_legacy_alter_table</a> + <a href="pragma.html#pragma_optimize">pragma.html#pragma_optimize</a> <a href="releaselog/3_7_8.html">releaselog/3_7_8.html</a> <a href="releaselog/3_8_10.html">releaselog/3_8_10.html</a> <a href="releaselog/3_8_10_1.html">releaselog/3_8_10_1.html</a> @@ -2513,7 +2527,6 @@ antiRobotDefense(); <a href="pragma.html#pragma_journal_mode">pragma.html#pragma_journal_mode</a> <a href="pragma.html#pragma_legacy_alter_table">pragma.html#pragma_legacy_alter_table</a> <a href="pragma.html#pragma_mmap_size">pragma.html#pragma_mmap_size</a> - <a href="pragma.html#pragma_optimize">pragma.html#pragma_optimize</a> <a href="releaselog/3_5_8.html">releaselog/3_5_8.html</a> <a href="releaselog/3_6_1.html">releaselog/3_6_1.html</a> <a href="releaselog/3_7_17.html">releaselog/3_7_17.html</a> @@ -2588,11 +2601,13 @@ antiRobotDefense(); <a href="changes.html#version_3_38_1">changes.html#version_3_38_1</a> <a href="changes.html#version_3_42_0">changes.html#version_3_42_0</a> <a href="changes.html#version_3_43_0">changes.html#version_3_43_0</a> + <a href="changes.html#version_3_46_0">changes.html#version_3_46_0</a> <a href="compile.html#gmtime_r">compile.html#gmtime_r</a> <a href="compile.html#localtime_r">compile.html#localtime_r</a> <a href="compile.html#localtime_s">compile.html#localtime_s</a> <a href="datatype3.html#datetime">datatype3.html#datetime</a> <a href="deterministic.html#dtexception">deterministic.html#dtexception</a> + <a href="news.html">news.html</a> <a href="quirks.html">quirks.html</a> <a href="releaselog/3_10_0.html">releaselog/3_10_0.html</a> <a href="releaselog/3_10_1.html">releaselog/3_10_1.html</a> @@ -2615,6 +2630,7 @@ antiRobotDefense(); <a href="releaselog/3_43_0.html">releaselog/3_43_0.html</a> <a href="releaselog/3_43_1.html">releaselog/3_43_1.html</a> <a href="releaselog/3_43_2.html">releaselog/3_43_2.html</a> + <a href="releaselog/3_46_0.html">releaselog/3_46_0.html</a> <li>date/time special case → <a href="changes.html#version_3_20_0">changes.html#version_3_20_0</a> <a href="releaselog/3_20_0.html">releaselog/3_20_0.html</a> <a href="releaselog/3_20_1.html">releaselog/3_20_1.html</a> @@ -2708,7 +2724,7 @@ antiRobotDefense(); <a href="fullsql.html">fullsql.html</a> <a href="isolation.html">isolation.html</a> <a href="lang.html">lang.html</a> - <a href="lang_analyze.html#req">lang_analyze.html#req</a> + <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> <a href="lang_createtable.html#notnullconst">lang_createtable.html#notnullconst</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> @@ -2822,7 +2838,7 @@ antiRobotDefense(); <a href="fts3.html#fts4">fts3.html#fts4</a> <a href="lang.html">lang.html</a> <a href="lang_altertable.html#otheralter">lang_altertable.html#otheralter</a> - <a href="lang_analyze.html#req">lang_analyze.html#req</a> + <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createvtab.html">lang_createvtab.html</a> @@ -3181,6 +3197,7 @@ antiRobotDefense(); <a href="intern-v-extern-blob.html">intern-v-extern-blob.html</a> <a href="whentouse.html#appfileformat">whentouse.html#appfileformat</a> <a href="whentouse.html#container">whentouse.html#container</a> + <a href="whybytecode.html">whybytecode.html</a> <li>file control → <a href="c3ref/snapshot_recover.html">c3ref/snapshot_recover.html</a> <a href="c3ref/total_changes.html">c3ref/total_changes.html</a> <a href="capi3ref.html#sqlite3_snapshot_recover">capi3ref.html#sqlite3_snapshot_recover</a> @@ -3249,6 +3266,7 @@ antiRobotDefense(); <a href="windowfunctions.html#wexcls">windowfunctions.html#wexcls</a> <li>flattened → <a href="changes.html#version_3_35_0">changes.html#version_3_35_0</a> <a href="lang_with.html#mathint">lang_with.html#mathint</a> + <a href="optoverview.html#coroutines">optoverview.html#coroutines</a> <a href="optoverview.html#pushdown">optoverview.html#pushdown</a> <a href="releaselog/3_35_0.html">releaselog/3_35_0.html</a> <a href="releaselog/3_35_1.html">releaselog/3_35_1.html</a> @@ -3870,7 +3888,7 @@ antiRobotDefense(); <li>http://en.wikipedia.org/wiki/ACID → <a href="about.html">about.html</a> <a href="transactional.html">transactional.html</a> <li>http://en.wikipedia.org/wiki/Charlotte,_North_Carolina → <a href="crew.html">crew.html</a> -<li>http://en.wikipedia.org/wiki/Coordinated_Universal_Time → <a href="lang_datefunc.html#tmdif">lang_datefunc.html#tmdif</a> +<li>http://en.wikipedia.org/wiki/Coordinated_Universal_Time → <a href="lang_datefunc.html#tmval">lang_datefunc.html#tmval</a> <li>http://en.wikipedia.org/wiki/Endianness → <a href="about.html">about.html</a> <a href="onefile.html">onefile.html</a> <li>http://en.wikipedia.org/wiki/Fuzz_testing → <a href="testing.html#fuzztesting">testing.html#fuzztesting</a> @@ -3878,7 +3896,7 @@ antiRobotDefense(); <li>http://en.wikipedia.org/wiki/ISO_8601 → <a href="lang_datefunc.html">lang_datefunc.html</a> <li>http://en.wikipedia.org/wiki/Julian_day → <a href="lang_datefunc.html">lang_datefunc.html</a> <a href="lang_datefunc.html#jlndy">lang_datefunc.html#jlndy</a> - <a href="lang_datefunc.html#tmdif">lang_datefunc.html#tmdif</a> + <a href="lang_datefunc.html#tmval">lang_datefunc.html#tmval</a> <li>http://en.wikipedia.org/wiki/Kibibyte → <a href="oldnews.html">oldnews.html</a> <li>http://en.wikipedia.org/wiki/Modified_Condition/Decision_Coverage → <a href="testing.html#mcdc">testing.html#mcdc</a> <li>http://en.wikipedia.org/wiki/OpenDocument → <a href="affcase1.html">affcase1.html</a> @@ -3887,7 +3905,7 @@ antiRobotDefense(); <li>http://en.wikipedia.org/wiki/R-tree → <a href="rtree.html">rtree.html</a> <li>http://en.wikipedia.org/wiki/Serializability → <a href="transactional.html">transactional.html</a> <li>http://en.wikipedia.org/wiki/Syslog → <a href="errlog.html">errlog.html</a> -<li>http://en.wikipedia.org/wiki/Unix_time → <a href="lang_datefunc.html#tmshf">lang_datefunc.html#tmshf</a> +<li>http://en.wikipedia.org/wiki/Unix_time → <a href="lang_datefunc.html#jdmod">lang_datefunc.html#jdmod</a> <li>http://en.wikipedia.org/wiki/UUID → <a href="changes.html#version_3_3_13">changes.html#version_3_3_13</a> <a href="releaselog/3_3_13.html">releaselog/3_3_13.html</a> <li>http://en.wikipedia.org/wiki/Zip_%28file_format%29 → <a href="affcase1.html">affcase1.html</a> @@ -4013,7 +4031,7 @@ antiRobotDefense(); <li>http://www.tcl.tk/ → <a href="sqlanalyze.html">sqlanalyze.html</a> <a href="th3.html">th3.html</a> <li>http://www.valgrind.org/ → <a href="qmplan.html">qmplan.html</a> -<li>http://www.w3c.org/TR/NOTE-datetime → <a href="lang_datefunc.html#tmdif">lang_datefunc.html#tmdif</a> +<li>http://www.w3c.org/TR/NOTE-datetime → <a href="lang_datefunc.html#tmval">lang_datefunc.html#tmval</a> <li>http://www.xojo.com/ → <a href="famous.html">famous.html</a> <li>http://zlib.net/ → <a href="sqlar.html">sqlar.html</a> <li>https://airsdk.harman.com → <a href="famous.html">famous.html</a> @@ -4026,7 +4044,9 @@ antiRobotDefense(); <li>https://developers.google.com/open-source/osa#2005-google-oreilly-open-source-award-winners → <a href="oldnews.html">oldnews.html</a> <li>https://digitalocean.com → <a href="qmplan.html">qmplan.html</a> <li>https://docs.microsoft.com/en-us/azure/cosmos-db/serverless-computing-database → <a href="serverless.html">serverless.html</a> +<li>https://eagle.to/ → <a href="crew.html#dan">crew.html#dan</a> <li>https://en.wikipedia.org/wiki/Abstract_syntax_tree → <a href="howitworks.html">howitworks.html</a> + <a href="whybytecode.html">whybytecode.html</a> <li>https://en.wikipedia.org/wiki/Artificial_intelligence → <a href="queryplanner.html">queryplanner.html</a> <li>https://en.wikipedia.org/wiki/Assert.h → <a href="assert.html">assert.html</a> <li>https://en.wikipedia.org/wiki/Berkeley_DB → <a href="howitworks.html">howitworks.html</a> @@ -4036,6 +4056,7 @@ antiRobotDefense(); <a href="releaselog/3_10_2.html">releaselog/3_10_2.html</a> <li>https://en.wikipedia.org/wiki/Database_index#Clustered → <a href="withoutrowid.html">withoutrowid.html</a> <li>https://en.wikipedia.org/wiki/Database_transaction → <a href="howitworks.html">howitworks.html</a> +<li>https://en.wikipedia.org/wiki/Dataflow_programming → <a href="whybytecode.html">whybytecode.html</a> <li>https://en.wikipedia.org/wiki/Declarative_programming → <a href="howitworks.html">howitworks.html</a> <li>https://en.wikipedia.org/wiki/DO-178B → <a href="hirely.html">hirely.html</a> <a href="qmplan.html">qmplan.html</a> @@ -4048,12 +4069,16 @@ antiRobotDefense(); <li>https://en.wikipedia.org/wiki/Hash_join → <a href="optoverview.html#hashjoin">optoverview.html#hashjoin</a> <li>https://en.wikipedia.org/wiki/Imperative_programming → <a href="howitworks.html">howitworks.html</a> <li>https://en.wikipedia.org/wiki/Information_schema → <a href="pragma.html#pragfunc">pragma.html#pragfunc</a> +<li>https://en.wikipedia.org/wiki/Java_virtual_machine → <a href="whybytecode.html">whybytecode.html</a> <li>https://en.wikipedia.org/wiki/Julian_day → <a href="quirks.html">quirks.html</a> <li>https://en.wikipedia.org/wiki/LALR_parser → <a href="howitworks.html">howitworks.html</a> + <a href="whybytecode.html">whybytecode.html</a> <li>https://en.wikipedia.org/wiki/Library_(computing) → <a href="howitworks.html">howitworks.html</a> <li>https://en.wikipedia.org/wiki/Linus%27s_law → <a href="testing.html#3pfuzz">testing.html#3pfuzz</a> <li>https://en.wikipedia.org/wiki/Modified_condition/decision_coverage → <a href="th3.html">th3.html</a> <li>https://en.wikipedia.org/wiki/Mutation_testing → <a href="testing.html#mutationtests">testing.html#mutationtests</a> +<li>https://en.wikipedia.org/wiki/Online_analytical_processing → <a href="whybytecode.html">whybytecode.html</a> +<li>https://en.wikipedia.org/wiki/Online_transaction_processing → <a href="whybytecode.html">whybytecode.html</a> <li>https://en.wikipedia.org/wiki/Patch_(Unix) → <a href="sessionintro.html">sessionintro.html</a> <li>https://en.wikipedia.org/wiki/Recursive_descent_parser → <a href="compile.html#json_max_depth">compile.html#json_max_depth</a> <li>https://en.wikipedia.org/wiki/Robustness_principle → <a href="lang_select.html#nonstd">lang_select.html#nonstd</a> @@ -4071,7 +4096,9 @@ antiRobotDefense(); <a href="th3.html">th3.html</a> <li>https://en.wikipedia.org/wiki/Tar_(computing) → <a href="sqlar.html">sqlar.html</a> <li>https://en.wikipedia.org/wiki/Tcl → <a href="vtablist.html">vtablist.html</a> +<li>https://en.wikipedia.org/wiki/Unix_time → <a href="lang_datefunc.html">lang_datefunc.html</a> <li>https://en.wikipedia.org/wiki/Web_SQL_Database → <a href="bindptr.html">bindptr.html</a> +<li>https://en.wikipedia.org/wiki/WebAssembly → <a href="whybytecode.html">whybytecode.html</a> <li>https://en.wikipedia.org/wiki/Yacc → <a href="lemon.html">lemon.html</a> <li>https://en.wikipedia.org/wiki/Zip_%28file_format%29 → <a href="zipfile.html">zipfile.html</a> <li>https://en.wikipedia.org/wiki/Zip_(file_format) → <a href="changes.html#version_3_22_0">changes.html#version_3_22_0</a> @@ -4153,6 +4180,10 @@ antiRobotDefense(); <a href="json1.html#json5">json1.html#json5</a> <li>https://spec.json5.org/#introduction → <a href="json1.html#json5">json1.html#json5</a> <li>https://sqlite.org/docsrc/finfo/pages/whynotgit.in → <a href="whynotgit.html">whynotgit.html</a> +<li>https://sqlite.org/forum → <a href="optoverview.html#option2">optoverview.html#option2</a> + <a href="optoverview.html#uplus">optoverview.html#uplus</a> + <a href="queryplanner-ng.html#howtofix">queryplanner-ng.html#howtofix</a> + <a href="whybytecode.html">whybytecode.html</a> <li>https://sqlite.org/forum/about → <a href="cves.html#cvetab">cves.html#cvetab</a> <li>https://sqlite.org/forum/forum → <a href="flextypegood.html">flextypegood.html</a> <a href="quirks.html">quirks.html</a> @@ -4532,6 +4563,7 @@ antiRobotDefense(); <li>https://www.loc.gov/preservation/resources/rfs/data.html → <a href="locrsf.html">locrsf.html</a> <li>https://www.microsoft.com/en-us/research/people/gray/ → <a href="fasterthanfs.html">fasterthanfs.html</a> <li>https://www.microsoft.com/en-us/research/publication/to-blob-or-not-to-blob-large-object-storage-in-a-database-or-a-filesystem/ → <a href="fasterthanfs.html">fasterthanfs.html</a> +<li>https://www.mistachkin.com/ → <a href="crew.html#dan">crew.html#dan</a> <li>https://www.neooffice.org/neojava/en/index.php → <a href="affcase1.html">affcase1.html</a> <li>https://www.postgresql.org → <a href="lang_returning.html">lang_returning.html</a> <li>https://www.reddit.com/r/programming/comments/84fzoc/why_is_sqlite_coded_in_c/ → <a href="whyc.html">whyc.html</a> @@ -5166,6 +5198,7 @@ antiRobotDefense(); <li>https://www.sqlite.org/src/vdiff?from=e4ab094f8afce0817f4074e823fabe59fc29ebb4&to=83afe23e553e802c0947c80d0ffdd120423e7c52&sbs=1 → <a href="oldnews.html">oldnews.html</a> <li>https://www.sqlite.org/src/vpatch?from=version-3.9.0&to=version-3.9.1 → <a href="oldnews.html">oldnews.html</a> <li>https://www.sqlite.org/th3 → <a href="qmplan.html">qmplan.html</a> +<li>https://www.tcl.tk/ → <a href="crew.html#dan">crew.html#dan</a> <li>https://www.tcl.tk/man/tcl8.3/UserCmd/tclsh.htm → <a href="cli.html#compiling">cli.html#compiling</a> <li>https://www2.eecs.berkeley.edu/Pubs/TechRpts/2006/EECS-2006-1.html → <a href="faq.html#q6">faq.html#q6</a> <li>https://www2.sqlite.org → <a href="qmplan.html">qmplan.html</a> @@ -5343,7 +5376,7 @@ antiRobotDefense(); <a href="fullsql.html">fullsql.html</a> <a href="isolation.html">isolation.html</a> <a href="lang.html">lang.html</a> - <a href="lang_analyze.html#req">lang_analyze.html#req</a> + <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> <a href="lang_conflict.html">lang_conflict.html</a> <a href="lang_createtable.html#dfltval">lang_createtable.html#dfltval</a> <a href="lang_createtable.html#notnullconst">lang_createtable.html#notnullconst</a> @@ -5427,7 +5460,7 @@ antiRobotDefense(); <li>internal schema objects → <a href="fileformat2.html#ffschema">fileformat2.html#ffschema</a> <li>internal table → <a href="autoinc.html">autoinc.html</a> <li>internal tables → <a href="lang_analyze.html">lang_analyze.html</a> - <a href="lang_analyze.html#req">lang_analyze.html#req</a> + <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> <li>Internal Versus External BLOBs → <a href="aff_short.html">aff_short.html</a> <a href="appfileformat.html">appfileformat.html</a> <a href="fasterthanfs.html">fasterthanfs.html</a> @@ -5460,6 +5493,7 @@ antiRobotDefense(); <a href="releaselog/3_45_2.html">releaselog/3_45_2.html</a> <a href="releaselog/3_45_3.html">releaselog/3_45_3.html</a> <li>join order → <a href="eqp.html">eqp.html</a> + <a href="optoverview.html">optoverview.html</a> <li>join-clause → <a href="lang_aggfunc.html">lang_aggfunc.html</a> <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> @@ -5552,6 +5586,7 @@ antiRobotDefense(); <li>json → <a href="changes.html#version_3_10_0">changes.html#version_3_10_0</a> <a href="json1.html#jarray">json1.html#jarray</a> <a href="json1.html#jobj">json1.html#jobj</a> + <a href="json1.html#jpretty">json1.html#jpretty</a> <a href="json1.html#jset">json1.html#jset</a> <a href="json1.html#json5">json1.html#json5</a> <a href="json1.html#varg">json1.html#varg</a> @@ -5587,6 +5622,7 @@ antiRobotDefense(); <a href="changes.html#version_3_43_0">changes.html#version_3_43_0</a> <a href="features.html">features.html</a> <a href="fullsql.html">fullsql.html</a> + <a href="lang.html">lang.html</a> <a href="lang_corefunc.html">lang_corefunc.html</a> <a href="lang_expr.html#*funcinexpr">lang_expr.html#*funcinexpr</a> <a href="news.html">news.html</a> @@ -5650,6 +5686,9 @@ antiRobotDefense(); <a href="releaselog/3_18_0.html">releaselog/3_18_0.html</a> <a href="releaselog/3_18_1.html">releaselog/3_18_1.html</a> <a href="releaselog/3_18_2.html">releaselog/3_18_2.html</a> +<li>json_pretty → <a href="changes.html#version_3_46_0">changes.html#version_3_46_0</a> + <a href="news.html">news.html</a> + <a href="releaselog/3_46_0.html">releaselog/3_46_0.html</a> <li>json_quote → <a href="changes.html#version_3_14">changes.html#version_3_14</a> <a href="json1.html#howtocompile">json1.html#howtocompile</a> <a href="releaselog/3_14.html">releaselog/3_14.html</a> @@ -5989,7 +6028,7 @@ antiRobotDefense(); <li>ltrim → <a href="lang_corefunc.html">lang_corefunc.html</a> <li>mailing lists → <a href="bindptr.html">bindptr.html</a> <a href="qmplan.html">qmplan.html</a> -<li>Manual Control Of Query Plans Using SQLITE_STAT Tables → <a href="lang_analyze.html#req">lang_analyze.html#req</a> +<li>Manual Control Of Query Plans Using SQLITE_STAT Tables → <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> <li>master journal → <a href="changes.html#version_3_12_0">changes.html#version_3_12_0</a> <a href="releaselog/3_12_0.html">releaselog/3_12_0.html</a> <a href="releaselog/3_12_1.html">releaselog/3_12_1.html</a> @@ -6034,7 +6073,8 @@ antiRobotDefense(); <a href="releaselog/3_35_4.html">releaselog/3_35_4.html</a> <a href="releaselog/3_35_5.html">releaselog/3_35_5.html</a> <li>math functions → <a href="lang_expr.html#*funcinexpr">lang_expr.html#*funcinexpr</a> -<li>mathfunc → <a href="lang_corefunc.html">lang_corefunc.html</a> +<li>mathfunc → <a href="lang.html">lang.html</a> + <a href="lang_corefunc.html">lang_corefunc.html</a> <li>max → <a href="lang_corefunc.html">lang_corefunc.html</a> <li>max_agg → <a href="lang_aggfunc.html#aggfunclist">lang_aggfunc.html#aggfunclist</a> <a href="lang_corefunc.html#max_scalar">lang_corefunc.html#max_scalar</a> @@ -6100,6 +6140,7 @@ antiRobotDefense(); <a href="releaselog/3_15_0.html">releaselog/3_15_0.html</a> <a href="releaselog/3_15_1.html">releaselog/3_15_1.html</a> <a href="releaselog/3_15_2.html">releaselog/3_15_2.html</a> +<li>modifiers → <a href="lang_datefunc.html">lang_datefunc.html</a> <li>most used → <a href="index.html">index.html</a> <li>most widely deployed → <a href="about.html">about.html</a> <a href="appfileformat.html">appfileformat.html</a> @@ -6125,10 +6166,10 @@ antiRobotDefense(); <a href="versionnumbers.html">versionnumbers.html</a> <li>Next Generation Query Planner → <a href="howitworks.html">howitworks.html</a> <a href="optoverview.html">optoverview.html</a> + <a href="optoverview.html#joins">optoverview.html#joins</a> <li>NGQP → <a href="changes.html#version_3_8_0">changes.html#version_3_8_0</a> <a href="limits.html#max_sql_length">limits.html#max_sql_length</a> <a href="oldnews.html">oldnews.html</a> - <a href="optoverview.html">optoverview.html</a> <a href="releaselog/3_8_0.html">releaselog/3_8_0.html</a> <a href="releaselog/3_8_0_1.html">releaselog/3_8_0_1.html</a> <a href="releaselog/3_8_0_2.html">releaselog/3_8_0_2.html</a> @@ -6168,6 +6209,8 @@ antiRobotDefense(); <li>NULLS LAST → <a href="changes.html#version_3_30_0">changes.html#version_3_30_0</a> <a href="releaselog/3_30_0.html">releaselog/3_30_0.html</a> <a href="releaselog/3_30_1.html">releaselog/3_30_1.html</a> +<li>numeric literals → <a href="changes.html#version_3_46_0">changes.html#version_3_46_0</a> + <a href="releaselog/3_46_0.html">releaselog/3_46_0.html</a> <li>numeric-literal → <a href="lang_expr.html#litvalue">lang_expr.html#litvalue</a> <li>object resolution → <a href="lang_dropview.html">lang_dropview.html</a> <li>octet_length → <a href="changes.html#version_3_43_0">changes.html#version_3_43_0</a> @@ -6226,7 +6269,6 @@ antiRobotDefense(); <a href="releaselog/3_31_1.html">releaselog/3_31_1.html</a> <li>OpenOffice case study → <a href="appfileformat.html">appfileformat.html</a> <li>optimize command → <a href="fts3.html#fts4">fts3.html#fts4</a> -<li>optimize pragma → <a href="lang_analyze.html#req">lang_analyze.html#req</a> <li>optimizer → <a href="eqp.html">eqp.html</a> <li>OR optimization → <a href="changes.html#version_3_11_0">changes.html#version_3_11_0</a> <a href="changes.html#version_3_14">changes.html#version_3_14</a> @@ -6496,9 +6538,9 @@ antiRobotDefense(); <a href="vtablist.html">vtablist.html</a> <li>PRAGMA analysis_limit → <a href="changes.html#version_3_32_0">changes.html#version_3_32_0</a> <a href="lang_analyze.html#approx">lang_analyze.html#approx</a> + <a href="lang_analyze.html#pragopt">lang_analyze.html#pragopt</a> <a href="pragma.html#pragma_optimize">pragma.html#pragma_optimize</a> <a href="pragma.html#toc">pragma.html#toc</a> - <a href="queryplanner-ng.html#fossilcasestudy">queryplanner-ng.html#fossilcasestudy</a> <a href="releaselog/3_32_0.html">releaselog/3_32_0.html</a> <a href="releaselog/3_32_1.html">releaselog/3_32_1.html</a> <a href="releaselog/3_32_2.html">releaselog/3_32_2.html</a> @@ -6801,16 +6843,21 @@ antiRobotDefense(); <a href="releaselog/3_30_0.html">releaselog/3_30_0.html</a> <a href="releaselog/3_30_1.html">releaselog/3_30_1.html</a> <li>PRAGMA optimize → <a href="changes.html#version_3_18_0">changes.html#version_3_18_0</a> + <a href="changes.html#version_3_46_0">changes.html#version_3_46_0</a> <a href="lang_analyze.html#approx">lang_analyze.html#approx</a> <a href="lang_analyze.html#autoanalyze">lang_analyze.html#autoanalyze</a> + <a href="lang_analyze.html#pragopt">lang_analyze.html#pragopt</a> <a href="news.html">news.html</a> + <a href="optoverview.html#option2">optoverview.html#option2</a> <a href="pragma.html#pragma_analysis_limit">pragma.html#pragma_analysis_limit</a> <a href="pragma.html#toc">pragma.html#toc</a> <a href="queryplanner-ng.html#fossilcasestudy">queryplanner-ng.html#fossilcasestudy</a> <a href="queryplanner-ng.html#howtofix">queryplanner-ng.html#howtofix</a> + <a href="queryplanner-ng.html#qpstab">queryplanner-ng.html#qpstab</a> <a href="releaselog/3_18_0.html">releaselog/3_18_0.html</a> <a href="releaselog/3_18_1.html">releaselog/3_18_1.html</a> <a href="releaselog/3_18_2.html">releaselog/3_18_2.html</a> + <a href="releaselog/3_46_0.html">releaselog/3_46_0.html</a> <li>PRAGMA page_count → <a href="changes.html#version_3_6_1">changes.html#version_3_6_1</a> <a href="pragma.html#toc">pragma.html#toc</a> <a href="releaselog/3_6_0.html">releaselog/3_6_0.html</a> @@ -6995,6 +7042,7 @@ antiRobotDefense(); <a href="releaselog/3_27_0.html">releaselog/3_27_0.html</a> <a href="releaselog/3_27_1.html">releaselog/3_27_1.html</a> <a href="releaselog/3_27_2.html">releaselog/3_27_2.html</a> + <a href="whybytecode.html">whybytecode.html</a> <li>PRAGMA wal_autocheckpoint → <a href="pragma.html#toc">pragma.html#toc</a> <li>PRAGMA wal_checkpoint → <a href="c3ref/wal_checkpoint_v2.html">c3ref/wal_checkpoint_v2.html</a> <a href="capi3ref.html#sqlite3_wal_checkpoint_v2">capi3ref.html#sqlite3_wal_checkpoint_v2</a> @@ -7117,6 +7165,7 @@ antiRobotDefense(); <a href="threadsafe.html">threadsafe.html</a> <a href="vfs.html">vfs.html</a> <a href="vtablist.html">vtablist.html</a> + <a href="whybytecode.html">whybytecode.html</a> <li>prepared statements → <a href="35to36.html">35to36.html</a> <a href="bytecodevtab.html">bytecodevtab.html</a> <a href="c3ref/c_config_covering_index_scan.html#sqliteconfigmultithread">c3ref/c_config_covering_index_scan.html#sqliteconfigmultithread</a> @@ -7189,7 +7238,6 @@ antiRobotDefense(); <li>push-down optimization → <a href="changes.html#version_3_23_0">changes.html#version_3_23_0</a> <a href="changes.html#version_3_35_0">changes.html#version_3_35_0</a> <a href="changes.html#version_3_35_4">changes.html#version_3_35_4</a> - <a href="changes.html#version_3_42_0">changes.html#version_3_42_0</a> <a href="lang_with.html#mathint">lang_with.html#mathint</a> <a href="releaselog/3_23_0.html">releaselog/3_23_0.html</a> <a href="releaselog/3_23_1.html">releaselog/3_23_1.html</a> @@ -7199,7 +7247,6 @@ antiRobotDefense(); <a href="releaselog/3_35_3.html">releaselog/3_35_3.html</a> <a href="releaselog/3_35_4.html">releaselog/3_35_4.html</a> <a href="releaselog/3_35_5.html">releaselog/3_35_5.html</a> - <a href="releaselog/3_42_0.html">releaselog/3_42_0.html</a> <li>Q → <a href="c3ref/mprintf.html">c3ref/mprintf.html</a> <a href="capi3ref.html#sqlite3_mprintf">capi3ref.html#sqlite3_mprintf</a> <a href="printf.html">printf.html</a> @@ -7250,9 +7297,11 @@ antiRobotDefense(); <a href="changes.html#version_3_20_0">changes.html#version_3_20_0</a> <a href="compile.html#enable_qpsg">compile.html#enable_qpsg</a> <a href="compile.html#enable_stat4">compile.html#enable_stat4</a> + <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> <a href="oldnews.html">oldnews.html</a> <a href="releaselog/3_20_0.html">releaselog/3_20_0.html</a> <a href="releaselog/3_20_1.html">releaselog/3_20_1.html</a> +<li>query-time index → <a href="optoverview.html#flattening">optoverview.html#flattening</a> <li>query_only pragma → <a href="changes.html#version_3_8_0">changes.html#version_3_8_0</a> <a href="releaselog/3_8_0.html">releaselog/3_8_0.html</a> <a href="releaselog/3_8_0_1.html">releaselog/3_8_0_1.html</a> @@ -7372,6 +7421,7 @@ antiRobotDefense(); <a href="lang_altertable.html#altertableishard">lang_altertable.html#altertableishard</a> <a href="lts.html">lts.html</a> <a href="onefile.html">onefile.html</a> +<li>Recommended usage patterns for ANALYZE → <a href="queryplanner-ng.html#qpstab">queryplanner-ng.html#qpstab</a> <li>record format → <a href="changes.html#version_3_21_0">changes.html#version_3_21_0</a> <a href="fileformat2.html#stat4tab">fileformat2.html#stat4tab</a> <a href="opcode.html#codes">opcode.html#codes</a> @@ -7700,6 +7750,8 @@ antiRobotDefense(); <li>rtrim → <a href="lang_corefunc.html">lang_corefunc.html</a> <li>rules for determining column affinity → <a href="lang_expr.html#castexpr">lang_expr.html#castexpr</a> <li>Run-Time Loadable Extensions → <a href="cli.html#dotload">cli.html#dotload</a> +<li>running ANALYZE via PRAGMA optimize → <a href="changes.html#version_3_46_0">changes.html#version_3_46_0</a> + <a href="releaselog/3_46_0.html">releaselog/3_46_0.html</a> <li>safe command-line option → <a href="changes.html#version_3_40_1">changes.html#version_3_40_1</a> <a href="news.html">news.html</a> <a href="releaselog/3_40_1.html">releaselog/3_40_1.html</a> @@ -7776,7 +7828,7 @@ antiRobotDefense(); <a href="fts3.html#simple_fts_queries">fts3.html#simple_fts_queries</a> <a href="isolation.html">isolation.html</a> <a href="lang.html">lang.html</a> - <a href="lang_analyze.html#req">lang_analyze.html#req</a> + <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_expr.html#cosub">lang_expr.html#cosub</a> <a href="lang_expr.html#subq">lang_expr.html#subq</a> @@ -9673,7 +9725,6 @@ antiRobotDefense(); <a href="changes.html#version_3_16_0">changes.html#version_3_16_0</a> <a href="changes.html#version_3_31_0">changes.html#version_3_31_0</a> <a href="changes.html#version_3_41_0">changes.html#version_3_41_0</a> - <a href="pragma.html#pragma_optimize">pragma.html#pragma_optimize</a> <a href="releaselog/3_16_0.html">releaselog/3_16_0.html</a> <a href="releaselog/3_16_1.html">releaselog/3_16_1.html</a> <a href="releaselog/3_16_2.html">releaselog/3_16_2.html</a> @@ -10326,6 +10377,7 @@ antiRobotDefense(); <a href="vtab.html#obc">vtab.html#obc</a> <a href="vtab.html#xbestindex">vtab.html#xbestindex</a> <a href="vtab.html#xfindfunction">vtab.html#xfindfunction</a> + <a href="whybytecode.html">whybytecode.html</a> <li>sqlite3_prepare16 → <a href="c3ref/bind_parameter_name.html">c3ref/bind_parameter_name.html</a> <a href="c3ref/funclist.html">c3ref/funclist.html</a> <a href="c3ref/set_authorizer.html">c3ref/set_authorizer.html</a> @@ -10513,11 +10565,7 @@ antiRobotDefense(); <a href="capi3ref.html#sqlite3">capi3ref.html#sqlite3</a> <a href="capi3ref.html#sqlite3_preupdate_blobwrite">capi3ref.html#sqlite3_preupdate_blobwrite</a> <li>sqlite3_profile → <a href="c3ref/c_trace.html#sqlitetraceprofile">c3ref/c_trace.html#sqlitetraceprofile</a> - <a href="c3ref/funclist.html">c3ref/funclist.html</a> - <a href="c3ref/sqlite3.html">c3ref/sqlite3.html</a> <a href="c3ref/trace_v2.html">c3ref/trace_v2.html</a> - <a href="capi3ref.html">capi3ref.html</a> - <a href="capi3ref.html#sqlite3">capi3ref.html#sqlite3</a> <a href="capi3ref.html#sqlite3_trace_v2">capi3ref.html#sqlite3_trace_v2</a> <a href="capi3ref.html#sqlitetraceprofile">capi3ref.html#sqlitetraceprofile</a> <a href="changes.html#version_3_14">changes.html#version_3_14</a> @@ -11094,7 +11142,7 @@ antiRobotDefense(); <a href="lang_corefunc.html#likelihood">lang_corefunc.html#likelihood</a> <a href="lang_corefunc.html#likely">lang_corefunc.html#likely</a> <a href="lang_corefunc.html#unlikely">lang_corefunc.html#unlikely</a> - <a href="lang_datefunc.html#tmdif">lang_datefunc.html#tmdif</a> + <a href="lang_datefunc.html#tmval">lang_datefunc.html#tmval</a> <a href="lang_explain.html">lang_explain.html</a> <a href="lang_returning.html">lang_returning.html</a> <a href="malloc.html#lookaside">malloc.html#lookaside</a> @@ -11125,6 +11173,7 @@ antiRobotDefense(); <a href="cintro.html">cintro.html</a> <a href="tclsqlite.html#trace_v2">tclsqlite.html#trace_v2</a> <a href="unlock_notify.html">unlock_notify.html</a> + <a href="whybytecode.html">whybytecode.html</a> <li>sqlite3_stmt_busy → <a href="c3ref/funclist.html">c3ref/funclist.html</a> <a href="c3ref/stmt.html">c3ref/stmt.html</a> <a href="capi3ref.html">capi3ref.html</a> @@ -11427,12 +11476,8 @@ antiRobotDefense(); <a href="releaselog/3_37_1.html">releaselog/3_37_1.html</a> <a href="releaselog/3_37_2.html">releaselog/3_37_2.html</a> <li>sqlite3_trace → <a href="c3ref/c_trace.html#sqlitetracestmt">c3ref/c_trace.html#sqlitetracestmt</a> - <a href="c3ref/funclist.html">c3ref/funclist.html</a> <a href="c3ref/profile.html">c3ref/profile.html</a> - <a href="c3ref/sqlite3.html">c3ref/sqlite3.html</a> <a href="c3ref/trace_v2.html">c3ref/trace_v2.html</a> - <a href="capi3ref.html">capi3ref.html</a> - <a href="capi3ref.html#sqlite3">capi3ref.html#sqlite3</a> <a href="capi3ref.html#sqlite3_profile">capi3ref.html#sqlite3_profile</a> <a href="capi3ref.html#sqlite3_trace_v2">capi3ref.html#sqlite3_trace_v2</a> <a href="capi3ref.html#sqlitetracestmt">capi3ref.html#sqlitetracestmt</a> @@ -11757,7 +11802,7 @@ antiRobotDefense(); <a href="compile.html#os_other">compile.html#os_other</a> <a href="custombuild.html">custombuild.html</a> <a href="howtocorrupt.html#posix_close_bug">howtocorrupt.html#posix_close_bug</a> - <a href="lang_datefunc.html#tmdif">lang_datefunc.html#tmdif</a> + <a href="lang_datefunc.html#tmval">lang_datefunc.html#tmval</a> <a href="loadext.html#persist">loadext.html#persist</a> <a href="loadext.html#statext">loadext.html#statext</a> <a href="oldnews.html">oldnews.html</a> @@ -12009,6 +12054,12 @@ antiRobotDefense(); <a href="capi3ref.html#sqlite3_win32_set_directory">capi3ref.html#sqlite3_win32_set_directory</a> <li>sqlite3changegroup_add → <a href="session.html">session.html</a> <a href="session.html#sqlite3_changegroup">session.html#sqlite3_changegroup</a> + <a href="session.html#sqlite3changegroup_add_change">session.html#sqlite3changegroup_add_change</a> + <a href="session/changegroup.html">session/changegroup.html</a> + <a href="session/funclist.html">session/funclist.html</a> + <a href="session/sqlite3changegroup_add_change.html">session/sqlite3changegroup_add_change.html</a> +<li>sqlite3changegroup_add_change → <a href="session.html">session.html</a> + <a href="session.html#sqlite3_changegroup">session.html#sqlite3_changegroup</a> <a href="session/changegroup.html">session/changegroup.html</a> <a href="session/funclist.html">session/funclist.html</a> <li>sqlite3changegroup_add_strm → <a href="session.html">session.html</a> @@ -13292,7 +13343,7 @@ antiRobotDefense(); <a href="changes.html#version_3_6_20">changes.html#version_3_6_20</a> <a href="changes.html#version_3_7_6">changes.html#version_3_7_6</a> <a href="changes.html#version_3_7_9">changes.html#version_3_7_9</a> - <a href="lang_analyze.html#req">lang_analyze.html#req</a> + <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> <a href="oldnews.html">oldnews.html</a> <a href="releaselog/3_6_18.html">releaselog/3_6_18.html</a> <a href="releaselog/3_6_20.html">releaselog/3_6_20.html</a> @@ -13304,7 +13355,7 @@ antiRobotDefense(); <a href="compile.html#enable_stat2">compile.html#enable_stat2</a> <a href="compile.html#enable_stat4">compile.html#enable_stat4</a> <a href="fileformat2.html#stat3tab">fileformat2.html#stat3tab</a> - <a href="lang_analyze.html#req">lang_analyze.html#req</a> + <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> <a href="oldnews.html">oldnews.html</a> <a href="optoverview.html#rangequery">optoverview.html#rangequery</a> <a href="releaselog/3_30_0.html">releaselog/3_30_0.html</a> @@ -13322,7 +13373,7 @@ antiRobotDefense(); <a href="compile.html#enable_stat3">compile.html#enable_stat3</a> <a href="fileformat2.html#stat3tab">fileformat2.html#stat3tab</a> <a href="fileformat2.html#stat4tab">fileformat2.html#stat4tab</a> - <a href="lang_analyze.html#req">lang_analyze.html#req</a> + <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> <a href="oldnews.html">oldnews.html</a> <a href="optoverview.html#rangequery">optoverview.html#rangequery</a> <a href="releaselog/3_41_2.html">releaselog/3_41_2.html</a> @@ -14889,6 +14940,7 @@ antiRobotDefense(); <a href="security.html">security.html</a> <a href="sharedcache.html#dontuse">sharedcache.html#dontuse</a> <a href="unlock_notify.html">unlock_notify.html</a> + <a href="whybytecode.html">whybytecode.html</a> <li>SQLITE_SECURE_DELETE → <a href="changes.html#version_3_6_21">changes.html#version_3_6_21</a> <a href="faq.html#q20">faq.html#q20</a> <a href="pragma.html#pragma_secure_delete">pragma.html#pragma_secure_delete</a> @@ -14951,11 +15003,11 @@ antiRobotDefense(); <li>sqlite_stat1 → <a href="changes.html#version_3_13_0">changes.html#version_3_13_0</a> <a href="changes.html#version_3_33_0">changes.html#version_3_33_0</a> <a href="changes.html#version_3_8_1">changes.html#version_3_8_1</a> - <a href="lang_analyze.html#req">lang_analyze.html#req</a> + <a href="lang_analyze.html#pragopt">lang_analyze.html#pragopt</a> + <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> <a href="oldnews.html">oldnews.html</a> <a href="optoverview.html#manctrl">optoverview.html#manctrl</a> <a href="optoverview.html#multi_index">optoverview.html#multi_index</a> - <a href="pragma.html#pragma_optimize">pragma.html#pragma_optimize</a> <a href="queryplanner-ng.html#fossilcasestudy">queryplanner-ng.html#fossilcasestudy</a> <a href="queryplanner-ng.html#howtofix">queryplanner-ng.html#howtofix</a> <a href="releaselog/3_13_0.html">releaselog/3_13_0.html</a> @@ -14964,15 +15016,13 @@ antiRobotDefense(); <li>SQLITE_STAT1 → <a href="queryplanner-ng.html#fossilcasestudy">queryplanner-ng.html#fossilcasestudy</a> <a href="queryplanner-ng.html#hazards">queryplanner-ng.html#hazards</a> <a href="queryplanner-ng.html#howtofix">queryplanner-ng.html#howtofix</a> -<li>sqlite_stat2 → <a href="lang_analyze.html#req">lang_analyze.html#req</a> -<li>sqlite_stat3 → <a href="lang_analyze.html#req">lang_analyze.html#req</a> - <a href="optoverview.html#manctrl">optoverview.html#manctrl</a> +<li>sqlite_stat2 → <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> +<li>sqlite_stat3 → <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> <a href="optoverview.html#rangequery">optoverview.html#rangequery</a> <li>sqlite_stat4 → <a href="changes.html#version_3_8_6">changes.html#version_3_8_6</a> <a href="changes.html#version_3_8_7">changes.html#version_3_8_7</a> <a href="compile.html#enable_stat4">compile.html#enable_stat4</a> - <a href="lang_analyze.html#req">lang_analyze.html#req</a> - <a href="optoverview.html#manctrl">optoverview.html#manctrl</a> + <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> <a href="optoverview.html#rangequery">optoverview.html#rangequery</a> <a href="releaselog/3_8_6.html">releaselog/3_8_6.html</a> <a href="releaselog/3_8_7.html">releaselog/3_8_7.html</a> @@ -15431,9 +15481,11 @@ antiRobotDefense(); <li>strategies → <a href="eqp.html">eqp.html</a> <li>strftime → <a href="lang_datefunc.html#subsec">lang_datefunc.html#subsec</a> <li>strftime SQL function → <a href="changes.html#version_3_44_0">changes.html#version_3_44_0</a> + <a href="changes.html#version_3_46_0">changes.html#version_3_46_0</a> <a href="releaselog/3_44_0.html">releaselog/3_44_0.html</a> <a href="releaselog/3_44_1.html">releaselog/3_44_1.html</a> <a href="releaselog/3_44_2.html">releaselog/3_44_2.html</a> + <a href="releaselog/3_46_0.html">releaselog/3_46_0.html</a> <li>STRICT → <a href="datatype3.html#affname">datatype3.html#affname</a> <a href="lang_createtable.html#primkeyconst">lang_createtable.html#primkeyconst</a> <li>STRICT table → <a href="pragma.html#pragma_table_list">pragma.html#pragma_table_list</a> @@ -15454,7 +15506,8 @@ antiRobotDefense(); <a href="releaselog/3_44_2.html">releaselog/3_44_2.html</a> <li>subprograms → <a href="opcode.html">opcode.html</a> <li>Subqueries → <a href="fullsql.html">fullsql.html</a> -<li>subsec modifier → <a href="lang_datefunc.html#uepch">lang_datefunc.html#uepch</a> +<li>subsec modifier → <a href="lang_datefunc.html#dttm">lang_datefunc.html#dttm</a> + <a href="lang_datefunc.html#uepch">lang_datefunc.html#uepch</a> <li>subsecond modifier → <a href="changes.html#version_3_42_0">changes.html#version_3_42_0</a> <a href="releaselog/3_42_0.html">releaselog/3_42_0.html</a> <li>substr → <a href="arch.html">arch.html</a> @@ -15635,6 +15688,7 @@ antiRobotDefense(); <a href="testing.html#stmtvbr">testing.html#stmtvbr</a> <a href="testing.html#tcl">testing.html#tcl</a> <li>the - and - operators → <a href="changes.html#version_3_38_0">changes.html#version_3_38_0</a> + <a href="changes.html#version_3_46_0">changes.html#version_3_46_0</a> <a href="lang_expr.html#collateop">lang_expr.html#collateop</a> <a href="lang_expr.html#extract">lang_expr.html#extract</a> <a href="releaselog/3_38_0.html">releaselog/3_38_0.html</a> @@ -15643,6 +15697,7 @@ antiRobotDefense(); <a href="releaselog/3_38_3.html">releaselog/3_38_3.html</a> <a href="releaselog/3_38_4.html">releaselog/3_38_4.html</a> <a href="releaselog/3_38_5.html">releaselog/3_38_5.html</a> + <a href="releaselog/3_46_0.html">releaselog/3_46_0.html</a> <li>the - operator → <a href="json1.html#jobj">json1.html#jobj</a> <a href="json1.html#jset">json1.html#jset</a> <a href="json1.html#varg">json1.html#varg</a> @@ -15686,6 +15741,8 @@ antiRobotDefense(); <a href="releaselog/3_43_0.html">releaselog/3_43_0.html</a> <a href="releaselog/3_43_1.html">releaselog/3_43_1.html</a> <a href="releaselog/3_43_2.html">releaselog/3_43_2.html</a> +<li>time-value → <a href="lang_datefunc.html">lang_datefunc.html</a> +<li>time-values → <a href="lang_datefunc.html">lang_datefunc.html</a> <li>timediff SQL function → <a href="changes.html#version_3_43_0">changes.html#version_3_43_0</a> <a href="releaselog/3_43_0.html">releaselog/3_43_0.html</a> <a href="releaselog/3_43_1.html">releaselog/3_43_1.html</a> @@ -15702,7 +15759,7 @@ antiRobotDefense(); <li>transaction state → <a href="c3ref/txn_state.html">c3ref/txn_state.html</a> <a href="capi3ref.html#sqlite3_txn_state">capi3ref.html#sqlite3_txn_state</a> <li>transactional → <a href="fasterthanfs.html">fasterthanfs.html</a> -<li>treats the CROSS JOIN operator specially → <a href="optoverview.html#table_order">optoverview.html#table_order</a> +<li>treats the CROSS JOIN operator specially → <a href="optoverview.html#joins">optoverview.html#joins</a> <a href="queryplanner-ng.html#howtofix">queryplanner-ng.html#howtofix</a> <li>trigger → <a href="changes.html#version_3_45_3">changes.html#version_3_45_3</a> <a href="news.html">news.html</a> @@ -15808,6 +15865,8 @@ antiRobotDefense(); <a href="releaselog/3_38_3.html">releaselog/3_38_3.html</a> <a href="releaselog/3_38_4.html">releaselog/3_38_4.html</a> <a href="releaselog/3_38_5.html">releaselog/3_38_5.html</a> +<li>unixepoch modifier → <a href="lang_datefunc.html">lang_datefunc.html</a> + <a href="lang_datefunc.html#tmval">lang_datefunc.html#tmval</a> <li>unlikely → <a href="changes.html#version_3_8_1">changes.html#version_3_8_1</a> <a href="changes.html#version_3_8_8">changes.html#version_3_8_8</a> <a href="lang_corefunc.html">lang_corefunc.html</a> @@ -15852,7 +15911,7 @@ antiRobotDefense(); <a href="isolation.html">isolation.html</a> <a href="lang.html">lang.html</a> <a href="lang_altertable.html#caution">lang_altertable.html#caution</a> - <a href="lang_analyze.html#req">lang_analyze.html#req</a> + <a href="lang_analyze.html#statanal">lang_analyze.html#statanal</a> <a href="lang_createtable.html#notnullconst">lang_createtable.html#notnullconst</a> <a href="lang_createtable.html#primkeyconst">lang_createtable.html#primkeyconst</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> @@ -15977,6 +16036,8 @@ antiRobotDefense(); <li>Using the SQLite Unlock Notification Feature → <a href="c3ref/unlock_notify.html">c3ref/unlock_notify.html</a> <a href="capi3ref.html#sqlite3_unlock_notify">capi3ref.html#sqlite3_unlock_notify</a> <a href="compile.html#enable_unlock_notify">compile.html#enable_unlock_notify</a> +<li>utc and localtime modifiers → <a href="changes.html#version_3_46_0">changes.html#version_3_46_0</a> + <a href="releaselog/3_46_0.html">releaselog/3_46_0.html</a> <li>utc modifier → <a href="changes.html#version_3_10_0">changes.html#version_3_10_0</a> <a href="deterministic.html#dtexception">deterministic.html#dtexception</a> <a href="releaselog/3_10_0.html">releaselog/3_10_0.html</a> @@ -16345,6 +16406,7 @@ antiRobotDefense(); <li>version 3.45.1 → <a href="chronology.html">chronology.html</a> <li>version 3.45.2 → <a href="chronology.html">chronology.html</a> <li>version 3.45.3 → <a href="chronology.html">chronology.html</a> +<li>version 3.46.0 → <a href="chronology.html">chronology.html</a> <li>version 3.5.0 → <a href="35to36.html">35to36.html</a> <a href="c3ref/enable_shared_cache.html">c3ref/enable_shared_cache.html</a> <a href="c3ref/vfs.html">c3ref/vfs.html</a> @@ -17089,11 +17151,24 @@ antiRobotDefense(); <a href="releaselog/3_7_6.html">releaselog/3_7_6.html</a> <a href="wal.html#fast">wal.html#fast</a> <li>WHERE clause → <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> +<li>WHERE-clause push-down optimization → <a href="changes.html#version_3_13_0">changes.html#version_3_13_0</a> + <a href="changes.html#version_3_42_0">changes.html#version_3_42_0</a> + <a href="changes.html#version_3_46_0">changes.html#version_3_46_0</a> + <a href="changes.html#version_3_9_0">changes.html#version_3_9_0</a> + <a href="releaselog/3_13_0.html">releaselog/3_13_0.html</a> + <a href="releaselog/3_42_0.html">releaselog/3_42_0.html</a> + <a href="releaselog/3_46_0.html">releaselog/3_46_0.html</a> + <a href="releaselog/3_9_0.html">releaselog/3_9_0.html</a> + <a href="releaselog/3_9_1.html">releaselog/3_9_1.html</a> + <a href="releaselog/3_9_2.html">releaselog/3_9_2.html</a> + <a href="releaselog/3_9_3.html">releaselog/3_9_3.html</a> +<li>Why SQLite Uses Bytecode → <a href="opcode.html">opcode.html</a> <li>window chaining → <a href="changes.html#version_3_28_0">changes.html#version_3_28_0</a> <a href="releaselog/3_28_0.html">releaselog/3_28_0.html</a> <li>window function → <a href="appfunc.html">appfunc.html</a> <a href="changes.html#version_3_27_2">changes.html#version_3_27_2</a> <a href="news.html">news.html</a> + <a href="optoverview.html#flattening">optoverview.html#flattening</a> <a href="releaselog/3_27_2.html">releaselog/3_27_2.html</a> <li>Window functions → <a href="appfunc.html">appfunc.html</a> <li>window functions → <a href="appfunc.html">appfunc.html</a> @@ -17142,6 +17217,7 @@ antiRobotDefense(); <a href="windowfunctions.html#wexcls">windowfunctions.html#wexcls</a> <li>window-function-invocation → <a href="lang_expr.html#*funcinexpr">lang_expr.html#*funcinexpr</a> <a href="windowfunctions.html">windowfunctions.html</a> +<li>winfunc → <a href="lang.html">lang.html</a> <li>WITH → <a href="fullsql.html">fullsql.html</a> <a href="lang_select.html">lang_select.html</a> <li>WITH clause → <a href="changes.html#version_3_23_0">changes.html#version_3_23_0</a> |