Debian Codegraph @

www/releaselog/3_32_3.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.32.3 On 2020-06-18</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.32.3 On 2020-06-18</h2><p><b>Prior changes from version 3.32.0 (2020-05-22):</b></p>
119 <p><ol class='lessindent'>
120 <li value='1'> Added support for <a href="../lang_analyze.html#approx">approximate ANALYZE</a> using the
121 <a href="../pragma.html#pragma_analysis_limit">PRAGMA analysis_limit</a> command.
122 <li> Added the <a href="../bytecodevtab.html">bytecode virtual table</a>.
123 <li> Add the <a href="../cksumvfs.html">checksum VFS shim</a> to the set of run-time loadable
124 extensions included in the source tree.
125 <li> Added the <a href="../lang_corefunc.html#iif">iif() SQL function</a>.
126 <li> INSERT and UPDATE statements now always apply <a href="../datatype3.html#affinity">column affinity</a>
127 before computing <a href="../lang_createtable.html#ckconst">CHECK constraints</a>. This bug fix could, in
128 theory, cause problems for legacy databases with unorthodox
129 CHECK constraints the require the input type for an INSERT
130 is different from the declared column type. See ticket
131 <a href="https://sqlite.org/src/info/86ba67afafded936">86ba67afafded936</a>
132 for more information.
133 <li> Added the <a href="../c3ref/create_filename.html">sqlite3_create_filename()</a>, <a href="../c3ref/create_filename.html">sqlite3_free_filename()</a>,
134 and <a href="../c3ref/database_file_object.html">sqlite3_database_file_object()</a>
135 interfaces to better support of <a href="../vfs.html#shim">VFS shim</a> implementations.
136 <li> Increase the <a href="../limits.html#max_variable_number">default upper bound</a>
137 on the number of <a href="../lang_expr.html#varparam">parameters</a> from 999 to 32766.
138 <li> Added code for the <a href="../uintcseq.html">UINT collating sequence</a> as an optional
139 <a href="../loadext.html">loadable extension</a>.
140 <li> Enhancements to the <a href="../cli.html">CLI</a>:
141 <ol type="a">
142 <li> Add options to the <a href="../cli.html#csv">.import</a> command: --csv, --ascii, --skip
143 <li> The <a href="../cli.html#dump">.dump</a> command now accepts multiple LIKE-pattern arguments
144 and outputs the union of all matching tables.
145 <li> Add the .oom command in debugging builds
146 <li> Add the --bom option to the <a href="../cli.html#dotexcel">.excel</a>, <a href="../cli.html#dotoutput">.output</a>, and <a href="../cli.html#dotoutput">.once</a>
147 commands.
148 <li> Enhance the .filectrl command to support the --schema option.
149 <li> The <a href="../uintcseq.html">UINT collating sequence</a> extension is automatically loaded
150 </ol>
151 <li> The <a href="../lang_expr.html#like">ESCAPE</a> clause of a <a href="../lang_expr.html#like">LIKE</a> operator now overrides wildcard
152 characters, so that the behavior matches what PostgreSQL does.
153 </ol>
154 <p><b>Prior changes from version 3.32.1 (2020-05-25):</b></p>
155 <p><ol class='lessindent'>
156 <li value='11'> Fix two long-standing bugs that allow malicious SQL statements
157 to crash the process that is running SQLite. These bugs were announced
158 by a third-party approximately 24 hours after the 3.32.0 release but are
159 not specific to the 3.32.0 release.
160 <li> Other minor compiler-warning fixes and whatnot.
161 </ol>
162 <p><b>Prior changes from version 3.32.2 (2020-06-04):</b></p>
163 <p><ol class='lessindent'>
164 <li value='13'> Fix a long-standing bug in the byte-code engine that can cause a
165 <a href="../lang_transaction.html">COMMIT</a> command report as success when in fact it failed
166 to commit. Ticket
167 <a href="https://sqlite.org/src/info/810dc8038872e212">810dc8038872e212</a>
168 </ol>
169 <p><b>Changes in this specific patch release, version 3.32.3 (2020-06-18):</b></p>
170 <p><ol class='lessindent'>
171 <li value='14'> Various minor bug fixes including fixes for tickets
172 <a href="https://sqlite.org/src/info/8f157e8010b22af0">8f157e8010b22af0</a>,
173 <a href="https://sqlite.org/src/info/9fb26d37cefaba40">9fb26d37cefaba40</a>,
174 <a href="https://sqlite.org/src/info/e367f31901ea8700">e367f31901ea8700</a>,
175 <a href="https://sqlite.org/src/info/b706351ce2ecf59a">b706351ce2ecf59a</a>,
176 <a href="https://sqlite.org/src/info/7c6d876f84e6e7e2">7c6d876f84e6e7e2</a>, and
177 <a href="https://sqlite.org/src/info/c8d3b9f0a750a529">c8d3b9f0a750a529</a>.
178 <p><b>Hashes:</b>
179 <li>SQLITE_SOURCE_ID: 2020-06-18 14:00:33 7ebdfa80be8e8e73324b8d66b3460222eb74c7e9dfd655b48d6ca7e1933cc8fd
180 <li>SHA3-256 for sqlite3.c: b62b77ee1c561a69a71bb557694aaa5141f1714c1ff6cc1ba8aa8733c92d4f52
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