Debian Codegraph @

www/releaselog/3_32_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.32.0 On 2020-05-22</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.0 On 2020-05-22</h2><p><ol class='lessindent'>
119 <li> Added support for <a href="../lang_analyze.html#approx">approximate ANALYZE</a> using the
120 <a href="../pragma.html#pragma_analysis_limit">PRAGMA analysis_limit</a> command.
121 <li> Added the <a href="../bytecodevtab.html">bytecode virtual table</a>.
122 <li> Add the <a href="../cksumvfs.html">checksum VFS shim</a> to the set of run-time loadable
123 extensions included in the source tree.
124 <li> Added the <a href="../lang_corefunc.html#iif">iif() SQL function</a>.
125 <li> INSERT and UPDATE statements now always apply <a href="../datatype3.html#affinity">column affinity</a>
126 before computing <a href="../lang_createtable.html#ckconst">CHECK constraints</a>. This bug fix could, in
127 theory, cause problems for legacy databases with unorthodox
128 CHECK constraints the require the input type for an INSERT
129 is different from the declared column type. See ticket
130 <a href="https://sqlite.org/src/info/86ba67afafded936">86ba67afafded936</a>
131 for more information.
132 <li> Added the <a href="../c3ref/create_filename.html">sqlite3_create_filename()</a>, <a href="../c3ref/create_filename.html">sqlite3_free_filename()</a>,
133 and <a href="../c3ref/database_file_object.html">sqlite3_database_file_object()</a>
134 interfaces to better support of <a href="../vfs.html#shim">VFS shim</a> implementations.
135 <li> Increase the <a href="../limits.html#max_variable_number">default upper bound</a>
136 on the number of <a href="../lang_expr.html#varparam">parameters</a> from 999 to 32766.
137 <li> Added code for the <a href="../uintcseq.html">UINT collating sequence</a> as an optional
138 <a href="../loadext.html">loadable extension</a>.
139 <li> Enhancements to the <a href="../cli.html">CLI</a>:
140 <ol type="a">
141 <li> Add options to the <a href="../cli.html#csv">.import</a> command: --csv, --ascii, --skip
142 <li> The <a href="../cli.html#dump">.dump</a> command now accepts multiple LIKE-pattern arguments
143 and outputs the union of all matching tables.
144 <li> Add the .oom command in debugging builds
145 <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>
146 commands.
147 <li> Enhance the .filectrl command to support the --schema option.
148 <li> The <a href="../uintcseq.html">UINT collating sequence</a> extension is automatically loaded
149 </ol>
150 <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
151 characters, so that the behavior matches what PostgreSQL does.
152 <li>SQLITE_SOURCE_ID: 2020-05-22 17:46:16 5998789c9c744bce92e4cff7636bba800a75574243d6977e1fc8281e360f8d5a
153 <li>SHA3-256 for sqlite3.c: 33ed868b21b62ce1d0352ed88bdbd9880a42f29046497a222df6459fc32a356f
154
155 </ol></p>
156
157 <p>A <a href="../changes.html">complete list of SQLite releases</a>
158 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
159 A detailed history of every
160 check-in is available at
161 <a href="https://sqlite.org/src/timeline">
162 SQLite version control site</a>.</p>
163
164