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

35 check-ins using file src/select.c version 9b759521

2012-12-14
15:36
Fix the virtual table IN optimizer so that it work even if the virtual table implementation leaves the sqlite3_index_info.aConstraintUsage[].omit flag clear for an equality constraint that it intends to use. check-in: d6e045f8 user: drh tags: vtab-IN-opt
2012-10-29
14:27
Make the multiplexor and the IntArray extensions callable from C++. check-in: cbd8fddf user: drh tags: trunk
2012-10-28
19:35
Merge VSIX tooling and packaging enhancements to trunk. check-in: 99f27d64 user: mistachkin tags: trunk
2012-10-26
19:22
Fix a 32-bit integer overflow problem that could cause an error in a CREATE INDEX statement that writes more than 16GB of data. check-in: e24ba5be user: dan tags: trunk
18:40
Make sure the automatic index optimization is checked even if the covering index scan optimization was previously selected. check-in: ac1d5d8a user: drh tags: trunk
13:46
Add QNX-specific performance tweaks to the unix VFS. (Cherry-pick merge of [b02849e7bde458].) check-in: 63a7dd75 user: drh tags: trunk
00:55
Make sure all virtual table cursors have been closed on a prepared statement prior to unlinking the perpared statement from its database connection. The test case for this is in TH3, in the main39.test module. check-in: 6d42d806 user: drh tags: trunk
00:11
Make sure all virtual table cursors have been closed on a prepared statement prior to unlinking the perpared statement from its database connection. Closed-Leaf check-in: f7c5abe8 user: drh tags: deferred-close-order
2012-10-25
23:47
Further work on getting ssdsim to run. This is an incremental checkin to save my place while jumping off to work on other things. Leaf check-in: ae2f1627 user: drh tags: ssdsim
19:25
Fix a bug in fts3 causing it to return SQLITE_NOMEM when NEAR, OR and some auxiliary functions were used together. Also a segfault in vtab.c that could follow an OOM condition. check-in: 33f4f981 user: dan tags: trunk
15:43
Fix typo in usage text for the command-line shell. Also, in the same usage text, make the file name argument to -init uppercase for consistency. check-in: a6d906cf user: mistachkin tags: trunk
15:32
Merge the command-line shell enhancements from trunk. Other edits toward trying to get ssdsim to run. check-in: 848f87e2 user: drh tags: ssdsim
15:23
Improvements to the command-line argument parsing in the command-line shell. Command-line options can now occur either before or after the database name and first command and are still accepted and processed. Command-line options are processed even if no database name is given (and :memory: is assumed). check-in: 317c80cb user: drh tags: trunk
03:07
Implementation of the INSTR() SQL function, as found in SQL Server, MySQL, and Oracle. Closed-Leaf check-in: 49ccae96 user: drh tags: instr
01:50
Initial check-in of a test VFS designed to simulate a NAND-flash SSD for the purpose of measuring and subsequently minimizing write amplification caused by SQLite. The code in this check-in compiles but does not run. check-in: 9e6efcf0 user: drh tags: ssdsim
2012-10-24
00:47
Translate the Debug/Release project configurations to the Debug/Retail VSIX package configurations. Closed-Leaf check-in: 5023a7ad user: mistachkin tags: vsixFlavor
2012-10-20
09:35
Modify clean target to handle all VSIX package flavors. check-in: 023217ea user: mistachkin tags: vsixFlavor
08:40
Modify VSIX build tools in support of an additional package flavor. check-in: 702ebc64 user: mistachkin tags: vsixFlavor
2012-10-19
02:10
Make sure substructure elements have proper alignment in the ICU tokenizers of FTS2 and FTS3. check-in: aaa2d9b0 user: drh tags: trunk
00:23
Add detailed comments to the build tools used to generate the VSIX package. Also, allow the build configurations and native library directories to be overridden for the multi-platform build tool for MSVC. check-in: 0482c73b user: mistachkin tags: trunk
2012-10-18
20:49
Put auxiliary libraries after libsqlite3.a in the testfixture target of the "main.mk" makefile. check-in: 8fc8548f user: drh tags: trunk
15:01
Merge Watcom compiler warning fixes into trunk. check-in: 5be96788 user: drh tags: trunk
10:35
More warning fixes. Closed-Leaf check-in: 51a6a797 user: mistachkin tags: warnings
09:39
Fix harmless compiler warnings. check-in: 018e09c7 user: mistachkin tags: warnings
2012-10-17
20:28
Add a comment to fts3_snippet.c. check-in: b5f5ba31 user: dan tags: trunk
20:15
Initialize variables used as outputs of custom tokenizer method calls in fts4. check-in: 514505a8 user: dan tags: trunk
16:20
Add a test for the problem fixed by [bf44d73d3e]. check-in: db9b1fa5 user: dan tags: trunk
15:28
Change the way the tcl crash-test code works to avoid triggering an assert() in os_unix.c. check-in: b8b7b8f9 user: dan tags: trunk
13:15
Remove an incorrect "#ifndef SQLITE_OMIT_AUTOVACUUM" from pager. check-in: bf44d73d user: drh tags: trunk
2012-10-16
23:17
Enable optimization of IN operators on constraints to virtual tables. check-in: aa650746 user: drh tags: vtab-IN-opt
23:08
Merge updates from trunk. check-in: f021559d user: mistachkin tags: configReadOnly
21:08
An optimization that converts "a IN (b)" into "a==b". Seems to work, but needs additional test cases. Leaf check-in: 8b4c3c5e user: drh tags: degenerate_IN
2012-10-15
20:28
Correct comments and enhance readability of the mkvsix tool. check-in: 2c3af657 user: mistachkin tags: trunk
18:02
Hold the mutex on the shared-cache for the duration of a VACUUM operation. check-in: 629a42d4 user: dan tags: trunk
16:24
Dequote column names generated by the query flattener. check-in: 5526e0aa user: drh tags: trunk