Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
39 check-ins using file src/select.c version ea6f3b0c
2016-02-05
| ||
04:55 | Improve ERRORLEVEL handling in the MSVC batch build tool sub-routine 'fn_UnsetVariable'. (check-in: fe123ab4 user: mistachkin tags: trunk) | |
04:39 | Another small tweak to the MSVC batch build tool. (check-in: 76718bbc user: mistachkin tags: trunk) | |
2016-02-04
| ||
19:50 | Temporarily back out the 0.5% performance improvement from check-in [632071bac5ff32]. Need a more elaborate solution that works with reentrant virtual tables and SQL functions. (check-in: 42736fb0 user: drh tags: trunk) | |
19:45 | Further improve performance of unindexed fts5 prefix queries. (check-in: c9c6457d user: dan tags: trunk) | |
17:31 | Avoid running some particularly time-consuming tests as part of veryquick.test. (check-in: f465944b user: dan tags: trunk) | |
11:48 | Remove unnecessary sets of db->mallocFailed. (check-in: b787165b user: drh tags: trunk) | |
11:15 | Use sqlite3_malloc64() instead of sqlite3_malloc() in the spellfix extension. (check-in: 634d008c user: drh tags: trunk) | |
10:28 | Escape control characters in JSON. Fix for ticket [ad2559db380abf8]. (check-in: 4f1b5229 user: drh tags: trunk) | |
09:48 | Refinements to synchronous logic: (1) Use PAGER_SYNCHRONOUS_FULL rather than the corresponding magic number. (2) Honor SQLITE_NO_SYNC on xDelete calls with sync (3) Count xDelete syncs during testing (4) Fix #ifs on SQLITE_EXTRA_DURABLE so that directory syncs on journal unlink are off by default. (check-in: e3157cb5 user: drh tags: trunk) | |
2016-02-03
| ||
22:14 | In the VDBE loop, only check for OOM errors at jumps rather than after every opcode, for about a 0.5% performance increase. (check-in: 632071ba user: drh tags: trunk) | |
20:04 | Improve performance of fts5 prefix queries on detail=col tables. (check-in: ca11f46d user: dan tags: trunk) | |
19:52 | Fix markup errors in comments used to generate the documentation - specifically in the documentation on the OP_Seek opcode. (check-in: ef252bc4 user: drh tags: trunk) | |
19:20 | Add "PRAGMA synchronous=EXTRA" which syncs the directory containing the rollback journal when the rollback journal is deleted in order to commit a transaction in DELETE mode. (check-in: af924018 user: drh tags: trunk) | |
01:55 | Enhance the internal sqlite3VdbeAddOpList() interface to automatically update jump destinations. Use this feature to simplify the AUTOINCREMENT code generator. (check-in: ae8b9d2e user: drh tags: trunk) | |
2016-02-02
| ||
21:19 | Add tests to restore full coverage of fts5 code. (check-in: 063755c8 user: dan tags: trunk) | |
17:40 | Enhance the performance of fts5 AND and OR queries. (check-in: 62ea9e5a user: dan tags: trunk) | |
02:53 | Merge recent enhancements from trunk. (check-in: 347f6a80 user: drh tags: begin-concurrent) | |
02:30 | Merge recent enhancements from trunk. (check-in: e6a4a163 user: drh tags: apple-osx) | |
02:22 | Merge all recent enhancements from trunk. (check-in: f3f92001 user: drh tags: sessions) | |
02:04 | Enhance the comment on the sqlite3_index_constraint object to bring attention to the fact than iColumn field can be negative for a rowid. (check-in: d8b7b199 user: drh tags: trunk) | |
00:59 | Add the SQLITE_DBCONFIG_REQUIRE_WRITE_TXN connection setting, which if enabled requires all write operations to be enclosed within BEGIN ... COMMIT. (Leaf check-in: 7453790c user: drh tags: require-write-txn) | |
2016-02-01
| ||
21:48 | Change the OP_SetCookie instruction to write the literal P3 value, not the value in register P3. (check-in: 6d7d4703 user: drh tags: trunk) | |
20:12 | Improve performance of fts5 queries. (check-in: 2334e882 user: dan tags: trunk) | |
17:20 | Number VDBE opcodes starting with 0 instead of 1, as this obviates the lower-bound test on "switch(opcode){...}", making the code smaller and faster. (check-in: 4c9222f7 user: drh tags: trunk) | |
16:36 | Update walcrash.test to ensure that, during a particular test, enough data is written to cause SQLite to sync the wal file 14 times. (check-in: 5d7c0928 user: dan tags: trunk) | |
13:58 | Fix a problem causing the OR/covering-index optimization to be disabled if compile time parameter SQLITE_MAX_ATTACHED were set to greater than 30. (check-in: a17712bf user: dan tags: trunk) | |
13:21 | Minor simplification to the OP_AutoCommit opcode. Fix some code comments related to transaction control. (check-in: a9b6a067 user: drh tags: trunk) | |
00:21 | Fix an assert() that might fail on a corrupt database. (check-in: 22eaced7 user: drh tags: trunk) | |
2016-01-30
| ||
21:09 | Fix new test cases in stat.test so that they work with -DSQLITE_DEFAULT_AUTOVACUUM=1 builds. (check-in: a2810cf6 user: dan tags: trunk) | |
19:16 | Performance enhancement for fts5 column filter queries on detail=full tables. (check-in: 13fb4aa6 user: dan tags: trunk) | |
16:59 | Merge the implementation of OP_IdxRowid and OP_Seek so that OP_Seek no longer requires the rowid register and a separate OP_IdxRowid call. Shorter and faster prepared statements result. (check-in: 9bec50a1 user: drh tags: trunk) | |
15:52 | Only honor the register subtype value if the MEM_Subtype flag is set. Revised and improved fix for ticket [f45ac567eaa9f9]. (check-in: 1f4c667f user: drh tags: trunk) | |
15:46 | A different way to clear the subtype on VDBE registers when the value of the register is overwritten with new content. To fix [[f45ac567eaa9f93]. (Closed-Leaf check-in: 2e9fb129 user: dan tags: clear-subtype-flag) | |
14:53 | Take care to clear the subtype on VDBE registers when the value of the register is overwritten with new content. (Closed-Leaf check-in: ec653cbc user: drh tags: clear-subtype-fail) | |
14:17 | Output subtype information on register traces for PRAGMA vdbe_trace. (check-in: 96b78020 user: drh tags: trunk) | |
13:32 | Add the BTREE_FORDELETE and BTREE_AUXDELETE flags to the b-tree layer interface and use them. Add assert() statement to verify that they are correct. (check-in: 85c46704 user: drh tags: trunk) | |
12:50 | Simplification and size reduction to the printf logic. Remove the bFlags parameter from sqlite3VXPrintf() and sqlite3XPrintf(). Use sqlite3XPrintf() instead of sqlite3_snprintf() for rendering P4 values in EXPLAIN output. (check-in: 0bdb41c4 user: drh tags: trunk) | |
02:10 | Make use of covering indexes in the OR optimization. (check-in: 9de3d712 user: drh tags: trunk) | |
00:45 | Change the P4_INTARRAY so that always begins with a length integer. Print the content of the INTARRAY on EXPLAIN output. (Closed-Leaf check-in: 6c520d57 user: drh tags: covering-or) | |