SQLite
Timeline
Not logged in

179 timeline items tagged with "trunk" occurring on or after release.

2017-07-24
17:37
[f483d06a] Leaf: Handle a real OOM condition when incrblob2.test is run on a low-memory machine. (user: drh, tags: trunk)
15:29
[b1572d4e] Additional documentation on sqlite3_bind_pointer() and sqlite3_result_pointer(). No changes to code. (user: drh, tags: trunk)
14:44
[a98f07d9] Compiler warning fix associated with date/time functions. (user: drh, tags: trunk)
2017-07-21
20:31
[8de20fc7] Remove stray (and incomplete) comment from a test file. No changes to code. (user: mistachkin, tags: trunk)
2017-07-20
20:49
[e4b1dd36] Fix a harmless typo, but one that would show up in the documentation if not fixed. (user: drh, tags: trunk)
15:08
[a90c062d] Enhance the built-in date/time functions so that they can be used in CHECK constraints, in the WHERE clause or partial indexes, and index expressions, provided that none of the non-deterministic keywords ("now", "localtime", "utc") are used as arguments. (user: drh, tags: trunk)
2017-07-19
18:01
[d14fc621] Remove some 'breakpoint' commands in test files. (user: mistachkin, tags: trunk)
11:52
[c93284cd] Add further tests to unionvtab.test. (user: dan, tags: trunk)
2017-07-18
21:19
[255d6b99] Fix a crash in unionvtab caused by a misconfiguration. Add other test cases for the same. (user: dan, tags: trunk)
20:59
[505fdc8f] Fix shell.c.in so that it aligns with shell.c. (user: drh, tags: trunk)
20:49
[deadaad2] Add test cases and fix minor error-handling issues in unionvtab.c. (user: dan, tags: trunk)
20:30
[47b80ecc] Fix duplicate test name. No changes to code. (user: mistachkin, tags: trunk)
20:28
[d49639c2] Fix another harmless compiler warning. Get the MSVC makefile working with unionvtab. (user: drh, tags: trunk)
20:22
[4d147a1e] Suppress harmless compiler warnings in union-vtab. (user: drh, tags: trunk)
20:17
[a447fdf1] Remove an unused variable from unionvtab.c. (user: dan, tags: trunk)
20:03
[5bcf0f86] Improve the readability of the unionvtab code. (user: dan, tags: trunk)
19:51
[4a6c416f] Have unionvtab support constraints on the column that corresponds to the INTEGER PRIMARY KEY field of the underlying source tables in the same way as rowid. (user: dan, tags: trunk)
18:50
[6c9128e1] Add test cases to unionvtab.test. (user: dan, tags: trunk)
18:19
[948f9504] Add the union-vtab extension - still experimental and under active development. (user: drh, tags: trunk)
17:34
[9dbae1df] Do not use the flattening optimization for a sub-query on the RHS of a LEFT JOIN if that subquery reads data from a virtual table. Because it prevents the planner from creating an automatic index on the results of the sub-query, the flattening optimization sometimes slows things down in this case. (user: dan, tags: trunk)
17:13
[d2f0b2e8] Avoid creating an automatic index on the RHS of a LEFT JOIN to optimize an IS term. Fix for [ce68383b]. (user: dan, tags: trunk)
14:41
[0b69aa7e] Change the default command-line shell history depth to 2000 lines. (user: drh, tags: trunk)
2017-07-17
18:45
[e0aca7d2] Merge all changes from branch-3.20. Improvements to the fts5() extension interface. Work around a gcc/valgrind bug in the sqlite3_value_pointer() interface. (user: drh, tags: trunk)
13:37
[9e8e1c4a] Merge the pointer-type enhancement from the 3.20 branch. (user: drh, tags: trunk)
2017-07-15
20:33
[253945d4] Fix a register allocation problem in PRAGMA integrity_check that caused the same register to be used for two different purposes on the first ATTACHed database if the schema for the ATTACHed database was noticable more complex than the schema for the first database. Fix for ticket [a4e06e75a9ab61a1]. (user: drh, tags: trunk)
20:25
[687bd478] Fix a missing \n at the end of a comment causing a line to be too long. No code changes. (user: drh, tags: trunk)
17:57
[5ec37c62] Enhance the showstat4 utility program to show the full precision of floating point values in sqlite_stat4 tables. (user: drh, tags: trunk)
08:02
[0953e746] Fix another minor problem in test file like.test. (user: dan, tags: trunk)
06:35
[b61cc5a0] Fix test problems causing the "prepare" permutation test to fail. (user: dan, tags: trunk)
2017-07-14
20:53
[ad6699d4] Fix test problems with stmtvtab1.test under some permutations. (user: dan, tags: trunk)
19:52
[65f9f29c] Fix a typo in a comment used to generate documentation. No code changes. (user: drh, tags: trunk)
19:47
[ab165dcf] Identify requirements text in the SQLITE_DBCONFIG_ENABLE_QPSG documentation. Add some implementation marks for SQLITE_DBCONFIG_MAINDBNAME requirements. No code changes. (user: drh, tags: trunk)
19:22
[26423867] Add requirements marks for some of the new features in the 3.20 release. (user: drh, tags: trunk)
19:12
[394c6f4f] Tweak Makefile.in so that testfixture can be built with the --disable-amalgamation configure switch. (user: dan, tags: trunk)
17:50
[1eb56fe0] Modify mkopcodeh.tcl so that it can handle "same as" opcodes with values larger than the total number of opcodes. (user: dan, tags: trunk)
15:57
[6ed4ef03] In the LSM1 virtual table, dequote the filename before opening the file. (user: drh, tags: trunk)
15:45
[7dc5e70e] Changes to the LSM1 Tcl tests to make things work on Win32. (user: mistachkin, tags: trunk)
15:42
[b5e3b264] Include a hint in the header comment of the LSM1 makefile about how to set the LSMOPTS variable. (user: drh, tags: trunk)
15:32
[fe319bcd] Update the Makefile for LSM1 so that the LSMOPTS can be set prior to including the Makefile, in order to add platform arguments such as -fPIC. (user: drh, tags: trunk)
15:18
[604b9664] Fix a typo in the header comment to the remember extension. No code changes. (user: drh, tags: trunk)
15:14
[1bc4e934] Change the name of the STMT virtual table to SQLITE_STMT. Also remove the first column of that virtual table, which was a pointer leak. (user: drh, tags: trunk)
13:24
[8f6dd5e2] Minor updates to requirements marks and documention. No changes to code. (user: drh, tags: trunk)
11:40
[5e0a9793] Add very simple tcl tests for the lsm1 extension. (user: dan, tags: trunk)
04:16
[d8cd0434] Minor tweaks to documentation. No code changes. (user: drh, tags: trunk)
00:28
[271ca4ac] Fix harmless compiler warnings in the readline tab-completion logic of the command-line shell. (user: drh, tags: trunk)
2017-07-13
22:39
[889968bd] Improved documentation for the new sqlite3_bind_pointer() interface and its cousins. (user: drh, tags: trunk)
22:03
[26577814] Improvements to the documentation for SQLITE_PREPARE_PERSISTENT. No code changes. (user: drh, tags: trunk)
20:11
[9319f7b7] Fix documentation typo. No changes to code. (user: drh, tags: trunk)
19:11
[55f53965] Update header comments on the carray() and remember() extensions to bring out the fact that the pointer arguments must be bound using sqlite3_bind_pointer(). (user: drh, tags: trunk)
18:09
[72de49f2] Add new interfaces sqlite3_bind_pointer(), sqlite3_result_pointer(), and sqlite3_value_pointer() used to safely move pointer values through SQL without exposing underlying memory address information. (user: drh, tags: trunk)
2017-07-12
20:43
[0c805935] Smaller and faster implementation for vdbeFreeOpArray() and freeP4(). (user: drh, tags: trunk)
18:05
[604c11d1] Fix harmless compiler warnings about incomplete structure initializers. (user: drh, tags: trunk)
17:26
[f951c8b7] Remove unnecessary EP_Leaf settings on the Expr object. (user: drh, tags: trunk)
17:08
[54f55d3b] The EP_Resolved flag on the Expr object is not required for correctness nor performance, so remove it. (user: drh, tags: trunk)
14:10
[68824a43] Clarification and simplification and result column naming logic. (user: drh, tags: trunk)
14:03
[3e56a79a] Fix a problem in an lsmtest test case caused by writing data in "text" mode instead of "binary". (user: dan, tags: trunk)
12:19
[783100b8] Compile cleanly with SQLITE_OMIT_UTF16. (user: drh, tags: trunk)
2017-07-11
20:36
[39069941] In lsm, attempt to unmap the database file before truncating it when disconnecting. A mapped file may not be truncated on win32. (user: dan, tags: trunk)
19:55
[b0a49d90] Simplify the way in which the database file is truncated when the last connection disconnects. Also ignore the error code from the xTruncate call - as truncating a database file is always optional. (user: dan, tags: trunk)
18:11
[55e93f25] Fix harmless compiler warnings in the core. (user: drh, tags: trunk)
17:54
[2fe3a843] Make win32GetTimeOfDay() in the lsm1 test code more portable. (user: mistachkin, tags: trunk)
17:28
[b9debd62] Enabled the new sqlite3_prepare_v3() and sqlite3_prepare16_v3() interfaces for loadable extensions. (user: drh, tags: trunk)
17:06
[a8e651e0] Fix a whitespace alignment issue in lsm1. (user: mistachkin, tags: trunk)
16:46
[0f1307f1] Fix more harmless compiler warnings in lsm1, seen with MSVC 2015. (user: mistachkin, tags: trunk)
16:36
[cf6da4a5] Fix harmless compiler warnings seen with MSVC for lsm1. (user: mistachkin, tags: trunk)
13:59
[95cd1d9f] Add support for tab-completion (using the ext/misc/completion.c virtual table) to the command-line shell. (user: drh, tags: trunk)
13:34
[17e0bb12] Change the src/shell.c file so that it is generated from a new script at tool/mkshellc.tcl and the template file src/shell.c.in, and automatically includes the extensions it needs out of ext/misc. (user: drh, tags: trunk)
02:53
[724819b4] Fix a backup2 test case so that it works on FreeBSD. (user: drh, tags: trunk)
02:05
[0e213555] Add the "phase" output column on the COMPLETION table-valued function, for debugging. Improved comments on the implementation. (user: drh, tags: trunk)
01:38
[1cc97711] The COMPLETION virtual table now looks at the names of databases, tables, and columns in addition to SQL keywords. (user: drh, tags: trunk)
00:09
[caefbc72] Incomplete implementation of the COMPLETION table-valued function. So far it only works for SQL keywords. (user: drh, tags: trunk)
2017-07-10
21:32
[bd8a1fb9] Fix harmless compiler warnings in lsmtest. (user: mistachkin, tags: trunk)
20:39
[9a8f045d] Fix errors in comments in the STMT virtual table. No code changes. (user: drh, tags: trunk)
20:33
[bf7eda67] Minor cleanup and refactoring of the Win32 VFS for lsm1. (user: mistachkin, tags: trunk)
19:54
[05129374] Another spelling error in the README.md file. (user: drh, tags: trunk)
19:08
[12bc47c5] Spelling error in README.md (user: drh, tags: trunk)
19:07
[75c9327b] Yet another typo in README.md (user: drh, tags: trunk)
19:05
[20b1f0ef] Fix another README.md typo. (user: drh, tags: trunk)
19:03
[4f6ce7a3] Fix an obsolete statement about Lemon in the README.md file. (user: drh, tags: trunk)
18:57
[f3a6a64e] Cleanup header usage in lsmtest for files that require _O_BINARY. (user: mistachkin, tags: trunk)
18:52
[7bfd3ab7] Updates to the repository README.md file. (user: drh, tags: trunk)
18:33
[a82a9bea] In LSM, avoid calling the VFS xTestLock method to test for a lock that conflicts with one held by the same process. The results of such a call are considered undefined (since they are different under win32 and posix). (user: dan, tags: trunk)
18:04
[bde431b1] Add the "--newlines" option to the ".dump" command in the shell to disable the newline escaping mechanism. (user: drh, tags: trunk)
17:00
[c4cb9048] When multiple constraints need to be evaluated for a row, do any constraints that involve correlated subqueries last. Hence, the priority is index-covered constraints first, correlated subquery constraints last, and all others in the middle. This is a follow-on and improvement to the push-down optimization of check-in [d7bb79ed]. (user: drh, tags: trunk)
13:24
[dc857a96] For sqlite3TreeView() debugging output, show the Expr.flags field on scalar subqueries. (user: drh, tags: trunk)
12:07
[f27b6370] Update error message text for standard error codes to better describe the latest usage of those error codes. Modify sqlite3_open_v2() so that it does return a valid sqlite3 object in the event of SQLITE_MISUSE due to bad open flags, so that sqlite3_errmsg() does not report "out of memory" in that case. (user: drh, tags: trunk)
11:17
[871752f2] Remove the error message text from disused error codes such as SQLITE_EMPTY and SQLITE_FORMAT. (user: drh, tags: trunk)
2017-07-09
18:55
[70096c50] Always make "column%d" column-names 1-based, never 0-based. (user: drh, tags: trunk)
00:30
[acf3b9cc] Make sure the columns of a VALUES() clause are named "column%d" even if the VALUES() clause is a subquery in the FROM clause of an outer query. (user: drh, tags: trunk)
2017-07-08
22:30
[70dae08a] Add the --icc, --gcc7, and --orm options to the speed-check.sh test script. (user: drh, tags: trunk)
2017-07-07
22:47
[0c246017] Basic test cases for PRAGMA secure_delete=FAST. (user: drh, tags: trunk)
21:20
[12a421bc] Fix comment in the Win32 VFS for lsm1. (user: mistachkin, tags: trunk)
21:15
[aea6e0ff] For lsmtest, use a more portable means of setting open() files to binary. (user: mistachkin, tags: trunk)
20:35
[54a38555] Adjust copy_file() lsmtest function so it works properly for locked database files on Win32. (user: mistachkin, tags: trunk)
20:06
[38978ce6] Add the "PRAGMA secure_delete=FAST" option, which overwrites most deleted content without increasing the amount of I/O. Deleted content might persist on the free page list, however. And extra CPU cycles are used for zeroing, of course. (user: drh, tags: trunk)
19:43
[732f90d6] Change the error message text for SQLITE_ERROR to omit the part about "missing database" as that meaning is now obsolete (since approx SQLite 2.0). (user: drh, tags: trunk)
19:22
[0961ec87] Fix typos in Win32 VFS for lsm1. (user: mistachkin, tags: trunk)
19:12
[aa4890b9] Fix the memcpy calls in the lsmWin32OsShmMap function for lsm1. (user: mistachkin, tags: trunk)
19:02
[2d6faebc] Enhance the MSVC makefile 'clean' target to handle lsm1. (user: mistachkin, tags: trunk)
18:31
[277a7fed] Add support for LSM_DEBUG to the MSVC makefile for lsm1. (user: mistachkin, tags: trunk)
18:06
[cc329eb8] In the command-line shell, when running ".schema" give a sensible error when the database file is locked. (user: drh, tags: trunk)
17:57
[63599fa5] Fix the usleep() macro in the Win32 test code for lsm1. (user: mistachkin, tags: trunk)
17:43
[e0b6ae92] Add new PRAGMAs: "function_list", "module_list", and "pragma_list". All are enclosed within #ifdef SQLITE_INTROSPECTION_PRAGMAS. The compile-time option is not on ctime.c yet, since these are still experimental and one can always test "PRAGMA pragma_list" and see whether or not it returns an empty set. (user: drh, tags: trunk)
16:46
[9c7a9e80] Improve clarity in the Win32 VFS for lsm1. (user: mistachkin, tags: trunk)
16:29
[3340de83] Add support for LSM_DEBUG_MEM to the MSVC makefile for lsm1. (user: mistachkin, tags: trunk)
16:27
[5f726f28] Remove a block from the Win32 VFS for lsm1 that is now superfluous. (user: dan, tags: trunk)
16:09
[281ad505] In lsmtest, use an empty string instead of ":memory:" when requesting a temporary database from SQLite. This prevents other test code from trying to unlink() ":memory:", which fails on win32. (user: dan, tags: trunk)
16:07
[db4a4140] Remove a block from the Win32 VFS for lsm1 that is now superfluous. (user: mistachkin, tags: trunk)
16:06
[5a3140e4] Memory reallocation fix for the Win32 VFS for lsm1. (user: mistachkin, tags: trunk)
16:00
[c46f0f07] Enhance the sqlite3VdbeMultiLoad() interface to automatically generate the OP_ResultRow opcode on PRAGMA implementations, for a small reduction in the library footprint. (user: drh, tags: trunk)
13:59
[aacbb9a4] Exploit the fact that Expr.pRight and Expr.x are never used at the same time for a small performance gain. (user: drh, tags: trunk)
12:58
[115d4b83] More efficient and compact implementation of walkExpr(). (user: drh, tags: trunk)
12:43
[c1a1d68c] More aggressive use of EP_Leaf on expression nodes, to help prune searches. (user: drh, tags: trunk)
11:49
[9bc65635] Very slightly smaller and faster sqlite3WalkSelect(). (user: drh, tags: trunk)
2017-07-06
22:43
[7c7d53a9] Small adjustment to main.mk that facilitates giving non-standard compile-time options to the shell. (user: drh, tags: trunk)
16:33
[c5ed5ebd] Change the (machine-generated) keywordhash.h file to increase the scope of the tables used for keyword matching, so that the tables are accessible to functions other then keywordCode(). (user: drh, tags: trunk)
13:51
[efb4aab0] More compact implementation of the typeof() SQL function. (user: drh, tags: trunk)
13:23
[06269257] Avoid unnecessary upper-to-lower case conversion for function names when registering the built-in functions. (user: drh, tags: trunk)
03:06
[55ecd303] Small size reduction in findCollSeqEntry(). (user: drh, tags: trunk)
02:49
[503ba172] Avoid unnecessary calls to sqlite3GetCollSeq() for a small performance gain. (user: drh, tags: trunk)
01:28
[4da663d9] Slightly more compact implementation of the byte-code generator for the COMMIT and ROLLBACK commands. (user: drh, tags: trunk)
01:02
[7b2623f1] Small performance increase in sqlite3SrcListAppend(). (user: drh, tags: trunk)
2017-07-05
23:33
[f762f1ef] Make the hash table implementation a little smaller and faster. (user: drh, tags: trunk)
18:48
[b6b14ab6] Have fts3 virtual table cursors free internal resources when they reach EOF, instead of waiting until the xClose method is called. (user: dan, tags: trunk)
14:29
[2bce64c8] Fix a problem in lsmtest causing one test to fail for multi-threaded LSM connections. (user: dan, tags: trunk)
2017-07-04
19:34
[d1ba2002] Add the count-of-view optimization when compiled using SQLITE_COUNTOFVIEW_OPTIMIZATION. (user: drh, tags: trunk)
19:23
[ca757c86] Fix further OOM handling cases in LSM. (user: dan, tags: trunk)
17:25
[989a5c17] Fix a couple of problems in handling OOM conditions within LSM. (user: dan, tags: trunk)
12:50
[268a40f4] Fix a problem in the lempar.c Lemon template for YYSTACKDEPTH<=0 introduced by check-in [36e54cd8b1fb37] (user: drh, tags: trunk)
2017-07-03
21:09
[9bd3be92] Fix compiler warnings in LSM1, especially in the test logic. (user: drh, tags: trunk)
20:19
[b2c24879] Fix a bug in lsm queries on levels undergoing incremental an merge that contain range-delete markers. (user: dan, tags: trunk)
17:37
[9111ac69] Attempt to improve documentation on sqlite3_column_ and sqlite3_value_ interfaces. (user: drh, tags: trunk)
09:00
[e34eafd4] Add more tests for LSM log file recovery. Fix a problem in recovering log files that contain range deletes. (user: dan, tags: trunk)
2017-07-01
20:59
[dd55af30] Fix a memory management problem in lsm log recovery code. (user: dan, tags: trunk)
15:21
[66de6f4a] Enhance the RTree module to detect node truncation early and report an error. (user: drh, tags: trunk)
2017-06-30
20:11
[0db20efe] Improved documentation for sqlite3_value_type(). (user: drh, tags: trunk)
19:22
[d076d58f] Add some assert() statements in the Win32 interface for lsm1. (user: mistachkin, tags: trunk)
18:12
[0ef777d7] Fix some minor typos in lsm1. (user: mistachkin, tags: trunk)
11:44
[bacfe8cb] Avoid constantly freeing and reallocing small internal buffers associated with LSM cursors. Instead, allow them to persist for the lifetime of the cursor if they are LSM_SEGMENTPTR_FREE_THRESHOLD (default 1024) bytes or smaller. This change is based on research by Martijn Blaauw. (user: dan, tags: trunk)
2017-06-29
21:33
[5e3f9ea5] In the command-line shell, add the -quote option to start up in quote mode. Enhance the ".mode" command so that it reports the current output mode if given no arguments. (user: drh, tags: trunk)
21:11
[7782c04e] Remove the ".explain" command from the ".help" output of the command-line shell, though keep the implementation around for backwards compatibility. (user: drh, tags: trunk)
20:31
[a26e17ee] Some simple tests for the STMT virtual table. (user: drh, tags: trunk)
20:23
[3ed6877f] Avoid reading or writing the 32 locking bytes at the end of the first meta-page of an LSM database. (user: dan, tags: trunk)
19:08
[38ec4141] Fix issues in the POSIX and Win32 interfaces for lsm1. (user: mistachkin, tags: trunk)
17:27
[284707a7] Edit comments in sqlite.h.in used for generating documentation, to improve the description of the new sqlite3_prepare_v3() interfaces, and other miscellaneous cleanup. No changes to executable code. (user: drh, tags: trunk)
16:51
[cae64769] More updates to the Win32 interface for lsm1. (user: mistachkin, tags: trunk)
15:57
[1b4facb1] Correct typo in the Win32 interface for lsm1. (user: mistachkin, tags: trunk)
15:24
[03977248] Add interfaces sqlite3_prepare_v3() and sqlite3_prepare16_v3() with the extra prepFlags argument. Add the SQLITE_PREPARE_PERSISTENT option as one bit in that argument. Use the new option in FTS3, FTS5, and RTREE. (user: drh, tags: trunk)
15:13
[4df6e247] Further corrections to the Win32 interface for lsm1. (user: mistachkin, tags: trunk)
14:33
[adfdb801] Rename the "stmts" virtual table to just "stmt" without the final "s". (user: drh, tags: trunk)
14:17
[ebbd98e9] A couple fixes for the Win32 interface for lsm1. (user: mistachkin, tags: trunk)
13:41
[60c62829] Add the stmts virtual table to testfixture builds. Add new compile-time options SQLITE_ENABLE_QPSG and SQLITE_ENABLE_STMTSVTAB to ctime.c (user: drh, tags: trunk)
13:35
[b7794cc5] Compilation fix for lsm1 using MSVC. (user: mistachkin, tags: trunk)
13:19
[824e8327] Add the LSM1 extension. (user: drh, tags: trunk)
13:13
[88976ae3] Add the "stmts" virtual table to the amalgamation, activated when compiled using -DSQLITE_ENABLE_STMTSVTAB. Add the SQLITE_STMTSTATUS_REPREPARE and SQLITE_STMTSTATUS_RUN statistics outputs from sqlite3_stmt_status() and add corresponding columns to the stmts virtual table. Change the numeric value of SQLITE_STMTSTATUS_MEMUSED to get it out of the way of counter values. (user: drh, tags: trunk)
12:59
[c322bfa2] The query planner examines the values of bound parameters to help determine if a partial index is usable. Reprepares may happen if the bindings change. This behavior is disabled by the QPSG setting. (user: drh, tags: trunk)
2017-06-28
15:17
[f02a5459] Fix harmless compiler warnings in the CSV extension. (user: drh, tags: trunk)
15:01
[36e54cd8] Faster parser stack overflow detection. (user: drh, tags: trunk)
14:26
[cc4810b2] Minor tweak to the SQL grammar to make the parser tables a few bytes smaller. (user: drh, tags: trunk)
13:47
[b362f0d8] In the lemon-generated parser, store the number of symbols on the RHS of each rule as a negative number and add it to the stack pointer, rather than storing the value as a positive and subtracting it. This makes the parser faster. (user: drh, tags: trunk)
11:56
[c46d94a8] In the lemon-generated parser, automatically promote SHIFTREDUCE actions on nonterminal systems to pure REDUCE actions, for a performance enhancement. (user: drh, tags: trunk)
01:21
[6480916c] Simplify error handling logic in sqlite3_exec() to save about 40 bytes. (user: drh, tags: trunk)
01:12
[bfc4e7f3] Minor code simplification in the ALTER TABLE logic. (user: drh, tags: trunk)
00:55
[29d6ceb3] Avoid an unnecessary call to sqlite3XPrintf() in the code generator, for a performance improvement. (user: drh, tags: trunk)
2017-06-27
23:36
[b82efd2a] Add SQLITE_DBCONFIG_ENABLE_QPSG that forces the query planner stability guarantee. This is the fix for ticket [b9f010107724c] (user: drh, tags: trunk)
16:39
[87b38166] Fix a virtual table problem that can occur when the vtab is on the RHS of a LEFT JOIN and there is a MATCH constraint in the ON clause, or when the vtab is in a sub-query that is the RHS of a LEFT JOIN and there is a MATCH constraint in the WHERE clause of the sub-query. (user: dan, tags: trunk)
2017-06-26
21:08
[18f0616e] Add the -withoutnulls option to the "db eval" method in the TCL interface. (user: drh, tags: trunk)
18:42
[7c15d762] The ".import" command of the shell, and the csv virtual table extension both ignore a single UTF-8 BOM at the beginning of their input. (user: drh, tags: trunk)
2017-06-24
19:21
[c8186874] Disable shell tests for the .schema command if virtual tables are not available. (user: drh, tags: trunk)
16:35
[c2ea6293] Make sure the config.h header is included by ctime.c, if that header exists. (user: drh, tags: trunk)
16:03
[f0ec36d4] Query planner tuning: When deciding between two plans with the same cost, bias the selection toward the one that does not use the sorter. (user: drh, tags: trunk)
13:31
[0583b84a] Make sure enough memory is allocated for pathological quoting cases when computing a quoted table name in the command-line shell. (user: drh, tags: trunk)
2017-06-23
15:47
[712267c9] When generating individual loops for each ORed term of an OR scan, move any constant WHERE expressions outside of the loop, as is done for top-level loops. (user: dan, tags: trunk)
2017-06-21
01:36
[118f7bb3] Enable pragma virtual tables for the integrity_check, quick_check, and foreign_key_check pragmas. (user: drh, tags: trunk)
2017-06-20
18:19
[94e420ec] Rename the azCompileOpt global constant to avoid a harmless compiler warning about a name conflict with a local variable. (user: drh, tags: trunk)
17:43
[48346268] Ensure that the query planner knows that any column of a flattened LEFT JOIN can be NULL even if that column is labeled with "NOT NULL". Fix for ticket [892fc34f173e99d8]. (user: dan, tags: trunk)
2017-06-17
18:49
[f3db02f4] Fix a missing comma in the previous check-in. (user: drh, tags: trunk)
17:55
[9a443397] Rework the code in ctime.c a bit to report on more compile time options. And to only output configuration options passed in to SQLite, not the default values of #define symbols set automatically. Also generate the large array in ctime.c using new script tool/mkctime.tcl, instead of entering it manually. (user: dan, tags: trunk)
16:39
[603838fc] Add extra test cases for sqlite3changeset_apply() and ALTER TABLE ADD COLUMN. (user: dan, tags: trunk)