Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update the change log. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
f7f4ae78ccad5dca2d0ec957c9172228 |
| User & Date: | drh 2016-04-04 17:45:49 |
Context
|
2016-04-08
| ||
| 20:15 | Merge changes from the 3.12.0 branch. Improvements to change-log rendering. check-in: 3d991d2d4e user: drh tags: trunk | |
|
2016-04-04
| ||
| 17:45 | Update the change log. check-in: f7f4ae78cc user: drh tags: trunk | |
| 12:24 | Merge typo fixes from the 3.12.0 branch. check-in: 8370e949b7 user: drh tags: trunk | |
Changes
Changes to pages/changes.in.
17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
proc chng {date desc {options {}}} {
global nChng aChng
set aChng($nChng) [list $date $desc $options]
incr nChng
}
chng {2016-05-00 (3.13.0)} {
<li>Added the [session] extension to trunk
}
chng {2016-04-01 (3.9.3)} {
<li>Backport a
[https://www.sqlite.org/src/info/c648539b52ca28c0|simple query planner optimization]
that allows the IS operator
to drive an index on a LEFT OUTER JOIN. No other changes from the
|
| > > > > > > > |
17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 |
proc chng {date desc {options {}}} {
global nChng aChng
set aChng($nChng) [list $date $desc $options]
incr nChng
}
chng {2016-05-00 (3.13.0)} {
<li>Added the [session] extension to trunk.
<li>Added the ".auth ON|OFF" command to the [command-line shell].
<li>Improved unicode filename handling in the [command-line shell] on Windows.
<li>Enhanced the query planner so that the [IS operator] is able to drive
indexes in a LEFT OUTER JOIN.
<li>Improved resistance against goofy query planner decisions caused by
incomplete or incorrect modifications to the [sqlite_stat1]
table by the application.
}
chng {2016-04-01 (3.9.3)} {
<li>Backport a
[https://www.sqlite.org/src/info/c648539b52ca28c0|simple query planner optimization]
that allows the IS operator
to drive an index on a LEFT OUTER JOIN. No other changes from the
|
Changes to pages/cli.in.
137
138
139
140
141
142
143
144
145
146
147
148
149
150
...
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
|
<p>
For a listing of the available dot commands, you can enter ".help"
at any time. For example:
</p>
<tcl>DisplayCode {
sqlite> (((.help)))
.backup ?DB? FILE Backup DB (default "main") to FILE
.bail on|off Stop after hitting an error. Default OFF
.binary on|off Turn binary output on or off. Default OFF
.changes on|off Show number of rows changed by SQL
.clone NEWDB Clone data into NEWDB from the existing database
.databases List names and files of attached databases
.dbinfo ?DB? Show status information about the database
................................................................................
.save FILE Write in-memory database into FILE
.scanstats on|off Turn sqlite3_stmt_scanstatus() metrics on or off
.schema ?TABLE? Show the CREATE statements
If TABLE specified, only show tables matching
LIKE pattern TABLE.
.separator COL ?ROW? Change the column separator and optionally the row
separator for both the output mode and .import
.shell CMD ARGS... Run CMD ARGS... in a system shell
.show Show the current values for various settings
.stats on|off Turn stats on or off
.system CMD ARGS... Run CMD ARGS... in a system shell
.tables ?TABLE? List names of tables
If TABLE specified, only list tables matching
LIKE pattern TABLE.
.timeout MS Try opening locked tables for MS milliseconds
.timer on|off Turn SQL timer on or off
.trace FILE|off Output each SQL statement as it is run
|
>
>
|
|
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
...
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
|
<p>
For a listing of the available dot commands, you can enter ".help"
at any time. For example:
</p>
<tcl>DisplayCode {
sqlite> (((.help)))
.auth ON|OFF Show authorizer callbacks
.backup ?DB? FILE Backup DB (default "main") to FILE
.bail on|off Stop after hitting an error. Default OFF
.binary on|off Turn binary output on or off. Default OFF
.changes on|off Show number of rows changed by SQL
.clone NEWDB Clone data into NEWDB from the existing database
.databases List names and files of attached databases
.dbinfo ?DB? Show status information about the database
................................................................................
.save FILE Write in-memory database into FILE
.scanstats on|off Turn sqlite3_stmt_scanstatus() metrics on or off
.schema ?TABLE? Show the CREATE statements
If TABLE specified, only show tables matching
LIKE pattern TABLE.
.separator COL ?ROW? Change the column separator and optionally the row
separator for both the output mode and .import
.session CMD ... Create or control sessions
.shell CMD ARGS... Run CMD ARGS... in a system shell
.show Show the current values for various settings
.stats ?on|off? Show stats or turn stats on or off
.system CMD ARGS... Run CMD ARGS... in a system shell
.tables ?TABLE? List names of tables
If TABLE specified, only list tables matching
LIKE pattern TABLE.
.timeout MS Try opening locked tables for MS milliseconds
.timer on|off Turn SQL timer on or off
.trace FILE|off Output each SQL statement as it is run
|