Debian Codegraph @

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