Debian Codegraph @

www/releaselog/3_17_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.17.0 On 2017-02-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.17.0 On 2017-02-13</h2><p><ol class='lessindent'>
119 <li>Approximately 25% better performance from the <a href="../rtree.html">R-Tree extension</a>.
120 <ol type='a'>
121 <li> Uses compiler built-ins (ex: __builtin_bswap32() or _byteswap_ulong())
122 for byteswapping when available.
123 <li> Uses the <a href="../c3ref/blob.html">sqlite3_blob</a> key/value access object instead of SQL
124 for pulling content out of R-Tree nodes
125 <li> Other miscellaneous enhancements such as loop unrolling.
126 </ol>
127 <li>Add the <a href="../compile.html#default_lookaside">SQLITE_DEFAULT_LOOKASIDE</a> compile-time option.
128 <li>Increase the default <a href="../malloc.html#lookaside">lookaside</a>
129 size from 512,125 to 1200,100
130 as this provides better performance while only adding 56KB
131 of extra memory per connection. Memory-sensitive
132 applications can restore the old
133 default at compile-time, start-time, or run-time.
134 <li>Use compiler built-ins __builtin_sub_overflow(), __builtin_add_overflow(),
135 and __builtin_mul_overflow() when available. (All compiler
136 built-ins can be omitted with the <a href="../compile.html#disable_intrinsic">SQLITE_DISABLE_INTRINSIC</a> compile-time
137 option.)
138 <li>Added the <a href="../compile.html#enable_null_trim">SQLITE_ENABLE_NULL_TRIM</a> compile-time option, which
139 can result in significantly smaller database files for some
140 applications, at the risk of being incompatible with older
141 versions of SQLite.
142 <li>Change <a href="../compile.html#default_pcache_initsz">SQLITE_DEFAULT_PCACHE_INITSZ</a> from 100 to 20, for
143 improved performance.
144 <li>Added the SQLITE_UINT64_TYPE compile-time option as an
145 analog to SQLITE_INT64_TYPE.
146 <li>Perform some <a href="../lang_update.html">UPDATE</a> operations in a single pass instead of
147 in two passes.
148 <li>Enhance the <a href="../sessionintro.html">session extension</a> to support <a href="../withoutrowid.html">WITHOUT ROWID</a>
149 tables.
150 <li>Fixed performance problems and potential stack overflows
151 when creating <a href="../lang_createview.html">views</a> from multi-row VALUES clauses with
152 hundreds of thousands of rows.
153 <li>Added the <a href="https://sqlite.org/src/file/ext/misc/sha1.c">sha1.c</a>
154 extension.
155 <li>In the <a href="../cli.html">command-line shell</a>, enhance the ".mode" command so that it
156 restores the default column and row separators for modes "line",
157 "list", "column", and "tcl".
158 <li>Enhance the <a href="../compile.html#direct_overflow_read">SQLITE_DIRECT_OVERFLOW_READ</a> option so that it works
159 in <a href="../wal.html">WAL mode</a> as long as the pages being read are not in the WAL file.
160 <li>Enhance the
161 <a href="../lemon.html">Lemon parser generator</a>
162 so that it can store the parser object as a stack variable rather than
163 allocating space from the heap and make use of that enhancement in
164 the <a href="../amalgamation.html">amalgamation</a>.
165 <li>Other performance improvements. Uses about <a href="../cpu.html">6.5% fewer CPU cycles</a>.
166 <p><b>Bug Fixes:</b>
167 <li>Throw an error if the ON clause of a LEFT JOIN references tables
168 to the right of the ON clause. This is the same behavior as
169 PostgreSQL. Formerly, SQLite silently converted the LEFT JOIN
170 into an INNER JOIN. Fix for ticket
171 <a href="https://sqlite.org/src/info/25e335f802dd">25e335f802dd</a>.
172 <li>Use the correct affinity for columns of automatic indexes. Ticket
173 <a href="https://sqlite.org/src/info/7ffd1ca1d2ad4ec">7ffd1ca1d2ad4ec</a>.
174 <li>Ensure that the <a href="../c3ref/blob_reopen.html">sqlite3_blob_reopen()</a> interface can correctly
175 handle short rows. Fix for ticket
176 <a href="https://sqlite.org/src/info/e6e962d6b0f06f46e">e6e962d6b0f06f46e</a>.
177 <p><b>Hashes:</b>
178 <li>SQLITE_SOURCE_ID: "2017-02-13 16:02:40 ada05cfa86ad7f5645450ac7a2a21c9aa6e57d2c"
179 <li>SHA1 for sqlite3.c: cc7d708bb073c44102a59ed63ce6142da1f174d1
180
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