/ 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.

22 check-ins using file src/select.c version 16d1f351

2018-04-10
00:30
Update the top-level README.md file to point to the whynotget.html document. check-in: 7dfd4543 user: drh tags: upsert
2018-04-09
15:57
Enhance the query planner so that it detects when the xBestIndex method of a virtual table gives out-of-sequence argvIndex values and reports an error. Secondary fix for ticket [2b8aed9f7c9e6]. check-in: 9506ec14 user: drh tags: trunk
14:26
Fix the fts5 xBestIndex method so that it is not confused by "IS", "!=", "REGEXP", "GLOB" or "LIKE" operators. Fix for ticket [2b8aed9f]. check-in: a0ca4ddb user: dan tags: trunk
13:58
Improvements to ".wheretrace" output. check-in: ea2e5b34 user: drh tags: trunk
11:43
Add a "flags" parameter to experimental API sqlite3changeset_apply_v2(). Also add the SQLITE_CHANGESETAPPLY_NOSAVEPOINT flag. check-in: 3d29631f user: dan tags: trunk
00:46
Fix a (harmless) signed integer overflow warning. check-in: 43c2c60c user: drh tags: trunk
2018-04-07
15:04
More complete parsing of UPSERT, including UPSERT within a trigger. The sqlite3Insert() logic to actually perform the UPSERT is not yet implemented, however. check-in: 5cc2a5a3 user: drh tags: upsert
2018-04-06
19:36
Demonstration of how the parser can be augmented to recognize a PostgreSQL-style UPSERT. This check-in implements parsing only. check-in: 9b22905b user: drh tags: upsert
19:12
Enhance LEMON to show precendence of symbols and all rules in the report that is generated in parallel to the parser. check-in: 602fbd81 user: drh tags: trunk
16:22
Fix a problem in the sessions module causing sqlite3session_apply_strm() to allocate enough memory for the entire input buffer - which defeats the point of a streaming interface. check-in: 7594e609 user: dan tags: trunk
2018-04-05
16:26
Fix an instance where an uninitialized VM register might be accessed. Fix for [093420fc0]. This problem was found by OSSFuzz. check-in: a3b02db7 user: dan tags: trunk
12:02
Fix the sqlite3WhereTrace mechanism so that it compiles with the --disable-amalgamation and the --enable-debug options to ./configure using clang. check-in: 81322436 user: drh tags: trunk
2018-04-04
12:21
Fix segfault in 'eval.c' extension when used with 'empty_result_callbacks'. check-in: e8b87bd4 user: mistachkin tags: trunk
2018-04-03
20:44
Fix an error message in speedtest1.c and make the "trigger" testset sensitive to the --size parameter. check-in: 5a6fd9e0 user: drh tags: trunk
20:00
Update speedtest1.c with new testset "trigger" based on the tests in speed4p.test. check-in: 7b7fa5fa user: dan tags: trunk
17:05
Fix a few small test script issues affecting SQLITE_TEMP_STORE=3 builds. check-in: e171f372 user: dan tags: trunk
14:25
Fix the generate_series virtual table so that it correctly returns no rows if any of its constraints are NULL. Ticket [fac496b61722daf28]. check-in: 3328e828 user: drh tags: trunk
14:04
Change the LEFT JOIN strength reduction optimization so that assumes that virtual table constraints can be true even if terms within the constraint are NULL. This works around dodgy virtual table implementations. Fix for ticket [fac496b61722daf2]. check-in: cbb977fe user: drh tags: trunk
2018-04-02
11:04
Version 3.23.0 check-in: 736b53f5 user: drh tags: trunk, release, version-3.23.0
00:16
Better solution to the LIKE problem from the previous check-in that works even if the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option is used. check-in: b850dd15 user: drh tags: trunk
2018-03-31
23:28
Fix a logic error discovered by OSSFuzz that can cause an assert() fault if a LIKE operator is used on an INTEGER PRIMARY KEY. check-in: fc06ddd4 user: drh tags: trunk
16:31
Fix an assertion failure triggered by a SELECT with a compound sub-query that contains an incorrectly placed ORDER BY clause. This problem is just an assert() failure - non-DEBUG builds are not affected. Problem found by OSSFuzz. check-in: 823779d3 user: dan tags: trunk