/ Timeline
Login

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

50 check-ins occurring around dff823ca8b5ca4a5.

2019-05-24
11:55
Fix an fts5 segfault that could occur after parsing a corrupt structure record. check-in: 600daa9c27 user: dan tags: trunk
2019-05-23
16:40
Add test cases for the fix in the previous commit. check-in: c1057b2a60 user: dan tags: trunk
16:38
Improvements to the view-self-join optimization so that it works on all VIEWs, not just on Common Table Expressions. check-in: d2fe370caf user: drh tags: trunk
2019-05-22
23:12
New test case for check-in [74ef97bf51dd531a] that takes the fix in the previous check-in into account. check-in: cb1d06521d user: drh tags: trunk
22:49
Renumber the Select.selId values in the copies of SELECT statements that implement VIEWs when the VIEW is expanded, so that when the same VIEW is used twice in the same join, each expansion as a distinct selId. This fixes ticket [ce823231949d3abf42453c8]. check-in: 3cacc4b940 user: drh tags: trunk
14:35
New dbsqlfuzz find added to test/fuzzdata8.db. check-in: 42af7c819b user: drh tags: trunk
14:22
Fix a buffer overread that could in fts3 when dealing with corrupt records. check-in: 1660d7733e user: dan tags: trunk
2019-05-21
17:04
Combine the implementations of the key and hexkey pragmas into a single case. Have both pragmas return "ok" if they are implemented. check-in: b3692c406f user: drh tags: trunk
16:32
Fix a problem in [b5ca442a] causing an assert() to fail in REINDEX commands. check-in: a3e77c7776 user: dan tags: trunk
14:42
Use a statement journal for all CREATE INDEX statements in case an indexed exprsesion throws an exception when it is evaluated. Fix for [b5ca442a]. check-in: b8071d10cb user: dan tags: trunk
2019-05-20
19:46
Fix a segfault that could occur in sqlite3session_diff() if NULL were passed as the pzErrMsg argument. check-in: aee73fd28f user: dan tags: trunk
18:43
Improvements to the automatic compile-time selection of byte-order, as suggested on the mailing list by Seb Kemper. check-in: b7aad92961 user: drh tags: trunk
18:35
A minor variation on check-in [1685610ef8e0dc] which (hopefully) makes the logic a little easier to follow. Also disallows the use of the double-quoted string hack in the query expression used for VACUUM INTO, which is not strictly required, but moves us toward the goal of disallowing the double-quoted string hack everywhere. check-in: 3e1b55f3ab user: drh tags: trunk
17:14
Disallow string constants enclosed in double-quotes within new CREATE TABLE and CREATE INDEX statements. It is still possible to enclose column names in double-quotes, and existing database schemas that use double-quotes for strings can still be loaded. This addresses ticket [9b78184b]. check-in: 1685610ef8 user: dan tags: trunk
10:36
Update the sqlite3ExprCompare() routine so that it does not think "? IS NOT TRUE" is the same as "? IS TRUE". Fix for [d3e7f2ba5b3]. check-in: 99eba69b3a user: dan tags: trunk
2019-05-18
21:22
Fix an assert() failure that could occur in a join query if the RHS of an IN() operator is a list containing correlated expressions. This problem was introduced by checkin [e130319317e7611938] which was part of the fix for ticket [787fa716be3a7f650c] - so this commit is part of that ticket's fix too. check-in: 778b1224a3 user: dan tags: trunk
19:49
Avoid including the comment in the output of "PRAGMA table_info" in situations where there is a comment following a DEFAULT value within a CREATE TABLE statement. check-in: d91095ba71 user: dan tags: trunk
2019-05-17
20:37
Disable PRAGMA journal_mode=OFF when SQLITE_DBCONFIG_DEFENSIVE is turned on. Ticket [f4ec250930342e0c]. check-in: a0f5eb5c79 user: drh tags: trunk
15:59
Always store a REAL value in a column with REAL affinity if the integer equivalent would require 8 bytes of storage. Fix for [3c27b97e3]. check-in: 14c00b1016 user: dan tags: trunk
2019-05-16
20:40
Add test cases to test/fuzzdata7.db for (harmless) dbfuzz2 finds. check-in: 1eb2a628e4 user: drh tags: trunk
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: 4b05caeb1b user: drh tags: trunk
20:13
Fix an assert() in the OP_Delete opcode that could fail with a corrupt database. check-in: 915388ab39 user: dan tags: trunk
16:44
Add new test file fts5corrupt4.test. check-in: 5dfc4fe98a 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: 3dac90728a user: drh tags: trunk
03:47
Fix harmless compiler warning in the session extension. check-in: dff823ca8b 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: d612fb7873 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: 05897ca48a user: drh tags: trunk
10:16
Simplify the "Verifying Code Authenticity" section of the README.md file. No code changes. check-in: adebffc18e user: drh tags: trunk
2019-05-14
22:25
Merge all the latest trunk enhancements into the reuse-schema branch. check-in: 018f3199b9 user: drh tags: reuse-schema
22:07
Merge the latest trunk and wal2 enhancements. check-in: 3deaa6e23b user: drh tags: begin-concurrent-pnu-wal2
22:02
Merge the latest trunk enhancements into the wal2 branch. check-in: 23ec34e4f6 user: drh tags: wal2
21:51
Merge the latest trunk enhancements into begin-concurrent-pnu. check-in: e70878b363 user: drh tags: begin-concurrent-pnu
21:51
Merge the latest trunk enhancements into begin-concurrent. check-in: 5d3a6e18d4 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: bc7d2c1656 user: dan tags: trunk
19:39
Merge recent enhancements from trunk into apple-osx. check-in: 40362d5181 user: drh tags: apple-osx
19:20
New test cases in test/fuzzdata8.db. check-in: 228e1087c0 user: drh tags: trunk
18:33
Fix a problem with corrupt db handling in the fts5_vocab module. check-in: 456ced5777 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: 8be8bd0d56 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: f7aadfab3b 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: f158c048be 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: b3413197f5 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: 1b24303220 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: 0ba6d709b5 user: dan tags: trunk
2019-05-10
20:44
Add tests for the RBU module. check-in: a194e53670 user: dan tags: trunk
17:54
Fix harmless compiler warnings. check-in: 956ca2a452 user: drh tags: trunk
17:50
Fix harmless compiler warnings in the CLI. check-in: 2846bc0429 user: drh tags: trunk
16:16
Fix some harmless compiler warnings. Closed-Leaf check-in: ca068d8238 user: mistachkin tags: warnings
14:34
Ensure that the BtShared.nPage value is reset correctly on a SAVEPOINT ROLLBACK. check-in: e6d5fee8cd 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: 7e4809eadf 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: e80b2d9fcb user: drh tags: trunk