/ Timeline
Login

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

200 most recent check-ins using file ext/fts5/fts5_test_tok.c version 80de1a4b

2019-01-22
18:20
Add the SQLITE_ENABLE_EARLY_CURSOR_CLOSE compile-time option which causes read cursors to be closed after their usefulness ends during a two-pass UPDATE. Leaf check-in: 8790368b user: mistachkin tags: branch-3.26
2018-12-29
20:47
Merge latest begin-concurrent changes with this branch. check-in: 1625887c user: dan tags: begin-concurrent-wal2
20:42
Fix a problem causing a corrupt pager-cache if an OOM or IO error was encountered while committing a concurrent transacation. check-in: 48ca30f9 user: dan tags: begin-concurrent
16:34
Increase coverage provided by permutation "coverage-wal" on this branch. check-in: f664f940 user: dan tags: begin-concurrent-wal2
2018-12-28
16:20
Add new test file wal2rollback.test to this branch. check-in: 85a376fc user: dan tags: wal2
2018-12-27
20:12
Fix another problem with corrupt database handling in fts5. check-in: fb0d7fba user: dan tags: trunk
17:11
Merge latest wal2 changes with this branch. check-in: ea96001e user: dan tags: begin-concurrent-wal2
16:55
Modify the btree02.test module so that it does not depend on whether TCL interprets a value as a string or as an integer. check-in: d9e4f957 user: drh tags: trunk
16:49
Increase test coverage of wal.c provided by permutation "coverage-wal" on this branch. check-in: 2f7f893a user: dan tags: wal2
15:36
Fix another problem in fts5 caused by a corrupt schema record. check-in: ff45f9dd user: dan tags: trunk
13:52
Fix the filename normalization in the dbtotxt utility program. check-in: 29a00a05 user: drh tags: trunk
07:46
Fix a null-pointer dereference that could occur in fts5 with a corrupt database. check-in: b0a49d5e user: dan tags: trunk
02:16
Fix a problem in which nested CTEs with the same table name trick the code generator into thinking they are the same CTE, which then tries to use the manifest them both into the same transient table. check-in: 202dd033 user: drh tags: trunk
00:30
In the treeview debugging output, provide additional details for the Table object associated with each FROM clause term. check-in: 11d4682d user: drh tags: trunk
2018-12-26
20:42
Improve testing of the wal.c changes on this branch. check-in: 63483e22 user: dan tags: wal2
19:10
Merge latest trunk changes with this branch. check-in: 404f9d99 user: dan tags: wal2
18:34
Update the coverage-wal permutation to cover branches enabled by SQLITE_ENABLE_SNAPSHOT. check-in: 6821c61f user: dan tags: trunk
17:49
Add a few more test cases to walvfs.test. check-in: 14a64df3 user: dan tags: trunk
16:57
Avoid an "uninitialized value read" problem in fts5 that can occur with a corrupt database. check-in: 6cae81cd user: dan tags: trunk
16:04
Fix a problem with handling corrupt databases in the fts5 integrity-check function. check-in: 9bad745d user: dan tags: trunk
15:04
Here is the beginnings of an effort to factor out the implementation of scalar subqueries to be implemented as subroutines at the end of the main body of bytecode, after the jump back to the OP_Init opcode. This is an incremental check-in that contains only preliminary changes. check-in: 50e5f390 user: drh tags: factor-out-scalar-subselect
14:15
Fix a problem with corrupt fts3 database detection introduced by [95a9a39f]. check-in: c80bb15b user: dan tags: trunk
12:50
Fix a problem with the CSV extension when it uses the "header" option on a real file. check-in: 7acaed08 user: drh tags: trunk
2018-12-25
11:17
Fix a typo in a comment that is used to generate session documentation. check-in: a1f50d57 user: drh tags: trunk
00:15
Increase the number of parameters to sqlite3WhereCodeOneLoopStart() to encourage the compiler to inline that routine within sqlite3WhereBegin(). This gives a performance improvement. check-in: 3c2ad0e9 user: drh tags: reuse-subqueries
2018-12-24
20:21
Improvements to EXPLAIN QUERY PLAN formatting. The MULTI-INDEX OR now shows a separate "INDEX" subtree for each index. SCALAR SUBQUERY entries provide a subquery number that is related back to the .selecttrace output. check-in: 7153552b user: drh tags: reuse-subqueries
20:00
Add a few more test cases to walfault2.test and walvfs.test. check-in: 3873941c user: dan tags: trunk
19:59
Change another fts5 assert() that may fail with a corrupt database to an assert_nc(). check-in: d9653380 user: dan tags: trunk
18:51
Add test cases to test file walvfs.test. check-in: d697f6f3 user: dan tags: trunk
18:10
Always include OP_Explain opcodes in the bytecode when SQLITE_DEBUG is enabled. check-in: d8c1235c user: drh tags: trunk
15:22
Copy some extra test infrastructure from the mutexfree-shmlock branch to trunk. check-in: 883337ff user: dan tags: trunk
15:15
Merge latest trunk with this branch. Leaf check-in: 606b1ead user: dan tags: mutexfree-shmlock
14:30
Restore a line of code that was previously commented out for debugging. check-in: e53781f5 user: drh tags: reuse-subqueries
13:34
Change the way a comparison used to detect corrupt databases in fts3 is done to avoid potential pointer overflow in 32-bit builds. check-in: 95a9a39f user: dan tags: trunk
12:09
Do not generate subroutines for non-static SELECT and EXISTS expressions. Fix up some test cases to account for the minor changes in EXPLAIN QUERY PLAN output. check-in: 06de44ec user: drh tags: reuse-subqueries
11:55
Prevent the use of subroutines to implement the RHS of IN operators within CHECK constraints. check-in: 6b24d3fb user: drh tags: reuse-subqueries
02:34
Experimental code that tries to put the computation of subqueries inside a subroutine, and reuse that subroutine if the same subquery is evaluated more than once. Current code does not work for CHECK constraints. check-in: 6c44838a user: drh tags: reuse-subqueries
2018-12-23
21:27
Split the code generation for the RHS of IN operators and for SELECT and EXISTS expressions into two separate subroutines, because there is now little commonality between those to functions. This is intended to help make the code easier to read and maintain. check-in: 2b6494b1 user: drh tags: trunk
2018-12-22
20:32
Improve the coverage of wal.c provided by the "coverage-wal" test permutation. check-in: 62314851 user: dan tags: trunk
19:54
Catch another case of a corrupted structure record in fts5. check-in: fb17fea4 user: dan tags: trunk
19:09
Change a faulty assert() in fts5 that could fail on a corrupt db to an if() statement. check-in: 1daaba9f user: dan tags: trunk
16:14
Fix one more instance of excess whitespace in test result strings. check-in: c064964d user: drh tags: trunk
15:50
Enhance the wal2 header comment in wal.c to explain how the wal-hook is invoked in wal2 mode. check-in: 118aa7e3 user: dan tags: wal2
15:46
Remove unnecessary whitespace from testcase result strings. check-in: ad70f03c user: drh tags: trunk
15:21
Fix an assert() in fts5 that could fail with a corrupt database. check-in: 83935b95 user: dan tags: trunk
13:34
Fix a "jump or move depends on uninitialized value" valgrind error that could occur in fts5 when dealing with a corrupt database. check-in: 3518c09b user: dan tags: trunk
09:39
Avoid a left-shift of a negative value (undefined behaviour) when dealing with a corrupt database in fts3. check-in: b851d124 user: dan tags: trunk
07:16
Fix cut-and-paste error in test file fts4umlaut.test. check-in: cad5da1b user: dan tags: trunk
01:13
Do not all REPLACE to sneak a NULL value into a NOT NULL column. Detect that situation and ABORT instead. Fix for ticket [e6f1f2e34dceeb1ed61531c7e98]. check-in: db8d1d12 user: drh tags: trunk
00:34
The OP_Eq and OP_Ne operators have a special P5 value SQLITE_NOTNULL that asserts that the values are not null. Except that is not always true for a corrupt database. Adjust the assert() and add a testcase() to make this point clear. check-in: a3fdb2c7 user: drh tags: trunk
2018-12-21
22:11
Update the dbtotxt utility program so that it does not output characters that are special to TCL, thus making the output of dbtotxt easier to insert into test scripts. check-in: 48438bb3 user: drh tags: trunk
22:08
Improved detection of shadow table corruption in RTREE. check-in: b39bf435 user: drh tags: trunk
20:18
Add new sqlite3_prepare_v3() flag SQLITE_PREPARE_NO_VTAB, for preparing statements that are not allowed to use any virtual tables. Use this to prevent circular references in triggers on virtual table shadow tables from causing resource leaks. check-in: da587d18 user: dan tags: trunk
19:55
Use SQLITE_PREPARE_NO_VTAB in rtree as well. Closed-Leaf check-in: 82a2ae71 user: dan tags: prepare-no-vtab
19:30
Add tests for the use of SQLITE_PREPARE_NO_VTAB in fts5. check-in: 19996120 user: dan tags: prepare-no-vtab
19:29
Add new sqlite3_prepare_v3() flag SQLITE_PREPARE_NO_VTAB, for preparing statements that are not allowed to use any virtual tables. Use this to prevent circular references in triggers on virtual table shadow tables from causing resource leaks. check-in: 25666e3d user: dan tags: prepare-no-vtab
18:51
In FTS3, avoid calling memcpy() with a NULL source pointer, even if the transfer amount is zero bytes. check-in: 1abb83d2 user: drh tags: trunk
18:50
The fts4umlaut.test module requires FTS5, so do not try to run it without that module. check-in: dee3ae90 user: drh tags: trunk
18:17
Fix the node hash function in RTREE to ensure that it always returns a non-negative value. check-in: 0bf4c70a user: drh tags: trunk
17:51
Fix a potential NULL-pointer deference in RTREE due to corrupt shadow tables. check-in: 1fdd3604 user: drh tags: trunk
16:53
Prevent an infinite loop in rtree that can result from a corrupt shadow table. check-in: 08566718 user: drh tags: trunk
15:13
Fix the RTree extension so that it correctly ignores constraints that it does not understand, even if they are against a dimension column. check-in: ed8531e5 user: drh tags: trunk
13:30
In RTREE, turn an assert() into an if() because the condition can sometimes be false when dealing with a corrupt database. check-in: 99bce435 user: drh tags: trunk
11:53
Remove an assert() that could fail on a corrupt db from fts3_write.c. check-in: 4cdcda40 user: dan tags: trunk
2018-12-20
22:08
Do not set the Cursor.seekOp test variable in the OP_NotExists opcode. This is a change to test logic only and does not affect deliverable builds. check-in: 98f34307 user: drh tags: trunk
17:32
Fix a bug in the code that detects self-referencing rows as part of foreign key processing. Fix for [50d2a6c2]. check-in: 16fff053 user: dan tags: trunk
15:04
Fix a segfault caused by using the RAISE function incorrectly (library now returns an error instead of crashing). check-in: ddf06db7 user: dan tags: trunk
2018-12-18
20:31
In defensive mode, do not allow shadow tables to be renamed using ALTER TABLE. check-in: 23e200da user: dan tags: trunk
19:46
Add the "mutexfree-shmlock" patch to this branch. check-in: c3191fc8 user: dan tags: begin-concurrent-pnu-wal2
18:16
Fix a test script problem in wal2savepoint.test. check-in: e388d029 user: dan tags: begin-concurrent-pnu-wal2
18:01
Merge the wal2 feature into this branch. check-in: a2c618c0 user: dan tags: begin-concurrent-pnu-wal2
17:47
Merge latest begin-concurrent changes into this branch. check-in: a93ca38b user: dan tags: begin-concurrent-pnu
17:32
Merge latest trunk changes into this branch. check-in: b3a163b4 user: dan tags: begin-concurrent-wal2
17:20
Merge latest trunk changes into this branch. check-in: 123cbb33 user: dan tags: begin-concurrent
16:24
Add the ".integrity_check" command to tserver. check-in: fa46fa3b user: dan tags: begin-concurrent-wal2
2018-12-17
22:19
Move variable declaration to address compilation issue (C89). check-in: d64f248d user: mistachkin tags: trunk
18:26
Add wal2 related tests to this branch. check-in: 56458220 user: dan tags: begin-concurrent-wal2
15:22
Merge changes from wal2 branch. check-in: 85f49f0d user: dan tags: begin-concurrent-wal2
15:22
Add extra test case to wal2recover.test. check-in: 1a5aa734 user: dan tags: wal2
2018-12-15
20:59
Merge latest wal2 changes into this branch. check-in: 06bb80ee user: dan tags: begin-concurrent-wal2
20:20
Further test cases for wal2 mode. check-in: 9cb5f8da user: dan tags: wal2
07:12
Fix errors in comments in fts5.h. check-in: 4002790d user: dan tags: trunk
2018-12-14
21:58
Experimental support for new sqlite3_bind_blob() and sqlite3_bind_text() interfaces that take an extra void* argument that is passed into the destructor in front of the object that is to be destroyed. Leaf check-in: 33a1924e user: drh tags: custom-destructors
19:53
Add further tests for wal2 mode. check-in: 54e628f9 user: dan tags: wal2
18:11
Fix harmless compiler warnings. check-in: 27221c69 user: drh tags: trunk
17:57
Fix possible integer overflow while running PRAGMA integrity_check on a database file with a badly corrupted freelist. check-in: 39559911 user: drh tags: trunk
16:20
Back out the expansion of the temporary buffer size from [32754ca6f86da816] and replace it with an explicit test for buffer overreads. check-in: 8ba3d9f3 user: drh tags: trunk
16:00
Avoid a buffer overread in ptrmapPutOvflPtr() that can occurs in a corrupt database file that has large entries and uses autovacuum. check-in: f8b781cf user: drh tags: trunk
13:47
Fix a harmless compiler warning in Sessions. check-in: fc9791ea user: drh tags: trunk
13:35
Expand the size of the temporary page used during btree rebalancing by a few bytes, to avoid problems with small buffer overreads that can occur on corrupted database files. check-in: 32754ca6 user: drh tags: trunk
13:18
When saving the position of a cursor at the b-tree layer, allocate a few extra bytes at the end of the buffer used to save the key. Otherwise, if the key is corrupt, the code that restores the cursor position may overread the buffer by a little. check-in: 160b1e31 user: dan tags: trunk
11:16
Fix a problem with bytecode generation when a query involves two or more indexes on expressions connected by OR. Ticket [d96eba87698a428c1ddd0790ea04] check-in: 7e4ed8b5 user: drh tags: trunk
08:40
Possible fix for [d96eba87]. Closed-Leaf check-in: 89a25abf user: dan tags: tkt-d96eba87
03:16
Report corruption when an attempt is made to write a pointer-map page that is also being used as a btree page. Also, fix a bug in fuzzcheck that cause it to overlook a pointer-map bug that was trigger by the fuzzcheck test data, and also fix the pointer-map bug. check-in: cc42dd15 user: drh tags: trunk
03:14
Detect when an attempt is made to write to a pointer map page that is also being used as a btree page and report corruption. Closed-Leaf check-in: 3036fd71 user: drh tags: fuzzcheck-fix
02:29
Fix a bug in the custom in-memory VFS used by fuzzcheck. This bug masks other bugs that should have caused some existing fuzzdata7.db entries to fail, and so this fix is initially on a branch until those other bugs can be repaired. check-in: e0994e99 user: drh tags: fuzzcheck-fix
2018-12-13
22:58
Fix the dbtotxt decoder in the CLI so that it ignores excess bytes. check-in: 18740bd4 user: drh tags: trunk
21:52
dbfuzz2 found a NEVER() that is sometimes true. check-in: 1201615c user: drh tags: trunk
21:11
Add extra tests for database corruption inside the defragmentPage() routine, as dbfuzz2 has found ways for corruption to leak into that point. Add test cases in fuzzdata7.db. check-in: 997b6511 user: drh tags: trunk
21:05
Fix a problem in sqlite3BtreeDelete() in which deleting an entry from a corrupt database can leave a btree page with zero cells. check-in: 682053d1 user: drh tags: trunk
20:49
Add the "decode_hexdb" TCL command to testfixture. Add the dbfuzz001.test module to demonstration how to use decode_hexdb to deserialize a dbtotxt database description for use in a corruption test. check-in: 1f583c53 user: drh tags: trunk
18:59
Fix the CLI to keep proper track of input line numbers for use in error messages, even after processing in-line hex database inputs using ".open --hexdb". check-in: 7ffa9858 user: drh tags: trunk
18:30
Fix the CLI so that the ".open --hexdb" command works even if it is contained in a subscript that is read using ".read". check-in: 67a87399 user: drh tags: trunk
16:26
Add tests cases for recovery in wal2 mode. check-in: 34f56f8a user: dan tags: wal2
15:52
Merge the dbtotxt enhancement from trunk. Closed-Leaf check-in: b386fce9 user: drh tags: dbfuzz2-cases
15:06
Add the "dbtotxt" utility program and the ability to read "dbtotxt" output as a deserialized input database in the CLI, using the --hexdb option to the ".open" command. check-in: e3bf1d3e user: drh tags: trunk
12:37
Include OPTS in the build of dbfuzz2. check-in: eac9c0c4 user: drh tags: trunk
12:28
Fix the Makefile so that it honors CFLAGS when building sessionfuzz. check-in: 54231ac4 user: drh tags: trunk
03:36
New database corruption test cases discovered by dbfuzz2. The new cases have been added to test/fuzzdata7.db, but have not yet all been fixed, so tests will not currently pass. check-in: b4210d32 user: drh tags: dbfuzz2-cases
2018-12-12
21:34
Fix another problem found by Matthew Denton's new fuzzer. check-in: 2b690dbd user: drh tags: trunk
20:39
Add new test file wal2big.test. check-in: e3e50bcd user: dan tags: wal2
20:11
Remove an ALWAYS() from a branch that is not always taken. The test case found by OSSFuzz has been added to TH3. check-in: 5c7dab85 user: drh tags: trunk
19:04
Add tests to ensure that each of the 4 wal read-locks does what it is supposed to. check-in: 4d5779f3 user: dan tags: wal2
11:57
OSSFuzz found a case where an assert() inside sqlite3ExprCompare() can be true. Test case added to TH3. check-in: bc891ac6 user: drh tags: branch-3.26
11:54
Fix a problem with using "<db>-vacuum" (the default) as the state database when resuming an RBU vacuum. check-in: 6b7567fc user: drh tags: branch-3.26
11:50
Do not use a partial index as a table scan in an IN operator. Fix for ticket [1d958d90596593a77420e59]. check-in: c1c735a8 user: drh tags: branch-3.26
11:23
OSSFuzz found a case where an assert() inside sqlite3ExprCompare() can be true. Test case added to TH3. check-in: 23b62fb1 user: drh tags: trunk
2018-12-11
17:56
Change the way wal2 locks work to ensure a reader only ever has to lock a single slot. check-in: 18b2c23a user: dan tags: wal2
13:44
Merge latest trunk changes into this branch. check-in: d8dd98a3 user: dan tags: wal2
12:51
Small performance improvement in sqlite3_step(). check-in: d1db8d58 user: drh tags: trunk
12:20
Small performance improvement in the sqlite3_bind() family of interfaces. check-in: 1dc0c3df user: drh tags: trunk
2018-12-10
20:01
Further refinements to the sqlite3_normalized_sql() interface. TH3 now gives 100% MC/DC on that interface. check-in: c96bf6cc user: drh tags: trunk
18:15
Refactor the sqlite3_normalized_sql() implementation. check-in: 06e955e5 user: drh tags: trunk
16:53
Merge latest mutexfree-shmlock changes into this branch. Leaf check-in: 186b376e user: dan tags: begin-concurrent-pnu-mutexfree-shmlock
16:52
Make SQLITE_MFS_NSHARD a compile time setting. check-in: b9a74151 user: dan tags: mutexfree-shmlock
16:49
Fix issues with the new normalizer. Leaf check-in: 057d7d40 user: drh tags: normalize-refactor
16:00
Refactor the sqlite3_normalized_sql() implementation. This is a work-in-progress. There are still issues. check-in: a4c890b0 user: drh tags: normalize-refactor
15:58
Merge the latest version of mutexfree-shmlock with this branch. check-in: 6007abfe user: dan tags: begin-concurrent-pnu-mutexfree-shmlock
15:51
Add extra tests to shmlock.test (direct testing of xShmLock methods). check-in: d2c785f9 user: dan tags: mutexfree-shmlock
15:24
Rework the SQLITE_MUTEXFREE_SHMLOCK code to reduce contention. check-in: d9157dd1 user: dan tags: mutexfree-shmlock
09:45
Avoid a mutex in-and-out in unixShmBarrier() on this branch. Use __sync_synchronize() instead. check-in: a8c5fd86 user: dan tags: mutexfree-shmlock
09:36
Avoid a mutex in-and-out in unixShmBarrier() on this branch. Use __sync_synchronize() instead. check-in: 280d1a72 user: dan tags: begin-concurrent-pnu-mutexfree-shmlock
08:41
Fix a problem with using "<db>-vacuum" (the default) as the state database when resuming an RBU vacuum. check-in: c878d741 user: dan tags: trunk
02:00
Merge enhancements from trunk. check-in: b1bbc718 user: drh tags: apple-osx
01:48
Add support for the VACUUM INTO command. check-in: 77f150b8 user: drh tags: trunk
00:41
Fix the shell1.test test for the new format of the .backup command. Closed-Leaf check-in: 9748d799 user: drh tags: vacuum-into
00:40
Merge fixes from trunk. check-in: ab1e58fa user: drh tags: vacuum-into
2018-12-09
18:55
New test case for ticket [1d958d90596593a77420e59]. check-in: b7bf3c98 user: drh tags: trunk
2018-12-08
20:30
Do not use a partial index as a table scan in an IN operator. Fix for ticket [1d958d90596593a77420e59]. check-in: 15bc915d user: drh tags: trunk
01:09
Add the --async option to the ".backup" command in the CLI. check-in: 7b6a605b user: drh tags: vacuum-into
00:43
Allow the INTO clause of VACUUM to be a text-valued expression. check-in: af172b53 user: drh tags: vacuum-into
2018-12-07
23:48
Do not allow VACUUM INTO into a file that already exists. check-in: 92f70e0f user: drh tags: vacuum-into
20:40
Merge the VACUUM simplification from trunk. check-in: 93d92a0a user: drh tags: vacuum-into
20:26
Remove a line of code from VACUUM that is no longer needed, due to the change that allows ATTACH to run within a transaction. check-in: a92c398f user: drh tags: trunk
20:25
Add multi-threaded performance test program "tserver" to this branch. Fix bugs in the begin-concurrent/wal2 integration revealed by the same. check-in: 7bd3b356 user: dan tags: begin-concurrent-wal2
17:28
Prototype implementation for the VACUUM INTO command. check-in: 036e3320 user: drh tags: vacuum-into
16:32
Fix the sqlite3_normalized_sql() interface so that it renders double-quoted string literals as "?". check-in: 0d8e1504 user: drh tags: trunk
03:01
Fix dbfuzz2.c so that it works with -DSQLITE_OMIT_INIT check-in: 9ad796a8 user: drh tags: trunk
02:01
Fix the sqlite3ExprDup() function so that it correctly duplicates the Window object list on a Select that contains window functions. Fix for ticket [f09fcd17810f65f717]. check-in: 65aafb55 user: drh tags: branch-3.26
01:56
Fix the sqlite3ExprDup() function so that it correctly duplicates the Window object list on a Select that contains window functions. Fix for ticket [f09fcd17810f65f717]. check-in: db5ed226 user: drh tags: trunk
2018-12-06
22:12
Performance improvement: Avoid using sqlite3WalkerSelectExpr() and sqlite3WalkerSelectFrom() twice, so that the compiler will in-line their implementation. Closed-Leaf check-in: 2b9258b8 user: drh tags: ticket-f09fcd17810f
22:04
Fix the sqlite3ExprDup() routine so that it makes complete duplications of subqueries containing window functions. check-in: 94017454 user: drh tags: ticket-f09fcd17810f
20:26
Add the mutexfree-shmlock experiment to the begin-concurrent-pnu branch. check-in: 3aead209 user: dan tags: begin-concurrent-pnu-mutexfree-shmlock
20:18
Experimental changes to (optionally) allow double-quoted strings to be checked against known identifiers. Leaf check-in: 73a6b8c1 user: mistachkin tags: normalize_v4
19:56
New test case that still hits an assertion fault, just to prove that the previous checkin merely made the problem more obscure and did not completely fix it. check-in: a9a3b532 user: drh tags: ticket-f09fcd17810f
19:15
Simplify the query flattener so that it does not duplicate the WHERE clause of subquery that is being incorporated into the outer query - copies it directly. This is more efficient. And it also fixes the specific test case show for ticket [f09fcd17810f65f71789525] but it does not resolve the more general problem that sqlite3ExprDup() does not correctly duplicate expressions that contain subqueries with window functions. check-in: f1b18d44 user: drh tags: ticket-f09fcd17810f
18:58
Experiment with using an atomic CPU primitive instead of a mutex for intra-process locking with the unix-excl VFS. check-in: 8f4cb9dd user: dan tags: mutexfree-shmlock
17:06
When masking bits off of sqlite3.flags, make sure the mask is 64 bits in size so as not to accidentally mask of high-order bits. check-in: 53d3b169 user: drh tags: trunk
16:54
Add test file wal2snapshot.test that should have been added as part of an earlier commit. check-in: f6baa7e1 user: dan tags: wal2
16:50
When saving off the value of sqlite3.flags, take care to preserve all 64 bits. check-in: 9c6dbcfa user: drh tags: trunk
16:11
Issue a warning whenever a double-quoted string literal is used. check-in: ac9ad504 user: drh tags: trunk
14:24
Bump the version number to 3.26.1. check-in: e97e053b user: drh tags: branch-3.26
14:11
Fix a potential NULL pointer dereference that can occur in ALTER TABLE following an OOM. Test case in TH3. check-in: 99a0951f user: drh tags: branch-3.26
13:57
Ensure that ALTER TABLE modifies table and column names embedded in WITH clauses that are part of views and triggers. check-in: e066b4e1 user: drh tags: branch-3.26
03:59
Invoking the sqlite3_trace() or sqlite3_trace_v2() interfaces cancels any sqlite3_profile() that is running. check-in: ec63d350 user: drh tags: trunk
03:13
Merge fixes from trunk. check-in: f2083ee4 user: drh tags: begin-concurrent-pnu
02:08
Merge bug fixes from trunk. check-in: 1e13aaa2 user: drh tags: begin-concurrent
02:01
Remove the unused pColHash field from the Table object. check-in: 3a2c0479 user: drh tags: trunk
01:53
Fix a potential NULL pointer dereference that can occur in ALTER TABLE following an OOM. Test case in TH3. check-in: ea50815b user: drh tags: trunk
01:08
Fix a missing mutex in the sqlite3_normalized_sql() interface when it is called on a prepared statement that did not previously have a computed normalization of the input SQL. check-in: 1a1a59c6 user: drh tags: trunk
00:08
Merge ALTER TABLE and sqlite3_normalized_sql() bug fixes from trunk. check-in: 3793e5d5 user: drh tags: begin-concurrent-pnu
00:05
Merge ALTER TABLE and sqlite3_normalized_sql() fixes from trunk. check-in: acf10b3f user: drh tags: begin-concurrent
2018-12-05
23:56
Get rid of the hash table used to track IN operators in the sqlite3_normalized_sql() implementation. Use simple integer variables instead. check-in: 272dc74f user: drh tags: trunk
23:45
The sqlite3_normalized_sql() interface should not be transforming quoted identifier names into wildcards. Fix this, and at the same time simplify the code substantially. check-in: e8540377 user: drh tags: trunk
23:25
Bungled checkin. Ignore. Closed-Leaf check-in: 9b6e9a6e user: drh tags: mistake
21:55
Fix an imbalanced lock problem in sqlite3Normalize() introduced by the simplification in [94ea6379178e3ff6a]. check-in: f6962437 user: drh tags: trunk
19:42
Increase the version number to 3.27.0 for the next development cycle. check-in: 8f8d6828 user: drh tags: trunk
18:28
Merge enhancements and the ALTER TABLE bug fix from trunk. check-in: edfc2acf user: drh tags: apple-osx
18:25
Add test cases to wal2concurrent.test. check-in: ef9e7a87 user: dan tags: begin-concurrent-wal2
17:48
Simplifications to the sqlite3_normalized_sql() implementation. check-in: 94ea6379 user: drh tags: trunk
17:36
Fix a test script problem on this branch. check-in: 692ddc28 user: dan tags: begin-concurrent-wal2
17:31
Fix a test script problem on this branch. check-in: 285d1c59 user: dan tags: wal2
17:20
Fix a problem causing "PRAGMA journal_mode" to report the wrong journal mode (wal instead of wal2) under some circumstances. check-in: bf309107 user: dan tags: begin-concurrent-wal2
17:14
Fix a problem causing "PRAGMA journal_mode" to report the wrong journal mode (wal instead of wal2) under some circumstances. check-in: 1d8d4f68 user: dan tags: wal2
16:45
Fixes for snapshots API on this branch. Also ensure that the snapshots API cannot be used with wal2 mode databases (for now anyhow). check-in: d8c2d55f user: dan tags: begin-concurrent-wal2
16:31
Fixes for snapshots API on this branch. Also ensure that the snapshots API cannot be used with wal2 mode databases (for now anyhow). check-in: 19c61ab7 user: dan tags: wal2
13:49
Merge enhancements from trunk, especially the sqlite3_normalized_sql() enhancement. check-in: 342c9538 user: drh tags: begin-concurrent-pnu
13:49
Ensure that ALTER TABLE modifies table and column names embedded in WITH clauses that are part of views and triggers. check-in: f44bc7a8 user: dan tags: trunk
13:44
Merge enhancements from trunk, especially the enhanced sqlite3_normalized_sql() interface. check-in: 47b73f6b user: drh tags: begin-concurrent
13:39
Enhance the sqlite3_normalize_sql() interface so that it works even if the prepared statement was not initially compiled using SQLITE_PREPARE_NORMALIZED. Enhance the ".trace" command in the CLI so that it is able to access the full scope of functionality provided by sqlite3_trace_v2() and in particular so that it is able to show normalized SQL output using the newly enhanced sqlite3_normalize_sql() interface. check-in: 7da617e9 user: drh tags: trunk
2018-12-04
21:16
When compiled with SQLITE_ENABLE_NORMALIZE, always have sqlite3_exec() enable the SQLITE_PREPARE_NORMALIZE flag. Leaf check-in: 28643d83 user: mistachkin tags: execWithNormalize
19:41
First attempt at making features work together. Only the most minimal testing so far. check-in: fd707001 user: dan tags: begin-concurrent-wal2
16:51
Add the "index_usage" utility program. check-in: df954552 user: drh tags: trunk
14:33
Performance improvement in sqlite3_step() by creating a new mTrace flag for the legacy xProfile pointer that is set by sqlite3_profile(). check-in: e28584e8 user: drh tags: trunk
13:51
Fix a problem with SQLITE_ENABLE_EXPENSIVE_ASSERT builds on this branch. check-in: ddb4a6fb user: dan tags: begin-concurrent
13:51
Small performance increase in sqlite3_step() for the common case where it returns SQLITE_ROW. check-in: 89344826 user: drh tags: trunk
01:18
Attempt to make the parser a little faster by storing the ON and USING clause in a single OnUsing object. Leaf check-in: 6770ed08 user: drh tags: on-using-opt
2018-12-03
23:57
Reduce the size of the parser tables generated by Lemon by splitting the yyRuleInfo structure into separate yyRuleInfoLhs and yyRuleInfoNRhs arrays. check-in: 70fe8ec2 user: drh tags: trunk
20:49
Merge the wal2 and begin-concurrent code. Both features work, but not at the same time. check-in: b7281a1c user: dan tags: begin-concurrent-wal2
20:38
Minor change to wal.c on this branch to make it more similar to trunk. check-in: 6a7af3ea user: dan tags: begin-concurrent