/ Timeline
Login

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

100 most recent check-ins that include changes to files matching 'test/*'

2019-05-20
10:36
Update the sqlite3ExprCompare() routine so that it does not think "? IS NOT TRUE" is the same as "? IS TRUE". Fix for [d3e7f2ba5b3]. Leaf check-in: 99eba69b 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: 778b1224 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: d91095ba 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: a0f5eb5c 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: 14c00b10 user: dan tags: trunk
2019-05-16
20:40
Add test cases to test/fuzzdata7.db for (harmless) dbfuzz2 finds. check-in: 1eb2a628 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
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
2019-05-14
22:25
Merge all the latest trunk enhancements into the reuse-schema branch. Leaf check-in: 018f3199 user: drh tags: reuse-schema
22:07
Merge the latest trunk and wal2 enhancements. Leaf check-in: 3deaa6e2 user: drh tags: begin-concurrent-pnu-wal2
22:02
Merge the latest trunk enhancements into the wal2 branch. Leaf check-in: 23ec34e4 user: drh tags: wal2
21:51
Merge the latest trunk enhancements into begin-concurrent-pnu. Leaf check-in: e70878b3 user: drh tags: begin-concurrent-pnu
21:51
Merge the latest trunk enhancements into begin-concurrent. Leaf 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. Leaf check-in: 40362d51 user: drh tags: apple-osx
19:20
New test cases in test/fuzzdata8.db. check-in: 228e1087 user: drh 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-11
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
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
12:06
Fix the round() SQL function so that it handles infinities correctly. check-in: db9acef1 user: drh tags: trunk
2019-05-09
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
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: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
2019-05-08
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
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
2019-05-06
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
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
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
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
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
2019-05-02
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
14:15
Merge enhancements from trunk Leaf 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
2019-05-01
19:01
Add a test case for ticket [ae0f637bddc5290b44669e066a]. check-in: ece48169 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
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
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
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-27
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
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
17:08
Omit tests of the LIKE optimization in like3.test when SQLITE_ENABLE_ICU is defined. check-in: af53c41a user: dan tags: trunk
2019-04-25
20:06
Merge latest trunk changes into this branch. check-in: 1da302d8 user: dan tags: dbdata
2019-04-24
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:13
Fix an error in fts3_write.c allowing a corrupt database to cause a crash. check-in: 6e4a5f22 user: dan tags: trunk
2019-04-23
18:03
Fixes for the ".recover" shell command. check-in: 8dcc1d89 user: dan tags: dbdata
12:31
New test cases in fuzzdata8.db. check-in: 0fe3c3fd 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
11:47
Fix an assert() that may be false for corrupt databases. check-in: b2ce5ed1 user: dan tags: trunk
2019-04-19
16:34
Fix a problem with renaming a table that starts with "sqlite". Fix for ticket [f00d7b65]. check-in: a2ead8aa user: dan 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
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
21:17
Add the experimental dbdata extension. check-in: a3ab5883 user: dan tags: dbdata
2019-04-16
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
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
2019-04-13
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
15:07
Partially revert the test file changes in [4371a0c46e]. It is no longer required following [93ae382e97c23c90]. check-in: 593a7e6e user: dan tags: trunk
2019-04-12
16:25
Test case changes so that they work with both Tcl8.6 and Tcl8.7. check-in: 7b771405 user: drh tags: trunk
13:40
Tweaks to wapptest.tcl: Ensure that the "Debug" checkbox is disabled unless the app is in "config" state, and have Debug variants run "test" instead of "fulltest". check-in: dd248c18 user: dan tags: trunk
12:10
Fix minor problems in tcl test scripts. check-in: 56b66418 user: dan tags: trunk
2019-04-11
19:07
Add the test/wapptest.tcl script, an alternative to releasetest.tcl that uses wapp to provide the user-interface. check-in: edd87cd6 user: dan tags: trunk
19:04
Merge trunk changes into this branch. Closed-Leaf check-in: d805fc0c user: dan tags: wapptest
19:03
Further tweaks to wapptest.tcl. Add the ability to run the extra (n)debug tests that releasetest.tcl runs. check-in: ec9c4f6d user: dan tags: wapptest
2019-04-10
19:45
Have wapptest.tcl display the name, OS and architecture of the host. check-in: c47e53b4 user: dan tags: wapptest
18:56
Various fixes for the wapptest.tcl script. check-in: cbf42365 user: dan tags: wapptest
2019-04-09
21:37
New test case for SQLITE_TOOBIG errors. check-in: 4c77fbbe user: drh tags: trunk
20:50
Fix a problem caused by a small SQLITE_LIMIT_LENGTH value and a CREATE TABLE with a very large name. Closed-Leaf check-in: 9b5d4088 user: dan tags: toobig-fix
19:53
Add test/wapptest.tcl, a wapp alternative to releasetest.tcl. check-in: a4af0c2f user: dan tags: wapptest
2019-04-07
18:04
Fix a faulty assert() in the sqlite3VdbeMemExpandBlob() routine. check-in: df58774e user: drh tags: trunk
2019-04-05
20:47
Add further tests so that veryquick.test covers all vdbe branches. check-in: cbc67de5 user: dan tags: trunk
2019-04-04
21:40
Merge all the latest changes and enhancements from trunk. check-in: 521d5186 user: drh tags: apple-osx
20:55
Add further test cases to improve VDBE branch coverage. check-in: 51a95e52 user: dan tags: trunk
18:20
Minor fixes to requirements marks. check-in: 02ebc60b user: drh tags: trunk
17:58
Add test cases to improve coverage of VDBE branches. Still some to go. check-in: 4cef609d user: dan tags: trunk