Debian Codegraph @

www/releaselog/3_49_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.49.1 On 2025-02-18</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.49.1 On 2025-02-18</h2><p><b>Prior changes from version 3.49.0 (2025-02-06):</b></p>
119 <p><ol class='lessindent'>
120 <li value='1'> Enhancements to the <a href="../optoverview.html">query planner</a>:
121 <ol type="a">
122 <li> Improve the <a href="../optoverview.html#autoindex">query-time index</a> optimization so that it works on
123 <a href="../withoutrowid.html">WITHOUT ROWID</a> tables.
124 <li> Better query plans for large <a href="../queryplanner-ng.html#starq">star-query</a> joins. This fixes
125 three different performance regressions that were reported on
126 the SQLite Forum.
127 <li> When two or more queries have the same estimated cost, use
128 the one with the fewer bytes per row.
129 </ol>
130 <li> Enhance the <a href="../lang_corefunc.html#iif">iif() SQL function</a> so that it can accept any number of
131 arguments greater than or equal to two.
132 <li> Enhance the <a href="../sessionintro.html">session extension</a> so that it works on databases that
133 make use of <a href="../gencol.html">generated columns</a>.
134 <li> Omit the SQLITE_USE_STDIO_FOR_CONSOLE compile-time option which was
135 not implemented correctly and never worked right. In its place add
136 the SQLITE_USE_W32_FOR_CONSOLE_IO compile-time option. This option
137 applies to command-line tools like the <a href="../cli.html">CLI</a> only, not to the SQLite
138 core. It causes Win32 APIs to be used for console I/O instead of
139 stdio. This option affects Windows builds only.
140 <li> Three new options to <a href="../c3ref/db_config.html">sqlite3_db_config()</a>. All default to "on".
141 <ol type="a">
142 <li> <a href="../c3ref/c_dbconfig_defensive.html#sqlitedbconfigenableattachcreate">SQLITE_DBCONFIG_ENABLE_ATTACH_CREATE</a>
143 <li> <a href="../c3ref/c_dbconfig_defensive.html#sqlitedbconfigenableattachwrite">SQLITE_DBCONFIG_ENABLE_ATTACH_WRITE</a>
144 <li> <a href="../c3ref/c_dbconfig_defensive.html#sqlitedbconfigenablecomments">SQLITE_DBCONFIG_ENABLE_COMMENTS</a>
145 </ol>
146 <li> Replace <a href="https://en.wikipedia.org/wiki/GNU_Autotools">Autotools</a>
147 with <a href="https://msteveb.github.io/autosetup/">Autosetup</a> for the
148 configure script used in the <a href="../amalgamation.html#amalgtarball">precompiled amalgamation tarball</a>.
149 The configure script for the <a href="../amalg-v-canon.html#canon">canonical source code</a> was changed
150 to Autosetup in the previous (3.48.0) release.
151 Only the main SQLite configure script in the amalgamation tarball
152 is changed. The (deprecated) configuration script use by
153 <a href="https://www.tcl-lang.org/doc/tea/TEAOverview.html">TEA</a> subdirectory
154 of the amalgamation tarball still relies on Autotools.
155 <li> Various minor patches and fixes for problems seen in the 3.48.0 release.
156 </ol>
157 <p><b>Changes in this specific patch release, version 3.49.1 (2025-02-18):</b></p>
158 <p><ol class='lessindent'>
159 <li value='8'> Improve portability of makefiles and configure scripts.
160 <li> Fix a bug in the <a href="../lang_corefunc.html#concat_ws">concat_ws()</a> function, introduced in <a href="../releaselog/3_44_0.html">version 3.44.0</a>,
161 that could lead to a memory error, specifically a write past the end of
162 allocated space, if the separator string is larger than two megabytes.
163 <li> Enhanced the <a href="../c3ref/c_dbconfig_defensive.html#sqlitedbconfiglookaside">SQLITE_DBCONFIG_LOOKASIDE</a> interface to make it more
164 robust against misuse.
165 <p><b>Hashes:</b>
166 <li>SQLITE_SOURCE_ID: 2025-02-18 13:38:58 873d4e274b4988d260ba8354a9718324a1c26187a4ab4c1cc0227c03d0f10e70
167 <li>SHA3-256 for sqlite3.c: 22eab05c842463a3705c63922f12f68531200185ced510ed6aed2065ca44e816
168
169 </ol></p>
170
171 <p>A <a href="../changes.html">complete list of SQLite releases</a>
172 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
173 A detailed history of every
174 check-in is available at
175 <a href="https://sqlite.org/src/timeline">
176 SQLite version control site</a>.</p>
177
178