Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add the "X in (?)" optimization to the change log. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
487c29773107890d38e25955f294b113 |
| User & Date: | drh 2014-05-27 15:31:33 |
Context
|
2014-05-28
| ||
| 11:14 | Fix the description of the notindexed problem in the change log. check-in: 8803444b62 user: drh tags: trunk | |
|
2014-05-27
| ||
| 15:31 | Add the "X in (?)" optimization to the change log. check-in: 487c297731 user: drh tags: trunk | |
| 10:31 | Fix documentation typos reported on the mailing list. check-in: 84efe9e646 user: drh tags: trunk | |
Changes
Changes to pages/changes.in.
28 28 <li>Added the [sqlite3_rtree_query_callback()] interface to [R-Tree extension] 29 29 <li>Added the [SQLITE_IOCAP_IMMUTABLE] bit to the set of bits that can be returned by 30 30 the xDeviceCharacteristics method of a [VFS]. 31 31 <li>Added new [URI query parameters] "nolock" and "immutable". 32 32 <li>Use less memory by not remembering CHECK constraints on read-only 33 33 database connections. 34 34 <li>Enable the [or-connected-terms | OR optimization] for [WITHOUT ROWID] tables. 35 +<li>Render expressions of the form "x IN (?)" (with a single value in 36 + the list on the right-hand side of the IN operator) as if they where "x==?", 37 + Similarly optimize "x NOT IN (?)" 35 38 <p><b>Bug Fixes:</b> 36 39 <li>OFFSET clause ignored on queries without a FROM clause. 37 40 Ticket [http://www.sqlite.org/src/info/07d6a0453d | 07d6a0453d] 38 41 <li>Assertion fault on queries involving expressions of the form 39 42 "x IN (?)". Ticket [http://www.sqlite.org/src/info/e39d032577|e39d032577]. 40 43 <li>Incorrect column datatype reported. 41 44 Ticket [http://www.sqlite.org/src/info/a8a0d2996a | a8a0d2996a]