Debian Codegraph @

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