Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
299 check-ins using file test/pragma3.test version 3f1984a046
2017-03-31
| ||
08:00 | Update shell6.test to account for the fact that tests are now run in a separate directory. (check-in: 1e3622de8b user: dan tags: schemalint) | |
2016-10-17
| ||
23:44 | Fix SQLITE_DBCONFIG_REQUIRE_TXN so that it allows BEGIN IMMEDAITE and BEGIN EXCLUSIVE to run outside of a transaction. (Leaf check-in: 29997f797f user: drh tags: require-write-txn) | |
2016-04-29
| ||
11:28 | Lemon bug fix: Do not merge action routines unless their destructors are also identical. Problem and suggested fix reported on the mailing list by Kelvin Sherlock. (check-in: 4792d6dbba user: drh tags: trunk) | |
02:55 | Some optimization comments added to vdbe.c. No functional changes to code. (check-in: e7c22e3bff user: drh tags: trunk) | |
2016-04-28
| ||
22:29 | Further simplifications and improved commentting on the rowset.c module, including several optimization comments. (check-in: 9f15a520de user: drh tags: trunk) | |
20:11 | Comment changes only: Add several optimization marks in rowset.c. Add a header comment that explains what the various special comments mean. (check-in: 8cdbe89ac6 user: drh tags: trunk) | |
19:23 | Fix typo in comment. No changes to code. (check-in: 9f6f17b5c9 user: mistachkin tags: trunk) | |
18:53 | Rearrange some code in the RowSet logic for clarity of presentation, while adding an /*OPTIMIZATION-IF-TRUE*/ comment. It should operate identically. (check-in: 5748e64376 user: drh tags: trunk) | |
14:15 | Use comments to mark several branches as optimizations. No changes to code. (check-in: 33e6274727 user: drh tags: trunk) | |
03:52 | Remove an unnecessary conditional from the sqlite3DecOrHexToI64() routine. (check-in: fcf85bfe50 user: drh tags: trunk) | |
00:32 | Change the sqlite3Atoi64() routine so that it returns failure if not all of the input characters are consumed, even if it consumed all characters up to the first 0x00. This has no impact on external APIs as far as I can tell. (check-in: 46d4ffff3b user: drh tags: trunk) | |
2016-04-27
| ||
15:24 | More simplification of the sqlite3AtoF() routine. Add special comments to indicate branches that are for optimization purposes only and that give the correct answer even if always or never taken. (check-in: 0065fe97cb user: drh tags: trunk) | |
11:24 | Fix a couple of test script problems on this branch. Both related to the fact that temp database page sizes can no longer be changed by VACUUM or the backup API after the temp db is populated. (check-in: 6bb5aa2be2 user: dan tags: tempfiles-25) | |
02:35 | Remove still more unnecessary branches from sqlite3AtoF(). (check-in: 3adfe9f3e6 user: drh tags: trunk) | |
2016-04-26
| ||
23:14 | Further simplifications to sqlite3AtoF() to remove unneeded branches. (check-in: dd69e53cb0 user: drh tags: trunk) | |
21:02 | Remove an unnecessary line from the sqlite3AtoF() routine. (check-in: a9d007494c user: drh tags: trunk) | |
18:58 | The pcache and the built-in VFSes should not use mutexes when SQLITE_CONFIG_SINGLETHREAD is set. (check-in: 12418b1001 user: drh tags: trunk) | |
17:10 | Fix an issue in temptable2.test preventing it from working with SQLITE_DEFAULT_AUTOVACUUM=1 builds. (check-in: e790aac02e user: dan tags: tempfiles-25) | |
16:03 | Merge the checksymbols fix from trunk into this branch. (check-in: 04911cee0c user: dan tags: tempfiles-25) | |
13:13 | Fix the "checksymbols" target in Makefile.in to be able to deal with the sqlite3changegroup family of interfaces. (check-in: d819bfbd46 user: drh tags: trunk) | |
2016-04-25
| ||
22:39 | Add an sqlite3FaultSim() all to make it easier to simulate IO errors in a VACUUM commit. (check-in: 8bfde416c5 user: drh tags: tempfiles-25) | |
19:28 | Remove an obsolete comment from the pager. No code changes. (check-in: 36f97ca887 user: drh tags: tempfiles-25) | |
19:25 | Update the RBU vacuum code so that databases that use custom collation sequences can be vacuumed. (check-in: 7dd48c1079 user: dan tags: trunk) | |
19:20 | Fix some unreachable branches in the pager. (check-in: 3ae44770fd user: drh tags: tempfiles-25) | |
15:03 | Merge bug fix from trunk. (check-in: a905d5e08d user: drh tags: tempfiles-25) | |
02:20 | When checking for the WHERE-clause push-down optimization, verify that all terms of the compound inner SELECT are non-aggregate, not just the last term. Fix for ticket [f7f8c97e97597]. (check-in: ec215f94ac user: drh tags: trunk) | |
01:43 | Fix a typo in the Makefile. (check-in: d0a579b351 user: mistachkin tags: trunk) | |
2016-04-23
| ||
21:16 | Merge the temporary directory search algorithm fix from trunk. (check-in: 9b8fec60d8 user: drh tags: tempfiles-25) | |
20:59 | Fix the fix to the temporary directory search algorithm so that it continues to return "." as a fallback if that directory has the correct permissions. (check-in: b38fe522cf user: drh tags: trunk) | |
19:55 | Merge the latest trunk changes. (check-in: 84da122dd6 user: drh tags: tempfiles-25) | |
17:24 | Fix a problem with mixing temp-files and mmap-mode. (check-in: c80c5c62b2 user: dan tags: tempfiles-25) | |
14:55 | Fix some problems to do with temp-file databases and recovering from IO and SQLITE_FULL errors. (check-in: 3d61da4a76 user: dan tags: tempfiles-25) | |
2016-04-21
| ||
23:37 | Change the temporary directory search algorithm on unix so that directories with only -wx permission are allowed. And do not allow "." to be returned if it lacks -wx permission. (check-in: 67985761aa user: drh tags: trunk) | |
18:13 | Add the sqlite3rbu_vacuum() API, to create an RBU handle that can be used to rebuild a database in the same way as the VACUUM command. (check-in: bd4a6f8313 user: dan tags: trunk) | |
16:44 | If a call to sqlite3rbu_close() on an rbu handle opened by sqlite3rbu_vacuum() returns other than SQLITE_OK, delete the contents of the rbu_state table. This ensures that if an RBU vacuum operation either completes successfully or encounters an error, the next call to sqlite3rbu_vacuum() with the same parameters starts a new RBU vacuum operation. (Closed-Leaf check-in: 6e4ac704f5 user: dan tags: rbu-vacuum) | |
15:44 | Merge the latest changes from trunk. (Closed-Leaf check-in: 8183fa6829 user: drh tags: skip-ahead-distinct) | |
15:35 | Merge all recent enhancements from trunk. (check-in: a15c49aed0 user: drh tags: apple-osx) | |
15:26 | Fix a problem in rbu vacuum on tables with a large sqlite_master table. (check-in: 23eac52e98 user: dan tags: rbu-vacuum) | |
15:24 | Add a function prototype in order to fix a compiler warning. (check-in: 49aec9718d user: drh tags: tempfiles-25) | |
15:03 | Merge updates from trunk. (check-in: cc28106e5c user: drh tags: tempfiles-25) | |
02:27 | Add the SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION method for enabling sqlite3_load_extension() while leaving the load_extension() SQL function disabled. (check-in: c4f165c460 user: drh tags: trunk) | |
01:58 | Test cases for SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION. (Closed-Leaf check-in: debafa5efd user: drh tags: load-ext-security) | |
01:30 | Revert sqlite3_enable_load_extension() to its original long-standing behavior. Add SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION which will enable only the C-API and leave the SQL function disabled. (check-in: b2ae5bfa32 user: drh tags: load-ext-security) | |
2016-04-20
| ||
20:08 | Add a documentation comment for sqlite3rbu_vacuum() to sqlite3rbu.h. (check-in: da5c753dda user: dan tags: rbu-vacuum) | |
19:30 | When an error occurs while transitioning out of WAL mode, make sure the locking state is not left at EXCLUSIVE. (check-in: 3340f08651 user: drh tags: trunk) | |
18:31 | Fix a locking race condition in Windows 10 that can occur when two or more processes attempt to recover the same hot journal at the same time. (check-in: 38a4e9d928 user: drh tags: trunk) | |
17:47 | Add fault injection tests for rbu vacuum. Fix some problems revealed by the same. (check-in: f042fdd1ea user: dan tags: rbu-vacuum) | |
12:16 | Merge all recent enhancements from trunk. (check-in: 1f709fbf93 user: drh tags: begin-concurrent) | |
00:30 | API Change: Modify sqlite3_enable_load_extension() so that it only enables/disables the load_extension() SQL function, and leaves the C-APIs enabled at all times. In this way, applications can enable extension loading for the C interface without having to expose that capability to the SQL. (check-in: edb454e45a user: drh tags: load-ext-security) | |
2016-04-19
| ||
19:27 | Updates to ensure the values of PRAGMA settings like "page_size", "auto_vacuum", "user_version" and "application_id" are not lost when a database is RBU vacuumed. (check-in: 74ffea76b8 user: dan tags: rbu-vacuum) | |
17:11 | When an RBU vacuum is started on a db identified using a URI filename, pass the same URI parameters when creating the new version of the db. This ensures that RBU vacuum works with password protected databases. (check-in: ca021ba881 user: dan tags: rbu-vacuum) | |
16:20 | Detect attempts to use rbu vacuum on a wal mode database (not allowed). And attempts to write to a database in the middle of an rbu vacuum (which prevents the vacuum from resuming). (check-in: 00b2f4b09f user: dan tags: rbu-vacuum) | |
2016-04-18
| ||
21:00 | Another fix to rbu vacuum for a zipvfs case. (check-in: 29407d70e4 user: dan tags: rbu-vacuum) | |
18:18 | Fix some zipvfs related problems in RBU vacuum. (check-in: d76f4aaa4c user: dan tags: rbu-vacuum) | |
17:30 | Version 3.12.2 (Leaf check-in: 92dc59fd5a user: drh tags: release, branch-3.12.0, version-3.12.2) | |
16:18 | Correctly interpret negative "PRAGMA cache_size" values when determining the cache-size used for sorting large amounts of data (i.e. the functionality in vdbesort.c). (check-in: 39dd67afa5 user: drh tags: branch-3.12.0) | |
16:12 | Fix a problem in the code generator for joins on virtual tables where the outer loop of the join uses the IN operator. (check-in: a2cf496896 user: drh tags: branch-3.12.0) | |
16:06 | Fix the sqlite3BtreeDelete() routine so that it preserves the correct key even when the row being deleted is not on a leaf page. Fix for ticket [a306e56ff68b8fa56] (check-in: 368e86c760 user: drh tags: branch-3.12.0) | |
15:59 | Increase the version number to 3.12.2. (check-in: 9c37e9ce07 user: drh tags: branch-3.12.0) | |
15:54 | Remove quotes from identifiers used as datatype names in a CREATE TABLE statement. Fix for ticket [7d7525cb01b68] (check-in: ab9d279f40 user: drh tags: branch-3.12.0) | |
15:46 | Remove quotes from identifiers used as datatype names in a CREATE TABLE statement. Fix for ticket [7d7525cb01b68] (check-in: eba27d4d17 user: drh tags: trunk) | |
13:36 | Merge recent trunk changes. (check-in: d9768de502 user: drh tags: tempfiles-25) | |
13:30 | sqlite3PCachePerecentDirty() should return 0 if the pcache is empty. (check-in: 85f3d80eb7 user: drh tags: tempfiles-25) | |
13:09 | The last parameter to pread64() and pwrite64() should be off64_t, not off_t. (check-in: 3a7d72986f user: drh tags: trunk) | |
09:17 | Add the -vacuum switch to the "rbu" demonstration program. (check-in: 9a0078a538 user: dan tags: rbu-vacuum) | |
2016-04-16
| ||
19:02 | Changes so that rbu vacuum works with zipvfs databases. (check-in: bae7f875f4 user: dan tags: rbu-vacuum) | |
17:53 | Avoid creating any extra files ("<target>-vacuum") when running an RBU vacuum. Ensure that the OAL file created is "<target>-oal", not "<target>-vacuum-oal". (check-in: dc19aacc7e user: dan tags: rbu-vacuum) | |
15:03 | Fix a couple of assert() statements that were failing with OOM error tests. (check-in: 8eb3d7d836 user: dan tags: rbu-vacuum) | |
2016-04-15
| ||
22:03 | Add the SQLITE_SkipAhead optimization setting (check-in: 87703b7661 user: drh tags: skip-ahead-distinct) | |
20:46 | Add the experimental sqlite3rbu_vacuum() API function. For opening an RBU handle that rebuilds a database from scratch. (check-in: 0216b48f28 user: dan tags: rbu-vacuum) | |
16:27 | Skip-ahead is now just an optimization. If it gets confused, it falls back to an incremental scan with redundancy elimination. (check-in: 6fac0b9212 user: drh tags: skip-ahead-distinct) | |
16:17 | Skip-ahead does not always work. So we still have to check for redundancy. (check-in: db5a2364eb user: drh tags: skip-ahead-distinct) | |
15:54 | Fixes to the skip-ahead distinct logic. More issues remain. (check-in: 45a70b2bb8 user: drh tags: skip-ahead-distinct) | |
15:06 | Merge enhancements from trunk, especially the ".eqp full" enhancement to the command-line shell. (check-in: 491f0dbd63 user: drh tags: skip-ahead-distinct) | |
15:03 | CLI enhancement: Add the ".eqp full" option, that shows both the EXPLAIN QUERY PLAN and the EXPLAIN output for each command run. Also disable any ".wheretrace" and ".selecttrace" when showing EQP output. (check-in: 3e217d6265 user: drh tags: trunk) | |
14:13 | Several new test cases that cause failures. (check-in: 0379f2cff6 user: drh tags: skip-ahead-distinct) | |
13:24 | Fixed crash bugs. Still sometimes gets the wrong answers. (check-in: 2afcb2c752 user: drh tags: skip-ahead-distinct) | |
01:55 | Progress toward getting DISTINCT to use a seek to advance to the next distinct row, when driven by an appropriate index. (check-in: 9e14aa14cf user: drh tags: skip-ahead-distinct) | |
2016-04-14
| ||
19:29 | Work toward improving analysis and code generation for DISTINCT and aggregate queries. (Leaf check-in: 129083bd5e user: drh tags: better-distinct-agg) | |
17:29 | In the ICU extension toupper() and tolower() SQL functions, avoid calling u_strToUpper() or u_strToLower() a second time if the buffer passed to the first invocation turns out to be large enough. (check-in: d23e581351 user: dan tags: trunk) | |
16:40 | Add the SF_HasAgg constant (currently unused). Also enhance the comments on many other constant definitions to detail constraints on their values. (check-in: 7b7a69d098 user: drh tags: trunk) | |
15:44 | Correctly interpret negative "PRAGMA cache_size" values when determining the cache-size used for sorting large amounts of data (i.e. the functionality in vdbesort.c). (check-in: 79147dca87 user: dan tags: trunk) | |
15:38 | Add some missing testcase() macros to the pushDownWhereTerms() routine. (check-in: 67d7f79c5e user: drh tags: trunk) | |
13:35 | Rename WhereInfo.pResultSet to pDistinctSet to more accurately reflect what it represents. (check-in: 5317961411 user: drh tags: trunk) | |
13:16 | Since the return value of sqlite3OsClose() is always ignored, we might as well make it "void" instead of "int", and thereby save 50 bytes in the compiled binary. (check-in: 7ee570e7a9 user: drh tags: trunk) | |
13:06 | Additional ".selecttrace" debugging output when the query is transformed from a DISTINCT into a GROUP BY. (check-in: 5a46914510 user: drh tags: trunk) | |
2016-04-13
| ||
21:00 | Fix compiler warnings by removing surplus local variables in the schema pretty-printer logic of the command-line shell. (check-in: 55a62483b9 user: drh tags: trunk) | |
19:20 | Merge enhancements from trunk via tempfiles-lazy-open. (check-in: ae16310c4e user: drh tags: tempfiles-25) | |
16:52 | On commit, flush dirty temp-file pages only if the file is already open and 25% or more of the cache is dirty. (check-in: f6babf2920 user: dan tags: tempfiles-25) | |
16:02 | Merge enhancements from trunk. (Closed-Leaf check-in: e2edd34e79 user: drh tags: tempfiles-lazy-open) | |
15:52 | Fixes for harmless compiler warnings. (check-in: 68142dc541 user: drh tags: trunk) | |
15:33 | Add the --indent option to the .schema and .fullschema commands in the shell, to enable simple but effective pretty-printing. (check-in: 83cfe82cd6 user: drh tags: trunk) | |
2016-04-12
| ||
20:26 | A couple more compiler warning fixes. (Closed-Leaf check-in: 929fa4c31e user: mistachkin tags: warnings) | |
20:15 | Even more compiler warning fixes. (check-in: 7faec9ea33 user: mistachkin tags: warnings) | |
20:05 | More harmless compiler warning fixes. (check-in: ab69527c16 user: mistachkin tags: warnings) | |
19:30 | Compilation fix for a C99-ism in the 'fts3view' tool. (check-in: bedb88a4b9 user: mistachkin tags: trunk) | |
19:20 | Fix harmless compiler warnings in the 'session' module. (check-in: a18a6ce227 user: mistachkin tags: trunk) | |
19:09 | Once a temporary database file has been opened, flush all dirty pages to disk when comitting a transaction. (check-in: bbac71aa2a user: dan tags: tempfiles-lazy-open) | |
17:13 | Fix speedtest1 so that it automatically unlinks its test database prior to startup. (check-in: b65b69f6b6 user: drh tags: trunk) | |
16:59 | Add the --temp option to the speedtest1.c performance test program. (check-in: 8053a6e2bf user: drh tags: trunk) | |
16:23 | Improved localtime() support for WindowsCE (check-in: 662c32af02 user: drh tags: trunk) | |
16:11 | Add and adjust comments. (Closed-Leaf check-in: 541c6da238 user: mistachkin tags: winCeLocalTime) | |
16:10 | Merge enhancements from trunk. (check-in: 9682c0433c user: drh tags: tempfiles-lazy-open) | |
16:04 | Add the sqlite3_snapshot_cmp() interface (available only with SQLITE_ENABLE_SNAPSHOT). (check-in: 7e72896551 user: drh tags: trunk) | |
15:14 | Update the documentation for sqlite3_snapshot_cmp() to make the circumstances under which the comparison is valid clearer. Add tests for the same. (Closed-Leaf check-in: 8fc834741b user: dan tags: snapshot-cmp) | |
11:58 | Update the header comment on the memjournal.c file. No code changes. (check-in: 07f10deabb user: drh tags: trunk) | |
00:26 | Performance optimization the Vdbe allocator. (check-in: e2c4995bf1 user: drh tags: trunk) | |
00:16 | Avoid unnecessary calls to object destructors for a small performance gain. (check-in: aec94b6ee6 user: drh tags: trunk) | |
00:00 | Performance improvements in sqlite3WhereExprUsage(). (check-in: fdf752394b user: drh tags: trunk) | |
2016-04-11
| ||
22:45 | Further refinements. (check-in: b35bb928b2 user: mistachkin tags: winCeLocalTime) | |
22:24 | Merge updates from trunk. (check-in: b8094166b3 user: mistachkin tags: winCeLocalTime) | |
22:23 | Fix typo in the MSVC makefile. (check-in: 3189a7f185 user: mistachkin tags: trunk) | |
22:10 | Fix some compilation issues. (check-in: 016481b39f user: mistachkin tags: winCeLocalTime) | |
19:59 | Add the sqlite3_snapshot_cmp() API. (check-in: c698a21af7 user: dan tags: snapshot-cmp) | |
19:24 | Fix a typo in temptable2.test. (check-in: 04b1890fbc user: dan tags: tempfiles-lazy-open) | |
19:23 | Add tests for wal mode to temptable2.test. (check-in: c6d0d441a1 user: dan tags: tempfiles-lazy-open) | |
19:01 | Performance optimization to sqlite3Dequote() and its callers. (check-in: 9efe2265b1 user: drh tags: trunk) | |
18:50 | Merge latest trunk changes with this branch. (check-in: ffc62af1d5 user: dan tags: tempfiles-lazy-open) | |
18:49 | Add extra tests to temptable2.test. (check-in: 7dd9d4c15b user: dan tags: tempfiles-lazy-open) | |
18:25 | Performance optimization for the sqlite3ExprListDelete() routine. (check-in: 2764aeaa11 user: drh tags: trunk) | |
18:15 | Performance optimizations in the column cache of the code generator, and especially the sqlite3ExprCacheRemove() routine. (check-in: e35b345cf8 user: drh tags: trunk) | |
18:07 | Fixes for OOM and IO error handling with temp file databases. (check-in: 4eb06e843a user: dan tags: tempfiles-lazy-open) | |
16:43 | Simplification and performance improvements in sqlite3ExprDup() and its subroutines. More work is possible in this area. (check-in: 476cc28388 user: drh tags: trunk) | |
16:35 | Rename the OP_MX_JUMP macro to SQLITE_MX_JUMP_OPCODE to avoid confusing the opcode name generator. (check-in: e554a4c38b user: drh tags: trunk) | |
14:49 | Performance improvement in sqlite3ExprDelete(). (check-in: 60ad80e3af user: drh tags: trunk) | |
13:36 | Remove the VdbeOp.opflags field and its associated initialization overhead. Update mkopcodeh.tcl to reorder opcode numbers to help the resolveP2Values() routine run faster. (check-in: 099478fa75 user: drh tags: trunk) | |
09:39 | Update this branch with the latest changes from the trunk. (check-in: 982b753d0b user: dan tags: tempfiles-lazy-open) | |
01:43 | Back off of the parser optimization in the previous check-in, slightly, to preserve some backwards compatibility regarding some undocumented behavior in the '#AAA' style query parameter. (check-in: ef1966c246 user: drh tags: trunk) | |
01:26 | Small size reduction and performance improvement in the parser. (check-in: 16df71284b user: drh tags: trunk) | |
01:06 | Factor out the common operation of setting the Expr.x.pSelect field of an Expr object into a subroutine. (check-in: 6a5cceee48 user: drh tags: trunk) | |
2016-04-09
| ||
18:04 | Fix a problem in the code generator for joins on virtual tables where the outer loop of the join uses the IN operator. (check-in: 6c56b3a047 user: drh tags: trunk) | |
17:04 | Fix the sqlite3BtreeDelete() routine so that it preserves the correct key even when the row being deleted is not on a leaf page. Fix for ticket [a306e56ff68b8fa56] (check-in: ca2ef8a86c user: drh tags: trunk) | |
14:36 | Limit the number of digits shown in the "prereq" mask for ".wheretrace" debugging output. (check-in: 3686ed7413 user: drh tags: trunk) | |
2016-04-08
| ||
21:35 | Attempt to treat the arguments to a table-valued function as if they occur in the ON clause of a LEFT JOIN rather than in the WHERE clause. But this causes undesirable behavior with generate_series, as demonstrated by test cases. This is an incremental check-in pending further work. (Leaf check-in: 00ac73a01c user: drh tags: tabfunc-in-left-join) | |
19:44 | Update documentation for sqlite3_snapshot_open(). No code changes. (check-in: 1dfa5234d3 user: drh tags: trunk) | |
15:09 | Version 3.12.1 (check-in: fe7d3b75fe user: drh tags: release, branch-3.12.0, version-3.12.1) | |
2016-04-07
| ||
23:18 | Enhance the query planner so that IS and IS NULL operators are able to drive an index on a LEFT OUTER JOIN. (check-in: 84d2a09eab user: drh tags: branch-3.12.0) | |
21:29 | Update the version number to 3.12.1. This is the first release candidate. (check-in: 300f1b61a0 user: drh tags: branch-3.12.0) | |
21:29 | Carry table column types through into VIEW definitions, where possible. (check-in: 3360ab098a user: drh tags: branch-3.12.0) | |
21:22 | Prevent the in-memory journal read cursor from entering an inconsistent state when it reads the last few bytes out of the journal file. Fix for ticket [7f7f8026eda38]. (check-in: c232b99e65 user: drh tags: branch-3.12.0) | |
21:14 | Add test cases for ticket [7f7f8026eda387d544]. (check-in: 87aa9357fb user: drh tags: trunk) | |
18:42 | Prevent the in-memory journal read cursor from entering an inconsistent state when it reads the last few bytes out of the journal file. Fix for ticket [7f7f8026eda38]. (check-in: c4b9c611bd user: drh tags: trunk) | |
14:16 | Avoid decrementing a pointer off the front end of the buffer in OP_MakeRecord. (check-in: 153135bfb3 user: drh tags: trunk) | |
14:05 | Instead of just commenting out the unneeded code in the previous check-in, remove it completely. (check-in: 8415d4848a user: drh tags: trunk) | |
14:01 | Remove an unnecessary test for a NULL pointer in freeP4(). (check-in: e84e88e31b user: drh tags: trunk) | |
13:45 | Update comments on the unix file locking protocol. No changes to code. (check-in: 716b20de43 user: drh tags: trunk) | |
2016-04-06
| ||
18:20 | For a pager backed by a temp file, store the main journal in memory until it is at least sqlite3_config.nStmtSpill bytes in size. Prevent the backup API from being used to change the page-size of a temp file. (check-in: 84c557010c user: dan tags: tempfiles-lazy-open) | |
17:32 | Add a couple options to the MSVC makefile. (check-in: ea4de04d67 user: mistachkin tags: branch-3.12.0) | |
16:27 | Fix a problem in test script lock.test. Fix minor issues in pager.c. (check-in: 84de8813c3 user: dan tags: tempfiles-lazy-open) | |
15:39 | Add tests to this branch. Fix a problem with temporary databases in auto-vacuum mode. (check-in: afe9bd9b4b user: dan tags: tempfiles-lazy-open) | |
2016-04-05
| ||
23:39 | Remove an unnecessary branch in the sqlite3LogEstToInt() routine. (check-in: da81d7afeb user: drh tags: trunk) | |
21:07 | Defer opening the file used for the temp database (where CREATE TEMP TABLE tables are stored) until the database is too large to reside entirely within the cache. There are likely still problems on this branch. (check-in: be5a549eba user: dan tags: tempfiles-lazy-open) | |
20:59 | Carry table column types through into VIEW definitions, where possible. (check-in: fb555c3c2a user: drh tags: trunk) | |
19:46 | Remove superfluous directories from the Makefile clean targets. (check-in: 0bf9926c7a user: mistachkin tags: trunk) | |
17:59 | Merge updates from trunk. (check-in: 00990020d0 user: mistachkin tags: winCeLocalTime) | |
17:50 | Add the SQLITE_DBCONFIG_REQUIRE_TXN argument for sqlite3_dbconfig() which when set requires an explicit transaction before updating the database. (check-in: b7570ac14d user: drh tags: require-write-txn) | |
15:59 | Incorrect version of build.c checked in at [87e5f5a6c60e3] (because I neglected to press the "Save" button on the text editor). There is no change to the logic, just improved presentation. (check-in: cf569f9f2f user: drh tags: trunk) | |
14:02 | Make sure "0" intended as a NULL pointer is cast to a pointer when used in a varargs functions parameter. (check-in: ed128e8b82 user: drh tags: trunk) | |
14:01 | Remove an unnecessary conditional from the index builder. (check-in: 87e5f5a6c6 user: drh tags: trunk) | |
13:35 | Use SQLITE_WITHIN() for pointer range comparisons in some testing code. (check-in: 7cacf4e954 user: drh tags: trunk) | |
13:19 | Do not allow pointer arithmetic to move a pointer across a memory allocation boundary. (check-in: 85b979319b user: drh tags: trunk) | |
00:44 | Avoid unnecessary memset() operations in sqlite3PagerGet(). (Leaf check-in: 0c97b80240 user: drh tags: pager-get-noinit) | |
2016-04-04
| ||
18:04 | Fix documentation typos. Comment changes only. No changes to code. (check-in: d5fc2f7f90 user: drh tags: trunk) | |
17:59 | Improve error messages from the 'shell1-5.0' test. (check-in: cefd36ff7b user: mistachkin tags: trunk) | |
17:34 | Improved handling of UTF8 by the command-line shell. (check-in: 4534ebf15f user: drh tags: trunk) | |
17:23 | Add the ".auth ON|OFF" command to the command-line shell. (check-in: 65c7bcc427 user: drh tags: trunk) | |
16:40 | Test that the view name is passed to the authorization callback when a SELECT statement is run on a view. (check-in: 8627a4cd6d user: dan tags: trunk) | |
15:47 | Add and enhance the new tests. (Closed-Leaf check-in: f4cbd18db4 user: mistachkin tags: altShellFix) | |
14:57 | Enhance sqlite3session_apply() and sqlite3session_apply_strm() so that conflicts are retried before the xConflict() callback is invoked, as long as the "apply" operation is making forward progress. (check-in: 42a2196684 user: drh tags: trunk) | |
13:46 | Minor performance optimization in the comparison opcodes of the VDBE. (check-in: e375fe52ce user: drh tags: trunk) | |
12:38 | Fix harmless compiler warnings. (check-in: 0213d6af84 user: drh tags: trunk) | |
02:33 | Refinements to the previous check-in. (check-in: b36dfdff78 user: mistachkin tags: altShellFix) | |
02:16 | Experimental changes to the command line shell to make it work better with Unicode on Windows. (check-in: 74183a5f80 user: mistachkin tags: altShellFix) | |
02:05 | More refactoring and cleanup work on the Win32 string conversion and utility routines. (check-in: 02ccb444a3 user: mistachkin tags: altShellFix) | |
2016-04-03
| ||
22:44 | Revise and enhance the Win32 string conversion routines. (check-in: 345860c921 user: mistachkin tags: altShellFix) | |
20:50 | Replace the new fprintf() calls. (check-in: f76c3a0ca4 user: mistachkin tags: altShellFix) | |
20:45 | Merge updates from trunk. (check-in: 566b551e5a user: mistachkin tags: altShellFix) | |
2016-04-01
| ||
17:54 | Preupdate hook documentation fixes. No changes to code. (check-in: 59814f35d1 user: drh tags: trunk) | |
12:35 | When reading an sqlite_stat1 table with missing entries for some indexes, set the default for the missing indexes after all other indexes are set so that the default values are more in line with indexes that are actually in the stat1 table. (check-in: a62340dc05 user: drh tags: trunk) | |
2016-03-31
| ||
22:53 | Update the clean target in the MSVC makefile. (check-in: 69f4d83210 user: mistachkin tags: trunk) | |
20:40 | Enhance the query planner so that IS and IS NULL operators are able to drive an index on a LEFT OUTER JOIN. (check-in: c648539b52 user: drh tags: trunk) | |
15:08 | Add another OOM test to this branch. (Closed-Leaf check-in: 49763fc3ae user: dan tags: session-retry) | |
10:50 | Add further tests for the code on this branch. Fix a problem in OOM handling. (check-in: 195f3340ee user: dan tags: session-retry) | |
02:44 | Enhanced comments describing the sessions file format. No changes to code. (check-in: 84dc41e2df user: drh tags: session-retry) | |
00:45 | Fix the return code in sessionRetryConstraints(). (check-in: ea917c14b9 user: drh tags: session-retry) | |
2016-03-30
| ||
21:19 | Have the sqlite3session_apply() function and its streaming equivalent retry any operations that failed with SQLITE_CONSTRAINT after all other operations on the same table have been attempted. New code is largely untested. (check-in: 1085911afb user: dan tags: session-retry) | |
16:23 | Updates for the MSVC makefiles. (check-in: 7cf0cab730 user: mistachkin tags: trunk) | |
16:22 | Fix typo in comment. No changes to code. (check-in: 64d75cbe2c user: mistachkin tags: trunk) | |
15:30 | Simplifications and clarification to update callback handling in the OP_Delete and OP_Insert opcodes. (check-in: 47887ef89e user: drh tags: trunk) | |
14:26 | Increase the version number to 3.13.0 on account of the new session extension. (check-in: e9bcd5acb9 user: drh tags: trunk) | |
14:17 | Remove a redundant test for disabling RESTRICT with defer_foreign_keys=ON. (check-in: 9cdf813c6a user: drh tags: trunk) | |
13:43 | Incorporate the sessions extension and the SQLITE_ENABLE_PREUPDATE_HOOK compile-time option. (check-in: 4af7a90f98 user: drh tags: trunk) | |
12:56 | Avoid compiler warnings and excess opcodes when SQLITE_ENABLE_PREUPDATE_HOOK is not used. Fix the EXPLAIN output for P4_TABLE opcodes. (Closed-Leaf check-in: 5ab46d760d user: drh tags: sessions) | |
12:20 | Improvements to the performance testing program "speedtest1.c" and the shell script that invokes it. (check-in: e4bee561fd user: drh tags: trunk) | |
2016-03-29
| ||
21:19 | Fix some code and test coverage issues in fts5_index.c. (Leaf check-in: 7635c68018 user: dan tags: fts5) | |
10:36 | Merge 3.12.0 changes. (check-in: d7381efff4 user: drh tags: begin-concurrent) | |
10:30 | Merge 3.12.0 changes. (check-in: eef557449c user: drh tags: apple-osx) | |
10:19 | Merge changes for 3.12.0. (check-in: ed22eb653f user: drh tags: sessions) | |
10:14 | Version 3.12.0 (check-in: e9bb4cf40f user: drh tags: trunk, release, version-3.12.0) | |
2016-03-28
| ||
20:13 | Add further tests for savepoint rollback. Fix various code issues and add missing comments in fts5_index.c. (check-in: a805c6f7ea user: dan tags: fts5) | |
15:06 | Integrate the vcreate-stmt branch into this one. (check-in: 06039d901a user: dan tags: fts5) | |
14:57 | Open a statement transaction for "CREATE VIRTUAL TABLE" statements in order to ensure that if the xCreate() call fails, changes made to the sqlite_master and possibly other tables are rolled back. (Closed-Leaf check-in: d0a3853b37 user: dan tags: vcreate-stmt) | |
11:01 | Fix the multiplexor so that it does not assume that the xGetLastError method is non-NULL in the child VFS. (check-in: f6a88cccbc user: drh tags: trunk) | |
2016-03-26
| ||
20:11 | Fix a problem with OOM handling when setting an fts5 configuration option. (check-in: 53b80a6d05 user: dan tags: fts5) | |
15:36 | More changes to the shellN.test scripts to get them working on all variations of Windows. (check-in: 8213c2f581 user: drh tags: trunk) | |
14:41 | Remove the catchcmd_collapse_space procedure in tester.tcl - no longer needed. (check-in: 3bd499d3bd user: drh tags: trunk) | |
13:26 | Update shell1.test tests to deal with backslash escaping in TCL on Windows-style pathnames. (check-in: 219a251e18 user: drh tags: trunk) | |
2016-03-25
| ||
20:10 | Do not run the shell3.test module under mingw because of mingw's dodgy command-line parsing. (check-in: a7c080a90a user: drh tags: trunk) | |
17:19 | In the Win32 VFS, avoid trying to use rand_s() on Windows CE. (check-in: 183350fa7c user: mistachkin tags: trunk) | |
17:09 | Add the catchcmd_collapse_space command and use it to help make shell testing more robust against TCL space escapes. (check-in: 93caabb660 user: drh tags: trunk) | |
12:10 | Fix two instances of undefined behavior in the C code - both harmless for all current compilers. (check-in: 99fd194c83 user: drh tags: trunk) | |
2016-03-24
| ||
20:55 | Make test cases in shell1.test robust against TCL deciding to quote strings using lots of backslashes. (check-in: 817e93f42c user: drh tags: trunk) | |
20:36 | Prevent negative values of SQLITE_DEFAULT_CACHE_SIZE from making SQLITE_WIN32_HEAP_INIT_SIZE negative. (check-in: e0737f5236 user: mistachkin tags: trunk) | |
15:32 | Larger margins for one memsubsys1 range check when running with a non-zero reserved-bytes value. (check-in: 6db1d1fbc6 user: drh tags: trunk) | |
15:09 | Fix some test scripts so that they work with various permutations. (check-in: f4d234b501 user: dan tags: trunk) | |
14:34 | Merge the beta changes into sessions. (check-in: beb5ea1439 user: drh tags: sessions) | |
2016-03-23
| ||
17:54 | Avoid calling realloc() with a zero size in fuzzcheck.c. (check-in: a1fd14694c user: drh tags: trunk) | |
16:32 | Fix "ifcapable" tests in capi3.test and capi3c.test so that the tests work with more build configurations. (check-in: 3fa88f68c3 user: dan tags: trunk) | |
15:53 | Remove an unused local variable from FTS5. (check-in: 0ed693c29f user: drh tags: trunk) | |
15:04 | Explicitly limit the size of fts5 tokens to 32768 bytes. (check-in: 70fc69eed9 user: dan tags: trunk) | |
13:46 | Update a requirement mark. No changes to code. (check-in: 412984642a user: drh tags: trunk) | |
2016-03-22
| ||
20:05 | The sqlite3_column_decltype() routine should return NULL, not an empty string, if the column has no declared type. (check-in: 605eba4a75 user: drh tags: trunk) | |
15:26 | Fix harmless compiler warning for MSVC. (check-in: 142cd359d3 user: mistachkin tags: trunk) | |
15:25 | Fix a harmless compiler warning. (check-in: 5ace870d3a user: drh tags: trunk) | |
15:01 | Fix some errors in fts5 test scripts. (check-in: e1ab2d376a user: dan tags: trunk) | |
14:37 | Create the "uptr" typedef (the same as uintptr_t when available) and use it to cast pointers before comparison. (check-in: 2484cc0c3f user: drh tags: trunk) | |
14:10 | Avoid the possibility of integer overflow on a pointer comparison test for corruption in the database file. (check-in: ff1b1ac331 user: drh tags: trunk) | |
2016-03-21
| ||
22:28 | Fix harmless compiler warnings. (check-in: 25d776e452 user: drh tags: trunk) | |
16:25 | Add tests to ensure that fts5 is now deterministic. (check-in: 3d076094ce user: dan tags: trunk) | |
16:19 | Skip recently added test cases in nolock.test when running in the inmemory_journal permutation. (check-in: a1dcf7af42 user: drh tags: trunk) | |
16:06 | Remove an unreachable branch from the unlink verification logic in the UNIX VFS. (check-in: 4dc30cce7f user: drh tags: trunk) | |
15:54 | Merge all recent changes from trunk. (check-in: 8ee7d346c1 user: drh tags: begin-concurrent) | |
15:32 | Merge 3.12.0 beta changes from trunk. (check-in: 3296a0ceed user: drh tags: sessions) | |
15:30 | Have fts5 cache the structure of its index in main memory. Use "PRAGMA data_version" to figure out when this cache should be invalidated. (check-in: 902f221754 user: dan tags: trunk) | |
15:18 | Rearrange code so that tests pass whether SQLITE_DEBUG is defined or not. (Closed-Leaf check-in: 89296a46c3 user: dan tags: fts5-data-version) | |
14:52 | Merge the sqlite3_system_errno() change from trunk. (check-in: 063f1b3705 user: drh tags: apple-osx) | |
14:46 | Add the sqlite3_system_errno() interface. (check-in: 4bd12b57ea user: drh tags: trunk) | |
12:28 | Make sure system errors that occur durign sqlite3_step() are captured for use by sqlite3_system_errno(). (Closed-Leaf check-in: b4a1114f73 user: drh tags: sqlite_system_errno) | |
11:57 | Improved comments. No logical changes to code. (check-in: a6b6c6c466 user: drh tags: sqlite_system_errno) | |
11:38 | Do a better job of capturing all system errno values regardless of when they occur. (check-in: 7d49998d57 user: drh tags: sqlite_system_errno) | |
10:49 | Merge updates from trunk. (check-in: 86ab864396 user: drh tags: sqlite_system_errno) | |
09:56 | Change the way fts5 internally allocates segment ids in order to eliminated non-determinism from the module. (check-in: d6e2637df1 user: dan tags: trunk) | |
00:38 | Change the Vdbe.aMem array so that it is zero-based instead of one-based. (check-in: c39081e878 user: drh tags: trunk) | |
00:30 | Remove an unreachable branch. Improvements to comments. (Closed-Leaf check-in: c5677ecd5c user: drh tags: zero-base-aMem) | |
2016-03-19
| ||
23:32 | Change the Vdbe.aMem array so that it is zero-based instead of one-based. (check-in: e07b0c47eb user: drh tags: zero-base-aMem) | |
18:11 | Fix exclusive.test so that it works with -DSQLITE_TEMP_STORE=3. (check-in: d7852c6396 user: dan tags: trunk) | |
18:00 | Updates to the Lemon documentation. (check-in: f095341471 user: drh tags: trunk) | |
17:48 | Add the sqlite3rbu_bp_progress() API to the RBU extension. Used to obtain the percentage progress of an RBU update. (check-in: 209e31c729 user: dan tags: trunk) | |
17:09 | Fix a problem detecting invalid values in the rbu_control column of an rbu database table. (Closed-Leaf check-in: a1132dd902 user: dan tags: rbu-percent-progress) | |
16:21 | Update the sqldiff tool so that it generates an rbu_count table. (check-in: 1f7afb6e9b user: dan tags: rbu-percent-progress) | |
15:34 | Merge latest trunk changes, including fixes to test script rbudiff.test, into this branch. (check-in: 734fc68fb1 user: dan tags: rbu-percent-progress) | |
15:13 | Fix another problem in test script rbudiff.test. (check-in: 41c29c123f user: dan tags: trunk) | |
14:53 | Fix test scripts sqldiff.test and rbudiff.test so that they work with the --testdir option. (check-in: 1ffe3cde03 user: dan tags: trunk) | |
14:47 | Add test file fts5multiclient.test. (check-in: 7832466f91 user: dan tags: fts5-data-version) | |
00:40 | Fix a VDBE register allocation bug exposed by recent enhancements to PRAGMA integrity_check. (check-in: c73b5b9ccf user: drh tags: apple-osx) | |
00:35 | Fix a register allocation bug in the VDBE code generator for PRAGMA integrity_check; (check-in: 88439a866b user: drh tags: trunk) | |
2016-03-18
| ||
20:12 | Add further tests for sqlite3rbu_bp_progress(). Fix a problem in handling WITHOUT ROWID tables in the same. (check-in: 65e02368e2 user: dan tags: rbu-percent-progress) | |
18:56 | Change the name of the new API on this branch to "sqlite3_bp_progress". Add tests and documentation for the same. (check-in: 1a1b69e87e user: dan tags: rbu-percent-progress) | |
11:03 | Test case tweaks to better support the Apple configuration options. (check-in: cb0ffe844c user: drh tags: apple-osx) | |
10:29 | Add tests for the changes on this branch. Fix a problem with calls to the new progress indicator API made after an rbu update has been resumed. (check-in: bf82321724 user: dan tags: rbu-percent-progress) | |
00:58 | Merge recent enhancements from trunk. (check-in: ec052b4f14 user: drh tags: apple-osx) | |
00:39 | Fix FTS5 so that it works with SQLITE_OMIT_AUTORESET. (check-in: b199637d81 user: drh tags: trunk) | |
00:19 | Fix more test-case errors in the Apple configuration. (check-in: 6631e1e655 user: drh tags: trunk) | |
2016-03-17
| ||
23:56 | Fix some test cases so that they work under the Apple configuration. (check-in: 399c60764d user: drh tags: trunk) | |
23:16 | Fix harmless compiler warnings that arise with -DSQLITE_OMIT_LOAD_EXTENSION (check-in: 65ba2f0b46 user: drh tags: trunk) | |
23:00 | Changes to releasetest.tcl: Rename the "OS-X" configuration to "Apple". Bring the "Apple" configuration up to date. Allow the use of "if:os=..." arguments in a configuration. Run the Apple configuration on Linux in addition to on Macs, but without -DSQLITE_ENABLE_LOCKING_STYLE. (check-in: beb2a80b43 user: drh tags: trunk) | |
21:06 | Add an API to indicate the percentage progress of an rbu update. (check-in: ffc58d2c25 user: dan tags: rbu-percent-progress) | |
19:28 | Change the xGetLastError() method on the windows VFS so that it continues to format an error message (if requested) but returns the system error code, rather than an SQLite status code. (check-in: 1602f6b536 user: drh tags: sqlite_system_errno) | |
19:07 | A more compact implementation of the code generator for the IS and IS NOT operators. (check-in: 8607e3ac7a user: drh tags: trunk) | |
18:41 | An alternative method of encoding the wildcard in "SELECT *". This is an experiment. (Closed-Leaf check-in: 41335d8800 user: drh tags: select-wildcard) | |
17:23 | Simple test cases for sqlite3_system_errno() (check-in: 185bc8644c user: drh tags: sqlite_system_errno) | |
16:01 | Experimental implementation of the sqlite3_system_errno() interface. (check-in: 6782c87b37 user: drh tags: sqlite_system_errno) | |
12:39 | Fix some OOM-handling issues in the fts5 changes on this branch. (check-in: 020a0bda59 user: dan tags: fts5-data-version) | |
2016-03-16
| ||
21:29 | The prepared statements for some pragmas can now be reused without invoking an automatic reprepare. (check-in: 97b0e88cc7 user: drh tags: trunk) | |
20:53 | Merge the changes on the reusable-pragma branch into this one. (check-in: 6c4a17b963 user: dan tags: fts5-data-version) | |
20:44 | Some pragmas can be reused without an automatic reprepare. (Closed-Leaf check-in: db1ce7e13e user: drh tags: reusable-pragma) | |
20:05 | Fix a comment on the freelist_count and data_version pragmas. (check-in: 10a3e2a01d user: drh tags: trunk) | |
19:53 | Add a cast to an implict (size_t -> int) conversion in fts5_expr.c. (check-in: d9b5ff7aba user: dan tags: trunk) | |
19:48 | Have fts5 cache the decoded structure of fts5 indexes in memory. Use "PRAGMA data_version" to detect stale caches. (check-in: 33ef2210ef user: dan tags: fts5-data-version) | |
19:45 | Enhance Lemon so that it reorders the reduce rules such that rules without actions occur at the end and so that the first rule is number 0. This reduces the size of the jump table on the reduce switch, and helps the parser to run faster. (check-in: d5712f21ec user: drh tags: trunk) | |
19:34 | Merge the latest enhancements from trunk. (check-in: a7978ab6d2 user: drh tags: begin-concurrent) | |
19:10 | Avoid a few unnecessary fstat()s on journal files. (check-in: dbf8470591 user: drh tags: trunk) | |
18:26 | Fix the query planner so that it is able to use the integer primary key from an index as part of a multi-column constraint. (check-in: 96ea990942 user: drh tags: trunk) | |
01:16 | Merge all recent enhancements from trunk. (check-in: 6a7ee04b0d user: drh tags: sessions) | |
01:09 | Merge the SQLITE_OMIT_CODEC_FROM_TCL compile-time option from trunk. (check-in: 161d91e485 user: drh tags: apple-osx) | |
01:03 | Add the SQLITE_OMIT_CODEC_FROM_TCL compile-time option. (check-in: 45f7f0c80b user: drh tags: trunk) | |
00:36 | Rearrange some internal fields in the sqlite3_stmt object to avoid a harmless TSAN warning. (check-in: e0b116edd6 user: drh tags: trunk) | |
2016-03-15
| ||
22:00 | Change the OP_IntegrityCk opcode to accept the list of root pages as an intarray argument in P4. Slightly smaller and faster. (check-in: 15e4a272df user: drh tags: trunk) | |
19:10 | In the Win32 VFS, use SQLITE_FCNTL_LAST_ERRNO instead of (the older) SQLITE_LAST_ERRNO. (check-in: 9463762c43 user: mistachkin tags: trunk) | |
17:52 | Implement FROM-clause subqueries as co-routines whenever they are guaranteed to be the outer-most loop of the join. (check-in: c7bae50bdc user: drh tags: trunk) | |
12:45 | Merge updates from trunk - FTS5 fixes and enhancemenets to the tests scripts so that they work with SEE. (check-in: f41a7361a1 user: drh tags: apple-osx) | |
12:37 | More test-case changes so that everything works when the reserved_bytes value in the header is non-zero. (check-in: 2fd095b14b user: drh tags: trunk) | |
09:55 | Fix the shellN.test test scripts so that they work with the --testdir option. (check-in: 051c61ebae user: dan tags: trunk) | |
09:42 | Update this branch with latest trunk changes. (check-in: 249cd361b8 user: dan tags: schemalint) | |
2016-03-14
| ||
21:26 | Fix the permutations.test script so that it works again. (check-in: 9f194f90c0 user: drh tags: trunk) | |
21:12 | Update test scripts so that they work with SEE. (check-in: f4693ba4bb user: drh tags: trunk) | |
20:49 | Changing page size using VACUUM or backup is not allowed with a codec attached. (Closed-Leaf check-in: 92be06c1a8 user: drh tags: see-testing) | |
18:42 | Merge test script fixes from trunk. (check-in: ea1d2cddd5 user: drh tags: see-testing) | |
18:34 | Many more test cases fixed. Only a few remain. (check-in: 99b9d7eef6 user: drh tags: see-testing) | |