Debian Codegraph @

www/releaselog/3_49_2.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.2 On 2025-05-07</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.2 On 2025-05-07</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>Prior changes from 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 </ol>
166 <p><b>Changes in this specific patch release, version 3.49.2 (2025-05-07):</b></p>
167 <p><ol class='lessindent'>
168 <li value='11'> Fix a bug in the NOT NULL optimization of version 3.40.0
169 (item 3c in the <a href="../releaselog/3_40_0.html">version 3.40.0 change log</a>) that can lead to
170 a memory error if abused.
171 <li> Fix the count-of-view optimization so that it does not give an incorrect
172 answer for a DISTINCT query.
173 <li> Fix a possible incorrect answer that can result if a UNIQUE constraint
174 of a table contains the PRIMARY KEY column and that UNIQUE constraint is
175 used by an IN operator.
176 <li> Fix obscure problems with the generate_series() extension function.
177 <li> Incremental improvements to the configure/make.
178 <p><b>Hashes:</b>
179 <li>SQLITE_SOURCE_ID: 2025-05-07 10:39:52 17144570b0d96ae63cd6f3edca39e27ebd74925252bbaf6723bcb2f6b4861fb1
180 <li>SHA3-256 for sqlite3.c: 17f4857fc6a0def2749d248d5365c59282c044270533c6c2b21287295f01eb23
181
182 </ol></p>
183
184 <p>A <a href="../changes.html">complete list of SQLite releases</a>
185 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
186 A detailed history of every
187 check-in is available at
188 <a href="https://sqlite.org/src/timeline">
189 SQLite version control site</a>.</p>
190
191