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

100 check-ins occurring around 30392985612c51d4.

2019-05-16
20:36
Initialize the 18-byte overrun area on the buffer used to reconstruct overflow btree cells during a btree search, to avoid a harmless jump-depends-on-uninit-values warning. check-in: 4b05caeb user: drh tags: trunk
20:13
Fix an assert() in the OP_Delete opcode that could fail with a corrupt database. check-in: 915388ab user: dan tags: trunk
16:44
Add new test file fts5corrupt4.test. check-in: 5dfc4fe9 user: dan tags: trunk
11:47
Fix a harmless use-of-initialized-value fault in the assert() logic added by check-in [d612fb7873cf59d] check-in: 3dac9072 user: drh tags: trunk
03:47
Fix harmless compiler warning in the session extension. check-in: dff823ca user: mistachkin tags: trunk
01:22
Make sure the OP_Concat opcode always correctly zero-terminates a UTF16 string, even if the input strings are ill-formed. This is a followup to check-in [3a16ddf91f0c9c516a7] that fixes a case the previous check-in missed. Also add assert()s to prove correct zero termination. check-in: d612fb78 user: drh tags: trunk
2019-05-15
18:42
Fix the count-of-view optimization so that it is (correctly) disabled for a query that includes a WHERE clause or a GROUP BY clause. check-in: 05897ca4 user: drh tags: trunk
10:16
Simplify the "Verifying Code Authenticity" section of the README.md file. No code changes. check-in: adebffc1 user: drh tags: trunk
2019-05-14
22:25
Merge all the latest trunk enhancements into the reuse-schema branch. check-in: 018f3199 user: drh tags: reuse-schema
22:07
Merge the latest trunk and wal2 enhancements. check-in: 3deaa6e2 user: drh tags: begin-concurrent-pnu-wal2
22:02
Merge the latest trunk enhancements into the wal2 branch. check-in: 23ec34e4 user: drh tags: wal2
21:51
Merge the latest trunk enhancements into begin-concurrent-pnu. check-in: e70878b3 user: drh tags: begin-concurrent-pnu
21:51
Merge the latest trunk enhancements into begin-concurrent. check-in: 5d3a6e18 user: drh tags: begin-concurrent
20:25
Fix a problem with the fix for [9cf6c9bb51] (commit [658b84d7]) that could cause a cursor to be left in an invalid state following a (rowid < text-value) search. check-in: bc7d2c16 user: dan tags: trunk
19:39
Merge recent enhancements from trunk into apple-osx. check-in: 40362d51 user: drh tags: apple-osx
19:20
New test cases in test/fuzzdata8.db. check-in: 228e1087 user: drh tags: trunk
18:33
Fix a problem with corrupt db handling in the fts5_vocab module. check-in: 456ced57 user: dan tags: trunk
11:33
Fix an assert() and potential buffer overrun in fts5 that could occur if the database was corrupt. check-in: 8be8bd0d user: dan tags: trunk
00:43
Disable index seek optimizations on REINDEX when the order of primary keys in the index differs from the main table. Fix for ticket [bba7b69f9849b5bf11b4]. check-in: f7aadfab user: drh tags: trunk
2019-05-13
11:52
Fix an assert() failure in fts5 that could occur when processing a corrupt database. check-in: f158c048 user: dan tags: trunk
2019-05-11
19:36
A new implementation for the sqlite3ExprImpliesExpr() theorem prover that does a better job of answering TRUE to "(NOT A) OR B" when B is a NOT NULL expression. check-in: b3413197 user: drh tags: trunk
16:14
When considering partial indexes, do not assume that a "CASE x ..." expression implies "x IS NOT NULL". check-in: 1b243032 user: dan tags: trunk
13:04
Do not assume that "x IS NOT ?" implies "x NOT NULL" when considering partial indexes. Fix for ticket [8025674847]. check-in: 0ba6d709 user: dan tags: trunk
2019-05-10
20:44
Add tests for the RBU module. check-in: a194e536 user: dan tags: trunk
17:54
Fix harmless compiler warnings. check-in: 956ca2a4 user: drh tags: trunk
17:50
Fix harmless compiler warnings in the CLI. check-in: 2846bc04 user: drh tags: trunk
16:16
Fix some harmless compiler warnings. Closed-Leaf check-in: ca068d82 user: mistachkin tags: warnings
14:34
Ensure that the BtShared.nPage value is reset correctly on a SAVEPOINT ROLLBACK. check-in: e6d5fee8 user: drh tags: trunk
14:26
Treat integer values in window definition ORDER BY clauses as constants, not as references to another expression. check-in: 7e4809ea user: dan tags: trunk
14:03
Improved comments and extra assert() statements on the OP_Savepoint opcode, just to make the code a little easier to read and reason about. check-in: e80b2d9f user: drh tags: trunk
12:14
Fix the previous check-in [db9acef14d492121] so that the amalgamation build works for systems for which lack HAVE_ISNAN. check-in: 3cc55e09 user: drh tags: trunk
12:06
Fix the round() SQL function so that it handles infinities correctly. check-in: db9acef1 user: drh tags: trunk
2019-05-09
18:37
Fix another small buffer overread in sqlite_dbdata triggered by a corrupt database page. check-in: 1dfc95b8 user: dan tags: trunk
18:33
Fix a problem in the ".recover" command allowing a circular loop of b-tree pages in a database file to cause an infinite loop. check-in: 8d2a062e user: dan tags: trunk
18:13
Make the ".schema" command in the CLI resistant to corrupt database files. check-in: f22c7e22 user: drh tags: trunk
17:54
Fix a crash in the sqlite_dbdata module that could occur if a pointer within an overflow chain in a corrupt database pointed past the end of the db. check-in: 3eae4e30 user: dan tags: trunk
17:10
Disable the optimization where a REAL value with no fractional part is stored as an INTEGER when the integer uses as much space as the real value it proposes to stand in for (8 bytes). This avoids corner cases of comparing integers against real values that are beyond the resolution of an IEEE 754 double. Fix for ticket [6c1d3febc00b22d457c78c2] check-in: 9b091527 user: drh tags: trunk
16:57
Avoid long delays that can occur when ".recover"ing data from a database with a corrupt freelist. check-in: 20f06bf2 user: dan tags: trunk
16:22
Improved debugging output from the OP_MakeRecord opcode. check-in: ac790729 user: drh tags: trunk
15:51
Fix another corruption related buffer overread in the sqlite_dbdata module. check-in: 5cd728fb user: dan tags: trunk
15:07
Fix further buffer overreads triggered by passing corrupt records to the sqlite_dbdata module. check-in: dbc6a9f7 user: dan tags: trunk
14:15
Have ".recover" handle cases where the sqlite_master table contains malformed SQL statements. check-in: e736da9c user: dan tags: trunk
11:45
Fix a problem with running the ".recover" command on a database that is zero pages in size. check-in: 47fa6534 user: dan tags: trunk
11:34
Avoid reading outside a record buffer when extracting an SQL value in the sqlite_dbdata virtual table code. check-in: d99bb0c1 user: dan tags: trunk
11:21
Merge accidental fork in trunk. check-in: ec937303 user: dan tags: trunk
11:19
Fix a problem in the new code introduced by [658b84d7] causing corruption and other errors to be ignored. check-in: 7ccf2e7d user: dan tags: trunk
11:18
Improved error handling for the ".open --hexdb" command of the CLI. check-in: 4fa831d5 user: drh tags: trunk
2019-05-08
23:55
Ensure that the sqlite3BtreeLast() interface initializes the *pRes return to zero if the cursor is already sitting on the last entry of the table. Manuel Rigger found the obscure test case for which this makes a difference. check-in: ebe4845c user: drh tags: trunk
23:53
This is part of the previous check-in that didn't get committed for some reason - probably because I failed to press the "Save" button on the text editor. check-in: 51d32173 user: drh tags: trunk
21:14
Add another test case to cover a previously uncovered branch in the RBU module. check-in: 30392985 user: dan tags: trunk
19:55
Fix another pattern for which the LIKE optimization does not work for a non-TEXT affinity. Case found by Manuel Rigger. check-in: 74020110 user: drh tags: trunk
19:32
Simplification to the logic underlying PRAGMA case_sensitive_like. check-in: ef0015fd user: drh tags: trunk
19:06
Avoid an excess register allocation in UPDATE, when possible. This improves speed (slightly) and reduces the code footprint. check-in: 8658574e user: drh tags: trunk
18:49
Add tests to improve code coverage of the RBU module. check-in: ecb56b75 user: dan tags: trunk
17:27
Provide the SQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA compile-time option to omit the case_sensitive_like pragma. This change, in combination with documentation changes, is the current solution to ticket [a340eef47b0cad5]. check-in: eabe7f2d user: drh tags: trunk
11:52
Fix VDBE opcodes OP_SeekLT and OP_SeekLE so that they work on intkey tables with non-numeric text values. Fix for [9cf6c9bb]. check-in: 658b84d7 user: dan tags: trunk
11:42
Fix VDBE opcodes OP_SeekLT and OP_SeekLE so that they work on intkey tables with non-numeric text values. Closed-Leaf check-in: a870c196 user: dan tags: tkt-9cf6c9bb
04:33
Remove an ALWAYS() that was previously added by check-in [a0819086] but which turns out can sometimes be false. check-in: ad8fc5d8 user: drh tags: trunk
03:34
Remove a NEVER() that was added in the previous check-in [a0819086a521f] because it is in fact reachable. check-in: 74eba255 user: drh tags: trunk
00:17
Earlier detections of errors in the byte-offset-to-cell-content integer at offset 5 in the header of a btree page. check-in: a0819086 user: drh tags: trunk
2019-05-07
20:06
Generate all records for INSERT or UPDATE prior to running foreign key constraint checks, since the FK checks might modify the datatype of registers used to generate the records. Fix for ticket [e63cbcfd3378afe6980d6]. check-in: 3c75605b user: drh tags: trunk
19:44
Do not commit an "OR FAIL" statement that causes foriegn key constraint violations. check-in: 659c551d user: dan tags: trunk
19:21
Add test cases for the fix on this branch. Closed-Leaf check-in: 2e31abe0 user: dan tags: tkt-e63cbcfd
19:13
On an INSERT or UPDATE, generate the new table record prior to running foreign key checks, in case the foreign key checks changes datatypes on the registers holding column values. Proposed fix for ticket [e63cbcfd3378afe6980d626]. check-in: 3f1c8051 user: drh tags: tkt-e63cbcfd
17:47
Strive to prevent harmless compiler warnings in GCC 4.8.5. check-in: 8b6691f6 user: drh tags: trunk
16:37
Optimize the restarting of an RBU vacuum. check-in: 82062351 user: dan tags: trunk
16:28
Remove some redundant code from sqlite3rbu.c. Add test cases for RBU vacuum. Closed-Leaf check-in: 7b051698 user: dan tags: rbu-opt
02:57
Add the exprNodeCopy() routine that will safely memcpy() an Expr node that might be a size-reduced node. Leaf check-in: ab2ba8e7 user: drh tags: expr-node-copy-patch
2019-05-06
20:40
Optimize further cases of restarting an RBU vacuum. check-in: 6b3261bf user: dan tags: rbu-opt
16:15
Fix a problem with renaming an INTEGER PRIMARY KEY column of a WITHOUT ROWID table using ALTER TABLE. check-in: 91f701d3 user: dan tags: trunk
2019-05-04
20:04
Optimize some cases of restarting an RBU vacuum. check-in: cdc09867 user: dan tags: rbu-opt
17:32
Fix the NOT NULL logic in the theorem prover that determines when a partial index can be used. Ticket [5c6955204c392ae763a95]. check-in: c2e439bc user: drh tags: trunk
03:56
Fix harmless compiler warning seen with MSVC. check-in: 5862b83e user: mistachkin tags: trunk
01:41
In the sqlite3_value or Mem object, make the MEM_IntReal type completely independent from MEM_Int and MEM_Real. This helps avoid problems when inserting non-float values into a "REAL" column. check-in: 5a8a23ee user: drh tags: trunk
01:29
New testcase macros to ensure that MEM_IntReal is fully tested. Closed-Leaf check-in: 8b8ef445 user: drh tags: int-real
2019-05-03
21:17
Add the SQLITE_TESTCTRL_RESULT_INTREAL test-control and use it to create the intreal() SQL function in testfixture. Write a few simple tests to prove this all works. TH3 will hold most of the INTREAL tests, probably. check-in: c9838731 user: drh tags: int-real
19:34
Ensure that UTF16 strings are properly zero-terminated before returning them in an sqlite3_value_text16() request, even if the string is invalid UTF16 because it was formed from an arbitrary and/or odd-length BLOB. check-in: 3a16ddf9 user: drh tags: trunk
18:50
Fix a memory-leak/segfault caused by using OP_OpenDup and OP_OpenEphemeral on the same VM cursor. check-in: a9b90aa1 user: dan tags: trunk
17:19
Fix a problem where self-joins on views that are aggregate queries may return the wrong result. check-in: 74ef97bf user: dan tags: trunk
17:08
Improved comments on the elements of the array constant used to implement the sqlite3_value_type() interface. check-in: f73a7de7 user: drh tags: int-real
02:41
Fix the ".open --hexdb" command in the CLI so that it works even with terminal input. check-in: 9b5d9434 user: drh tags: trunk
2019-05-02
21:36
Make MEM_IntReal a completely independent type, meaning a floating point value stored as an integer. This fixes a problem with arithmetic within arguments to string functions on indexes of expressions. But it is a big change and needs lots of new testcase() macros for MC/DC and so it is initially put on this branch. check-in: dba836e3 user: drh tags: int-real
17:45
Ensure that the typeof() function always returns SQLITE_FLOAT for floating point values even when the value is stored as an integer to save space. check-in: 48889530 user: drh tags: trunk
17:06
Add options to wapptest.tcl similar to those supported by releasetest.tcl. Also add the -noui switch, for running without wapp altogether. check-in: 005a1694 user: dan tags: trunk
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