Debian Codegraph @

www/releaselog/3_41_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.41.1 On 2023-03-10</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.41.1 On 2023-03-10</h2><p><b>Prior changes from version 3.41.0 (2023-02-21):</b></p>
119 <p><ol class='lessindent'>
120 <li value='1'>Query planner improvements:
121 <ol type="a">
122 <li> Make use of <a href="../expridx.html">indexed expressions</a> within an aggregate query that
123 includes a GROUP BY clause.
124 <li> The query planner has improved awareness of when an index is
125 a <a href="../queryplanner.html#covidx">covering index</a> and adjusts predicted runtimes accordingly.
126 <li> The query planner is more aggressive about using <a href="../optoverview.html#coroutines">co-routines</a> rather
127 than materializing subqueries and views.
128 <li> Queries against the built-in table-valued functions <a href="../json1.html#jtree">json_tree()</a> and
129 <a href="../json1.html#jeach">json_each()</a> will now usually treat "ORDER BY rowid" as a no-op.
130 <li> Enhance the ability of the query planner to use <a href="../expridx.html">indexed expressions</a>
131 even if the expression has been modified by the
132 <a href="../optoverview.html#constprop">constant-propagation optimization</a>.
133 (See <a href="https://sqlite.org/forum/forumpost/0a539c76db3b9e29">forum thread 0a539c7</a>.)
134 </ol>
135 <li>Add the built-in <a href="../lang_corefunc.html#unhex">unhex()</a> SQL function.
136 <li>Add the base64 and base85 application-defined functions as an extension and
137 include that extension in the <a href="../cli.html">CLI</a>.
138 <li>Add the <a href="../c3ref/stmt_scanstatus.html">sqlite3_stmt_scanstatus_v2()</a> interface. (This interface is only
139 available if SQLite is compiled using <a href="../compile.html#enable_stmt_scanstatus">SQLITE_ENABLE_STMT_SCANSTATUS</a>.)
140 <li>In-memory databases created using <a href="../c3ref/deserialize.html">sqlite3_deserialize()</a> now report their
141 filename as an empty string, not as 'x'.
142 <li>Changes to the <a href="../cli.html">CLI</a>:
143 <ol type="a">
144 <li> Add the new base64() and base85() SQL functions
145 <li> Enhanced <a href="../eqp.html">EXPLAIN QUERY PLAN</a> output using the new <a href="../c3ref/stmt_scanstatus.html">sqlite3_stmt_scanstatus_v2()</a>
146 interface when compiled using <a href="../compile.html#enable_stmt_scanstatus">SQLITE_ENABLE_STMT_SCANSTATUS</a>.
147 <li> The "<tt>.scanstats est</tt>" command provides query planner estimates in profiles.
148 <li> The continuation prompt indicates if the input is currently inside of a
149 string literal, identifier literal, comment, trigger definition, etc.
150 <li> Enhance the --safe command-line option to disallow dangerous SQL functions.
151 <li> The <a href="../quirks.html#dblquote">double-quoted string misfeature</a> is now disabled by default for CLI
152 builds. Legacy use cases can reenable the misfeature at run-time using
153 the "<tt>.dbconfig dqs_dml on</tt>" and "<tt>.dbconfig dqs_ddl on</tt>"
154 commands.
155 </ol>
156 <li>Enhance the <a href="../pragma.html#pragma_integrity_check">PRAGMA integrity_check</a> command so that it detects when text strings in
157 a table are equivalent to but not byte-for-byte identical to the same strings in the index.
158 <li>Enhance the <a href="../carray.html">carray table-valued function</a> so that it is able to bind an array of
159 BLOB objects.
160 <li>Added the <a href="../c3ref/interrupt.html">sqlite3_is_interrupted()</a> interface.
161 <li>Long-running calls to <a href="../c3ref/prepare.html">sqlite3_prepare()</a> and similar now invoke the
162 <a href="../c3ref/progress_handler.html">progress handler callback</a> and react to <a href="../c3ref/interrupt.html">sqlite3_interrupt()</a>.
163 <li>The <a href="../c3ref/vtab_in_first.html">sqlite3_vtab_in_first()</a> and <a href="../c3ref/vtab_in_first.html">sqlite3_vtab_in_next()</a> functions are enhanced so that
164 they reliably detect if they are invoked on a parameter that was not selected for
165 multi-value IN processing using <a href="../c3ref/vtab_in.html">sqlite3_vtab_in()</a>.
166 They return SQLITE_ERROR instead of SQLITE_MISUSE in this case.
167 <li>The parser now ignores excess parentheses around a subquery on the right-hand side
168 of an IN operator, so that SQLite now works the same as PostgreSQL in this regard.
169 Formerly, SQLite treated the subquery as an expression with an implied "LIMIT 1".
170 <li>Added the <a href="../c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlresetcache">SQLITE_FCNTL_RESET_CACHE</a> option to the <a href="../c3ref/file_control.html">sqlite3_file_control()</a> API.
171 <li>Makefile improvements:
172 <ol type="a">
173 <li>The new makefile target "sqlite3r.c" builds an <a href="../amalgamation.html">amalgamation</a> that includes
174 the <a href="../recovery.html">recovery extension</a>.
175 <li>New makefile targets "devtest" and "releasetest" for running a
176 quick developmental test prior to doing a check-in and for doing a full
177 release test, respectively.
178 </ol>
179 <li>Miscellaneous performance enhancements.
180 </ol>
181 <p><b>Changes in this specific patch release, version 3.41.1 (2023-03-10):</b></p>
182 <p><ol class='lessindent'>
183 <li value='16'> Provide compile-time options -DHAVE_LOG2=0 and -DHAVE_LOG10=0 to enable SQLite to be
184 compiled on systems that omit the standard library functions log2() and log10(), repectively.
185 <li> Ensure that the datatype for column t1.x in
186 "<tt>CREATE TABLE t1 AS SELECT CAST(7 AS INT) AS x;</tt>" continues to be INT and is not NUM,
187 for historical compatibility.
188 <li> Enhance <a href="../pragma.html#pragma_integrity_check">PRAGMA integrity_check</a> to detect when extra bytes appear at the end of an
189 index record.
190 <li> Fix various obscure bugs reported by the user community. See the
191 <a href="https://sqlite.org/src/timeline?from=version-3.41.0&to=version-3.41.1">timeline of changes</a>
192 for details.
193
194 <p><b>Hashes:</b>
195 <li>SQLITE_SOURCE_ID: 2023-03-10 12:13:52 20399f3eda5ec249d147ba9e48da6e87f969d7966a9a896764ca437ff7e737ff
196 <li>SHA3-256 for sqlite3.c: d0d9db8425570f4a57def04fb8f4ac84f5c3e4e71d3d4d10472e3639c5fdf09f
197
198 </ol></p>
199
200 <p>A <a href="../changes.html">complete list of SQLite releases</a>
201 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
202 A detailed history of every
203 check-in is available at
204 <a href="https://sqlite.org/src/timeline">
205 SQLite version control site</a>.</p>
206
207