Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Changes In Branch new-dbconfig-options Excluding Merge-Ins
This is equivalent to a diff from 9f887f15e5 to 09cea3924b
2019-06-17
| ||
14:14 | Add notes about the new sqlite3_db_config() interfaces. Enhanced discussion of the double-quoted string literal misfeature. (check-in: ab87f9f72b user: drh tags: trunk) | |
13:56 | Track the revised DQS interface. (Closed-Leaf check-in: 09cea3924b user: drh tags: new-dbconfig-options) | |
2019-06-15
| ||
15:24 | Documentation on the new SQLITE_DBCONFIG options. (check-in: 4ebc1051c2 user: drh tags: new-dbconfig-options) | |
2019-06-12
| ||
20:31 | Fix the description of how collation is computed to indicate that the collation is not blocked by a CAST operator. Fix for ticket https://www.sqlite.org/src/info/b148fa61059fb6c2. (check-in: 9f887f15e5 user: drh tags: trunk) | |
10:55 | Enhancements to the change log. (check-in: 06b9f7898d user: drh tags: trunk) | |
Changes to pages/changes.in.
︙ | |||
18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 | 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 | + + + + + + + + | global nChng aChng xrefChng set aChng($nChng) [list $date $desc $options] set xrefChng($date) $nChng incr nChng } chng {2019-07-00 (3.29.0)} { <li> The [double-quoted string literal] misfeature is deactivated by default for DDL statements. It can be reactivated if needed, to support legacy applications, using the [SQLITE_DBCONFIG_DQS_DDL] action of the [sqlite3_db_config()] interface. <li> Added the [SQLITE_DBCONFIG_DQS_DML] action to [sqlite3_db_config()] that will disable the [double-quoted string literal] misfeature for DML statements. <li> Improved optimization of AND and OR operators when one or the other operand is a constant. <li> Added the "[https://sqlite.org/src/file/ext/misc/dbdata.c|sqlite_dbdata]" virtual table for extracting raw low-level content from an SQLite database, even a database that is corrupt. <li> Enhancements to the [CLI]: <ol type="a"> <li> Add the ".recover" command which tries to recover as much content as possible from a corrupt database file. <li> Add the ".filectrl" command useful for testing. <li> Add the long-standing ".testctrl" command to the ".help" menu. <li> Added the ".dbconfig" command </ol> } chng {2019-04-16 (3.28.0)} { <li> Enhanced [window functions]: <ol type="a"> <li> Add support the [EXCLUDE clause]. |
︙ |
Changes to pages/lang.in.
︙ | |||
119 120 121 122 123 124 125 | 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 | - + + - + + + | RecursiveBubbleDiagram alter-table-stmt </tcl> <p>SQLite supports a limited subset of ALTER TABLE. The ALTER TABLE command in SQLite allows the user to rename a table, to rename a column within a table, or to add a new column to an existing table. |
︙ |
Changes to pages/pragma.in.
︙ | |||
816 817 818 819 820 821 822 823 824 825 826 827 828 829 | 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 | + + + | contain code that expect the incomplete behavior of [ALTER TABLE RENAME] found in older versions of SQLite. New applications should leave this flag turned off. <p>For compatibility with older [virtual table] implementations, this flag is turned on temporarily while the [sqlite3_module.xRename] method is being run. The value of this flag is restore after the [sqlite3_module.xRename] method finishes. <p>The legacy alter table behavior can also be toggled on and off using the [SQLITE_DBCONFIG_LEGACY_ALTER_TABLE] option to the [sqlite3_db_config()] interface. } Pragma legacy_file_format { <p>^(<b>PRAGMA legacy_file_format; <br>PRAGMA legacy_file_format = <i>boolean</i></b></p> <p>This pragma sets or queries the value of the legacy_file_format flag.)^ ^(When this flag is on, new SQLite databases are created in |
︙ |
Changes to pages/quirks.in.
︙ | |||
232 233 234 235 236 237 238 | 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 | - - + + - - - + + + + - + - - + + + + - + - + + - + + + + + + + + + + + + + + + + + + | [http://site.icu-project.org/|International Components for Unicode] library. <tcl>hd_fragment dblquote {double-quoted string literal}</tcl> <h1>Double-quoted String Literals Are Accepted</h1> <p> |
︙ |