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