Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 descendants and 200 ancestors of ec003958359d6b69
|
2015-11-19
| ||
| 18:11 | Fix problems with the way the IsHiddenColumn() macro is defined. (check-in: 126b998cf1 user: drh tags: trunk) | |
| 18:09 | Fix a problem with VACUUM and __hidden__ columns. (check-in: 13995756ad user: dan tags: trunk) | |
| 17:55 | When manifesting a view as part of an DELETE or UPDATE, be sure to include the hidden columns in the manifestation. (check-in: 28df5dc4a9 user: drh tags: trunk) | |
| 16:46 | Fix problems with INSERT INTO ... SELECT ... statements that write to tables with __hidden__ columns. (check-in: 59bd0ec7d4 user: dan tags: trunk) | |
| 16:33 | Create the new TK_ASTERISK token to represent the "*" in "SELECT *". Formerly that operator was TK_ALL, which was also used for UNION ALL. Less confusion if they operator symbols are distinct. (check-in: 201ac6d449 user: drh tags: trunk) | |
| 14:11 | If compiled with SQLITE_ENABLE_HIDDEN_COLUMNS, then columns in ordinary tables and views that have names beginning with "__hidden__" are omitted from the "*" expansion in SELECT statements and from the automatic list of columns following the table name in an INSERT INTO statement. (check-in: 011904cad2 user: drh tags: trunk) | |
| 13:53 | Only support the magic "__hidden__" column name prefix interpretation when compiled with SQLITE_ENABLE_HIDDEN_COLUMNS. (Closed-Leaf check-in: 5490646b2e user: drh tags: hidden-columns-in-tables) | |
| 13:21 | Fix a 10-year-old misguided attempt at parser performance improvement that actually made parsing slightly slower. (check-in: 3833cbac07 user: drh tags: trunk) | |
|
2015-11-18
| ||
| 21:22 | Get the __hidden__ column mechanism working on views with INSTEAD OF triggers. (check-in: 20c1e9ce75 user: drh tags: hidden-columns-in-tables) | |
| 20:59 | Add tests for views to hidden.test. (check-in: 27d4b6f575 user: dan tags: hidden-columns-in-tables) | |
| 20:57 | Honor the "__hidden__" prefix on the columns of views. (check-in: 3071ba2bdb user: drh tags: hidden-columns-in-tables) | |
| 20:07 | Add a test for the __hidden__ hack on this branch. (check-in: ebf4bbffec user: dan tags: hidden-columns-in-tables) | |
| 18:43 | If a table column name begins with "__hidden__" then do not include that column in "*" expansions in SELECT statements, nor fill in that column in an INSERT INTO that omits the column list. This branch is a proof-of-concept only and is not intended to ever be merged into trunk. (check-in: 2dbffb3a3b user: drh tags: hidden-columns-in-tables) | |
|
2015-11-17
| ||
| 21:42 | When using mmap mode on Win32, use a read-only mapping by default. Write to the database file using WriteFile(). Unless SQLITE_MMAP_READWRITE is defined, in which case use a read/write mapping and write into the file using memcpy(). (check-in: 4f521b5bb3 user: mistachkin tags: trunk) | |
| 20:56 | When using mmap mode on unix, use a read-only mapping by default. Write to the database file using write(). Unless SQLITE_MMAP_READWRITE is defined, in which case use a read/write mapping and write into the file using memcpy(). (check-in: 67c5d3c646 user: dan tags: trunk) | |
| 19:17 | Fix uninitialized variable in the command line shell. (check-in: dc2ac024d3 user: mistachkin tags: trunk) | |
| 19:16 | Fix harmless compiler warning. (check-in: eea26b6cae user: mistachkin tags: trunk) | |
| 02:23 | Basic functionality is now working. (check-in: aa129c51ec user: drh tags: lsm-vtab) | |
| 00:15 | The virtual table compiles but does not work and is missing many features. This is an incremental check-in. (check-in: a32849d6bf user: drh tags: lsm-vtab) | |
|
2015-11-16
| ||
| 16:00 | Import the LSM code from SQLite4 for use in an experimental virtual table. NB: This is a speculative experiment and could easily result in a dead-end branch. (check-in: 3d930501a2 user: drh tags: lsm-vtab) | |
| 15:28 | Add testfixture command "vfs_current_time_int64". Returns the value returned by the xCurrentTimeInt64 method of the default VFS. (check-in: f79d5b1853 user: dan tags: trunk) | |
| 08:54 | In the shell tool, avoid testing if (sqlite3_vfs.xGetCurrentInt64) is NULL for a version 1 VFS. This field is only defined for version 2 and greater. (check-in: ad5fcaa583 user: dan tags: trunk) | |
|
2015-11-15
| ||
| 11:13 | Fix the column name uniquifier so that it works with zero-length column names. (check-in: 791761ebac user: drh tags: trunk) | |
|
2015-11-14
| ||
| 22:04 | Code simplification in sqlite3ColumnsFromExprList(). Update the %z format code so that it works with buffers obtained from sqlite3DbMalloc(). Add a testcase for the slow column name uniquifier. (check-in: 9272426057 user: drh tags: trunk) | |
| 20:52 | Use a hash table to improve the preformance of column name uniqueness checking. (check-in: 5b08f29f45 user: drh tags: trunk) | |
| 16:47 | Use randomness to prevent slowness in the generated-column-name uniqueness checking. (check-in: 6266712968 user: drh tags: trunk) | |
|
2015-11-13
| ||
| 20:52 | Fix a memory leak in the fuzzcheck utility. (check-in: dfd6d9f4fb user: drh tags: trunk) | |
| 16:59 | Add the "--enable-static-shell" option to the amalgamation autoconf script. If set (the default) the compiled shell tool is statically linked against sqlite3.o. Otherwise, it is linked against libsqlite3.so. (check-in: 499a02a343 user: dan tags: trunk) | |
| 13:15 | Add the --transaction option to the sqldiff tool. (check-in: 8882d1f3ef user: drh tags: trunk) | |
| 12:52 | Fix the releasetest-out.txt log output from releasetest.tcl so that it works when the --jobs option is used. (check-in: 6bb314a502 user: drh tags: trunk) | |
| 12:32 | Disable two PRAGMA cache_spill tests when MEMORY_MANAGEMENT is enabled. (check-in: ebda77aad4 user: drh tags: trunk) | |
| 02:13 | Merge fixes from trunk. (check-in: f9060b2a98 user: drh tags: apple-osx) | |
| 00:03 | Change the error messages so that they can be grepped using '^!' instead of '^ '. There are far too many extraneous outputs that begin with a space. (check-in: 367ec0db49 user: drh tags: trunk) | |
|
2015-11-12
| ||
| 23:48 | Update the SQLLOG logic so that to builds in accordance with the instructions in the header comment. (check-in: ee6f2feec7 user: drh tags: trunk) | |
| 22:15 | Always parse the schema *before* running "PRAGMA cache_size", not after. (check-in: 12e7d9ec02 user: drh tags: trunk) | |
| 21:55 | Import the test_sqllog.c enhancements from trunk. (check-in: 178da33909 user: drh tags: apple-osx) | |
| 21:42 | Add a space before each line of error output in the test scripts so that all errors can be conveniently located in logs by doing "grep '^ '". (check-in: 9d532fb50d user: drh tags: trunk) | |
| 20:12 | Add support for the SQLITE_SQLLOG_CONDITIONAL environment variable to the logging code in test_sqllog.c. When defined, logging is only performed if the "<database>-sqllog" file is present in the file system when the main database is opened. (check-in: cab8126be9 user: dan tags: trunk) | |
| 16:51 | Merge the latest enhancements from trunk, and in particular the "PRAGMA cache_spill=N" change. (check-in: e72331c719 user: drh tags: apple-osx) | |
| 16:44 | Enhance the "PRAGMA cache_spill" statement to accept an integer argument which is the threshold at which spilling will begin. (check-in: f79d264db2 user: drh tags: trunk) | |
| 15:47 | Test cases. Minor problems fixed. All appears to work now. (Closed-Leaf check-in: 9a431362dc user: drh tags: cache_spill=N) | |
| 15:04 | Fix a #define in parse.y that disabled unused code in the generated parser. (check-in: f84e3085c8 user: drh tags: trunk) | |
| 14:57 | First attempt at enhancing the "PRAGMA cache_spill" statement to accept a cache threashold size. (check-in: 549d42be0d user: drh tags: cache_spill=N) | |
|
2015-11-11
| ||
| 18:43 | Fix missing word in a documentation comment. No changes to code. (check-in: ed24d30265 user: mistachkin tags: trunk) | |
| 18:08 | Add a hack to debug out a description of the WHERE clause of a SELECT (or other) statement. Use this in script tool/schemalint.tcl to automatically recommend indexes that might speed up specific queries. (check-in: c6fa01c28e user: dan tags: schemalint) | |
| 15:28 | Improvements to the SQLITE_CONFIG_PAGECACHE documentation. Enhance the command-line shell to be able to take advantage of the full range of SQLITE_CONFIG_PAGECACHE capabilities, such as setting pMem==NULL and N<0. (check-in: 2518d5c971 user: drh tags: trunk) | |
|
2015-11-10
| ||
| 14:51 | Improved output formatting for "PRAGMA parser_trace=ON;". (check-in: e43e1171fd user: drh tags: trunk) | |
| 14:27 | Make the output of "PRAGMA parser_trace" go to stdout instead of stderr. (check-in: 1e4849911e user: drh tags: trunk) | |
| 13:45 | Save a few bytes in the parser by using "int" instead of "u8" or "u16" for all small integer types. (check-in: 5dcd212bf6 user: drh tags: trunk) | |
| 12:41 | Change all parsers to use the standard "lempar.c" template in the tool/ folder and remove the customized lempar.c from src/, plus other compiler performance and space enhancements. (check-in: 0e7fb24ad3 user: drh tags: trunk) | |
| 12:31 | Fix harmless compiler warnings in FTS5. (Closed-Leaf check-in: 09752e51a1 user: drh tags: parser-enhancements) | |
| 03:30 | Performance enhancement to the tokenizer. (check-in: 6ea2df86c9 user: drh tags: parser-enhancements) | |
| 00:02 | Remove an unused non-terminal from the grammar. (check-in: 3c37c52288 user: drh tags: parser-enhancements) | |
|
2015-11-09
| ||
| 19:35 | Fix a comment typo in the lempar.c template that was missed by the prior check-in. (check-in: c4a7e93fca user: drh tags: parser-enhancements) | |
| 19:33 | Change the parser to use the standard "lempar.c" template over in the tool/ folder rather than the customized "lempar.c" found in src/. (check-in: 0a72991f4e user: drh tags: parser-enhancements) | |
| 15:06 | Avoid recursion in the yy_find_shift_action() routine of the Lemon-generated parser, so that routine can be inlined, for a size reduction and performance increase. (check-in: 0557a179f9 user: drh tags: trunk) | |
| 14:11 | Size reduction and performance improvement in the stack-popping logic of the Lemon-generated parser. (check-in: 9748c48a4f user: drh tags: trunk) | |
| 12:47 | Fix incorrect WHERE clause in sqldiff, as reported on the mailing list by Youcef Hilem. (check-in: e0ed4c3e37 user: drh tags: trunk) | |
| 12:44 | Check in the cg_anno.tcl and run-speed-test.sh scripts, as an historical record. (check-in: 836418d3b7 user: drh tags: trunk) | |
| 12:33 | Avoid unnecessary function prologues in the sqlite3VdbeAddOp3() routine. (check-in: 7c6a19ba9b user: drh tags: trunk) | |
| 02:08 | Small size reduction and performance increase in the parser. (check-in: d62cd757a6 user: drh tags: trunk) | |
|
2015-11-07
| ||
| 18:32 | Enhance the sqldiff utility to deal gracefully with ALTER TABLE ADD COLUMN. (check-in: 7ea036ac37 user: drh tags: trunk) | |
| 18:07 | Fix a bug in CTE handling discovered by LibFuzzer that can cause an infinite loop in the query planner. (check-in: 088009efdd user: dan tags: trunk) | |
| 17:51 | Add test cases for WITH clauses. (Closed-Leaf check-in: e7e65c7559 user: dan tags: infinite-with-loop-bug) | |
| 17:48 | Proposed fix for an infinite loop bug in the WITH clause semantic analysis logic. (check-in: 028475cb17 user: drh tags: infinite-with-loop-bug) | |
| 15:19 | Enhance TreeView to show WITH clauses. Add an assert to detect the infinite loop behavior when certain kinds of errors occur on a nested WITH clause. (check-in: 2040d88e87 user: drh tags: infinite-with-loop-bug) | |
| 01:57 | Merge recent enhancements and fixes from trunk. (check-in: 5429f99b98 user: drh tags: apple-osx) | |
| 01:33 | Merge recent enhancements and bug fixes from trunk. (check-in: 78bc42e664 user: drh tags: sessions) | |
| 01:19 | The OPFLAG_SEEKEQ optimization is only applicable to equality comparisons against an index, not against a rowid table. (check-in: 0f5b147d1f user: drh tags: trunk) | |
| 00:51 | Fix a harmless sanitizer warning in the ieee754 extension. (check-in: dd9a26ecde user: drh tags: trunk) | |
|
2015-11-06
| ||
| 20:22 | Avoid an unnecessary key comparison when doing an indexed lookup against an equality constraint. (check-in: d741e1ccdc user: drh tags: trunk) | |
| 20:13 | Work around a sign-extension bug in the optimizer on the HP C compiler that comes with HP/UX. (check-in: 46c36b1543 user: drh tags: trunk) | |
| 20:04 | Test changes: Omit numindex1.test from valgrind, since valgrind uses a none-standard floating-point processor which gives inconsistent answers. Run one releasetest.tcl module using LONGDOUBLE_TYPE=double. (check-in: d421efbf9a user: drh tags: trunk) | |
| 19:53 | Enforce consistent comparison results between integer and floating point values. Fix for ticket [38a97a87a6e4e83]. (check-in: 849e686da2 user: drh tags: trunk) | |
| 17:59 | Merge the fixes and tests for the ieee754 extension. (Closed-Leaf check-in: 7a9988d38c user: drh tags: int-float-precision) | |
| 17:28 | A proposed patch for working around a bug in the optimizer for the HP compiler found on HP/UX Itanium. (Closed-Leaf check-in: 8a171548e4 user: drh tags: hp-optimizer-fix) | |
| 17:01 | Test cases for the ieee754 extension. (check-in: 840cbda886 user: drh tags: trunk) | |
| 14:59 | A different approach to handling integer/float comparisons. This seems to work better on systems where "long double" and "double" are the same type, but still needs refinement and testing. (check-in: a3f7614b20 user: drh tags: int-float-precision) | |
| 12:50 | Have fts5 load its configuration from the xConnect() method is invoked. This ensures that the very first query run uses the correct value of the 'rank' option. (check-in: 33e6606f5e user: dan tags: trunk) | |
| 04:14 | More test cases for indexes on large numeric values. (check-in: c220741a62 user: drh tags: int-float-precision) | |
| 03:37 | Some simple test cases from the mailing list. (check-in: 1d642b73f9 user: drh tags: int-float-precision) | |
| 01:04 | Increase the precision of integer vs. floating-point comparisons. Candidate fix for ticket [38a97a87a6e4e8]. (check-in: cfcaa0ff27 user: drh tags: int-float-precision) | |
|
2015-11-05
| ||
| 22:30 | Improvements and simplifications to the equality seek logic. Tests are adjusted so that they all pass now. (Closed-Leaf check-in: 997ce6c90b user: drh tags: seekeq-experiment) | |
| 21:49 | Fix typo in help information for an FTS5 script. (check-in: 777ae8007f user: mistachkin tags: trunk) | |
| 20:25 | The top of an index equality loop normally starts with OP_SeekGE and OP_IdxGT. This check-in adds a flag to OP_SeekGE such that it fails immediately if the key is not equal, then jumps over the OP_IdxGT, saving a call to the key comparison functions. Consider this check-in a proof-of-concept. It needs improvement before going on trunk. Some tests fail, but only because they new use fewer key comparisons than expected (which is a good thing!). (check-in: 32e31b9bc8 user: drh tags: seekeq-experiment) | |
| 18:09 | Add the 'hashsize' configuration option to fts5, for configuring the amount of memory allocated to the in-memory hash table while writing. (check-in: 445480095e user: dan tags: trunk) | |
| 11:47 | Remove a #pragma used to work around an issues with MSVC 2012 that has been overcome but subsequent changes. (check-in: 8303e4cfed user: drh tags: trunk) | |
| 03:26 | Remove #pragma that was used to work around an obsolete issue with MSVC 2012. (Closed-Leaf check-in: b9b22fae69 user: mistachkin tags: reoptimizeArm) | |
|
2015-11-04
| ||
| 22:31 | Performance improvements in the getAndInitPage() routine of btree.c. (check-in: 2aa50f6f20 user: drh tags: trunk) | |
| 20:22 | Rename the sqlite3PagerAcquire() function to sqlite3PagerGet(). The former macro called sqlite3PagerGet() has been removed. (check-in: 708253be34 user: drh tags: trunk) | |
| 16:34 | In releasetest.tcl, run larger test first if --jobs is greater than 1. Run smaller tests cases first if --jobs is 1. (check-in: 3fece5d02a user: drh tags: trunk) | |
| 13:03 | Exclude cffault.test and symlink.test from the (incompatible) inmemory_journal permutation. (check-in: 4f16e9686d user: drh tags: trunk) | |
|
2015-11-03
| ||
| 23:39 | Increase the fuzzcheck timeout when running valgrind. (check-in: a5816877bd user: drh tags: trunk) | |
| 19:13 | In 'e_uri.test', make sure all created test database files get deleted. (check-in: 40c4f4a65e user: mistachkin tags: trunk) | |
| 15:39 | In the releasetest.tcl script, add the --progress option to cause the start of each subprocess to be shown. Otherwise, revert to the old-style display. Improvements to the handling of the --buildonly option. (check-in: d969792f34 user: drh tags: trunk) | |
| 15:16 | In the releasetest.tcl script, show the --jobs object on the command-line summary. Report the time of each "starting:" event. Do not show errors on a --dryrun. (check-in: b75107778f user: drh tags: trunk) | |
| 14:49 | Update the releasetest.tcl script so that it can run multiple tests in parallel in separate processes. (check-in: e3de82919d user: drh tags: trunk) | |
| 06:23 | Further enhancement and a bit of cleanup. (Closed-Leaf check-in: 0d8b59783e user: mistachkin tags: mp-releasetest) | |
| 02:47 | Use the native name for the MSVC makefile as well. (check-in: e457c61564 user: mistachkin tags: mp-releasetest) | |
|
2015-11-02
| ||
| 23:29 | Attempt to centralize and simplify the MSVC handling. (check-in: 4ae96d6dde user: mistachkin tags: mp-releasetest) | |
| 23:21 | Fix the backcompat.test module so that it does not try to compare against itself on windows. (check-in: f625bce8b7 user: drh tags: mp-releasetest) | |
| 21:05 | Get things working better on Windows with MSVC. (check-in: 22cc3e6c8e user: mistachkin tags: mp-releasetest) | |
| 20:52 | Fix the --dryrun option on the releasetest.tcl script. (check-in: e565e02615 user: dan tags: mp-releasetest) | |
| 20:28 | Fix releasetest.tcl so that it does not choke if a test fails so badly that there is no log file. Add the --jobs switch to the usage message. (check-in: 20e96f521f user: dan tags: mp-releasetest) | |
| 20:24 | Fix releasetest.tcl so that output lines are less than 80 characters wide. (check-in: aef177fef0 user: dan tags: mp-releasetest) | |
| 18:57 | Merge all recent enhancements and fixes from trunk. (check-in: 0546d1cd1a user: drh tags: sessions) | |
| 18:32 | Add the "--jobs N" option to the releasetest.tcl script to allow tests to be run in parallel by N processes. N defaults to 1. (check-in: 3d29f912cb user: dan tags: mp-releasetest) | |
| 15:10 | Merge latest trunk changes, including the follow-symlinks functionality and 3.9.2 bugfixes, into this branch. (check-in: 447521d747 user: dan tags: apple-osx) | |
| 15:08 | On unix, if a file is opened via a symlink, create, read and write journal and wal files based on the name of the actual db file, not the symlink. (check-in: 6d5ce3ede4 user: dan tags: trunk) | |
|
2015-11-01
| ||
| 21:19 | If a table-constraint PRIMARY KEY lists a single column in single-quotes and that column has type INTEGER, then make that column an integer primary key, for historical compatibility. Fix for ticket [ac661962a2aeab3c331]. (check-in: db319a035f user: drh tags: trunk) | |
|
2015-10-31
| ||
| 17:58 | On unix, if a file is opened via a symlink, create, read and write journal and wal files based on the name of the actual db file, not the symlink. (Closed-Leaf check-in: c7c8105099 user: dan tags: follow-symlinks) | |
|
2015-10-30
| ||
| 20:54 | Add mutex operations to test code in test3.c to avoid triggering assert() failures in certain configurations. (check-in: 9f19420b0a user: dan tags: trunk) | |
| 17:17 | Merge the sqlite3_db_cacheflush() enhancements and other changes from trunk. (check-in: f2cde4cfc5 user: drh tags: begin-concurrent) | |
| 16:50 | Merge all the latest enhancements from trunk. (check-in: 395a153ff7 user: drh tags: sessions) | |
| 16:37 | Merge the 3.10.0 version number update from trunk. (check-in: 980d620743 user: drh tags: apple-osx) | |
| 16:36 | Increase the version number to 3.10.0, due to the addition of the sqlite3_db_cacheflush() interface. (check-in: 7565b046ff user: drh tags: trunk) | |
| 16:23 | Merge latest trunk changes, including sqlite3_db_cacheflush(), with this branch. (check-in: 6e4306efaf user: dan tags: apple-osx) | |
| 16:14 | Add new API function sqlite3_db_cacheflush(). (check-in: ad80d30733 user: dan tags: trunk) | |
| 14:28 | Return immediately if sqlite3PagerWrite() is called when the pager is in PAGER_ERROR state. (Closed-Leaf check-in: a6695b0084 user: dan tags: cacheflush) | |
| 14:25 | Add the --enable-editline option to various autoconf scripts. (check-in: 866f027778 user: drh tags: trunk) | |
| 09:13 | Test that calling sqlite3_db_cacheflush() does not interfere with savepoints. (check-in: 0e09e4a269 user: dan tags: cacheflush) | |
|
2015-10-29
| ||
| 21:11 | Do not attempt to flush the pages of an in-memory database to disk if sqlite3_db_cacheflush() is called. (check-in: 9b79a39044 user: dan tags: cacheflush) | |
| 20:57 | Add a test case that calls sqlite3_db_cacheflush() on an in-memory database. (check-in: f0cdfb547b user: dan tags: cacheflush) | |
| 18:16 | Avoid automatically rolling back the transaction if an SQLITE_IOERR or SQLITE_FULL error occurs within sqlite3_db_cacheflush(). (check-in: 370b5d520c user: dan tags: cacheflush) | |
| 14:29 | The optimization on this branch is logically incorrect. It changes the return value of "SELECT 0 OR 'xyzzy'" FROM 0 to 'xyzzy'. (Closed-Leaf check-in: a0c08d2689 user: drh tags: simplify-or-clause) | |
| 13:48 | Fix uses of ctype functions (ex: isspace()) on signed characters in test programs and in some obscure extensions. No changes to the core. (check-in: 34eb6911af user: drh tags: trunk) | |
| 12:27 | Apply optimizations to simplify OR clauses that contain constant terms. (check-in: d533e23f05 user: drh tags: simplify-or-clause) | |
| 01:11 | Enhance comments in the MSVC batch build tool. (check-in: 2964ce2586 user: mistachkin tags: trunk) | |
|
2015-10-28
| ||
| 20:01 | Make the internal sqlite3PExpr() interface responsive to the TKFLG_DONTFOLD flag on the operator parameter. (check-in: b10ab59fb8 user: drh tags: trunk) | |
| 19:46 | Add experimental API sqlite3_db_cacheflush(). (check-in: 65b86dc1fa user: dan tags: cacheflush) | |
| 16:05 | Factor out adding NOT expression nodes in the parser into a subroutine. (check-in: 0018541816 user: drh tags: trunk) | |
|
2015-10-27
| ||
| 20:04 | Have contentless and external content fts5 tables ignore "OR REPLACE" conflict handling. (check-in: a85c2a4758 user: dan tags: trunk) | |
| 17:48 | Fix problems with prefix queries in fts5. (check-in: 3b5758c647 user: dan tags: trunk) | |
| 13:35 | Provide hints to the storage engine using the sqlite3BtreeCursorHint() interface when compiling with SQLITE_ENABLE_CURSOR_HINTS. (check-in: 45d3539e15 user: drh tags: trunk) | |
| 13:24 | Split out sqlite3BtreeCursorHintFlags() from sqlite3BtreeCursorHint() the interface for improved performance. (Closed-Leaf check-in: b3ec9a0d62 user: drh tags: cursor-hints) | |
|
2015-10-26
| ||
| 20:50 | Merge latest trunk changes, including the SQLITE_IOERR_AUTH error code, with this branch. (check-in: bc195e1cd9 user: dan tags: apple-osx) | |
| 20:39 | Add new extended error code SQLITE_IOERR_AUTH. (check-in: b4e70dd08e user: dan tags: trunk) | |
| 20:11 | Merge the BTREE_FORDELETE enhancement with this branch. (check-in: 20da0849ce user: dan tags: cursor-hints) | |
| 18:51 | Merge in all trunk changes prior to the BTREE_FORDELETE enhancement. (check-in: 53d5a4add6 user: drh tags: cursor-hints) | |
| 18:01 | Capture BTREE_FORDELETE test cases that were mistakenly omitted from the previous merge. (check-in: de6972515f user: drh tags: trunk) | |
| 17:50 | Provide the BTREE_FORDELETE flag to sqlite3BtreeCursor() if the cursor will be used only for deletions and seeking. (check-in: 871b1c78bc user: drh tags: trunk) | |
| 16:34 | Fix an uninitialized variable problem in the test code added by the previous commit. (Closed-Leaf check-in: 7849662ef9 user: dan tags: btree-fordelete-flag) | |
| 16:31 | Test that the binary record "0x01 0x00" is interpreted by OP_Column as a vector of NULL (or default) values. (check-in: 5bdc3c82bd user: dan tags: btree-fordelete-flag) | |
| 14:54 | Fix a C99-ism and a harmless compiler warning. (check-in: 138783b553 user: drh tags: trunk) | |
| 14:41 | When compiling with SQLITE_HAS_CODEC, honor the hexkey= query parameter on URI pathnames in sqlite3_open_v2(). (check-in: e0ce3fc089 user: drh tags: trunk) | |
| 12:55 | Remove an unreachable branch in malloc.c. (check-in: a36b7fe923 user: drh tags: trunk) | |
|
2015-10-24
| ||
| 20:31 | When creating an automatic-index on a sub-query, add a unique integer to the end of each index key to ensure the entire key is unique. Fix for [8a2adec1]. (check-in: bfea226d0d user: dan tags: trunk) | |
|
2015-10-23
| ||
| 11:50 | Remove an unused #define from whereInt.h. Add comments describing the new sqlite3BtreeCursor() flags. (check-in: 4c0ba8be43 user: dan tags: btree-fordelete-flag) | |
|
2015-10-22
| ||
| 20:54 | Modifications to pass a flag to internal routine sqlite3BtreeCursor() when a cursor that is used solely for deleting b-tree entries, or for obtaining the components of keys to delete from other b-trees, is opened. (check-in: cdc92919e6 user: dan tags: btree-fordelete-flag) | |
| 18:06 | Alternate compiler warning fix for sqlite3StatusHighwater. (check-in: 4315d20200 user: mistachkin tags: trunk) | |
|
2015-10-21
| ||
| 22:08 | Fix harmless compiler warnings in FTS5. (check-in: aa4e01ea1a user: mistachkin tags: trunk) | |
| 22:07 | Fix compilation of 'testfixture' with MSVC when the FTS5 and JSON1 extensions are enabled. (check-in: e31aa97a92 user: mistachkin tags: trunk) | |
| 20:56 | Remove some branches made unreachable by recent changes from fts5. (check-in: ae350bfbfd user: dan tags: trunk) | |
| 20:07 | Minor optimization for fts5 queries. (check-in: 363b36d50b user: dan tags: trunk) | |
| 08:26 | Add extra debugging function to test_rbu.c. Enhance the documentation for sqlite3rbu_db() to define the validity of the returned database handles. (check-in: b9c4aa5211 user: dan tags: trunk) | |
|
2015-10-20
| ||
| 23:40 | Fix compiler warnings. (Closed-Leaf check-in: 12e869bbac user: mistachkin tags: noWarn) | |
| 23:27 | Fix harmless compiler warnings in FTS5. (check-in: 0a903ec26b user: mistachkin tags: trunk) | |
| 21:05 | More optimizations for fts5 prefix queries. (check-in: b8fb263ed1 user: dan tags: trunk) | |
| 19:55 | Fix #line directives added to generated file fts5.c. (check-in: 1f5f5804cd user: dan tags: trunk) | |
| 15:49 | Initialize variables in the fts5 integrity-check code to avoid compiler warnings. (check-in: e979e2ccca user: dan tags: trunk) | |
|
2015-10-19
| ||
| 20:49 | Another optimization for fts5 prefix (and other) queries. (check-in: 60a8bde055 user: dan tags: trunk) | |
| 17:43 | Another tweak to improve performance of fts5 prefix queries. (check-in: 69be427c86 user: dan tags: trunk) | |
| 15:59 | Fix a problem in the fts5txt2db.tcl script causing it to fail when creating tables with more than 8 columns. (check-in: 68ee426a64 user: dan tags: trunk) | |
|
2015-10-17
| ||
| 20:34 | Add tests to cover new branches added to the fts5 code by the previous commit. (check-in: cf618334a8 user: dan tags: trunk) | |
| 19:49 | Handle equality and range constraints on the "term" column of fts5vocab tables. Also have the same module report columns using names instead of indexes. (check-in: 6020d96ab4 user: dan tags: trunk) | |
| 01:00 | Change the code generator for UPDATE to generate code in an order that might run more efficiently in many cases. (Leaf check-in: c6239bf943 user: drh tags: improved-update) | |
|
2015-10-16
| ||
| 23:55 | Fix a comment in expr.c and add a CORRUPT_DB to an assert() in btree.c. (check-in: 0df371d1a5 user: drh tags: trunk) | |
| 20:55 | Merge the 3.9.1 updates from trunk. (check-in: bf866e6c0d user: drh tags: begin-concurrent) | |
| 20:53 | Merge recent enhancements from trunk. Version now 3.9.1. (check-in: 26fa091d68 user: drh tags: cursor-hints) | |
| 20:13 | Enhancements to the MSVC makefile. (check-in: 39e8a5d93f user: mistachkin tags: trunk) | |
| 20:12 | Merge the 3.9.1 changes into trunk. (This only updates the version number and configure script since all the other changes in 3.9.1 were cherrypicked from trunk.) (check-in: eb2317429f user: drh tags: trunk) | |
| 15:42 | Fix the fuzzershell utility program so that it compiles with the amalgamation that includes JSON1 support. (check-in: d6fc616e4c user: drh tags: trunk) | |
| 15:35 | Fix the JSON1 extension so that it does not depend on isdigit() and strtod() from the standard library when compiled into SQLite as part of the amalgamation. (check-in: bc9a9a60c3 user: drh tags: trunk) | |
| 15:16 | Form-feed is not valid whitespace for json. Fix for ticket [57eec374ae1d0a1d] (check-in: 28957d6359 user: drh tags: trunk) | |
| 14:54 | Have the sqlite3VdbeSerialType() function go ahead and compute the serial length as well, since it is always needed. This avoids unnecessary calls to sqlite3VdbeSerialTypeLen(). (check-in: 2ad72be124 user: drh tags: trunk) | |
| 14:23 | Use a lookup table to compute the content length for serial types less than 128, for a 1.2% performance improvement. (check-in: 3395724814 user: drh tags: trunk) | |
| 13:50 | Simplify the OP_Column logic slightly. One very small performance improvement added. (check-in: 0114b45dc2 user: drh tags: trunk) | |
| 12:53 | OP_Column optimization: Do not check for an oversize row header unless the row header size is larger than the content available on the local page. (check-in: 8125b74cb4 user: drh tags: trunk) | |
| 12:39 | Improved header comment on the tool/vdbe_profile.tcl script. No changes to code. (check-in: b17ad8fc04 user: drh tags: trunk) | |
| 03:34 | Whenever two or more OP_Column opcodes on the same cursor occur in succession, try to reordering them so that the one that extracts the right-most column is first, so that it will warm up the row cache for all those that follow. This gives a small performance boost. (Leaf check-in: 08e8f04d12 user: drh tags: reorder-column-opcodes) | |
|
2015-10-15
| ||
| 21:30 | Performance optimization for the OP_Column opcode. (check-in: 076be5474d user: drh tags: trunk) | |
| 21:13 | Merge updates from trunk. (Leaf check-in: 4049368008 user: mistachkin tags: mutexInitIsInitReCheck) | |
| 21:12 | Merge updates from trunk. (Leaf check-in: a447cf90dd user: mistachkin tags: mutexInitSimpleCmpSwap) | |
| 20:17 | Experiments with an OP_Unpack opcode that extracts multiple columns from a record without caching. (Leaf check-in: 39ae92f5c6 user: drh tags: unpack-opcode) | |
| 19:21 | Enhance the use of the column cache for UPDATE statements, making them more efficient for the case where a column is modified to be an expression of other unmodified columns. (check-in: 871e091df6 user: drh tags: trunk) | |
| 18:04 | Add the OP_IntCopy opcode - an optimized version of OP_SCopy that only works for integer values. (check-in: 3a2f73a492 user: drh tags: trunk) | |
| 17:31 | Optimization to the out2Prerelease() helper routine in the VDBE engine. (check-in: 79298fe8c4 user: drh tags: trunk) | |
| 17:21 | Remove a superfluous conditional from the memory allocation initialization. (check-in: 9ccf8f8d35 user: drh tags: trunk) | |
| 16:20 | Performance optimizations to the sqlite3MallocSize() by requiring the argument to always be non-NULL. (check-in: cb65989b07 user: drh tags: trunk) | |
| 15:28 | Change sqlite3StatusSet() into sqlite3StatusHighwater() so that only the highwater mark is recorded. This gives a small size reduction and performance improvement. (check-in: 6422d223dd user: drh tags: trunk) | |
| 12:06 | Make sure sqlite.h is not #included by itself. (check-in: a61880c223 user: drh tags: trunk) | |
| 07:44 | Merge in the 3.9.0 changes from trunk. (check-in: 5c3a2a6ed6 user: drh tags: begin-concurrent) | |
|
2015-10-14
| ||
| 23:04 | In the MSVC makefile, add LIBTCLPATH variable to make it easier to run tests when the Tcl library is not already present in the PATH. (check-in: 54127602b9 user: mistachkin tags: trunk) | |
| 22:46 | In the MSVC makefile, make sure LDFLAGS is used for the tool executables as well. (check-in: 0a17ee49c6 user: mistachkin tags: trunk) | |
| 21:08 | Tests and minor fixes to improve coverage of FTS5 code. (check-in: f4de6d450e user: dan tags: trunk) | |
| 20:34 | Fix harmless compiler warnings. (check-in: 1c46c194a2 user: mistachkin tags: trunk) | |
| 20:09 | Merge in all the 3.9.0 updates from trunk. (check-in: 2944414934 user: drh tags: cursor-hints) | |
| 20:03 | Update makefiles to remove all uses of "awk" - to make building SQLite easier on Windows systems. The only requirements now are tclsh, a C compiler, and common file utilities. (check-in: 4bd0d43db7 user: drh tags: trunk) | |
| 20:01 | Enable cross-compiling the various tool EXEs with MSVC. (check-in: 7d77233389 user: mistachkin tags: trunk) | |
| 19:52 | Fixes to the JSON1 extension and its use by fuzzcheck to avoid problems when building DLLs. (check-in: 01d3ee7bbe user: drh tags: trunk) | |
| 19:44 | Fix fuzzcheck.c so that it assumes that JSON1 is already compiled in and does not need to be initialized further. (Closed-Leaf check-in: ec00395835 user: drh tags: dll-build-fix) | |
| 18:45 | Avoid exporting sqlite3_json_init() from amalgamation builds. (check-in: 8463f7e790 user: dan tags: dll-build-fix) | |
| 12:29 | Version 3.9.0 (check-in: a721fc0d89 user: drh tags: trunk, release, version-3.9.0) | |
| 10:56 | Add the missing 'extern "C" {...}' blocks to fts5.h and sqlite3rbu.h. (check-in: 47a2ce97d5 user: dan tags: trunk) | |
|
2015-10-12
| ||
| 22:31 | Remove the unused fts5ExprColsetTest() routine. (check-in: 9ecafc0c94 user: drh tags: trunk) | |
| 22:20 | Fix a couple harmless compiler warnings. (check-in: 7f896a971c user: mistachkin tags: trunk) | |
| 19:12 | Further tweaks to improve fts5 prefix query performance. (check-in: 1c20c1c28b user: dan tags: trunk) | |
| 04:56 | Change all references to 3.8.12 into 3.9.0. Comment changes only - no changes to code. (check-in: 6f2858f681 user: drh tags: trunk) | |
|
2015-10-11
| ||
| 20:39 | Detect and report circularly defined views even if the views have the columns defined in the CREATE VIEW statement. (check-in: 9ab9c8c6d7 user: drh tags: trunk) | |
| 20:08 | Remove an unreachable branch in the query flattener substitution logic. (check-in: 46ee3453a3 user: drh tags: trunk) | |
| 19:46 | Improved substitution logic in the query flattener. Saves code space, and (more importantly) works correctly with table-valued functions. (check-in: 3d0bd95e97 user: drh tags: trunk) | |
|
2015-10-10
| ||
| 16:41 | Work around a "security feature" bug in memcpy() on OpenBSD. (check-in: fab6f09044 user: drh tags: trunk) | |
| 15:57 | Remove another instance of strcpy() from FTS5, to mollify OpenBSD. (check-in: 35e6248abb user: drh tags: trunk) | |
| 15:11 | Omit the use of strcpy() in FTS5 since OpenBSD hates strcpy(). (check-in: bc24a5bbfd user: drh tags: trunk) | |
| 14:41 | Compiler warning fixes: Rename some local variables from "j1" to avoid a name collision with the j1() bessel function in the math library. Omit a dummy initializer that gcc 4.6.3 does not like. (check-in: 9ddef84d43 user: drh tags: trunk) | |
| 14:00 | Add some #ifdef-ery to json1.c to avoid a duplicate typedef when used in the amalgamation, since some compilers become upset over duplicate typedefs. (check-in: de28acd42f user: drh tags: trunk) | |
|
2015-10-09
| ||
| 20:40 | The previous fix to JSON1 was not complete. A few more tweaks are needed for correct handling of all oversized integers. (check-in: 4a47f01778 user: drh tags: trunk) | |
| 18:21 | Fix the JSON1 extension so that it renders integers outside the range of -9223372036854775808 to +9223372036854775807 as floating-point numbers. (check-in: ae736e35fb user: drh tags: trunk) | |
| 17:54 | Remove fts5 sources from TESTSRC2 in main.mk as there is no SQLITE_TEST code in said files. (check-in: c1840639b8 user: dan tags: trunk) | |
| 14:37 | Add --enable-fts5 and --enable-json1 options to the amalgamation autoconf package. (check-in: 8a4e19888f user: dan tags: trunk) | |
| 14:23 | In the MSVC makefile, adjust the names of two nmake variables for consistency. (check-in: 92aa4b6b6f user: mistachkin tags: trunk) | |
| 13:42 | Change the version number of the next release to 3.9.0. (check-in: aa8fdadf2d user: drh tags: trunk) | |
| 13:39 | Add the JSON1 and FTS5 extensions to the amalgamation. Add new options to ./configure: --enable-json1 and --enable-fts5. (check-in: 1eb7699331 user: drh tags: trunk) | |
| 13:29 | Fix a typo in the MSVC Makefile (Closed-Leaf check-in: c8a1208238 user: drh tags: amalg-json1-fts5) | |
| 12:48 | Add configure script options --enable-fts5 and --enable-json1. Automatically search for -lm when using --enable-fts5. (check-in: a0c44f1d46 user: drh tags: amalg-json1-fts5) | |
| 11:09 | Makefile and fts5 changes so that fts5 works with main.mk. Still does not work with Makefile.in. (check-in: 6ebac32d83 user: dan tags: amalg-json1-fts5) | |
| 01:42 | Trying to get FTS5 tests to build and run using main.mk. Not yet working. (check-in: 206174f9b1 user: drh tags: amalg-json1-fts5) | |
|
2015-10-08
| ||
| 23:37 | Json1 tests are working. Builds without FTS5 enabled. Still some problems building with FTS5. (check-in: 2928f8e87d user: drh tags: amalg-json1-fts5) | |
| 21:02 | Remove calls to "load_static_extension" from fts5 test scripts. (check-in: 53dd7c4c65 user: dan tags: amalg-json1-fts5) | |
| 21:00 | Further tweaks to main.mk so that fts5 builds as part of testfixture. (check-in: 97e11b79a5 user: dan tags: amalg-json1-fts5) | |
| 20:40 | Fix further fts5 compilation issues. (check-in: 0d7f301fb0 user: dan tags: amalg-json1-fts5) | |
| 20:28 | Fix two more warnings in fts5 code. (check-in: 5343e601fb user: dan tags: amalg-json1-fts5) | |
| 20:11 | Fix a couple of errors in fts5 compilation. This branch still does not build with -Wall -Werror. (check-in: e9e76e1281 user: dan tags: amalg-json1-fts5) | |
| 19:29 | First attempt to add json1 and fts5 to the amalgamation. This check-in does not compile. (check-in: d820a1bd1b user: drh tags: amalg-json1-fts5) | |
| 17:35 | In the RBU extension, use MoveFile() instead of rename() on Windows CE. (check-in: df9ef61f1b user: mistachkin tags: trunk) | |
| 02:44 | Remove two unused lines of code - discovered by scan-build. (check-in: 77b707b774 user: drh tags: trunk) | |
|
2015-10-07
| ||
| 19:06 | Further optimizations for fts5 prefix queries without a prefix index. (check-in: 83dc1ff7fa user: dan tags: trunk) | |
| 17:06 | Fix harmless compiler warning in FTS5. (check-in: 13adcd038f user: mistachkin tags: trunk) | |
| 17:01 | Allow the subsitute character (codepoint 26 - 0x1A) to appear in fts5 barewords. (check-in: baec1b96cb user: dan tags: trunk) | |
| 16:14 | Adjustments to spellfix2.test so that it works reliably on mac. (check-in: d591e860d3 user: drh tags: trunk) | |
| 13:24 | Add tests for fts5 phrase queries with column filters. (check-in: f20f9f813f user: dan tags: trunk) | |
| 09:02 | Add further tests for fts5 prefix queries. (check-in: accdc98b12 user: dan tags: trunk) | |
| 04:20 | Fix a typo in the previous check-in. (check-in: 80027709c3 user: mistachkin tags: trunk) | |
| 03:07 | When running tests on Tcl 8.6 under Windows, skip tests 'uri-1.12.*' due to a change in Tcl behavior related to NTFS ADS (alternate data streams). (check-in: 8a0a2aa5a6 user: mistachkin tags: trunk) | |
| 00:35 | Remove three obsolete and unused files from tool/ (check-in: 0abd65294e user: drh tags: trunk) | |
|
2015-10-06
| ||
| 21:49 | Fix typo in comments. No changes to code. (check-in: a05f903c64 user: mistachkin tags: trunk) | |
| 21:07 | Simplifications to the VDBE bytecode that handles LIMIT and OFFSET. (check-in: 041df7c2f1 user: drh tags: trunk) | |
| 20:53 | Optimizations for fts5 expressions that filter on column. More still to come. (check-in: bf1607ac15 user: dan tags: trunk) | |
| 17:27 | Fix the LIMIT and OFFSET handling for UNION ALL queries that contain a subquery with ORDER BY on the right-hand side. Fix for ticket [b65cb2c8d91f668584]. (check-in: 4b63136435 user: drh tags: trunk) | |
| 01:44 | Adjustments to sqlite3MemoryBarrier() when compiling with MSVC and/or WinCE. (check-in: 3168326ebf user: mistachkin tags: trunk) | |
|
2015-10-05
| ||
| 19:41 | Improve performance of prefix queries without a prefix index on fts5 tables. (check-in: f2f0184e9e user: dan tags: trunk) | |
| 15:39 | Update fts3 so that expressions to the left and right of a NOT operator are balanced. This prevents relatively small expressions (a dozen terms or so) that are children of NOT operators from triggering the "expression tree is too large" error. (check-in: d6b66cd7b8 user: dan tags: trunk) | |
| 11:57 | Add fts5txt2db.tcl, a tool for creating sample fts4/5 databases from text files. (check-in: 44f1ce30d1 user: dan tags: trunk) | |
|
2015-10-03
| ||
| 15:38 | Update fts5 to support the table function syntax. "... FROM fts5_tbl WHERE fts5_tbl MATCH ?1 AND rank MATCH ?1" can now be written "FROM fts5_tbl(?1, ?2)". (check-in: 41d17d9e24 user: dan tags: trunk) | |
| 12:23 | Add tests for the rtree module to verify that attempts to insert non-integer primary key values or non-numeric dimensions into an rtree table are handled correctly. (check-in: f653fce908 user: dan tags: trunk) | |
|
2015-10-02
| ||
| 20:04 | Update fts5 to avoid using a statement journal for UPDATE and DELETE operations that affect at most a single row. (check-in: 5c83b9db46 user: dan tags: trunk) | |
|
2015-10-01
| ||
| 18:31 | Fix an fts3 bug causing NEAR queries on uncommitted data to malfunction. (check-in: 6f90839e91 user: dan tags: trunk) | |
|
2015-09-30
| ||
| 14:30 | Add a corrupt database to test/fuzzdata3.db to validate the previous check-in. (check-in: e796c0efb6 user: drh tags: trunk) | |
| 14:19 | Fix an assert() in btree.c that is only true for non-corrupt databases. (check-in: 29f7227ff1 user: drh tags: trunk) | |
| 12:59 | Clear the BTCF_ValidNKey flag when putting a cursor into REQUIRESEEK state. Fix for [1b266395]. (check-in: a6d5e4e869 user: dan tags: trunk) | |
| 11:19 | Improve error handling in shell command ".tables". (check-in: 31a91ee7d3 user: dan tags: trunk) | |
|
2015-09-29
| ||
| 17:20 | Use symbolic names XN_ROWID and XN_EXPR in place of the (-1) and (-2) magic numbers in Index.aiColumn[]. Add asserts to help verify that Index.aiColumn[] is always used correctly. Fix one place in FK processing where Index.aiColumn[] was not being used correctly. (check-in: 7d272aa62c user: drh tags: trunk) | |
| 16:47 | Add the sqlite3_index_info.idxFlags field, allowing xBestIndex() implementations to specify to SQLite that a strategy may visit at most one row. Add support for this to fts3/4. Omit the statement journal from virtual table UPDATE and DELETE operations that are guaranteed not to affect more than one row. (check-in: a1d08fd3d0 user: dan tags: trunk) | |
| 16:41 | Ensure that the xSavepoint() virtual table method is correctly invoked if there are already open savepoints (or statement transactions) the first time a virtual table is written within a transaction. (check-in: 77948b5ece user: dan tags: trunk) | |
| 15:50 | Remove dead code, replacing with assert() statements that make sure the code really was dead. (Closed-Leaf check-in: 0e317dda5d user: drh tags: vtab-onepass) | |
| 13:25 | Create the sqlite3IsToplevel(Parse*) interface to check to see if a top-level VDBE is being coded (versus a trigger) and use that interface. (check-in: 59662cd2b6 user: drh tags: vtab-onepass) | |
| 12:32 | Fix compiler warnings. (check-in: d1a0783854 user: drh tags: vtab-onepass) | |
| 12:19 | Fix an off-by-one error in test function fts5_decode(). (check-in: 3a9f076250 user: dan tags: trunk) | |
| 11:59 | Merge latest trunk change into this branch. (check-in: b519c0d67a user: dan tags: vtab-onepass) | |
| 11:57 | Change the name of the new sqlite3_index_info.flags field to "idxFlags". Add documentation for the same to sqlite.h.in. (check-in: f61203bc0f user: dan tags: vtab-onepass) | |
| 10:11 | Add tests for fts3 and onepass update/delete operations. Also fix a problem with onepass updates that do not affect any rows. (check-in: 820c804468 user: dan tags: vtab-onepass) | |
|
2015-09-28
| ||
| 20:03 | Also allow UPDATE on virtual tables to use the onepass strategy. (check-in: 1aa27d706d user: dan tags: vtab-onepass) | |
| 17:05 | Extra information provided by .wheretrace on input flags to the query planner and on the result of sqlite3WhereOkOnePass(). (check-in: c5566bb39c user: drh tags: trunk) | |
| 15:23 | Update fts3 to use the onepass strategy for delete operations. (check-in: fffab4f70f user: dan tags: vtab-onepass) | |
| 15:20 | Changes to allow DELETE operations on virtual tables to use the onepass strategy under some circumstances. (check-in: e73f919fae user: dan tags: vtab-onepass) | |
| 15:08 | Add test cases to the ONEPASS optimization corruption problem fixed by the previous check-in. (check-in: 5c14d44705 user: drh tags: trunk) | |
| 14:40 | Fix a database corruption bug caused by the ONEPASS optimization added in check-in [8b93cc5937000535]. Bug detected (prior to release) by sqllogictest. Test cases to follow. (check-in: 9d057f5221 user: drh tags: trunk) | |
|
2015-09-26
| ||
| 17:44 | Enable adding JSON1 by appending the json1.c source file to the amalgamation and compiling with -DSQLITE_ENABLE_JSON1 (check-in: 33404b2029 user: drh tags: trunk) | |
| 11:15 | Fix a memory leak that can occur following a syntax error in CREATE VIEW. (check-in: f4704035a6 user: drh tags: trunk) | |
| 03:31 | Fix the title of the documentation on sqlite3_value_subtype(). This is a comment change only. (check-in: b790235424 user: drh tags: trunk) | |
| 03:23 | Expand the header comment to clarify the purpose for the sqlite3MemoryBarrier() function. (check-in: b89495ae09 user: drh tags: trunk) | |
| 01:28 | Remove an assert in the windows worker-thread logic that can fail in a race condition. (check-in: d7bfb96092 user: drh tags: trunk) | |
|
2015-09-25
| ||
| 23:40 | Fix threads.c so that setting sqlite3FaultSim(200) using the SQLITE_TESTCTRL_FAULT_INSTALL callback causes both unix and windows worker threads to be sequential and deterministic, so that they can be tested reliably. (check-in: 2d867c054d user: drh tags: trunk) | |
| 20:49 | Fix PRAGMA integrity_check so that it works with a UNIQUE index over expressions. (check-in: 113181cec4 user: drh tags: trunk) | |
| 13:42 | Report an error if the number of named columns in a VIEW is different from the number of result columns in the SELECT statement that implements the VIEW. (check-in: 6e4ac0be2d user: drh tags: trunk) | |
| 01:09 | Fix a problem computing affinities for indexes during skip-scan code generation when SQLITE_ENABLE_STAT4 is on. Bug introduced by check-in [1ee089a72d789002]. (check-in: 1350dd42d0 user: drh tags: trunk) | |
|
2015-09-24
| ||
| 18:47 | Enhance the query planner so that it is able to use indexed expressions to help fulfill an ORDER BY clause. (check-in: 668fc1ebaf user: drh tags: trunk) | |
| 17:38 | Fix over-length source code lines in where.c. No logic changes. (check-in: 1c8c5380a8 user: drh tags: trunk) | |
| 12:40 | Strengthen the implementations of xShmMemoryBarrier on both the unix and windows VFSes, so that they likely work even if SQLITE_THREADSAFE=0 is used. (check-in: c6ab807b72 user: drh tags: trunk) | |
| 12:19 | Make sure joins work correctly when both sides of the join are connected using indexed expressions. (check-in: c2fcb03299 user: drh tags: trunk) | |
| 11:26 | Correctly handle the case of a WHERE-clause term with indexed expressions on both sides of the == sign. (check-in: d9b716a6bd user: drh tags: trunk) | |
| 11:06 | Fix a JSON1 test case so that it works on builds that omit virtual tables. (check-in: a4444c0f66 user: drh tags: trunk) | |
| 01:40 | Another (smaller) performance optimization for the JSON parser. (check-in: c43daa8c78 user: drh tags: trunk) | |
| 01:06 | Performance optimizations on the JSON parser. (check-in: 7dd4b07a42 user: drh tags: trunk) | |
|
2015-09-23
| ||
| 19:17 | Take care that the number of reserved bits per page is consistent between the source and destination databases when doing the back-copy on a VACUUM. (check-in: 5b61b72f54 user: drh tags: trunk) | |
| 11:59 | Capture AFL-generated fuzz tests for json1.c into the test/fuzzdata4.db file. (check-in: 10a214fdb3 user: drh tags: trunk) | |
| 01:10 | Do not allow a comma at the end of a JSON array or object. (check-in: 7c7a3f3e9b user: drh tags: trunk) | |
|
2015-09-22
| ||
| 18:51 | Add the --export-sql and --export-db options to the fuzzcheck utility program. (check-in: 760af44551 user: drh tags: trunk) | |
| 17:46 | Fix a typo in the --help screen of the fuzzcheck utility. (check-in: b6ae61fe3b user: drh tags: trunk) | |
| 01:15 | Futher simplifications to json1.c. Also an obscure bug-fix in the initial output of json_tree() when using a path to an object contained within an array. (check-in: fcb1e327a6 user: drh tags: trunk) | |
| 00:21 | Fix json_set() so that it can overwrite a value that was previously overwritten during the same call. (check-in: 0f16041647 user: drh tags: trunk) | |
|
2015-09-21
| ||
| 23:53 | For MSVC, have the 'sqlite3.c' target depend on 'sqlite3ext.h' as well as other targets may depend on this behavior (e.g. extensions). (check-in: 737ac3faf4 user: mistachkin tags: trunk) | |
| 23:49 | Fix compilation under older versions of MSVC. (check-in: 17150ada14 user: mistachkin tags: trunk) | |
| 22:53 | Simplifications to the json1.c logic. (check-in: 1646a2bd85 user: drh tags: trunk) | |
|
2015-09-20
| ||
| 22:57 | Fix an overly-strict assert() in the btree logic. (check-in: 825ce3201d user: drh tags: trunk) | |
|
2015-09-19
| ||
| 20:27 | Do not allow table-valued function syntax to be used on a view. (check-in: 97cfe346e1 user: drh tags: trunk) | |
| 19:36 | Add the --disable-lookaside option to the fuzzershell utility program. (check-in: 0b04374449 user: drh tags: trunk) | |
| 18:54 | Fix a memory leak in json1.c that could occur after misuse of json_object(). (check-in: 394b81b11f user: drh tags: trunk) | |
| 18:11 | Add an assert() statement to delete.c. (check-in: 40fce67ecf user: dan tags: trunk) | |
| 18:08 | Fix compiler warnings. (check-in: 5c31ee62a1 user: drh tags: trunk) | |
| 16:51 | Add json1.c to the fuzzer test shells. (check-in: 809d67b611 user: drh tags: trunk) | |
| 16:45 | Adjust Makefiles to use SQLITE_CORE when statically linking json1.c into test shells. (Closed-Leaf check-in: 91682ac39e user: drh tags: json-fuzz) | |
| 14:57 | Adjust fuzzershell so that it adds the json1 extension separately for each no connection. (check-in: ca2d1e9036 user: drh tags: json-fuzz) | |
| 14:32 | Include json1.c in fuzzcheck and fuzzershell. (check-in: c4b68eff7f user: drh tags: json-fuzz) | |
| 12:04 | Fix a documentation typo in sqlite3_bind_parameter_index(). No code changes. (check-in: 650605a820 user: drh tags: trunk) | |
| 11:57 | Fix an off-by-one error (really off-by-2 in this case) in the buffer resize logic of json1. (check-in: d2a027372a user: drh tags: trunk) | |
| 03:07 | Do not allow rowid in a UNIQUE or PRIMARY KEY constraint. (This restores the same behavior exhibited by all prior releases.) (check-in: b1278301e3 user: drh tags: trunk) | |
|
2015-09-18
| ||
| 18:09 | Fix a crash that can occur with a skip-scan on an index with expressions when SQLITE_ENABLE_EXPLAIN_COMMENTS is defined. (check-in: 25f34cb9b5 user: drh tags: trunk) | |
| 15:38 | Adjustments to the spellfix2.test module so that it works reliably on windows. (check-in: 09a313fb7f user: drh tags: trunk) | |
| 15:35 | Adjust two test cases so that they conform to the current code. (check-in: 228e3d7c8f user: drh tags: trunk) | |
| 15:13 | Fix sqlilimits.test module so that it knows that the SELECT in a CREATE VIEW is not checked until the view is actually used. (check-in: acf5d87f94 user: drh tags: trunk) | |
| 14:45 | Ensure that "PRAGMA integrity_check" reports an error if the free-list count header field contains a value smaller than the actual number of pages on the database free-list. (check-in: 26f64986d1 user: dan tags: trunk) | |
| 14:42 | Fix the orderby9.test case so that it works with 32-bit versions of TCL (check-in: 4b6af77430 user: drh tags: trunk) | |
| 14:22 | Remove a test made obsolete by the ONEPASS DELETE optimization. (check-in: c88b62c28c user: drh tags: trunk) | |
|
2015-09-17
| ||
| 17:21 | Avoid passing (signed char) values directly to isspace(), isalnum() or isdigit() in json1.c. Cast the value to (unsigned char) first. (check-in: 6713e35b8a user: dan tags: trunk) | |
| 09:48 | Fix a crash in FTS5 caused by specifying NULL as the rhs of a MATCH operator. (check-in: e8ed62f82e user: dan tags: trunk) | |
|
2015-09-16
| ||
| 17:46 | Add a "flush" to force incremental output to releasetest-out.txt while running the test/releasetest.tcl. script. (check-in: 0f3de2d337 user: drh tags: trunk) | |
| 12:31 | Fix typo in fts5.h. (check-in: 07721c6c24 user: dan tags: trunk) | |
|
2015-09-15
| ||
| 14:39 | Add test cases to cover fts5 integrity-check code. (check-in: 1d018c35b9 user: dan tags: trunk) | |
| 13:42 | Reformat some code to make it easier to merge with sessions. No logic changes. (check-in: eade355faf user: drh tags: trunk) | |
| 11:58 | Fix a problem with fts5 "ORDER BY rowid DESC" queries and large terms. (check-in: b26d8f79c6 user: dan tags: trunk) | |
|
2015-09-14
| ||
| 19:51 | Improve test coverage of fts5_index.c. (check-in: c1f76686ce user: dan tags: trunk) | |
| 19:26 | Testability improvements for the ONEPASS_MULTI enhancement. (check-in: d2df93f26f user: drh tags: trunk) | |
| 14:49 | Fix a typo in an SQLITE_USER_AUTHENTICATION macro. (check-in: 379455af9f user: drh tags: trunk) | |
| 14:45 | Use symbolic names ONEPASS_OFF, ONEPASS_SINGLE, and ONEPASS_MULTI for the various modes of the one-pass optimization. (check-in: 16e56bdade user: drh tags: trunk) | |
| 14:08 | Fix a compiler warning and providing missing VdbeCoverage() calls. (check-in: 2edd2e5edd user: drh tags: trunk) | |
| 11:09 | Use a single-pass approach for DELETE statements on non-virtual tables that do not require trigger or foreign key processing. (check-in: 8b93cc5937 user: dan tags: trunk) | |
| 09:23 | Avoid calling sqlite3VdbeCursorMoveto() from more than one point in vdbe.c. Doing so prevents it from being inlined as part of OP_Column. (Closed-Leaf check-in: 166d5af891 user: dan tags: onepass-delete) | |
|
2015-09-13
| ||
| 20:15 | Add static VFS mutexes to the primary header file comments. (check-in: 9a867d9fbe user: mistachkin tags: trunk) | |
|
2015-09-12
| ||
| 19:50 | Fix compiler warnings in delete.c. (check-in: 0a4d285e18 user: dan tags: onepass-delete) | |
| 19:27 | Fix API documentation typos. Emphasize that the sqlite3_config() routine is not threadsafe. (check-in: 786333e05a user: drh tags: trunk) | |
| 19:26 | Experimental change to use a single-pass approach for DELETE statements on non-virtual tables that do not fire triggers or require foriegn-key processing. (check-in: eaeb2b80f6 user: dan tags: onepass-delete) | |
| 18:57 | Import common changes from the mutex initialization branch. (check-in: 334720c017 user: mistachkin tags: trunk) | |
|
2015-09-11
| ||
| 20:54 | Update evidence marks due to wording changes in requirements text. No changes to code. (check-in: 86781093bd user: drh tags: trunk) | |
| 18:05 | Fix harmless compiler warnings. (check-in: bfc7b84b76 user: mistachkin tags: trunk) | |
| 15:32 | More test cases in test/json102.test corresponding to new examples in the json1 documentation. (check-in: f599a42e19 user: drh tags: trunk) | |
| 14:15 | Fix some compiler warnings in fts5 code. (check-in: 0dc436116e user: dan tags: trunk) | |
| 01:22 | Updates to the sqlite3_value_subtype() and sqlite3_result_subtype() documentation and to test cases for json1 dealing with those interfaces. (check-in: d6cadbe9fe user: drh tags: trunk) | |
| 00:26 | Add new interfaces sqlite3_value_subtype() and sqlite3_result_subtype(). Update the json1.c extension to take advantages of those interfaces to avoid the goofy '$$' path syntax and to allow nested calls to json_array() and json_object() that work as expected. (check-in: db4152aef2 user: drh tags: trunk) | |
| 00:06 | Take out the goofy '$$' path syntax. Instead, use subtypes to communicate when a string is JSON. Add the json() function that validates and minifies the JSON and sets the appropriate subtype. (Closed-Leaf check-in: 8a80d6459e user: drh tags: subtypes) | |
|
2015-09-10
| ||
| 20:40 | Make the sqlite3_value_subtype() and sqlite3_result_subtype() interfaces available to loadable extensions. (check-in: c6fca0be11 user: drh tags: subtypes) | |
| 20:34 | Experimental implementation of sqlite3_result_subtype() and sqlite3_value_subtype() interfaces. (check-in: 7b5be299c6 user: drh tags: subtypes) | |
| 19:22 | Fix a potential NULL pointer deref in the testing logic of pcache1. NB: The -DSQLITE_TEST compile-time option is needed to hit the problem. (check-in: f5580f0853 user: drh tags: trunk) | |
| 17:23 | Modify the fts5 leaf page format to permit faster seek operations. This is a file-format change. Any existing databases can be upgraded by running the fts5 'rebuild' command. (check-in: 0c0c4ae971 user: dan tags: trunk) | |
| 17:20 | Create separate "path" and "root" columns in the json_each() and json_tree() virtual tables. "Root" is the 2nd parameter and is fixed. "Path" varies as json_tree() walks the hierarchy. (check-in: 127cce3eb9 user: drh tags: trunk) | |
| 16:39 | Increment the fts5 version value to indicate that the on-disk format has changed. (Closed-Leaf check-in: 99de5e3613 user: dan tags: fts5-incompatible) | |
| 16:19 | Fix a segfault in fts5 that could occur if the database contents were corrupt. (check-in: 4931e37da4 user: dan tags: fts5-incompatible) | |
| 15:52 | Merge latest changes from trunk. Including fts5_expr.c fixes. (check-in: 716e7e7477 user: dan tags: fts5-incompatible) | |
| 15:49 | Update description of on-disk format in fts5_index.c. (check-in: 85aac7b8b6 user: dan tags: fts5-incompatible) | |
| 15:24 | Make the sqlite3ext.h header file responsive to -DSQLITE_OMIT_LOAD_EXTENSION. (check-in: 47a46a9fa4 user: drh tags: trunk) | |
| 15:22 | Disable tests for json_each() and json_tree() on builds where virtual tables are not supported (check-in: bb8ee3b140 user: drh tags: trunk) | |
| 15:20 | Fix the --help option on test/releasetest.tcl. Also fix the final error count so that it includes a count of subtest crashes. (check-in: 9ecf684dfe user: drh tags: trunk) | |
| 10:40 | Revert an accidentally committed makefile change. (check-in: 402704b13f user: dan tags: fts5-incompatible) | |
| 10:01 | Fix an fts5 problem that could occur if a term and the first associated rowid are on different leaf pages. (check-in: ffe2796ac9 user: dan tags: fts5-incompatible) | |
| 05:40 | Change the array of 16-bit offsets at the end of each page to an array of varints. (check-in: fab245bea4 user: dan tags: fts5-incompatible) | |
| 04:17 | Attempt to declare sqlite3MemoryBarrier() correctly for all possible build configurations. (check-in: da8a288f8e user: drh tags: trunk) | |
| 03:29 | Fix the json_tree() scan for the case when a path is supplied. Add new json1 test cases. (check-in: 6adc7de76a user: drh tags: trunk) | |
| 01:22 | No-op the sqlite3_memory_alarm() interface in a different way, that does not break legacy memory behavior. This is a re-do of check-in [5d3f5df4da9f40d5]. (check-in: 8250e2a487 user: drh tags: trunk) | |
|
2015-09-09
| ||
| 23:54 | Fix harmless compiler warning in FTS5. (check-in: 86146a731d user: mistachkin tags: trunk) | |
| 19:44 | Fix an assert() enabled by SQLITE_ENABLE_EXPENSIVE_ASSERT in wal.c. (check-in: 8d2ed150a7 user: dan tags: trunk) | |
| 19:27 | Fix a possible NULL pointer deref when using SQLITE_ENABLE_MEMORY_MANAGEMENT. (check-in: 89bfdbfe94 user: drh tags: trunk) | |
| 17:23 | Fix harmless compiler warning. (check-in: 280fd3a482 user: mistachkin tags: trunk) | |
| 17:17 | Fix harmless compiler warnings in FTS5. (check-in: 2cdb18778f user: mistachkin tags: trunk) | |
| 13:28 | When running a CREATE TABLE AS, make the initial temporary sqlite_master entry for the new table a real record rather than a NULL, in case the query after the AS actually tries to read the sqlite_master table. Fix for ticket [acd12990885d9276]. (check-in: 4a18d8bd4c user: drh tags: trunk) | |
| 08:15 | Fix a bug in preprocessor macros within fts5_main.c. (check-in: 0eb2b9521f user: dan tags: fts5-incompatible) | |
|
2015-09-08
| ||
| 21:16 | Remove an unused local variable from Lemon. (check-in: fe9ffe5eed user: drh tags: trunk) | |
| 21:12 | Enhance the DBSTAT virtual table with a new hidden table "schema" that if set will cause the table to report on the specified schema rather than on "main". Also: Fix a faulty assert in sqlite3_context_db_handle(). (check-in: 6beb512c7a user: drh tags: trunk) | |
| 20:26 | Eponymous virtual tables exist in the "main" schema only. Enforce this rule. (check-in: 06f90bb274 user: drh tags: trunk) | |
| 19:55 | Remove the 0x00 terminators from the end of fts5 doclists stored on disk. (check-in: 00d990061d user: dan tags: fts5-incompatible) | |
| 17:31 | Fix the help message that sqlite3_analyzer.exe generates for invalid arguments. (check-in: 33a14e7be1 user: drh tags: trunk) | |
|
2015-09-07
| ||
| 23:40 | Minor tweaks to Lemon. (check-in: 986677224a user: drh tags: trunk) | |
| 20:11 | Enhance the Lemon parser generator to add SHIFTREDUCE states that reduce the sizes of some of the parser tables. (check-in: 99b992fa84 user: drh tags: trunk) | |
| 20:02 | Fix an unreachable branch in the new parse automaton. (Closed-Leaf check-in: e9d604b430 user: drh tags: lemon-update) | |
| 19:52 | Change the parser engine so that it (once again) waits for a lookahead token before reducing, even in a SHIFTREDUCE action. (check-in: 2c17a13583 user: drh tags: lemon-update) | |
| 18:23 | For the Lemon-generated parser, add a new action type SHIFTREDUCE and use it to further compress the parser tables and improve parser performance. (check-in: 531c3974b3 user: drh tags: lemon-update) | |
| 14:22 | In the "parse.out" output file from Lemon, show addition the complete text of rules on reduce actions. (check-in: b6ffb7e471 user: drh tags: trunk) | |
| 08:14 | Use macros to make the code in fts5_index.c easier to read. (check-in: 67ff5ae813 user: dan tags: fts5-incompatible) | |
| 02:23 | Improved "Parser Statistics" output (the -s option) for the Lemon parser generator. (check-in: 809503e4ef user: drh tags: trunk) | |
|
2015-09-06
| ||
| 10:31 | Improved memory barrier that should work with MinGW on older versions of Windows. (check-in: 47dc24bd1e user: drh tags: trunk) | |
| 02:51 | Add a memory barrier to the mutex initialization logic, try to work around an issue reported by WebKit. (check-in: 11a9a786ec user: drh tags: trunk) | |
|
2015-09-05
| ||
| 22:36 | Omit all use of Expr nodes for TK_AS, as those nodes no longer served a useful purpose and in fact interferred with the query planner. (check-in: 7ab0b258ea user: drh tags: trunk) | |
| 19:52 | Experiment with a different fts5 leaf page format that allows faster seeks. (check-in: a1f4c3b543 user: dan tags: fts5-incompatible) | |
| 19:21 | Fix an unreachable conditional in the WHERE clause analysis logic. (check-in: 24924a5819 user: drh tags: trunk) | |
| 19:07 | Get STAT4 range scan estimates work again when the bounds are determined by date/time functions. (check-in: d2761357a0 user: drh tags: trunk) | |
|
2015-09-04
| ||
| 18:03 | Fix over-length source code lines in Lemon. (check-in: 1efece95ff user: drh tags: trunk) | |
| 17:32 | Add support for CREATE INDEX statements that use deterministic expressions rather than only column names. (check-in: 2131a5ca53 user: drh tags: trunk) | |
| 13:02 | Merge trunk enhancements, and espeically the fix for allowing strings as column identifers in CREATE INDEX statements. (Closed-Leaf check-in: 5ff8552938 user: drh tags: index-expr) | |
| 12:54 | Continue to support the (broken) legacy syntax of allowing strings for column names in CREATE INDEX statements and in UNIQUE and PRIMARY KEY constraints. (check-in: 3d3df79bfa user: drh tags: trunk) | |
| 11:13 | Enhance showfts5.tcl so that it can optionally display the number of terms in each segment. (check-in: d648ddd93d user: dan tags: trunk) | |
| 10:31 | Modify the fts5 custom tokenizer interface to permit synonym support. The fts5_api.iVersion value is now set to 2. Existing fts5 custom tokenizers (if there are such things) will need to be updated to use the new api version. (check-in: 0b7e4ab8ab user: dan tags: trunk) | |
| 10:24 | Merge latest trunk changes. (Closed-Leaf check-in: 443a5eb8e1 user: dan tags: fts5-incompatible) | |