Debian Codegraph @

www/releaselog/3_46_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.46.1 On 2024-08-13</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.46.1 On 2024-08-13</h2><p><b>Prior changes from version 3.46.0 (2024-05-23):</b></p>
119 <p><ol class='lessindent'>
120 <li value='1'> Enhance <a href="../pragma.html#pragma_optimize">PRAGMA optimize</a> in multiple ways, to make it
121 <a href="../lang_analyze.html#pragopt">simpler to use</a>:
122 <ol type="a">
123 <li> PRAGMA optimize automatically implements a temporary
124 <a href="../pragma.html#pragma_analysis_limit">analysis limit</a> to prevent excess runtime
125 on large databases.
126 <li> Added the new 0x10000 bitmask option to check for updates on all tables.
127 <li> Automatically re-analyze tables that do not have sqlite_stat1 entries.
128 </ol>
129 <li> Enhancements to the <a href="../lang_datefunc.html">date and time functions</a>:
130 <ol type="a">
131 <li> The <a href="../lang_datefunc.html#strftm">strftime() SQL function</a> now supports %G, %g, %U, and %V.
132 <li> New modifiers 'ceiling' and 'floor' control the algorithm used to
133 resolve <a href="../lang_datefunc.html#dtambg">ambiguous dates</a> when shifting a date by an integer number
134 of months and/or years.
135 <li> The <a href="../lang_datefunc.html#localtime">'utc' and 'localtime' modifiers</a> are now no-ops if SQLite knows
136 that the time is already in UTC or in the localtime, respectively.
137 </ol>
138 <li> Add support for underscore ("_") characters between digits in
139 <a href="../lang_expr.html#litvalue">numeric literals</a>.
140 <li> Add the <a href="../json1.html#jpretty">json_pretty()</a> SQL function.
141 <li> Query planner improvements:
142 <ol type="a">
143 <li> The "VALUES-as-coroutine" optimization enables INSERT statements with
144 thousands of rows in the VALUES clause to parse and run in about half
145 the time and using about half as much memory.
146 <li> Allow the use of an index for queries like "SELECT count(DISTINCT col) FROM ...",
147 even if the index records are not smaller than the table records.
148 <li> Improved recognition of cases where the value of an SQL function is
149 constant because all its arguments are constant.
150 <li> Enhance the <a href="../optoverview.html#pushdown">WHERE-clause push-down optimization</a> so that it is able to
151 push down WHERE clause terms containing uncorrelated subqueries.
152 </ol>
153 <li> Allocate additional memory from the heap for the SQL parser stack if
154 that stack overflows, rather than reporting a "parser stack overflow" error.
155 <li> JSON changes:
156 <ol type="a">
157 <li> Allow ASCII control characters within JSON5 string literals.
158 <li> Fix <a href="../json1.html#jptr">the -> and ->> operators</a> so that when the right-hand side operand is a string
159 that looks like an integer it is still treated as a string, because that is what
160 PostgreSQL does.
161 </ol>
162 <li> Allow large hexadecimal literals to be used as the DEFAULT value to a table column.
163 </ol>
164 <p><b>Changes in this specific patch release, version 3.46.1 (2024-08-13):</b></p>
165 <p><ol class='lessindent'>
166 <li value='9'> Improved robustness while parsing the <a href="../fts5.html#tokenizers">tokenize= arguments</a> in <a href="../fts5.html">FTS5</a>.
167 <a href="https://sqlite.org/forum/forumpost/171bcc2bcd">Forum post 171bcc2bcd</a>.
168 <li> Enhancements to <a href="../queryplanner.html#covidx">covering index</a> prediction in the query planner.
169 Add early detection of over-prediction of covering indexes so that
170 <a href="../c3ref/prepare.html">sqlite3_prepare()</a> will return an error rather than just generate bad bytecode.
171 <a href="https://sqlite.org/forum/forumpost/e60e4c295d22f8ce">Forum post e60e4c295d22f8ce</a>.
172 <li> Do not let the number of terms on a <a href="../lang_select.html#values">VALUES clause</a> be limited by
173 <a href="../c3ref/c_limit_attached.html#sqlitelimitcompoundselect">SQLITE_LIMIT_COMPOUND_SELECT</a>, even if the VALUES clause contains
174 elements that appear to be variables due to
175 <a href="../quirks.html#dblquote">double-quoted string literals</a>.
176 <li> Fix the <a href="../windowfunctions.html">window function</a> version of <a href="../lang_aggfunc.html#group_concat">group_concat()</a> so that it returns
177 an empty string if it has one or more empty string inputs.
178 <li> In <a href="../fts5.html#the_secure_delete_configuration_option">FTS5 secure-delete mode</a>, fix false-positive
179 integrity-check reports about corrupt indexes.
180 <li> Syntax errors in <a href="../lang_altertable.html">ALTER TABLE</a> should always return <a href="../rescode.html#error">SQLITE_ERROR</a>. In
181 some cases, they were formerly returning <a href="../rescode.html#internal">SQLITE_INTERNAL</a>.
182 <li> JavaScript/WASM:
183 <ol type="a">
184 <li> Fix a corruption-causing bug in the JavaScript "opfs" VFS.
185 <li> Work around a couple of browser-specific OPFS quirks.
186 </ol>
187 <li> Other minor fixes.
188 <p><b>Hashes:</b>
189 <li>SQLITE_SOURCE_ID: 2024-08-13 09:16:08 c9c2ab54ba1f5f46360f1b4f35d849cd3f080e6fc2b6c60e91b16c63f69a1e33
190 <li>SHA3-256 for sqlite3.c: 186a1baa476b6d546de155160ca6d30ff7b7e6ee375f0bb6445e1a3d180a7dad
191
192 </ol></p>
193
194 <p>A <a href="../changes.html">complete list of SQLite releases</a>
195 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
196 A detailed history of every
197 check-in is available at
198 <a href="https://sqlite.org/src/timeline">
199 SQLite version control site</a>.</p>
200
201