SQLite

Timeline
Login

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

100 check-ins occurring around 442c177dc444d614.

2019-05-02
15:56
Earlier detection of a database corruption case in balance_nonroot(), to prevent a possible use of an uninitialized variable. check-in: c509d8a8 user: drh tags: trunk
14:15
Merge enhancements from trunk check-in: 3a4751a9 user: drh tags: hard-heap-limit
01:41
The "LIKE Optimization" (which converts a LIKE into a BETWEEN operator that is able to use an index) does not work and cannot be used if the collating sequence of the column is not TEXT and if the pattern starts with a "+" sign. This is another case of ticket [c94369cae9b561b1f996d005]. The new test case was discovered by Manuel Rigger. check-in: b043a54c user: drh tags: trunk
00:52
Fix an issue (discovered by OSSFuzz) in the enhanced OP_Concat operator from check-in [713caa382cf7dd] earlier today. check-in: 3e897702 user: drh tags: trunk
2019-05-01
19:01
Add a test case for ticket [ae0f637bddc5290b44669e066a]. check-in: ece48169 user: drh tags: trunk
18:59
When values have real affinity and are converted into strings for CHECK constraints or index expressions, do the conversions into a real-number format even if the values are stored as integers for efficiency. This appears to fix ticket [ae0f637bddc5290b446]. check-in: 5997d075 user: drh tags: trunk
17:36
Fix an incompatibility with -DSQLITE_OMIT_LOAD_EXTENSION=1 in dbdata.test. check-in: a77cd85b user: dan tags: trunk
17:32
Fix a case in wapptest.tcl where a failed test might report 0 errors. check-in: 2be1ed70 user: dan tags: trunk
15:32
Avoid unwelcomed side effects on the input operands in the OP_Concat operator. Fix for ticket [3be1295b264be2fac49b681] check-in: 713caa38 user: drh tags: trunk
15:25
Update wapptest.tcl so that it deletes extra files if the "Keep files:" checkbox is clear. Set it by default. check-in: 09623cc4 user: dan tags: trunk
14:41
In "PRAGMA vdbe_trace" output, show the results of OP_Affinity opcodes. check-in: 56604bb6 user: drh tags: trunk
08:48
Fix an incompatibility with auto-vacuum mode in new test script recover.test. check-in: 36dd5b08 user: dan tags: trunk
2019-04-30
20:43
Update wapptest.tcl to use a simpler slave script. And to leave scripts wapptest_configure.sh and wapptest_make.sh in each test directory. check-in: 07e527d7 user: dan tags: trunk
15:36
Fix a problem allowing a Table object to be deleted from within a call to the xDestroy method of the associated virtual table, causing a use-after-free error. check-in: 1dbbb010 user: dan tags: trunk
14:26
Fix an error message in the Lemon parser generator. check-in: b6d7d42b user: drh tags: trunk
11:54
Small performance increase and size reduction in the implementation of the LIKE and GLOB operators. check-in: f97626f9 user: drh tags: trunk
01:08
Slightly smaller and faster implementation of the OP_MakeRecord opcode. check-in: 3bdce7ef user: drh tags: trunk
2019-04-29
16:44
Changes to oserror.test so that it works even on systems that allow an unusually large number of file descriptors. check-in: a27b0b88 user: drh tags: trunk
13:48
Do not de-duplicate columns index columns associated with a WITHOUT ROWID table if the columns have different collating sequences. This is the fix for ticket [3182d3879020ef3b2]. There is one test case added, but most of the tests are done in TH3. check-in: 1b1dd4d4 user: drh tags: trunk
13:30
Improved header comment and precondition checking for the new isDupColumn() function. Closed-Leaf check-in: 740d5ff6 user: drh tags: tkt-3182d38790
11:41
Fix a buffer overwrite in shell.c.in (part of the new .recover code). check-in: 92facbc7 user: dan tags: trunk
11:27
Fix a stack overflow that could occur when renaming a table that has a trigger containing a window function invocation that itself contains a specific syntax error. check-in: c621fc66 user: dan tags: trunk
2019-04-28
19:27
Take collating sequence into account when removing redundant columns from indexes on WITHOUT ROWID tables. This is the first proof-of-concept fix for ticket [3182d3879020ef3]. More testing needed. check-in: b34fa5bf user: drh tags: tkt-3182d38790
2019-04-27
20:39
Add the shardvtab virtual table that uses the new cost estimation functions. Leaf check-in: 9404300a user: drh tags: cost-est
20:30
Add the ".recover" command to the shell tool. For recovering as much data as possible from corrupt databases. check-in: 50fe4845 user: dan tags: trunk
20:16
Fix a minor typo in a comment. No changes to code. check-in: 95209072 user: drh tags: trunk
20:15
Fix building the shell with SQLITE_OMIT_VIRTUAL_TABLE. And without SQLITE_ENABLE_DBPAGE_VTAB. Closed-Leaf check-in: 425d708c user: dan tags: dbdata
19:36
Add comments and fix formatting issues in new code in shell.c.in. check-in: b91d819b user: dan tags: dbdata
18:47
Add the "--lost-and-found" option to the ".recover" command. For setting the name of the orphaned rows table. check-in: 67bb88e2 user: dan tags: dbdata
15:35
Fix a problem in the .recover command with recovering WITHOUT ROWID tables where the PK columns are not the leftmost in the CREATE TABLE statement. check-in: 91df4b8e user: dan tags: dbdata
2019-04-26
21:11
Have .recover store all orphaned rows in a single table, with extra columns to indicate the orphaned page and sub-tree they were discovered within. check-in: 7221f6e3 user: dan tags: dbdata
17:20
An experimental interface for retrieving the estimated cost and estimated number of output rows for a query. check-in: 1b25fa10 user: drh tags: cost-est
17:08
Omit tests of the LIKE optimization in like3.test when SQLITE_ENABLE_ICU is defined. check-in: af53c41a user: dan tags: trunk
15:40
Fix another problem with database freelist handling in the ".recover" command. check-in: bee2652a user: dan tags: dbdata
15:14
Fix a locking-page related problem with the ".recover" command. check-in: afdae104 user: dan tags: dbdata
2019-04-25
20:06
Merge latest trunk changes into this branch. check-in: 1da302d8 user: dan tags: dbdata
19:23
Unless the "--freelist-corrupt" option is specified, do not have the .recover command attempt to recover data from pages that are on the database free-list. check-in: 8d2f52bb user: dan tags: dbdata
18:15
Add the sqlite3_hard_heap_limit64() interface and the corresponding "PRAGMA hard_heap_limit=N" command. check-in: b0ccef61 user: drh tags: hard-heap-limit
16:20
Fix a bug preventing .recover from working on databases where the final page of the db is corrupt. check-in: 959bbd11 user: dan tags: dbdata
2019-04-24
20:48
Improve the performance of the .recover command. check-in: a5076831 user: dan tags: dbdata
17:04
New test cases in test/fuzzdata8.db. check-in: 7be6222c user: drh tags: trunk
16:13
Fix another instance in fts3 where a corrupt record can cause a buffer overflow. check-in: e1724f1d user: dan tags: trunk
15:57
Fix a problem in fts5 where a corrupt position list could lead to a buffer overwrite. check-in: 516ca894 user: dan tags: trunk
15:13
Fix an error in fts3_write.c allowing a corrupt database to cause a crash. check-in: 6e4a5f22 user: dan tags: trunk
04:53
Correction to the #if in the previous check-in. check-in: 30dc05ac user: mistachkin tags: trunk
00:37
Fix for 8-byte alignment asserts that can trigger in some circumstances with 32-bit MSVC. check-in: 4c02832e user: mistachkin tags: trunk
2019-04-23
22:00
Make no atttempt to generate VDBE code for VACUUM after a syntax error. check-in: 93084247 user: drh tags: trunk
20:48
Have ".recover" handle "\r" and "\n" in the same way as ".dump". check-in: f95f0f02 user: dan tags: dbdata
18:03
Fixes for the ".recover" shell command. check-in: 8dcc1d89 user: dan tags: dbdata
15:30
Changes to the --hexdb decoder option in the shell (and also in the TCL test code) so that it works on systems where sscanf() does not recognize "%hhx" as wanting to delivery results into a character-size variable. check-in: 4258e42d user: drh tags: trunk
15:21
Minor simplification of NULL value handling for STAT4. Cherrypick of [69bad9257f8db6a2] from trunk. check-in: 442c177d user: mistachkin tags: branch-3.28
15:08
Minor simplification of NULL value handling for STAT4. check-in: 69bad925 user: mistachkin tags: trunk
12:31
New test cases in fuzzdata8.db. check-in: 0fe3c3fd user: drh tags: trunk
12:30
Improvement on the previous check-in. Parse.rc is less reliable than Parse.nErr for detecting SQLITE_TOOBIG errors. check-in: 8d478cfb user: drh tags: trunk
2019-04-22
20:52
Enhance the ".recover" command. Fix a problem with overflow pages in dbdata.c. check-in: f193ca58 user: dan tags: dbdata
20:05
Early detection of SQLITE_TOOBIG when processing nested queries. check-in: 5d85d80e user: drh tags: trunk
11:47
Fix an assert() that may be false for corrupt databases. check-in: b2ce5ed1 user: dan tags: trunk
2019-04-20
20:57
Add the ".recovery" command to the shell tool. For recovering the maximum amount data from corrupt databases. Still needs work. check-in: 7461d2e1 user: dan tags: dbdata
2019-04-19
23:05
Mark a single branch as no longer reachable. check-in: 4f35b3b7 user: drh tags: trunk
22:01
Increase the version number to 3.29 for the next development cycle. check-in: 6cf16703 user: drh tags: trunk
18:10
Mark two branches as unreachable. Oops - one of those branches was reachable via fuzzcheck tests. Closed-Leaf check-in: 9b888fcc user: drh tags: mistake
17:26
Improved optimization of the AND and OR operators. check-in: 0fbd154e user: drh tags: trunk
16:34
Fix a problem with renaming a table that starts with "sqlite". Fix for ticket [f00d7b65]. check-in: a2ead8aa user: dan tags: trunk
16:21
Use macros to determine if an expression is always true or always false. check-in: 6de980a0 user: drh tags: trunk
13:38
Streamline the processing of the AND operator. Slightly smaller and faster. check-in: 7713996a user: drh tags: trunk
2019-04-18
21:14
Add the sqlite_dbptr virtual table to the dbdata extension. For querying the links between b-tree pages. check-in: 3213a15f user: dan tags: dbdata
19:21
Minor simplification of NULL value handling for STAT4. Closed-Leaf check-in: 5718a9d5 user: mistachkin tags: nullStat4
17:37
Undo change to 'analyze9.test' because the extra output can be useful for debugging. Leaf check-in: f3081e59 user: mistachkin tags: msvc
2019-04-17
23:56
Fix a couple minor test issues. check-in: 1f1866d1 user: mistachkin tags: msvc
23:32
Work around lack of a C99 feature in MSVC. check-in: f6ebe1c2 user: mistachkin tags: msvc
21:17
Add the experimental dbdata extension. check-in: a3ab5883 user: dan tags: dbdata
21:12
Small performance and size optimization in sqlite3WalFindFrame(). check-in: 03f2e788 user: drh tags: trunk
13:58
Fix a typo in the CLI help output for the ".dump" command. check-in: 57638248 user: drh tags: trunk
13:23
In the "pgidx" report from "showdb", also show the number of rows on each database btree page. check-in: 2bda9dc4 user: drh tags: trunk
12:29
In the "pgidx" command of the showdb utility, try to identify orphaned pages and show when pages have been zeroed out. check-in: eed701ef user: drh tags: trunk
12:07
Small performance improvement on the variable-length integer decoder: sqlite3GetVarint(). check-in: 5df2bf62 user: drh tags: trunk
11:34
Faster and smaller implementation of sqlite3StrICmp(). check-in: 7ac500fb user: drh tags: trunk
2019-04-16
19:49
Version 3.28.0 check-in: 884b4b7e user: drh tags: trunk, release, version-3.28.0
11:21
Avoid a sanitizer error (pointer arithmatic overflow) in vdbesort.c. check-in: af61a2fc user: dan tags: trunk
10:51
Avoid a sanitizer error in test1.c. Have releasetest.tcl/wapptest.tcl create a file called "makecommand.sh" that can be used to rerun a test from the command line. check-in: 4de4480f user: dan tags: trunk
2019-04-15
19:17
Fix a bug in test module test_fs.c causing a segfault on OpenBSD. check-in: ee886600 user: dan tags: trunk
15:41
Fix a problem with the user-auth extension and deserializing in-memory databases. check-in: 09fa0b3c user: dan tags: trunk
15:35
Merge recent changes from trunk into reuse-schema check-in: 5c6c9e7f user: drh tags: reuse-schema
15:28
Merge all recent enhancements. check-in: 1cd536ec user: drh tags: begin-concurrent-pnu-wal2
15:17
Merge the latest trunk enhancements. check-in: 8950f119 user: drh tags: wal2
15:07
Merge the latest enhancements from trunk. check-in: 6caaaf21 user: drh tags: begin-concurrent-pnu
14:59
Merge the latest enhancements from trunk. check-in: 7c328e88 user: drh tags: begin-concurrent
14:49
Bring in the latest enhancements from trunk. check-in: 378230ae user: drh tags: apple-osx
13:59
Fix a test script problem in fts5corrupt3.test. check-in: 734192d8 user: dan tags: trunk
13:51
Update tool/symbols.sh to ignore symbols from sessions and rebaser and to not try to compile with ICU which is not available on all platforms. check-in: 0bab4ece user: drh tags: trunk
2019-04-14
00:40
Remove a stray tab from the source code. check-in: 0ada58e9 user: drh tags: trunk
00:34
Fix an obsolete comment and other minor issues from code inspection. check-in: cd084427 user: drh tags: trunk
2019-04-13
16:50
Fix a harmless compiler warning in test logic. check-in: c3932e66 user: drh tags: trunk
16:43
Fix the fts3varint.test script so that it works even on versions of TCL for which Tcl_GetWideIntFromObj() does not work. check-in: 53f787ad user: drh tags: trunk
16:35
Fix a test script problem in fts5corrupt3.test. check-in: 858f6227 user: dan tags: trunk
15:07
Partially revert the test file changes in [4371a0c46e]. It is no longer required following [93ae382e97c23c90]. check-in: 593a7e6e user: dan tags: trunk
14:17
Fix additional compiler warnings introduced by the previous check-in and found by MSVC. check-in: 6fc0deff user: drh tags: trunk
14:07
Fixes for harmless compiler warnings. check-in: c28c973a user: drh tags: trunk
04:38
Use the 64-bit memory allocator interfaces in extensions, whenever possible. check-in: 07ee06fd user: drh tags: trunk
04:01
Enforce the SQLITE_LIMIT_COLUMN limit on virtual tables. check-in: 0b6ae032 user: drh tags: trunk