Debian Codegraph @

www/releaselog/3_51_1.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="../sqlite.css" rel="stylesheet">
6 <title>SQLite Release 3.51.1 On 2025-11-28</title>
7 <!-- path=../ -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="../index.html">
12 <img class="logo" src="../images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="../index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='../about.html'>About</a>
23 <li class='desktoponly'><a href="../docs.html">Documentation</a>
24 <li class='desktoponly'><a href="../download.html">Download</a>
25 <li class='wideonly'><a href='../copyright.html'>License</a>
26 <li class='desktoponly'><a href="../support.html">Support</a>
27 <li class='desktoponly'><a href="../prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='../about.html'>About</a>
35 <li><a href='../docs.html'>Documentation</a>
36 <li><a href='../download.html'>Download</a>
37 <li><a href='../support.html'>Support</a>
38 <li><a href='../prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="../search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118 <h2>SQLite Release 3.51.1 On 2025-11-28</h2><p><b>Prior changes from version 3.51.0 (2025-11-04):</b></p>
119 <p><ol class='lessindent'>
120 <li value='1'> New macros in <tt>sqlite3.h</tt>:
121 <ol type="a">
122 <li> <tt>SQLITE_SCM_BRANCH</tt> &rarr; the name of the branch from which the source code is taken.
123 <li> <tt>SQLITE_SCM_TAGS</tt> &rarr; space-separated list of tags on the source code check-in.
124 <li> <tt>SQLITE_SCM_DATETIME</tt> &rarr; ISO-8601 date and time of the source code check-in.
125 </ol>
126 <li>Two new JSON functions, <a href="../json1.html#jbeach">jsonb_each()</a> and <a href="../json1.html#jbtree">jsonb_tree()</a> work the same as the existing
127 json_each() and json_tree() functions except that they return <a href="../json1.html#jsonbx">JSONB</a> for the "value" column
128 when the "type" is 'array' or 'object'.
129 <li>The <a href="../carray.html">carray</a> and <a href="../percentile.html">percentile</a> extensions are now built
130 into <a href="../amalgamation.html">the amalgamation</a>, though they are disabled by default and must be activated
131 at compile-time using the
132 <a href="../compile.html#enable_carray">-DSQLITE_ENABLE_CARRAY</a> and/or <a href="../compile.html#enable_percentile">-DSQLITE_ENABLE_PERCENTILE</a> options, respectively.
133 <li>Enhancements to <a href="../tclsqlite.html">TCL Interface</a>:
134 <ol type="a">
135 <li> Add the <code>-asdict</code> flag to the <code>eval</code> command
136 to have it set the row data as a dict instead of an array.
137 <li> User-defined functions may now <code>break</code> to return an
138 SQL NULL.
139 </ol>
140 <li><a href="../cli.html">CLI</a> enhancements:
141 <ol type="a">
142 <li> Increase the precision of ".timer" to microseconds.
143 <li> Enhance the "box" and "column" formatting modes to deal
144 with double-wide characters.
145 <li> The ".imposter" command provides read-only <a href="../imposter.html">imposter tables</a>
146 that work with <a href="../lang_vacuum.html">VACUUM</a> and do not require the --unsafe-testing
147 option.
148 <li> Add the --ifexists option to the CLI command-line option and to
149 the <a href="../cli.html#dotopen">.open command</a>.
150 <li> Limit columns widths set by the ".width" command to 30,000 or less,
151 as there is not good reason to have wider columns, but supporting
152 wider columns provides opportunity to malefactors.
153 </ol>
154 <li>Performance enhancements:
155 <ol type="a">
156 <li> Use fewer CPU cycles to commit a read transaction.
157 <li> Early detection of joins that return no rows due to one or more
158 of the tables containing no rows.
159 <li> Avoid evaluation of scalar subqueries if the result of the subquery
160 does not change the result of the overall expression.
161 <li> Faster window function queries when using
162 "<tt>BETWEEN :x FOLLOWING AND :y FOLLOWING</tt>" with a large :y.
163 </ol>
164 <li>Add the <a href="../pragma.html#pragma_wal_checkpoint">PRAGMA wal_checkpoint=NOOP;</a> command and the
165 <a href="../c3ref/c_checkpoint_full.html">SQLITE_CHECKPOINT_NOOP</a> argument for <a href="../c3ref/wal_checkpoint_v2.html">sqlite3_wal_checkpoint_v2()</a>.
166 <li>Add the <a href="../c3ref/set_errmsg.html">sqlite3_set_errmsg()</a> API for use by extensions.
167 <li>Add the <a href="../c3ref/db_status.html">sqlite3_db_status64()</a> API, which works just like the existing
168 <a href="../c3ref/db_status.html">sqlite3_db_status()</a> API except that it returns 64-bit results.
169 <li>Add the <a href="../c3ref/c_dbstatus_options.html">SQLITE_DBSTATUS_TEMPBUF_SPILL</a> option to the <a href="../c3ref/db_status.html">sqlite3_db_status()</a>
170 and <a href="../c3ref/db_status.html">sqlite3_db_status64()</a> interfaces.
171 <li>In the <a href="../sessionintro.html">session extension</a> add the <a href="../session/sqlite3changeset_apply.html">sqlite3changeset_apply_v3()</a> interface.
172 <li>For the <a href="../printf.html">built-in printf()</a> and the <a href="../lang_corefunc.html#format">format() SQL function</a>,
173 omit the leading '-' from negative floating point numbers if the
174 '+' flag is omitted and the "#" flag is present and all displayed digits are '0'.
175 Use '%#f' or similar to avoid outputs like '-0.00' and instead show just '0.00'.
176 <li>Improved error messages generated by <a href="../fts5.html">FTS5</a>.
177 <li>Enforce STRICT typing on computed columns.
178 <li>Improved support for VxWorks
179 <li> JavaScript/WASM now supports 64-bit WASM. The canonical builds continue to be
180 32-bit but creating one's own 64-bit build is now as simple
181 as running "make".
182 <li>Improved resistance to database corruption caused by an application
183 <a href="../howtocorrupt.html#posix_close_bug">breaking Posix advisory locks using close()</a>.
184 </ol>
185 <p><b>Changes in this specific patch release, version 3.51.1 (2025-11-28):</b></p>
186 <p><ol class='lessindent'>
187 <li value='18'> Fix incorrect results from nested EXISTS queries caused by the
188 optimization in item 6b in the 3.51.0 release.
189 <li> Fix a latent bug in <a href="../fts5.html#the_fts5vocab_virtual_table_module">fts5vocab</a> virtual table, exposed by
190 new optimizations in the 3.51.0 release
191 <p><b>Hashes:</b>
192 <li>SQLITE_SOURCE_ID: 2025-11-28 17:28:25 281fc0e9afc38674b9b0991943b9e9d1e64c6cbdb133d35f6f5c87ff6af38a88
193 <li>SHA3-256 for sqlite3.c: 7cec3a104797bea93970408168197af37f178ab608ea55efd48d28daa87a8ce3
194
195 </ol></p>
196
197 <p>A <a href="../changes.html">complete list of SQLite releases</a>
198 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
199 A detailed history of every
200 check-in is available at
201 <a href="https://sqlite.org/src/timeline">
202 SQLite version control site</a>.</p>
203
204