SQLite
Timeline
Not logged in

50 most recent timeline items

2015-08-27
18:24
[42f93f58] Leaf: Activate the ability to use expressions in indexes in a query. There are some test failures, but mostly this seems to work. (user: drh, tags: index-expr)
17:42
[fc17f731] Leaf: Fix a problem whereby concurrent transactions would not consider pages read by the transaction before the first write statement. (user: dan, tags: experimental-begin-unlocked)
16:07
[c80e9e8e] Merge changes from trunk. (user: drh, tags: index-expr)
15:58
[5611130a] Adjustments to the WHERE term scanning, to better handle scanning terms of an index. (user: drh, tags: index-expr)
2015-08-26
21:08
[cbc3c9a8] Leaf: Reduce the size of the WhereScan object by 24 bytes while also clarifying its operation. (user: drh, tags: trunk)
18:54
[69394dda] Fix an assert() in pager.c that could fail in a concurrent transaction. (user: dan, tags: experimental-begin-unlocked)
18:04
[ec6ddb3d] Merge enhancements from trunk. (user: drh, tags: index-expr)
18:02
[a0566382] Fix a problem allowing some conflicting transactions to be committed. (user: dan, tags: experimental-begin-unlocked)
14:01
[c2f3bbad] Evaluate expressions only once when the same expression is used in both the result set and in the ORDER BY clause. (user: drh, tags: trunk)
11:40
[58ba7363] Refactor With.a.zErr into With.a.zCteErr. No logic changes. (user: drh, tags: trunk)
11:34
[65a89187] Update the TreeView output for compound SELECT statements so that all entries are shown vertically aligned rather than each successive entry being indented. (user: drh, tags: trunk)
2015-08-25
19:42
[b3732a4e] Move sqlite3IndexColumnAffinity() inside of SQLITE_ENABLE_STAT3_OR_STAT4. (user: drh, tags: trunk)
19:24
[e8b02902] Merge trunk enhancements. (user: drh, tags: index-expr)
19:20
[1ee089a7] Use the sqlite3IndexColumnAffinity() routine to quickly and correctly find the affinity of an index column. (user: drh, tags: trunk)
19:10
[779b1d0e] Add miscellaneous test cases for concurrent transactions. (user: dan, tags: experimental-begin-unlocked)
17:16
[f32b57b4] If "PRAGMA integrity_check" is run while the database is being written by a CONCURRENT transaction, do not consider unreferenced pages to be an error. They may be part of the free-page list, which is not visible at the b-tree layer when running a CONCURRENT transaction. (user: dan, tags: experimental-begin-unlocked)
16:57
[efaabdb7] Add code to maintain indexes with expression arguments across DELETE, INSERT, and UPDATE statements. Legacy tests pass, but the new code paths are still largely untested. The query planner currently makes no effort to use expression indexes. (user: drh, tags: index-expr)
16:01
[c746e0bd] Test that if a corrupt wal-index header is encountered when attempting to commit a concurrent transaction, SQLITE_BUSY_SNAPSHOT is returned to the caller. (user: dan, tags: experimental-begin-unlocked)
14:37
[231b5880] Fix a segfault that could occur following an OOM condition in the concurrent transaction code. (user: dan, tags: experimental-begin-unlocked)
11:16
[3e7d6dd6] Merge latest trunk changes with this branch. (user: dan, tags: experimental-begin-unlocked)
00:34
[8f1d9f1f] Fix a memory leak that might occur when compiling with SQLITE_OMIT_CHECK. (user: drh, tags: trunk)
00:27 • Edit [0ad0f8d77d8f95ca|0ad0f8d7]: Edit check-in comment. (user: drh)
00:27
[0ad0f8d7] Changes toward being able to process indexes on expressions. Not there yet - this check-in is just movement in that direction. Some tests are failing. (user: drh, tags: index-expr)
2015-08-24
22:06
[47280f2a] Remove duplicated line of code. (user: mistachkin, tags: experimental-begin-unlocked)
20:54
[bdaf6646] Remove some redundant code: Call sqlite3ResolveExprListNames() rather than calling sqlite3ResolveExprNames() in a loop - in two places. (user: drh, tags: trunk)
20:21
[bed42116] Enhances the parser so that it accepts arbitrary expressions for the arguments of an index, though the code generator still rejects everything other than simple column names. The sqlite3RestrictColumnListSyntax() routine is removed since that feature is now handled by the parser. (user: drh, tags: trunk)
19:56
[ba1ab858] Change "BEGIN UNLOCKED" to "BEGIN CONCURRENT". (user: dan, tags: experimental-begin-unlocked)
19:08
[5b9f2721] Fix handling of attempts to modify the database schema, application_id or user_version within an UNLOCKED transaction. (user: dan, tags: experimental-begin-unlocked)
17:42
[d794b34d] Enhance the CREATE VIEW syntax so that the names of columns of the view can be specified after the view name. (user: drh, tags: trunk)
17:18
[a1ae20cd] Enhancements to the batch build tool for MSVC. (user: mistachkin, tags: trunk)
16:00
[04113557] Fix compilation without SQLITE_ENABLE_UNLOCKED. Also other code organization issues. (user: dan, tags: experimental-begin-unlocked)
15:39
[83cbc4d8] Disallow the use of COLLATE clauses and the ASC and DESC keywords within foreign key constraints and in the argument list to common table expressions. (user: drh, tags: trunk)
12:42
[196d66d3] Improvements to JSON string dequoting. (user: drh, tags: trunk)
10:05
[701302b4] Consolidate two blocks of similar code in btreeFixUnlocked(). (user: dan, tags: experimental-begin-unlocked)
06:44
[876810c2] Merge trunk changes with this branch. (user: dan, tags: experimental-begin-unlocked)
06:43
[4460764e] Fix another problem involving unlocked transactions and wal-file restarts. (user: dan, tags: experimental-begin-unlocked)
02:32
[f0aba0e1] Fix corner-case problems in the type and atom columns of json_each() and json_tree(). (user: drh, tags: trunk)
2015-08-23
20:48
[518d6220] Fix a comment typo on sqlite3ExprAlloc(). No code changes. (user: drh, tags: trunk)
20:44
[cc520414] Fix minor glitches in the json1.c extension, mostly having to do with OOM behavior. (user: drh, tags: trunk)
02:42
[fc1b24f3] Fixes to json_each() and json_tree(). Improved json_parse() debugging output. (user: drh, tags: trunk)
2015-08-22
20:32
[e3968b25] Fix a problem to do with detecting unlocked transaction conflicts if another client restarts the wal while the transaction is running. (user: dan, tags: experimental-begin-unlocked)
19:39
[380a9734] Add the json_valid() function to the json1.c extension. Fix various minor problems in the json1.c extension. (user: drh, tags: trunk)
17:28
[ed0a31be] Add further tests for deferred page allocation. And fixes for the same. (user: dan, tags: experimental-begin-unlocked)
07:56
[c2327a3b] Merge further trunk changes. (user: dan, tags: experimental-begin-unlocked)
07:55
[9021f736] Merge trunk changes into this branch. (user: dan, tags: experimental-begin-unlocked)
03:05
[213a6c5c] Fix a couple instances of OOM handling in the json extension. (user: drh, tags: trunk)
01:32 • Fixed ticket [c2a19d81]: Incorrect LEFT JOIN when FROM clause contains nested subqueries plus 5 other changes (user: drh)
01:32
[351bc22f] Do not apply the WHERE-clause pushdown optimization to terms that originate in the ON or USING clause of a LEFT JOIN. Fix for ticket [6df18e949d3676290]. (user: drh, tags: trunk)
2015-08-21
23:25 • New ticket [c2a19d81] Incorrect LEFT JOIN when FROM clause contains nested subqueries. (user: drh)
20:43
[178f9a35] Add extension functions for processing JSON. (user: drh, tags: trunk)