Debian Codegraph @

www/releaselog/3_24_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.24.0 On 2018-06-04</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.24.0 On 2018-06-04</h2><p><ol class='lessindent'>
119 <li> Add support for PostgreSQL-style <a href="../lang_upsert.html">UPSERT</a>.
120 <li> Add support for <a href="../rtree.html#auxcol">auxiliary columns in r-tree tables</a>.
121 <li> Add C-language APIs for discovering SQL keywords used by
122 SQLite: <a href="../c3ref/keyword_check.html">sqlite3_keyword_count()</a>, <a href="../c3ref/keyword_check.html">sqlite3_keyword_name()</a>, and
123 <a href="../c3ref/keyword_check.html">sqlite3_keyword_check()</a>.
124 <li> Add C-language APIs for dynamic strings based on the
125 <a href="../c3ref/str.html">sqlite3_str</a> object.
126 <li> Enhance <a href="../lang_altertable.html">ALTER TABLE</a> so that it recognizes "true" and "false" as
127 valid arguments to DEFAULT.
128 <li> Add the sorter-reference optimization as a compile-time option.
129 Only available if compiled with SQLITE_ENABLE_SORTER_REFERENCES.
130 <li> Improve the format of the <a href="../eqp.html">EXPLAIN QUERY PLAN</a> raw output, so that
131 it gives better information about the query plan and about the
132 relationships between the various components of the plan.
133 <li> Added the <a href="../c3ref/c_dbconfig_defensive.html#sqlitedbconfigresetdatabase">SQLITE_DBCONFIG_RESET_DATABASE</a> option to the
134 <a href="../c3ref/db_config.html">sqlite3_db_config()</a> API.
135 <p><b><a href="../cli.html">CLI</a> Enhancements:</b>
136 <li> Automatically intercepts the raw <a href="../eqp.html">EXPLAIN QUERY PLAN</a>
137 output and reformats it into an ASCII-art graph.
138 <li> Lines that begin with "#" and that are not in the middle of an
139 SQL statement are interpreted as comments.
140 <li> Added the --append option to the ".backup" command.
141 <li> Added the ".dbconfig" command.
142 <p><b>Performance:</b>
143 <li> <a href="../lang_update.html">UPDATE</a> avoids unnecessary low-level disk writes when the contents
144 of the database file do not actually change.
145 For example, "UPDATE t1 SET x=25 WHERE y=?" generates no extra
146 disk I/O if the value in column x is already 25. Similarly,
147 when doing <a href="../lang_update.html">UPDATE</a> on records that span multiple pages, only
148 the subset of pages that actually change are written to disk.
149 This is a low-level performance optimization only and does not
150 affect the behavior of TRIGGERs or other higher level SQL
151 structures.
152 <li> Queries that use ORDER BY and LIMIT now try to avoid computing
153 rows that cannot possibly come in under the LIMIT. This can greatly
154 improve performance of ORDER BY LIMIT queries, especially when the
155 LIMIT is small relative to the number of unrestricted output rows.
156 <li> The <a href="../optoverview.html#or_opt">OR optimization</a> is allowed to proceed
157 even if the OR expression has also been converted into an IN
158 expression. Uses of the OR optimization are now also
159 <a href="../eqp.html#or-opt">more clearly shown</a> in the <a href="../eqp.html">EXPLAIN QUERY PLAN</a> output.
160 <li> The query planner is more aggressive about using
161 <a href="../optoverview.html#autoindex">automatic indexes</a> for views and subqueries for which it is
162 not possible to create a persistent index.
163 <li> Make use of the one-pass UPDATE and DELETE query plans in the
164 <a href="../rtree.html">R-Tree extension</a> where appropriate.
165 <li> Performance improvements in the LEMON-generated parser.
166 <p><b>Bug fixes:</b>
167 <li> For the right-hand table of a LEFT JOIN, compute the values
168 of expressions directly rather than loading precomputed values
169 out of an <a href="../expridx.html">expression index</a> as the expression index might
170 not contain the correct value. Ticket
171 <a href="https://sqlite.org/src/info/7fa8049685b50b5aeb0c2">7fa8049685b50b5aeb0c2</a>
172 <li> Do not attempt to use terms from the WHERE clause to enable
173 indexed lookup of the right-hand table of a LEFT JOIN. Ticket
174 <a href="https://sqlite.org/src/info/4ba5abf65c5b0f9a96a7a">4ba5abf65c5b0f9a96a7a</a>
175 <li> Fix a memory leak that can occur following a failure to open error
176 in the <a href="../csv.html">CSV virtual table</a>
177 <li> Fix a long-standing problem wherein a corrupt schema on the
178 <a href="../fileformat2.html#seqtab">sqlite_sequence</a> table used by <a href="../autoinc.html">AUTOINCREMENT</a> can lead to
179 a crash. Ticket
180 <a href="https://sqlite.org/src/info/d8dc2b3a58cd5dc29">d8dc2b3a58cd5dc2918a1</a>
181 <li> Fix the <a href="../json1.html#jeach">json_each()</a> function so that it returns
182 valid results on its "fullkey" column when the input is a simple value
183 rather than an array or object.
184 <p><b>Hashes:</b>
185 <li>SQLITE_SOURCE_ID: "2018-06-04 19:24:41 c7ee0833225bfd8c5ec2f9bf62b97c4e04d03bd9566366d5221ac8fb199a87ca"
186 <li>SHA3-256 for sqlite3.c: 0d384704e1c66026228336d1e91771d295bf688c9c44c7a44f25a4c16c26ab3c
187
188 </ol></p>
189
190 <p>A <a href="../changes.html">complete list of SQLite releases</a>
191 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
192 A detailed history of every
193 check-in is available at
194 <a href="https://sqlite.org/src/timeline">
195 SQLite version control site</a>.</p>
196
197