/ Timeline
Login

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

100 check-ins occurring around 8ad34d36a141fa8f.

2019-11-29
12:51
Fix the parse.sql output file so that it is readable into a database where foreign keys are enforced. check-in: 3a82c554 user: drh tags: trunk
2019-11-27
20:40
More details on the comment justifying the aleged data race in the WAL-mode checkpoint logic. check-in: 0fab65c7 user: drh tags: trunk
12:03
Fix obsolete comment. No changes to code. Leaf check-in: 0ff59edb user: drh tags: reuse-shm
2019-11-26
14:24
Fix various documentation typos suggested by Mark Benningfield. No changes to code. check-in: 08f09dc4 user: drh tags: trunk
11:10
Fix to check-in [5d9a369301a65f32] so that it compiles without SQLITE_DEBUG. check-in: fefe2d04 user: drh tags: trunk
02:22
Add the new -S option to the lemon parser generator to cause it to output SQL that describes the input grammar. check-in: 4dbd398d user: drh tags: trunk
02:03
Fix an assert() in fts3 that could fail due to corrupt database records. check-in: 5d9a3693 user: dan tags: trunk
2019-11-25
23:55
Experimental file-controls for controlling the use of the -shm file. check-in: 12b8fa23 user: drh tags: reuse-shm
04:15
Modify journal3.test so that it can handle Tcl command "file attr <file> -perm" returning octal values in either "00755" or "0o755" format. check-in: b0b65562 user: dan tags: trunk
00:07
Minor enhancements to the TclKit download tool. check-in: 75e31b1d user: mistachkin tags: trunk
2019-11-23
16:34
Abort the window function tree rewrite early following an OOM. check-in: d66f95a5 user: drh tags: trunk
15:10
Avoid evaluating PARTITION BY or ORDER BY expressions multiple times for window function queries that use multiple window functions with the same window-definition. check-in: 57070c68 user: dan tags: trunk
08:51
Enhance the path arguments in JSON functions to access "#-N" array indexes. check-in: ffeec62c user: drh tags: trunk
08:36
Fix a memory leak in fts5 error handling code. check-in: de6637e1 user: dan tags: trunk
2019-11-22
17:37
Extend the json-path mechanism with array indexes of the form "#" or "#-n" for some positive number "n", to reference the end of an array. Closed-Leaf check-in: 35ed68a6 user: drh tags: json-path-enhancement
11:49
Fix a harmless compiler warning. check-in: 34343c4b user: drh tags: trunk
11:47
Fix an indentation error and improve the placement of an assert() based on a tweet from Yuri Kotov. check-in: e6314e38 user: drh tags: trunk
11:38
Add more test cases from Yongheng Chen and Rui Zhong. check-in: f24e6ca4 user: drh tags: trunk
10:14
Fix a crash that could occur if a sub-select that uses both DISTINCT and window functions also used an ORDER BY that is the same as its select list. check-in: bcdd66c1 user: dan tags: trunk
00:42
Revise the SQLITE_OPEN_NOFOLLOW so that it actually uses O_NOFOLLOW in the open() system call. This backs out the SQLITE_ACCESS_SYMLINK value but adds the new SQLITE_OK_SYMLINK return code from the xFullPathname method of sqlite3_vfs when that routine resolves symbolic links. O_NOFOLLOW is always included in open() system calls for journal files. check-in: 6a64fb6a user: drh tags: trunk
2019-11-21
20:24
Add all fuzz-test cases received from Yongheng Chen and Rui Zhong. Also fix a minor problem in gencol1.test cases. check-in: ac080432 user: drh tags: trunk
20:10
Fix an out-of-bounds array reference in the generated column logic. Problem discovered by valgrind. check-in: a0ab42f7 user: drh tags: trunk
19:37
Whenever a generated column is used, assume that all columns are used. check-in: 6601da58 user: drh tags: trunk
18:28
Fix a problem that comes up when using generated columns that evaluate to a constant in an index and then making use of that index in a join. check-in: 8b12e95f user: drh tags: trunk
17:14
Fix a recently introduced memory leak in the test code in test_vfs.c. check-in: 2d53a30c user: dan tags: trunk
14:20
Prevent direct and indirect recursive content= options in fts3/4 and fts5. check-in: 2eb99732 user: dan tags: trunk
2019-11-20
16:10
Fix a use-after-free problem in the test suite. No changes to production code. check-in: 0d1055a5 user: dan tags: trunk
13:31
Further improve detection of corrupt records in fts3. Also fix an error with check-in [dfcf081d842629a0] check-in: a0f6d526 user: dan tags: trunk
12:07
Changes to extensions and test logic so that the build works with gcc and with -std=iso9899:1999 check-in: 2575a68c user: drh tags: trunk
2019-11-19
21:22
Enhancements to DBSTAT: (1) Make name=? queries efficient. (2) Add the ability to aggregate results across each individual btree using the aggregate=TRUE constraint in the WHERE clause. check-in: a48f6e17 user: drh tags: trunk
18:48
Get the aggregate=TRUE feature working on the DBSTAT virtual table. Closed-Leaf check-in: 16fef3db user: drh tags: dbstat-enhancements
14:01
Begin an enhancement effort for the built-in DBSTAT virtual table. check-in: 9b5722f0 user: drh tags: dbstat-enhancements
00:13
Make the result of sqlite3_normalized_sql() survive its statement being reprepared. check-in: 4330f079 user: mistachkin tags: trunk
2019-11-18
23:48
Add support for the SQLITE_ACCESS_SYMLINK flag in the Win32 VFS. check-in: 175c1500 user: mistachkin tags: trunk
22:34
Ensure all file names passed to the VFS layer are double-zero terminated. check-in: 251230cf user: mistachkin tags: trunk
18:43
In the SQLITE_OPEN_NOFOLLOW processing, distinguish between an I/O error on the xAccess() call and an actual symlink encounter. check-in: 2e98b42f user: drh tags: trunk
17:46
Add support for SQLITE_OPEN_NOFOLLOW. check-in: cb79c828 user: drh tags: trunk
14:04
Improvements to detection of corruption in the %_stat shadow table of FTS4. check-in: 6b67eba5 user: drh tags: trunk
12:04
Further improvements to shadow table corruption detection in FTS3. check-in: e35d8c76 user: drh tags: trunk
11:14
Detect and prevent infinite recursion in fts3SelectLeaf() due to a malformed FTS3 btree. check-in: dfcf081d user: drh tags: trunk
10:37
Improved detection of corruption in the %_stat table of FTS4. Chromium ticket 1025467. check-in: 10f8a3b7 user: drh tags: trunk
2019-11-17
11:47
Fix an assert that can fail if the schema is corrupt. check-in: ed57c48e user: drh tags: trunk
02:41
Better detection of corruption in the %_stat and %_docsize shadow tables of FTS3. check-in: 1e449687 user: drh tags: trunk
00:08
Remove a reachable NEVER() in FTS3. check-in: 8bd75bf6 user: drh tags: trunk
2019-11-16
23:47
More improvements to shadow table corruption detection in FTS3. check-in: 51525f9c user: drh tags: trunk
21:40
Improved detection of corrupt shadow tables in FTS3. Enable the debugging special-inserts for FTS3 for both SQLITE_DEBUG and SQLITE_TEST. check-in: 04b2873b user: drh tags: trunk
18:36
Do not allow shadow tables to be dropped in defensive mode. Leaf check-in: 0a988ce3 user: drh tags: apple-osx
18:30
Modify three test cases so that they work even with unusual versions of the library printf(). check-in: c2528907 user: drh tags: apple-osx
16:54
More restrictions on changes to shadow tables when in defensive mode. check-in: bae76a5c user: drh tags: trunk
14:15
Do not allow CREATE TABLE or CREATE VIEW of an object with a name that looks like a shadow table name. Closed-Leaf check-in: 6aef58b6 user: drh tags: defensive-improvements
13:51
Break out the test for writable shadow tables into a separate subroutine. check-in: 8ad34d36 user: drh tags: defensive-improvements
12:04
Do not allow shadow tables to be dropped in defensive mode. check-in: 70390bbc user: drh tags: trunk
11:33
Fix a potential NULL pointer dereference on a RENAME TABLE that references a VIEW with a logic error in a window function in the ORDER BY clause. check-in: 0adb273f user: drh tags: trunk
2019-11-15
21:16
Modify three test cases so that they work even with unusual versions of the library printf(). check-in: 8f4a3750 user: drh tags: trunk
02:52
Merge the version 3.30.1 changes into the apple-osx branch. check-in: 2c8af352 user: drh tags: apple-osx
00:52
Fix table-valued functions so that they will work as the right table in a LEFT JOIN. Ticket [2ae0c599b735d59e] check-in: 2c35d3f6 user: drh tags: trunk
2019-11-14
23:08
Backport support for the sqlite3_hard_heap_limit64() interface and the hard_heap_limit pragma to the 3.30 branch. Leaf check-in: ba27012d user: drh tags: branch-3.30
18:07
Add support for the sqlite3_hard_heap_limit64() interface and the hard_heap_limit pragma. check-in: 6399c47e user: drh tags: trunk
17:46
Fix a bug in the hard_heap_limit pragma so that it returns the new value of the hard_heap_limit, not the soft_heap_limit. Change SQLITE_MAX_MEMORY so that it works by setting the default hard_heap_limit value. Closed-Leaf check-in: 33fd0c3a user: drh tags: hard-heap-limit
15:21
Merge recent enhancements from trunk. check-in: b8a631fd user: drh tags: hard-heap-limit
15:10
Minor documentation enhancements. No changes to code. check-in: 6153f3aa user: drh tags: hard-heap-limit
13:57
New test cases added to fuzzdata8.db. check-in: 5baffcda user: drh tags: trunk
13:24
Ensure that the same subquery does not go through the window-function rewrite more than once, even when that subquery is part of a virtual table constraint that lacks the omit flag. check-in: d0bc7db6 user: drh tags: trunk
2019-11-13
18:50
Add header guard to the expert extension. check-in: 7e315185 user: mistachkin tags: trunk
16:50
Fix the sqlite3TreeView() output to consistently use a colon and not a comma after the table number in the AST dumps. check-in: fa2416f6 user: drh tags: trunk
2019-11-12
16:21
For for the previous check-in: Always enable the nUri variable, even when debugging is turned off. check-in: f84a1539 user: drh tags: trunk
14:43
Ensure that the main filename and the journal filenames in the pager object are all correctly double-zero terminated. check-in: df51ae19 user: drh tags: trunk
03:45
Remove a harmless unused variable. check-in: 28091a48 user: drh tags: trunk
2019-11-11
15:13
Remove an asm() block from build tool mksourceid.c, as it causes build failures on some systems and performance is not important at build-time. check-in: 8e100e6c user: dan tags: trunk
2019-11-10
11:09
Proper surrogate pair decoding added to JSON functions. See the mailing list bug report and https://bugs.python.org/issue38749. More test cases needed here, but it seems to work so far. check-in: 51027f08 user: drh tags: trunk
10:08
Remove an incorrect ALWAYS() macro. check-in: f7a74f89 user: drh tags: trunk
2019-11-09
15:31
Change the COLFLAG_NOTAVAIL bitmask so that it fits in the single-byte Walker.eCode field. check-in: 53847f5c user: drh tags: trunk
14:44
New dbsqlfuzz test cases added. check-in: 18c3a17d user: drh tags: trunk
14:38
Make sure the WITH stack in the Parse object is disabled following an error. check-in: de6e6d68 user: drh tags: trunk
2019-11-08
20:13
When a virtual table reports orderByConsumed, that tells us nothing about whether or not the SQLITE_DISTINCTBY constraint is met. Fix for ticket [7e59041f9c4e5102]. Test cases in TH3. check-in: b59f94e4 user: drh tags: trunk
2019-11-07
19:59
Experimental branch to provide SQLITE_LIMIT_HEAP_K to limit the amount of allocated memory used by each database connection, individually. Leaf check-in: 4ab9dbb9 user: drh tags: limit_heap_k
14:51
Fix the xferCompatibleIndex() function so that it recognizes that a PRIMARY KEY index for a WITHOUT ROWID table is different from a UNIQUE constraint index on the primary key. Ticket [302027baf1374498] check-in: 34f64f11 user: drh tags: trunk
02:32
Restore generated column loop detection logic that was incorrectly removed from the previous check-in [9e07b48934e9a972]. This fixes ticket [299b50ba812d8e54] check-in: 104a2beb user: drh tags: trunk
2019-11-06
22:19
Change the way generated columns are computed so that no column is computed inside branch code that might not be taken. Ticket [4fc08501f4e56692] check-in: 9e07b489 user: drh tags: trunk
19:25
Minor simplification to the changes from check-in [36c11ad51f]. check-in: 7bc8205d user: mistachkin tags: trunk
17:31
Fix the OP_DeferredSeek index-to-table column map in P4 so that it works with generated columns. Ticket [ce22a07731530118] check-in: 36c11ad5 user: drh tags: trunk
14:49
Fix the handling of NOT NULL constraint violations for generated columns in a REPLACE statement. Ticket [2399f5986134f79c] check-in: 77b1c90a user: drh tags: trunk
2019-11-04
12:49
Changes an unreachable testcase() into an assert(). check-in: 5710845b user: drh tags: trunk
02:05
Fix a false-postive in the sqlite3ExprImpliesNonNullRow() decision routine, that resulted in an incorrect LEFT JOIN strength reduction when the WHERE clause contained a row-value comparison. Ticket [02aa2bd02f97d0f2] check-in: ea20068e user: drh tags: trunk
2019-11-03
00:07
The optimization of check-in [9b2879629c34fc0a] is incorrectly reasoned. The WHERE clause of the partial index might not be true if the table of the partial index is the right table of a left join. So disable the optimization in that case. Ticket [623eff57e76d45f6] check-in: 3be19e11 user: drh tags: trunk
2019-11-02
17:59
Fix a problem in VIEW creation that was introduced by the generated columns feature. check-in: 9c795c4d user: drh tags: trunk
13:45
"STORED" is not actually a keyword. The parser looks for STORED as an ordinary identifier. check-in: 167cd574 user: drh tags: trunk
13:32
In sqlite3GenerateIndexKey(), do not attempt to reuse column values from the previous index if the current index is a partial index as the partial index test may have changed those values. Ticket [a9efb42811fa41ee] check-in: 17e9f658 user: drh tags: trunk
00:00
Restore the on-line ".help" for the ".explain" command in the CLI. check-in: 28b8f103 user: drh tags: trunk
2019-11-01
18:52
Fix a harmless compiler warning. check-in: f0ebea35 user: drh tags: trunk
17:31
The SET DEFAULT and SET NULL conflict resolution actions for foreign key constraints should cause an error when they appear on a generated column. check-in: b47513d2 user: drh tags: trunk
16:37
Fix a potential use-after-free bug that follows an OOM error in code added two days ago by check-in [84e02d773d60cffe]. Problem discovered by OSSFuzz. check-in: 0a2eb949 user: drh tags: trunk
16:08
Add another missing column number translation to the foreign key logic. check-in: 32df5edc user: drh tags: trunk
15:19
Omit the optimization that reduces the column-count on rowid-table cursors when the table has generated columns, because we do not know what columns the generator expressions might try to access. check-in: e6c96ed9 user: drh tags: trunk
13:37
Fix an fts3 assert() that could fail when operating on a database containing corrupt records. check-in: 7c52f547 user: dan tags: trunk
12:14
Add missing column translations to foreign key logic. Ticket [c28a01da72f8957c] check-in: bc6a43e7 user: drh tags: trunk
10:49
Fix a potential array bounds overflow in the mkkeywordhash.c code generator. Also add marks to omit keywords specific to generated columns when building with -DSQLITE_OMIT_GENERATED_COLUMNS. check-in: cc6a4081 user: drh tags: trunk
02:30
Slightly faster keyword hash table. check-in: f12e743e user: drh tags: trunk
2019-10-31
20:54
Correctly generate pre-UPDATE content for virtual columns that are used by foreign key constraints. Ticket [b9befa4b83a660cc] check-in: 40d3282e user: drh tags: trunk
17:13
Add a few simple TCL test cases for generated columns. (Full test coverage of the generated column logic is provided separately by TH3.) check-in: acedb5c7 user: drh tags: trunk