SQLite

Timeline
Login

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

100 descendants and 100 ancestors of 2f58c8c9722fffc4

2015-05-05
00:48
Fix #ifdef problem in tclsqlite.c. check-in: fe723bb5 user: drh tags: trunk
2015-05-04
20:25
Automatically enable the dbstat virtual table on all new database connections with the SQLITE_ENABLE_DBSTAT_VTAB compile-time option is used. check-in: 1c9c6eaa user: drh tags: trunk
19:13
In the command-line shell, and the ".binary" command and additional C-style backslash escapes. check-in: 850c1186 user: drh tags: trunk
19:06
Add the "dbstat" virtual table as a standard component in the SQLite amalgamation, though turned off unless compiled with SQLITE_ENABLE_DBSTAT_VTAB. check-in: e7529705 user: drh tags: trunk
18:31
Rename the test_stat.c source file to dbstat.c and rework the makefiles to make dbstat.c a first-class source module. Closed-Leaf check-in: a24480a4 user: drh tags: dbstat-in-amalgamation
17:06
Include the "dbstat" virtual table in the amalgamation. check-in: fc6504aa user: drh tags: dbstat-in-amalgamation
16:09
Fix a faulty assert() in the SELECT code generator and add a test case to prevent regression. check-in: 1421c8ff user: drh tags: trunk
15:04
Fix a bug in --changeset output for sqldiff.exe for floating-point values. Also fix harmless compiler warnings in sqldiff.exe. check-in: 9f428530 user: drh tags: trunk
13:25
Add the --lib option to the sqldiff.exe command-line utility. check-in: a117e8f6 user: drh tags: trunk
12:29
Add the 'y' flag to the fts3/4 matchinfo() function. check-in: aef1e8f4 user: dan tags: trunk
2015-05-02
20:35
Reorganize some of the fts5 expression parsing code. Improve test coverage of the same. check-in: c4456dc5 user: dan tags: fts5
19:54
Improvements to fuzzershell: Avoid excess memory allocations when loading many files. Show the total runtime on final output. Show individual filenames as they are processed even if they are single test-case files. check-in: 34a722a2 user: drh tags: trunk
18:25
Add the SQLITE_LIMIT_PRINTF_WIDTH setting for sqlite3_limit() and associated logic for preventing DOS attacks using printf() with oversized widths or precisions. Leaf check-in: f8b15979 user: drh tags: limit-printf-width
17:40
Add the ".limit" command to the command-line shell. check-in: 803cb60e user: drh tags: trunk
12:40
Reorganize some multi-threaded code in vdbesort.c so that full MC/DC test coverage does not depend on the outcome of a race condition. check-in: 78c7ec95 user: dan tags: trunk
11:45
Cleanup of the sqlite3StrAccumInit() function. No functionality changes. check-in: 7952c322 user: drh tags: trunk
09:44
Add the experimental matchinfo 'y' flag to fts3/4. Closed-Leaf check-in: 92941609 user: dan tags: fts3-matchinfo-y
2015-05-01
20:38
Further improvements to test coverage of fts5 code. check-in: d4331943 user: dan tags: fts5
20:34
Enhance the fuzzershell --uniquecases option to output results in order of increasing runtime and to include the runtime in the comment separator of the output. check-in: 04630b98 user: drh tags: trunk
19:21
Enhance fuzzershell to accept multiple input files. Add the test/fuzzdata2.txt fuzz test content. check-in: ab5523aa user: drh tags: trunk
18:00
Fix an assert in RTREE that would fire if the rtree table is misdeclared. check-in: 9a45409c user: drh tags: trunk
16:57
Fix an assert() failure caused by setting "PRAGMA journal_mode=off" on an database in exclusive-mode that has already opened the journal file. check-in: 40db3e40 user: dan tags: trunk
15:25
Remove obselete comment text from the description of the Table object. No changes to code. check-in: 6566b72a user: drh tags: trunk
14:07
Use the sqlite3Fts3ErrMsg() function to set error message text in FTS3, and to ensure that error messages are not overwritten and thus leaked. check-in: 605347e0 user: drh tags: trunk
12:14
Improve test coverage of fts5.c. check-in: add4f468 user: dan tags: fts5
2015-04-30
20:35
Enhance the CLI to initialize the dbstat virtual table if compiled using SQLITE_ENABLE_STAT_VTAB. check-in: 822dfc00 user: drh tags: trunk
20:33
Fix a harmless comment typo. check-in: 012a0c4e user: drh tags: trunk
20:26
Avoid dropping an error code in test function sqlite3_dbstat_register(). check-in: 9a9f633f user: dan tags: trunk
13:06
Modify the mkfuzzdata1.tcl script so that it retains the culled test vectors in the tmp2 subdirectory. check-in: 431a958f user: drh tags: trunk
12:31
Fix signed/unsigned comparison compiler warnings. Add the SQLITE_OMIT_RANDOMNESS compile-time option to cause the PRNG to be seeded identically on every run, for testing purposes. check-in: 93ce2bca user: drh tags: trunk
2015-04-29
20:54
Improve fts5 tests. check-in: c1f07a3a user: dan tags: fts5
16:50
Use sqlite3_malloc64() in place of sqlite3_malloc() internally. check-in: 48f553b0 user: drh tags: trunk
00:35
Improved support for OSTRACE on Windows. check-in: ca43812b user: drh tags: trunk
2015-04-28
20:24
Fix an fts5 bug in handling writes while there are active cursors. check-in: 07f70955 user: dan tags: fts5
18:35
Improve coverage of fts5 tests. check-in: 8e8136f2 user: dan tags: fts5
14:49
Update the test/fuzzdata1.txt file with the latest cases discovered by AFL. check-in: f2063f53 user: drh tags: trunk
14:07
Fix an assert() failure that could occur if the internal sqlite3_rename_parent() SQL scalar function was invoked directly. check-in: 36e51526 user: dan tags: trunk
14:00
Fix sqlite3VdbeMakeWritable() to always clear the MEM_Ephem flag. Change the OP_Move opcode to always deephemeralize moved content. check-in: fbb06727 user: drh tags: trunk
13:11
Oops - the deephemerialization needs to occur before the move, not after. Was: Rather than try to keep track of the parent of an ephermeral register when the register moves, just deephemeralize all registers touched by the OP_Move opcode. Closed-Leaf check-in: 091cfe8e user: drh tags: mistake
12:44
Shift the Mem.pScopyFrom pointer in the correct direction in OP_Move. Fix for a defective check-in [a2135ad13049] and ticket [d6352363751]. Debugging code only - does not affect normal operation. check-in: add4e043 user: drh tags: trunk
12:27
Add code to the shell to optionally initialize the dbstat virtual table. Closed-Leaf check-in: 7ed86dd3 user: drh tags: stat-vtab-in-shell
01:28
Fix comment typos. No code changes. check-in: 60174cf5 user: drh tags: trunk
00:53
Add a TCL script that can be run to generate the fuzzdata1.txt file. check-in: fdc79fd1 user: drh tags: trunk
2015-04-27
19:53
Add fault-injection tests for the code in test_stat.c. check-in: ea5e0b74 user: dan tags: trunk
16:21
Change the fts5 content= option so that it matches fts5 columns with the underlying table columns by name, not by their position within the CREATE TABLE statement. check-in: e38e2bb6 user: dan tags: fts5
15:08
Update the fuzzer test data after having run it through afl-cmin to remove redundant test cases. check-in: 8134d41b user: drh tags: trunk
11:31
Further tests for fts5. check-in: ffeb3ef3 user: dan tags: fts5
2015-04-25
20:29
Improve coverage of fts5_index.c slightly. check-in: e5aaa013 user: dan tags: fts5
18:56
Add tests for fts5. check-in: e748651c user: dan tags: fts5
18:39
Fix compiler warnings in sqldiff. check-in: 5f48d6f6 user: drh tags: trunk
17:45
Update the AFL fuzzer data with newly discovered paths. check-in: d9821980 user: drh tags: trunk
16:39
Fuzzershell: change the error summary output to work with releasetest.tcl. Reduce the maximum number of OOM interations. check-in: f5e6c4b2 user: drh tags: trunk
13:39
Add the fuzzoomtest target to the makefiles. Invoke fuzzoomtest from releasetest.tcl. check-in: f60657c2 user: drh tags: trunk
12:20
Fix an obscure memory leak that could follow an OOM in where.c. check-in: 08ec9f2f user: dan tags: trunk
11:35
In fuzzershell: (1) comment fixes. (2) Set and clear g.zTestName[] correctly. (3) Use the value in g.zTestName[] in error messages. check-in: b7394755 user: drh tags: trunk
11:19
In the fuzzershell, always invoke the trace and log callbacks even if output is suppressed. Keep track of the current test name in a global variable for simplified debugging. check-in: 3045f454 user: drh tags: trunk
00:32
Do not send the extra ";" and "\000" tokens to the parser if a prior error has occurred. check-in: 9aa70ddf user: drh tags: trunk
00:20
Add fflush() calls to fuzzershell to keep stderr and stdout synchronized. check-in: 2b98a252 user: drh tags: trunk
2015-04-24
23:45
Add the --oom option to fuzzershell. check-in: 14a9e4a3 user: drh tags: trunk
20:18
Merge latest trunk changes with this branch. check-in: 1c78d892 user: dan tags: fts5
19:41
Add the "unindexed" column option to fts5. check-in: 86309961 user: dan tags: fts5
18:31
Fix fuzzershell so that it works with SQLITE_OMIT_TRACE. check-in: dc88fe7e user: drh tags: trunk
17:50
Add the --with-tcl=DIR option to the test/releasetest.tcl script. check-in: 4dda916a user: drh tags: trunk
16:53
Run fuzzershell as part of the valgrindtest makefile target. check-in: 0bb96a03 user: drh tags: trunk
16:16
Add the fuzztest target to the MSVC makefile. check-in: 98edc615 user: drh tags: trunk
16:09
Add AFL-generated test cases in the test/fuzzdata1.txt file. Automatically run fuzzershell against those cases on a "make test". check-in: 627ea83c user: drh tags: trunk
15:56
Add extra tests for corrupt database handling in fts5. check-in: 41449f7a user: dan tags: fts5
14:47
Add the --unique-cases option to fuzzershell. check-in: 7cb71849 user: drh tags: trunk
13:00
Fuzzershell enhancements: (1) Add the --verbose and --quiet flags (2) Show percentage complete and final test count for multi-test inputs (3) Omit trace and result logs unless the --verbose flag is used. check-in: ed202ffa user: drh tags: trunk
06:02
Fix an fts5 build problem in main.mk. check-in: 60045ced user: dan tags: fts5
2015-04-23
19:38
Fix a problem in the "ota" utility program causing it to crash if SQLite failed to open the target database. check-in: a1a2b4a2 user: dan tags: ota-update
19:32
Merge latest trunk changes into this branch. check-in: 1506e99e user: dan tags: ota-update
17:22
Modify the sqlite3session_diff() API so that tables with no PRIMARY KEYs are ignored. This matches the other sessions APIs. Also change sqlite3session_diff() so that it returns SQLITE_SCHEMA, instead of SQLITE_ERROR, if the tables being compared do not have compatible schemas. check-in: aada0ad0 user: dan tags: sessions
15:03
Fix the error message returned by sqlite3session_diff() for tables with no PRIMARY KEY. check-in: 4d34a3d4 user: dan tags: sessions
14:40
Fix a performance problem in sqlite3session_diff(). check-in: ea400eca user: dan tags: sessions
13:49
Merge the latest trunk enhancements and fixes into the sessions branch. check-in: 4e5f17d1 user: drh tags: sessions
13:37
Fix a faulty assert() in the "AS" alias resolution logic of the parser. check-in: b5e43602 user: drh tags: trunk
13:00
Improvement to "ID" formatting on the ".selecttrace 0x1ff" debugging function. check-in: 01c50cee user: drh tags: trunk
11:52
Fix a problem causing the fts3 integrity-check to fail if run inside a transaction. check-in: 3b925189 user: dan tags: trunk
2015-04-22
20:58
Add extra OOM tests for fts5. check-in: 2dd59b57 user: dan tags: fts5
20:14
Fix problems with doclist-indexes involving very large rowids. check-in: 1e599409 user: dan tags: fts5
14:41
Prototype for an sqlite3_db_log() interface. Leaf check-in: 658e20f5 user: drh tags: sqlite3_db_log
13:16
Improved filtering of input for fuzzershell for modes other than generic. check-in: 025e8370 user: drh tags: trunk
11:16
Change the printf, strftime, and glob modes of fuzzershell so that they reject all inputs that do not start with a string literal followed by a comma. This helps the fuzzer focus in on the kinds of behavior those modes are intended to test. check-in: 1cceefa7 user: drh tags: trunk
09:40
Update this branch with latest trunk changes. check-in: 9797482d user: dan tags: fts5
01:33
When compiling for UAP, link against the new minimal MSVC runtime. check-in: 2cb94511 user: mistachkin tags: trunk
2015-04-21
17:17
Alternative fix for the double-initialization of type and collating sequence problem that leaves the estimated table size intact. check-in: 623ddbdb user: drh tags: trunk
17:07
Make sure the datatype and collating sequence of transients tables are not initialized more than once. Otherwise a memory leak results. check-in: 9e6beda2 user: drh tags: trunk
16:38
Ensure that tables names are dequoted exactly once by the trigger logic. check-in: 9d887b92 user: dan tags: trunk
16:09
Fix a memory leak in the SELECT code generator tracing logic (code that is omitted in non-debugging builds). check-in: b623ebd8 user: drh tags: trunk
15:49
Fix an obscure problem with "INSERT INTO tbl(cols) SELECT" statements where the SELECT is a compound with an ORDER BY and "cols" is a strict subset of tbl's columns. check-in: 718d5d0e user: dan tags: trunk
15:16
Change an assert() in the aggregate query code generator into a testcase(). check-in: d1e6bc91 user: drh tags: trunk
12:06
Fix an fts4 problem to do with the handling of phrases that contain zero tokens. check-in: caba5be0 user: dan tags: trunk
03:13
Fix some identifier name de-quoting issues in the foreign key and trigger logic. check-in: 59e92bd9 user: drh tags: trunk
02:17
Test case for the previous check-in. check-in: a526f58b user: drh tags: trunk
02:12
Make sure the whereSplit() routine in the query planner is not confused by the likely() operator. check-in: 588db14f user: drh tags: trunk
00:23
Enable compilation and VSIX package creation with the Visual Studio 2015 CTP. check-in: 03b725a7 user: mistachkin tags: trunk
2015-04-20
23:53
Merge updates from trunk. Closed-Leaf check-in: 583a79a0 user: mistachkin tags: vsix2015
22:36
Add the --mode option to fuzzershell. check-in: b940b0fa user: drh tags: trunk
18:58
Many new configuration options for fuzzershell. check-in: 41c95439 user: drh tags: trunk
15:13
Fix a memory leak caused by duplicate entries in the sqlite_stat1 table. check-in: 2f58c8c9 user: dan tags: trunk
13:59
Fix an obscure memory leak in sqlite3Stat4ProbeFree() check-in: c72abbe2 user: drh tags: trunk
12:50
Enhance fuzzershell to support multiple blocks of SQL, each run in its own private in-memory database. check-in: ab0a96ca user: drh tags: trunk
01:13
Add an ALWAYS() around a new branch that was made unreachable by an even newer change. check-in: 592c0104 user: drh tags: trunk
2015-04-19
23:11
Fix an off-by-one assert() in the virtual table argument tokenizer. check-in: c83052e4 user: drh tags: trunk
22:41
Fix a broken assert() and comparison for INSERT INTO ... SELECT when the SELECT uses an unknown collating sequence. check-in: e73ac0cb user: drh tags: trunk
22:31
Silently ignore parser stack overflow when parsing a malformed schema in PRAGMA writable_schema mode. check-in: 2cb37b95 user: drh tags: trunk
21:59
Fix another assert() that is not true if the database schema is corrupt. check-in: bc97cec6 user: drh tags: trunk
20:39
Fix a faulty assert in the schema parsing logic. check-in: b1ed9495 user: drh tags: trunk
19:21
Fix a potential NULL pointer deference on a corrupt database schema. check-in: dc61b292 user: drh tags: trunk
18:32
Bring comments on the INSERT code generator up-to-date. Fix the INSERT code generator so that it correctly handles inserts from a SELECT into a virtual table with non-terminal hidden columns. check-in: 4ac81fac user: drh tags: trunk
2015-04-18
19:20
The sqlite3_trace() callback does not try to expand parameters in statements that have no parameter. check-in: 917e3c36 user: drh tags: trunk
17:43
Fix an incorrect assert() statement in the CREATE INDEX code generator. check-in: 2eed41fd user: drh tags: trunk
16:25
Ensure that if a "ROLLBACK TO" statement is used to rollback (but not close) theoutermost transaction, the xRollbackTo() method of any virtual tables involved in the transaction is invoked. check-in: e98d481d user: dan tags: trunk
04:45
Disregard leading zeros when converting strings to 32-bit integers. check-in: 691cc201 user: drh tags: trunk
00:22
Fix an incorrect assert() in the sqlite3_trace() logic. check-in: eabde339 user: drh tags: trunk
2015-04-17
20:51
Fix a problem affecting some fts3 UPDATE and DELETE statements on order=DESC tables. check-in: 284c1623 user: dan tags: trunk
19:41
In the expression-tree comparison routine, do not compiler Expr.iColumn and Expr.iTable for TK_STRING expressions. check-in: b67bb16c user: drh tags: trunk
18:52
Always resolve symbols in all ORDER BY clauses of a compound-SELECT, even illegal ORDER BY clauses. check-in: 6c39ef73 user: drh tags: trunk
18:22
Remove unnecessary parser error count increments. Let the sqlite3ErrorMsg() take care of doing that. check-in: 3f3b0f68 user: drh tags: trunk
16:12
Remove an ALWAYS() that turns out to be false when there is a semantic error on a compound SELECT. check-in: ad67a67c user: drh tags: trunk
15:58
Ensure that semantic SQL errors are always reported back up to the syntax parser. Also: Improve the defense against invalid PRAGMA synchronous settings. check-in: 7aeade9a user: drh tags: trunk
15:16
Fix a faulty assert() in sqlite3SelectNew(). check-in: 620d19c3 user: drh tags: trunk
14:30
Add the tool/fuzzershell.c utility program. check-in: db8d9af4 user: drh tags: trunk
12:16
Fix the header comment on the sqldiff utility program. No code changes. check-in: b355ca3a user: drh tags: trunk
2015-04-16
23:04
Restrict the scope of a local-use function in the parser. check-in: cd6598f4 user: drh tags: trunk
21:57
Use a heap rather than a bitmap for cell coverage and overlap testing on btree pages in PRAGMA integrity_check. check-in: e94b2ef2 user: drh tags: trunk
20:27
Fix a couple of unreachable branches. check-in: 8f391dff user: drh tags: trunk
20:10
Fix a boundry-value condition in the phrase poslist extractor of FTS3/4. check-in: 55d10baf user: drh tags: trunk
18:11
Make sure all cursors are closed when returning from a VDBE subprogram that implements a foreign-key construct. check-in: d04d354d user: drh tags: trunk
17:31
Fix the VDBE so that it always uses the original opcode for profiling and debugging even after the pOp pointer has been updated due to a jump. check-in: 647495cf user: drh tags: trunk
16:22
Fix a faulty assert() in the compound-SELECT code generator. check-in: 10715b05 user: drh tags: trunk
16:04
Silently ignore requests to change the PRAGMA synchronous setting to an illegal integer value, rather than raising an assertion. check-in: e0a88176 user: drh tags: trunk
15:47
Make sure errors in coding triggers are propagated back up to the parser. check-in: 928f973c user: drh tags: trunk
15:05
Add the --backslash option to the command-line shell for testing purposes. check-in: dd96211e user: drh tags: trunk
14:33
Fix a faulty assert() in the compound select code generator. check-in: 9d336be1 user: drh tags: trunk
14:13
Improvements to the way VALUES clauses are parsed. check-in: ec5a493a user: drh tags: trunk
12:12
Fix the corruptC.test module due to a change in error message text. check-in: 7c0deed2 user: drh tags: trunk
11:56
Use a heap instead of a bitmap for cell overlap and coverage testing of btree pages in PRAGMA integrity_check. Closed-Leaf check-in: 5619c959 user: drh tags: integrity-check-heap
08:54
Fix a problem in test file e_reindex.test. check-in: 5b3de939 user: dan tags: trunk
07:19
Ensure the sqlite3Select() routine always returns non-zero if an error has occurred. check-in: b51028ed user: dan tags: trunk
00:26
When parsing the schema, ignore any SQL that does not begin with "CREATE". check-in: d3c00d61 user: drh tags: trunk
2015-04-15
19:25
Fix a potential one-byte buffer overread in the command-line shell. check-in: e018f4bf user: drh tags: trunk
17:26
Prevent the fetchPayload() routine from reporting a cell size that extends off the end of the page on a pathologically corrupted database file. check-in: f71053cf user: drh tags: trunk
15:29
Enhance the showdb utility program so that it can read the last partial page of a truncated database file. check-in: 61d72e17 user: drh tags: trunk
14:52
Add the --msvc command-line option to the releasetest.tcl script. This is only a partial merge from the winTest branch as the OS_TRACE changes are omitted. check-in: b8768f12 user: drh tags: trunk
09:16
Remove an incorrect assert() statement from sqlite3Fts3Dequote(). check-in: bd06eeb8 user: dan tags: trunk
08:37
Remove a branch that became unreachable due to one of the earlier check-ins today. check-in: fa0956ed user: drh tags: trunk
08:20
Fix a problem causing an assert() to fail if a snippet containing 0 tokens was requested from fts3. check-in: eafd0a1e user: dan tags: trunk
07:57
Fix the error message generator for illegal token errors so that it does not leak memory if it immediately follows another erroneous SQL statement. check-in: 3576973f user: drh tags: trunk
07:34
Remove an incorrect ALWAYS() from the automatic index generator. check-in: eeb4bd06 user: drh tags: trunk
07:19
Remove an incorrect ALWAYS() from the table_info pragma. check-in: 0e087c01 user: drh tags: trunk
07:10
Change the multiSelectOrderBy() routine to return non-zero if there has been any prior error. check-in: 14784c31 user: drh tags: trunk
06:45
Fix a faulty assert() statement in the name resolver associated with the optimization that converts compound selects with ORDER BY COLLATE into subqueries. check-in: c72324ef user: drh tags: trunk
05:57
Correctly handle COLLATE operators applied to COLLATE operators in an ORDER BY clause. check-in: 9e1f837b user: drh tags: trunk
05:38
Fix a faulty assert() in the sqlite3StrAccumAppend() routine. check-in: 998cfdb8 user: drh tags: trunk
05:31
Correctly deal with an unknown collating sequence on an indexed DISTINCT query. check-in: a0b6e2fe user: drh tags: trunk
05:20
When adding the implied "LIMIT 1" to the end of a scalar subquery, make sure that subquery is not a VALUES-only query as such queries cannot deal with LIMIT clauses. check-in: 7c27310b user: drh tags: trunk
04:51
When doing the (dubious) conversion of double-quoted identifier into string literal for MySQL compatibility, be sure to also clear the iTable value from the Expr entry to avoid an assert. check-in: d7211b68 user: drh tags: trunk
04:20
Add a test case for what was formerly thought to be an unreachable condition: when the LHS of an OR operator contains an error and the RHS contains an IN operator. check-in: 38727425 user: drh tags: trunk
04:10
An oversize hex literal can cause a parsing error while generating code for constants that are factored out of the main body of the VDBE program. So allow for that case. check-in: a084690b user: drh tags: trunk
2015-04-14
19:01
Add the --summary option to the sqldiff command-line tool. check-in: 88b22761 user: drh tags: trunk
15:14
Update API documentation to identify many functions as methods on objects. No changes to code. check-in: b549cbce user: drh tags: trunk
2015-04-13
23:05
Add #ifdef magic for HAVE_GETHOSTUUID so that the build will hopefully now work on more verions of MacOS with SQLITE_ENABLE_LOCKING_STYLE turned on. check-in: 211411d0 user: drh tags: trunk
22:26
On a DETACH statement, keep all schemas intact except fo the one that is being detached, and thus avoid unnecessary schema reparsing. check-in: 661db19b user: drh tags: trunk
21:39
Omit the "pc" or "program counter" variable from the VDBE loop for 0.6% performance increase. check-in: d2f10c41 user: drh tags: trunk
19:14
Remove the out2-prerelease VDBE opcode property and its associated code, for a 0.5% performance improvement. check-in: e29c7f2c user: drh tags: trunk
17:43
Add a comment to wal.c to explain why a race condition is safe. check-in: bc33af86 user: dan tags: trunk
14:44
Remove a faulty assert() from the btree balancing logic. check-in: d06669d9 user: drh tags: trunk
14:08
Test that if the definition of a collation sequence is changed and VACUUM run, the new database contains records sorted in the (new) correct order. check-in: ce6eaac1 user: dan tags: trunk
14:03
Remove an unreachable branch from the VACUUM logic. check-in: 65ace4b0 user: drh tags: trunk
12:45
Remove an unreachable branch from the vdbeSorterCompareInt() routine. check-in: f666ef06 user: drh tags: trunk
2015-04-12
21:28
Update the version number to 3.8.10 because of the new sort optimizations from check-in [79326d6eec]. check-in: bd2cfa1d user: drh tags: trunk
17:35
Fix a problem with a stale Select.pWith pointer when a CTE is used together with a compound query and an ORDER BY clause. check-in: 9a453f52 user: drh tags: trunk
01:22
Avoid problems when a query has a GROUP BY and an ORDER BY but no FROM clause. check-in: e527d96a user: drh tags: trunk
2015-04-11
20:44
Optimizations for VACUUM, CREATE INDEX and some cases of ORDER BY. check-in: 79326d6e user: dan tags: trunk
20:20
Fix a problem with sorting large amounts of partially ordered data. check-in: acca97ef user: dan tags: trunk
18:45
Merge latest trunk changes with this branch. Closed-Leaf check-in: cf7590f6 user: dan tags: sorter-opt
13:49
Add the --changeset option to the sqldiff utility program, for generating a sessions changeset file instead of an SQL diff. check-in: f9a3a839 user: drh tags: trunk
13:48
The --changeset option now appears to be working. Closed-Leaf check-in: 1a2e2803 user: drh tags: sqldiff-changeset
12:07
First complete attempt to generate a working changeset. Still contains bugs. check-in: 5611fa9b user: drh tags: sqldiff-changeset
11:53
Update tests in whereD.test to account for the change in the previous commit. check-in: da49700c user: dan tags: trunk
11:44
Do not assume an index contains unique entries unless it is declared UNIQUE and NOT NULL is specified for all columns. Fix for [7b4fee9f6c]. check-in: e3b1f625 user: dan tags: trunk
02:08
Detect and report oversized records constructed from multiple zeroblobs. check-in: 9e139afd user: drh tags: trunk
2015-04-10
21:16
Minor build enhancements for MSVC. check-in: 40c417a7 user: mistachkin tags: trunk
19:41
Work toward adding the --changeset option to the sqldiff utility program. Changes are incomplete. This is an incremental check-in. check-in: 463e38d7 user: drh tags: sqldiff-changeset
16:05
In sqlite3_declare_vtab(), avoid accessing the database structure until after the "api-armour" safety-check has completed and the db mutex has been obtained. check-in: 860e4f8a user: dan tags: trunk
12:04
Fix foreign key CASCADE for cases where the parent key is an INTEGER PRIMARY KEY and the parent table contains other columns named "rowid", "_rowid_", and "oid". check-in: ed3cbaab user: drh tags: trunk
08:20
Update this branch with latest trunk changes. check-in: 60be9c1c user: dan tags: sorter-opt
07:55
Do not allow virtual table constructors to be called recursively. check-in: 0a72726d user: dan tags: trunk
2015-04-09
19:39
Fix incorrect column names in UPDATE statements generated by the sqldiff utility. check-in: ee53b460 user: drh tags: trunk
18:14
Add the --primarykey option to the sqldiff tool, which causes it to use the schema-defined PRIMARY KEY. check-in: 5063f907 user: drh tags: trunk
16:30
Remove two pointless assert() statements. This should silence harmless compiler warnings reported at https://bugzilla.mozilla.org/show_bug.cgi?id=1152845 check-in: 83b342a4 user: drh tags: trunk
13:40
Fix comment typos in the sqldiff.c utility program. check-in: 32ab2bb9 user: drh tags: trunk
13:34
Add the "sqldiff" utility program. check-in: 88da5bf5 user: drh tags: trunk
11:24
Remove a variable initializion to silence a harmless compiler warning. check-in: 79861adb user: drh tags: trunk
2015-04-08
12:16
Version 3.8.9 check-in: 8a8ffc86 user: drh tags: trunk, release, version-3.8.9
2015-04-07
15:39
Avoid signed integer overflow when converting oversized in-line integer widths and precisions in printf(). check-in: 8e4ac2ce user: drh tags: trunk
14:38
Another change to avoid a problem caused by integer overflow in the printf() code. check-in: 95625ef3 user: dan tags: trunk
13:28
Further changes to guard against integer overflow in the width and precision of printf() arguments. check-in: 5ce4e7d7 user: drh tags: trunk
12:41
Guard against excessive width and precision in floating-point conversions in the printf routines. check-in: c494171f user: drh tags: trunk