/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

20 check-ins using file src/select.c version da6d1e7a

2015-08-27
19:57
Add header comments for new methods in pager.c. check-in: 437c7e21 user: dan tags: begin-concurrent
19:22
Add test cases for concurrent transactions and long-lived SELECT statements. check-in: fd4798cb user: dan tags: begin-concurrent
17:42
Fix a problem whereby concurrent transactions would not consider pages read by the transaction before the first write statement. check-in: fc17f731 user: dan tags: begin-concurrent
2015-08-26
18:54
Fix an assert() in pager.c that could fail in a concurrent transaction. check-in: 69394dda user: dan tags: begin-concurrent
18:02
Fix a problem allowing some conflicting transactions to be committed. check-in: a0566382 user: dan tags: begin-concurrent
11:34
Update the TreeView output for compound SELECT statements so that all entries are shown vertically aligned rather than each successive entry being indented. check-in: 65a89187 user: drh tags: trunk
2015-08-25
19:42
Move sqlite3IndexColumnAffinity() inside of SQLITE_ENABLE_STAT3_OR_STAT4. check-in: b3732a4e user: drh tags: trunk
19:24
Merge trunk enhancements. check-in: e8b02902 user: drh tags: index-expr
19:20
Use the sqlite3IndexColumnAffinity() routine to quickly and correctly find the affinity of an index column. check-in: 1ee089a7 user: drh tags: trunk
19:10
Add miscellaneous test cases for concurrent transactions. check-in: 779b1d0e user: dan tags: begin-concurrent
17:16
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. check-in: f32b57b4 user: dan tags: begin-concurrent
16:57
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. check-in: efaabdb7 user: drh tags: index-expr
16:01
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. check-in: c746e0bd user: dan tags: begin-concurrent
14:37
Fix a segfault that could occur following an OOM condition in the concurrent transaction code. check-in: 231b5880 user: dan tags: begin-concurrent
11:16
Merge latest trunk changes with this branch. check-in: 3e7d6dd6 user: dan tags: begin-concurrent
00:34
Fix a memory leak that might occur when compiling with SQLITE_OMIT_CHECK. check-in: 8f1d9f1f user: drh tags: trunk
00:27
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. check-in: 0ad0f8d7 user: drh tags: index-expr
2015-08-24
20:54
Remove some redundant code: Call sqlite3ResolveExprListNames() rather than calling sqlite3ResolveExprNames() in a loop - in two places. check-in: bdaf6646 user: drh tags: trunk
20:21
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. check-in: bed42116 user: drh tags: trunk
17:42
Enhance the CREATE VIEW syntax so that the names of columns of the view can be specified after the view name. check-in: d794b34d user: drh tags: trunk