Debian Codegraph @

www/releaselog/current.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.53.2 On 2026-06-03</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.53.2 On 2026-06-03</h2><p><b>Prior changes from version 3.53.0 (2026-04-09):</b></p>
119 <p><ol class='lessindent'>
120 <li value='1'> Fix the <a href="../wal.html#walresetbug">WAL-reset database corruption bug</a>.
121 <li> Add the <a href="https://sqlite.org/src/file/ext/qrf">Query Result Formatter (QRF)</a>
122 library for formatting the results of SQL queries for human readability
123 on a fixed-pitch font screen.
124 <ol type="a">
125 <li> Add the <a href="../tclsqlite.html#format">format method</a> to the <a href="../tclsqlite.html">TCL Interface</a> so that QRF is
126 accessible from TCL.
127 <li> QRF is used for result formatting in the <a href="../cli.html">CLI</a>, resulting in improved
128 display capabilities.
129 </ol>
130 <li> New SQL language features:
131 <ol type="a">
132 <li> Enhance <a href="../lang_altertable.html">ALTER TABLE</a> to permit adding and removing NOT NULL
133 and CHECK constraints.
134 <li> The <a href="../lang_reindex.html">REINDEX EXPRESSIONS</a> statement rebuilds expression indexes.
135 (Useful to repair <a href="../staleexpridx.html">stale expression indexes</a>.)
136 <li> The body of <a href="../lang_createtrigger.html#temptrig">TEMP triggers</a> may now modify and/or query tables in
137 the main schema.
138 <li> Enhance <a href="../lang_vacuum.html#vacuuminto">VACUUM INTO</a> so that if a <a href="../uri.html">URI filename</a> is used as the
139 target and that filename has a reserve=N query parameter with N
140 between 0 and 255, then the <a href="../fileformat2.html#resbyte">reserve amount</a> for
141 the generated database copy is set to N.
142 </ol>
143 <li> New SQL functions:
144 <ol type="a">
145 <li> <a href="../json1.html#jarrayins">json_array_insert()</a>
146 <li> <a href="../json1.html#jarrayins">jsonb_array_insert()</a>
147 </ol>
148 <li> Renovations to the <a href="../cli.html">CLI</a>:
149 <ol type="a">
150 <li> Major enhancements to the <a href="../climode.html">.mode command</a>.
151 <li> Improved result formatting, due to the addition of the
152 <a href="https://sqlite.org/src/file/ext/qrf">QRF extension</a>.
153 For example, numeric values are now right-justified by default
154 in <a href="../climode.html#clmnr">tabular output modes</a>.
155 <li> The default output mode for interactive CLI sessions now uses
156 QRF to display query results in boxes formed using Unicode
157 box-drawing characters, for improved legibility. Batch CLI
158 sessions use the legacy output format for compatibility.
159 <li> Bare (unquoted) semicolons at the end of <a href="../cli.html#dotcmd">dot-commands</a> are
160 silently ignored. &emsp;&larr;&nbsp;Potential incompatibility!
161 <li> Fix the .testcase and .check commands so that they actually
162 work, and use those commands in scripts that are part of
163 the standard SQLite test suite included with the source tree.
164 <li> Command-line arguments that match *.sql or *.txt and are
165 the names of non-empty files are read and interpreted as scripts
166 of SQL statements and/or <a href="../cli.html#dotcmd">dot-commands</a>.
167 <li> The argument to the ".timer" command can now be "once", to run
168 the timer on only the next SQL statement.
169 <li> The new "--timeout S" option to the ".progress" dot-command
170 causes SQL statements to interrupt after S seconds.
171 <li> The ".indexes" command was changed so that the PATTERN argument
172 matches the name of the index, not the name of the table
173 being indexed (thus making the PATTERN argument actually useful).
174 And, several new options were added to ".indexes".
175 </ol>
176 <li> New C-language interfaces:
177 <ol type="a">
178 <li> <a href="../c3ref/str_append.html">sqlite3_str_truncate()</a>
179 <li> <a href="../c3ref/str_finish.html">sqlite3_str_free()</a>
180 <li> <a href="../c3ref/carray_bind.html">sqlite3_carray_bind_v2()</a>
181 <li> Add the <a href="../c3ref/c_prepare_dont_log.html#sqlitepreparefromddl">SQLITE_PREPARE_FROM_DDL</a> option to <a href="../c3ref/prepare.html">sqlite3_prepare_v3()</a> which
182 permits <a href="../vtab.html">virtual table</a> implementations to safely prepare SQL statements
183 that are derived from the database schema.
184 <li> Added the <a href="../c3ref/c_any.html#sqliteutf8zt">SQLITE_UTF8_ZT</a> constant which can be used as the encoding parameter to
185 <a href="../c3ref/result_blob.html">sqlite3_result_text64()</a> or <a href="../c3ref/bind_blob.html">sqlite3_bind_text64()</a> to indicate that the value
186 is UTF-8 encoded and zero terminated.
187 <li> The <a href="../c3ref/c_limit_attached.html#sqlitelimitparserdepth">SQLITE_LIMIT_PARSER_DEPTH</a> option is added to <a href="../c3ref/limit.html">sqlite3_limit()</a>.
188 <li> The <a href="../c3ref/c_dbconfig_defensive.html#sqlitedbconfigfpdigits">SQLITE_DBCONFIG_FP_DIGITS</a> option is added to <a href="../c3ref/db_config.html">sqlite3_db_config()</a>.
189 See also item 9b below.
190 </ol>
191 <li> Query planner improvements:
192 <ol type="a">
193 <li> Always use a sort-and-merge algorithm for EXCEPT, INTERSECT, and
194 UNION, since this is almost always faster than using a hash table.
195 <li> Improvements to join order selection in large multi-way joins on
196 a star schema.
197 <li> Enhance the EXISTS-to-JOIN optimization so that the inserted JOIN
198 terms are not required to be on the inner-most loops, as long as
199 all dependencies for the EXISTS-to-JOIN loops are in outer loops.
200 <li> Enhance the omit-noop-join optimization so that it is able to omit
201 a chain of joins that do not affect the output.
202 <li> Allow queries that use "GROUP BY e1 ORDER BY e2" where e1 and e2
203 are identical apart from ASC/DESC sort-orders to be optimized using
204 a single index.
205 <li> Allow virtual tables to optimize DISTINCT in cases where the
206 result-set of a query does not exactly match the ORDER BY clause.
207 </ol>
208 <li> Add new interfaces to the <a href="../sessionintro.html">session extension</a>
209 that enable an application to add changes one at
210 a time to the sqlite3_changegroup object:
211 <ol type="a">
212 <li> <a href="../session/sqlite3changegroup_change_begin.html">sqlite3changegroup_change_begin()</a>
213 <li> <a href="../session/sqlite3changegroup_change_blob.html">sqlite3changegroup_change_blob()</a>
214 <li> <a href="../session/sqlite3changegroup_change_double.html">sqlite3changegroup_change_double()</a>
215 <li> <a href="../session/sqlite3changegroup_change_int64.html">sqlite3changegroup_change_int64()</a>
216 <li> <a href="../session/sqlite3changegroup_change_null.html">sqlite3changegroup_change_null()</a>
217 <li> <a href="../session/sqlite3changegroup_change_text.html">sqlite3changegroup_change_text()</a>
218 <li> <a href="../session/sqlite3changegroup_change_finish.html">sqlite3changegroup_change_finish()</a>
219 <li> <a href="../session/sqlite3changegroup_config.html">sqlite3changegroup_config()</a>
220 </ol>
221 <li> Improvements to floating-point &harr; text conversions.
222 <ol type="a">
223 <li> Reimplemented to improve performance.
224 <li> Rounding is now done by <a href="../floatingpoint.html#*fpdigits">default to 17 significant digits</a>,
225 instead of 15, as was the case for all prior versions.
226 The <a href="../c3ref/db_config.html">sqlite3_db_config</a>(<a href="../c3ref/c_dbconfig_defensive.html#sqlitedbconfigfpdigits">SQLITE_DBCONFIG_FP_DIGITS</a>) API (item 6g above)
227 can change this, if desired.
228 </ol>
229 <li> Added the <a href="../staleexpridx.html#selfheal">self-healing index</a> feature to deal with the
230 <a href="../staleexpridx.html">stale expression index</a> problem.
231 <li> Add the "-p|--port" option to <a href="../rsync.html">sqlite3_rsync</a>.
232 <li> Discontinue support for <a href="https://en.wikipedia.org/wiki/Windows_RT">Windows RT</a>.
233 <li> JavaScript/WASM
234 <ol type="a">
235 <li> Add the "opfs-wl" VFS, functionally identical to the "opfs" VFS but
236 using Web Locks for locking, which can promise fairer lock sharing
237 than the "opfs" bespoke protocol can. "opfs-wl" requires
238 <code>Atomics.waitAsync()</code>, so requires newer browsers than "opfs"
239 does.
240 </ol>
241 </li>
242 </ol>
243 <p><b>Changes in this specific patch release, version 3.53.2 (2026-06-03):</b></p>
244 <p><ol class='lessindent'>
245 <li value='14'> Fixes for problems in 3.53.0 reported by users. See the
246 <a href="https://sqlite.org/src/timeline?from=version-3.53.0&to=version-3.53.2&to2=branch-3.53&y=ci">check-in timeline</a>
247 for details.
248 <p><b>Hashes:</b>
249 <li>SQLITE_SOURCE_ID: 2026-06-03 19:12:13 d6e03d8c777cfa2d35e3b60d8ec3e0187f3e9f99d8e2ee9cac695fd6fcdf1a24
250 <li>SHA3-256 for sqlite3.c: 44fd61b9f93b4155105cb2d80c957ae6c64a8b5bd6ed51a4992f0dbd438e4e11
251
252 </ol></p>
253
254 <p>A <a href="../changes.html">complete list of SQLite releases</a>
255 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
256 A detailed history of every
257 check-in is available at
258 <a href="https://sqlite.org/src/timeline">
259 SQLite version control site</a>.</p>
260
261