Debian Codegraph @

www/releaselog/3_40_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.40.1 On 2022-12-28</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.40.1 On 2022-12-28</h2><p><b>Prior changes from version 3.40.0 (2022-11-16):</b></p>
119 <p><ol class='lessindent'>
120 <li value='1'> Add support for compiling <a href="https://sqlite.org/wasm">SQLite to WASM</a>
121 and running it in web browsers. NB: The WASM build and its interfaces
122 are considered "beta" and are subject to minor changes if the need
123 arises. We anticipate finalizing the interface for the next release.
124 <li> Add the <a href="../recovery.html">recovery extension</a> that might be able to recover some content
125 from a corrupt database file.
126 <li> Query planner enhancements:
127 <ol type="a">
128 <li> Recognize <a href="../queryplanner.html#covidx">covering indexes</a> on tables with more than 63 columns where
129 columns beyond the 63rd column are used in the query and/or are
130 referenced by the index.
131 <li> Extract the values of expressions contained within <a href="../expridx.html">expression indexes</a>
132 where practical, rather than recomputing the expression.
133 <li> The NOT NULL and IS NULL operators (and their equivalents) avoid
134 loading the content of large strings and BLOB values from disk.
135 <li> Avoid materializing a view on which a full scan is performed
136 exactly once. Use and discard the rows of the view as they are computed.
137 <li> Allow flattening of a subquery that is the right-hand operand of
138 a LEFT JOIN in an aggregate query.
139 </ol>
140 <li> A new typedef named <a href="../c3ref/filename.html">sqlite3_filename</a> is added and used to represent
141 the name of a database file. Various interfaces are
142 modified to use the new typedef instead of "char*". This interface
143 change should be fully backwards compatible, though it might cause
144 (harmless) compiler warnings when rebuilding some legacy applications.
145 <li> Add the <a href="../c3ref/value_encoding.html">sqlite3_value_encoding()</a> interface.
146 <li> Security enhancement: <a href="../c3ref/c_dbconfig_defensive.html#sqlitedbconfigdefensive">SQLITE_DBCONFIG_DEFENSIVE</a> is augmented to prohibit
147 changing the <a href="../pragma.html#pragma_schema_version">schema_version</a>. The schema_version
148 becomes read-only in defensive mode.
149 <li> Enhancements to the <a href="../pragma.html#pragma_integrity_check">PRAGMA integrity_check</a> statement:
150 <ol type="a">
151 <li> Columns in non-STRICT tables with TEXT affinity should not contain numeric values.
152 <li> Columns in non-STRICT tables with NUMERIC affinity should not
153 contain TEXT values that could be converted into numbers.
154 <li> Verify that the rows of a <a href="../withoutrowid.html">WITHOUT ROWID</a> table are in the correct order.
155 </ol>
156 <li> Enhance the <a href="../lang_vacuum.html#vacuuminto">VACUUM INTO</a> statement so that it honors the
157 <a href="../pragma.html#pragma_synchronous">PRAGMA synchronous</a> setting.
158 <li> Enhance the <a href="../c3ref/strglob.html">sqlite3_strglob()</a> and <a href="../c3ref/strlike.html">sqlite3_strlike()</a> APIs so that they are able
159 to accept NULL pointers for their string parameters and still generate a sensible
160 result.
161 <li> Provide the new <a href="../compile.html#max_allocation_size">SQLITE_MAX_ALLOCATION_SIZE</a> compile-time option for limiting
162 the size of memory allocations.
163 <li> Change the algorithm used by SQLite's built-in pseudo-random number generator (PRNG)
164 from RC4 to Chacha20.
165 <li> Allow two or more indexes to have the same name as long as they are all in
166 separate schemas.
167 <li> Miscellaneous performance optimizations result in about 1% fewer CPU cycles
168 used on typical workloads.
169 </ol>
170 <p><b>Changes in this specific patch release, version 3.40.1 (2022-12-28):</b></p>
171 <p><ol class='lessindent'>
172 <li value='14'> Fix the <a href="../cli.html#safemode">--safe command-line option</a> to the <a href="../cli.html">CLI</a>
173 such that it correctly disallows the
174 use of SQL functions like writefile() that can cause harmful side-effects.
175 <li> Fix a potential infinite loop in the <a href="../malloc.html#memsys5">memsys5</a> alternative memory allocator. This
176 bug was introduced by a performance optimization in version 3.39.0.
177 <li> Various other obscure fixes.
178 <p><b>Hashes:</b>
179 <li>SQLITE_SOURCE_ID: 2022-12-28 14:03:47 df5c253c0b3dd24916e4ec7cf77d3db5294cc9fd45ae7b9c5e82ad8197f38a24
180 <li>SHA3-256 for sqlite3.c: 4d6800e9032ff349376fe612e422b49ba5eb4e378fac0b3e405235d09dd366ab
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