Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
663 check-ins using file src/trigger.c version ee7e178fb9
|
2015-05-21
| ||
| 02:07 | When parsing the schema, ignore any SQL that does not begin with "CREATE". Cherrypick of [d3c00d61581c] with additional changes. (check-in: 09784f376b user: drh tags: branch-3.7.11) | |
| 01:04 | Do not allow virtual table constructors to be called recursively. Cherrypick [0a72726da21581ab] (check-in: 0f0694e424 user: drh tags: branch-3.7.11) | |
| 00:50 | Add the ".open" command to the command-line shell. Cherrypick from [21eccb919441]. (check-in: a71e2a72c5 user: drh tags: branch-3.7.11) | |
|
2012-12-06
| ||
| 20:19 | Cherrypick [557c69055a3] and [0064bab7714] (OP_Once-related fixes for triggers). (check-in: 0d7b5d455c user: dan tags: branch-3.7.9) | |
|
2012-08-25
| ||
| 02:11 | Fix a harmless compiler warning. (check-in: 929b51840b user: drh tags: trunk) | |
| 01:38 | Merge all the latest trunk changes into the apple-osx branch. (check-in: 6723add4f4 user: drh tags: apple-osx) | |
| 01:21 | Merge the latest trunk changes into the sessions branch. (check-in: aa62d6881b user: drh tags: sessions) | |
|
2012-08-24
| ||
| 23:56 | When the same index is used for all OR-terms in a WHERE clause, then try to use that index as a covering index. (check-in: 62678be3df user: drh tags: trunk) | |
| 23:24 | Move field WhereLevel.pCovidx inside the union to WhereLevel.u.pCovidx. (Closed-Leaf check-in: b722143d07 user: drh tags: multi-or-covering-index) | |
| 21:54 | Remove a NEVER() that is in fact reachable on an OOM. This probably has nothing to do with the multi-or-covering-index change but just happened to be found while testing that change. (check-in: 5499af53eb user: drh tags: multi-or-covering-index) | |
| 19:58 | Another test for whereD.test. (check-in: 29d586178d user: dan tags: multi-or-covering-index) | |
| 19:52 | Add extra tests to whereD.test. (check-in: 7e961eef6b user: dan tags: multi-or-covering-index) | |
| 18:44 | Fix a problem to do with multi-or queries and automatic indexes. (check-in: a3e26038a1 user: dan tags: multi-or-covering-index) | |
| 17:52 | More test cases for OR-optimization covering indices. (check-in: e5c3190c27 user: drh tags: multi-or-covering-index) | |
| 15:29 | Additional test cases for OR-optimization with covering indices, including one test case that currently fails. (check-in: d8b7ab3712 user: drh tags: multi-or-covering-index) | |
| 10:52 | Experimental change to support the covering index optimization for queries with OR terms in the WHERE clause that search a single index more than once. (check-in: 1dc8c7c741 user: dan tags: multi-or-covering-index) | |
| 01:07 | Merge the nested aggregate query enhancements into trunk. (check-in: d4cd6017c9 user: drh tags: trunk) | |
|
2012-08-23
| ||
| 22:45 | Merge changes for the new sqlite3_win32_set_directory API to trunk. (check-in: 20f184f2d5 user: mistachkin tags: trunk) | |
| 19:46 | Add test cases and fix bugs associated with the previous check-in enhancements to nested aggregate subquery processing. (Closed-Leaf check-in: 00b1dc71be user: drh tags: nested-agg) | |
| 16:18 | Further improvements to the processing of nested aggregate queries. (check-in: 3c3ffa901f user: drh tags: nested-agg) | |
|
2012-08-22
| ||
| 15:16 | Do not let the multi-core sorter use lookaside memory, which is not thread-safe. (Leaf check-in: acdc7d1270 user: drh tags: threads-sort-ex1) | |
| 00:39 | Modify the MSVC makefile to make it easier to select the heap subsystem to use. (check-in: b1dbf49086 user: mistachkin tags: trunk) | |
| 00:18 | Add assert to check that the memory block for the previous directory value was allocated via sqlite3_malloc or related function. (Closed-Leaf check-in: 1246f15b14 user: mistachkin tags: win32SetDir) | |
|
2012-08-21
| ||
| 23:33 | Added sqlite3_win32_set_directory API to assist in portability to WinRT. (check-in: 600de08d40 user: mistachkin tags: win32SetDir) | |
| 17:46 | Merge in all the latest trunk changes. (check-in: 45cdc32f1e user: drh tags: threads-sort-ex1) | |
| 17:44 | Update the spellfix virtual table so that all OOM errors are reported out to the application. (check-in: 573770f5a6 user: drh tags: trunk) | |
| 17:36 | Cherry-pick [555fc07]: Changes to the thread routines to disable them when threading is turned off using sqlite3_config(). Also merge all recent trunk changes. (check-in: c92b0fe137 user: drh tags: threads) | |
| 13:08 | Update the spellfix virtual table so that all OOM errors are reported out to the application. ERROR: A single edit was missed in spellfix1 which means that this particular check-in won't build "make test". (Closed-Leaf check-in: c2cf498513 user: drh tags: mistake) | |
|
2012-08-20
| ||
| 17:24 | Add the SQLITE_DISABLE_FTS4_DEFERRED compile time option. (check-in: e799222f3b user: dan tags: trunk) | |
| 16:23 | Change the checkSpacing utility program to ignore whitespace at end-of-line unless the --wseol option is used. (check-in: be1faadebd user: drh tags: trunk) | |
| 16:08 | Silence harmless compiler warnings in the test code. (check-in: 7653973a52 user: drh tags: trunk) | |
| 15:53 | Remove tab characters from source code files. Replace them with spaces. (check-in: 7edd10a960 user: drh tags: trunk) | |
| 15:46 | Add a command-line program to tool/ that will check source code files for the presence of tabs, carriage-returns, whitespace at the ends of lines, and blank lines at the ends of files. (check-in: 656a9c8b47 user: drh tags: trunk) | |
| 12:36 | Changes to the thread routines to disable them when threading is turned off using sqlite3_config(). (check-in: 555fc07efd user: drh tags: threads-sort-ex1) | |
|
2012-08-17
| ||
| 13:44 | Clarify that the number-of-bytes parameter to sqlite3_bind_blob() must be non-negative. (check-in: b1b01c4cd9 user: drh tags: trunk) | |
| 12:13 | Fix MSVC compiler warning in the spellfix module. Also, add an assert. (check-in: e66cf0401f user: mistachkin tags: trunk) | |
| 11:47 | Skip defining some WAL specific things in the Win32 VFS code when compiling without WAL support. Also, fix an example command line in the MSVC makefile. (check-in: 61b1ae1217 user: mistachkin tags: trunk) | |
|
2012-08-16
| ||
| 20:05 | Attempt to use two cores to do sorting. Unfortunately, instead of making sorts go faster as was hoped, this changes slows sorting down by about 10%. (Later:) The previous measurement was compiled using -pg. When compiled using -Os, this new code is roughly 10% faster than the original. (check-in: 11dd05e598 user: drh tags: threads-sort-ex1) | |
| 11:24 | Update the threads branch to include all the latest trunk changes. (check-in: f4125771e2 user: drh tags: threads) | |
|
2012-08-15
| ||
| 16:43 | Changes to the spellfix test script to make the results deterministic. (check-in: 31c07db256 user: drh tags: trunk) | |
| 16:21 | Merge all the latest trunk changes into the sessions branch. (check-in: fc07a4795e user: drh tags: sessions) | |
| 16:06 | Change autoconf so that the --with-tcl=DIR option will override the TCL configuration that is found using tclsh. (check-in: 772d0de3f3 user: drh tags: trunk) | |
| 15:57 | Experimental change to speed up ORDER BY clauses that sort based on a single expression. (Leaf check-in: 2bb8c49261 user: dan tags: sorter-exp) | |
|
2012-08-14
| ||
| 19:04 | Silence three harmless compiler warnings in vdbesort.c. (check-in: a5431c86df user: drh tags: trunk) | |
| 18:43 | Add an assert() to the btree rebalancer in order to silence a clang/scan-build warning. (check-in: 6730579cf5 user: drh tags: trunk) | |
| 17:29 | Update the spellfix virtual table to the latest development code. (check-in: 6954fef006 user: drh tags: trunk) | |
| 01:45 | Refer to the file mapping Win32 API functions only when absolutely necessary. (check-in: 1de2237d00 user: mistachkin tags: trunk) | |
|
2012-08-13
| ||
| 22:05 | Refer to the WaitForSingleObjectEx and SetFilePointerEx Win32 functions only for platforms where they are going to be used. (check-in: 9888ce9294 user: mistachkin tags: trunk) | |
|
2012-08-08
| ||
| 14:04 | When populating an index b-tree as part of a CREATE INDEX or REINDEX statement, distribute cells between up to three siblings in balance_nonroot() instead of four. This produces identical database files, but is slightly faster. (check-in: b0d31e779e user: dan tags: trunk) | |
| 11:55 | When building a b-tree as part of a CREATE INDEX or REINDEX statement, attempt to pack keys into pages as tightly as possible. (check-in: efea62b96c user: dan tags: trunk) | |
| 10:14 | Change to securedel2.test so that it works even if SQLITE_DEFAULT_AUTOVACUUM=1 is defined. (check-in: 1e6f5ea481 user: dan tags: trunk) | |
|
2012-08-07
| ||
| 22:53 | Simplifications to the sorter to support full-coverage testing. (check-in: de804f4c90 user: drh tags: trunk) | |
| 17:41 | Add extra tests for secure-delete mode. (check-in: e380cd3ce3 user: dan tags: trunk) | |
| 15:19 | Fix a bug in hash.c introduced by [305b66672653]. (check-in: 17cb5e951e user: dan tags: trunk) | |
| 14:18 | Do not run test script spellfix.test if SQLITE_OMIT_VIRTUAL_TABLE is defined. Fix walro.test so that it works if DEFAULT_AUTOVACUUM is defined. (check-in: 26428b459b user: dan tags: trunk) | |
| 13:55 | Fix a bug in walthread.test causing intermittent failures. (check-in: a192a718d5 user: dan tags: trunk) | |
| 01:37 | Parser bug fix: Make sure the table constraints allowed by prior releases can still be parsed, even if they are technically not allowed by the syntax diagram. This is a cherry-pick of [a1c014d8a87c8940b3], [38bf90af1ede6ee64e], and [e536ac041815b118c4]. (Leaf check-in: 28aed847c6 user: drh tags: apple-osx-ml) | |
|
2012-08-06
| ||
| 23:21 | Backport VSIX packaging support and related changes. (Closed-Leaf check-in: 0620285da6 user: mistachkin tags: vsix-3.7.13) | |
| 22:29 | Modify VSIX package generation tool to put the PDB files in the Debug directory. (check-in: 9d0720833f user: mistachkin tags: trunk) | |
| 19:28 | Merge the sorter-coalesce-writes branch into the trunk. This improves CREATE INDEX performance on some platforms. (check-in: e1e9cb08b0 user: dan tags: trunk) | |
| 19:12 | Fix a crash that could follow an OOM condition. (Closed-Leaf check-in: 2e5741f774 user: dan tags: sorter-coalesce-writes) | |
| 18:50 | When reusing pages as part of creating a new index, allocate the leaves from each free-list trunk page in ascending order, instead of trying to maximize localization for each individual allocation. This increases the chance that pages will be written to disk in ascending order by a large CREATE INDEX statement, improving overall performance. (check-in: d045f8b2d4 user: dan tags: sorter-coalesce-writes) | |
| 18:10 | Update sorter-coalesce-writes branch with latest trunk changes. (check-in: 214f8cda17 user: dan tags: sorter-coalesce-writes) | |
| 10:51 | Update description strings in the VSIX package. (check-in: 541e9310a7 user: mistachkin tags: trunk) | |
|
2012-08-03
| ||
| 10:00 | Correct comment about WinRT compiler define. No changes to code. (check-in: 335e91e599 user: mistachkin tags: trunk) | |
|
2012-08-01
| ||
| 20:20 | Fix typos of function names sqlite3_result_error_toobig and sqlite3_result_error_nomem in the documentation. No changes to code. (check-in: bec97c9813 user: mistachkin tags: trunk) | |
|
2012-07-31
| ||
| 08:15 | Make the list of platforms dynamic in the SDK manifest inside the VSIX package. (check-in: 22b72e499d user: mistachkin tags: trunk) | |
| 00:43 | Modify metadata for the VSIX package and add tooling support for PDBs. (check-in: 12cbf6a934 user: mistachkin tags: trunk) | |
|
2012-07-30
| ||
| 14:53 | Replace a few sqlite3_malloc()+memset() sequences with calls to sqlite3MallocZero(). (check-in: 305b666726 user: dan tags: trunk) | |
|
2012-07-27
| ||
| 23:03 | Improve consistency in handling of build outputs and native library paths in the multi-platform build tool for MSVC. (check-in: e71f2de2cc user: mistachkin tags: trunk) | |
| 22:29 | Minor adjustments to the multi-platform build tool for MSVC. (check-in: e76b8f7765 user: mistachkin tags: trunk) | |
| 08:33 | For the clean makefile targets, delete the generated VSIX file as well. (check-in: d575d9619a user: mistachkin tags: trunk) | |
| 08:21 | Modify the multi-platform build tool for MSVC to support the latest RC version. (check-in: 95b65883bb user: mistachkin tags: trunk) | |
| 07:13 | Add tool to build the core DLL for multiple platforms using MSVC. (check-in: e42f5812f1 user: mistachkin tags: trunk) | |
| 02:36 | Add tool to generate a VSIX package usable by Visual Studio 2012 RC. (check-in: 8b90e0c4db user: mistachkin tags: trunk) | |
|
2012-07-26
| ||
| 09:21 | Update some comments in vdbesort.c. (check-in: f4b3fded23 user: dan tags: sorter-coalesce-writes) | |
|
2012-07-24
| ||
| 19:46 | Mark parameters to sorter interfaces as const where appropriate. (check-in: d8da26f1f4 user: drh tags: trunk) | |
| 06:02 | Add another define to the MSVC makefile that is sometimes required to build cleanly for WinRT. (check-in: d582cd890d user: mistachkin tags: trunk) | |
|
2012-07-23
| ||
| 21:43 | Refactor field names in the SelectDest object to make them distinct and easier to grep for. (check-in: b589f1efb3 user: drh tags: trunk) | |
| 20:10 | Fix an edge case in vdbesort.c. (check-in: 4ba266fc53 user: dan tags: sorter-coalesce-writes) | |
| 19:25 | Modify the code in vdbesort.c so that most reads and writes to temporary files are aligned page-sized blocks. (check-in: 55e47ef338 user: dan tags: sorter-coalesce-writes) | |
| 06:47 | Add an assert() to help verify the return code from the Win32 thread wait function. (check-in: ed3dc7a89f user: mistachkin tags: threads) | |
| 02:00 | Enhance implementation of the Win32 thread wait function. (check-in: 049b041173 user: mistachkin tags: threads) | |
|
2012-07-21
| ||
| 22:49 | Add Win32 support to the internal threads interface. Also, add several asserts and fix a few typos. (check-in: 793195d371 user: mistachkin tags: threads) | |
| 19:40 | Add an internal interface that allows the code to take advantage of multiple cores by pushing subcomputations off into separate threads. The interface is not currently used. (check-in: 0e4d977a4a user: drh tags: threads) | |
|
2012-07-19
| ||
| 20:27 | Further tweaks to malloc paths. (Closed-Leaf check-in: 0a33444105 user: dan tags: calloc) | |
|
2012-07-18
| ||
| 16:07 | Remove another branch from the DbMalloc() paths. (check-in: defd828e90 user: dan tags: calloc) | |
| 11:28 | Reorganize code to remove a few of the branches introduced into the critical sqlite3DbMallocXXX() path by the previous commit. (check-in: 75c095ee46 user: dan tags: calloc) | |
|
2012-07-17
| ||
| 19:32 | Enhance the custom memory allocation interface to allow the user to specify a calloc() function. (check-in: 8752237d12 user: dan tags: calloc) | |
| 17:46 | Cherrypick [8c9ee1d78f] and [e416359633] from trunk: Ensure that there is always at least one aReadMark slot usable by an unprivileged reader while a checkpoint is running. Also, if one or more transactions are recovered from a log file, initialize one of the aReadMark slots to contain mxFrame as part of the recovery process. (check-in: 6503591226 user: drh tags: apple-osx) | |
| 14:37 | Ensure that there is always at least one aReadMark slot usable by an unprivileged reader while a checkpoint is running. Also, if one or more transactions are recovered from a log file, initialize one of the aReadMark slots to contain mxFrame as part of the recovery process. (check-in: e416359633 user: dan tags: trunk) | |
| 02:56 | Amplification of a comment in wal.c. Change the aReadMark[] processing so that one read mark is left at zero when a WAL resets. (check-in: 8c9ee1d78f user: drh tags: trunk) | |
|
2012-07-16
| ||
| 23:13 | Merge the spellfix1 changes for supporting matchlen into trunk. (check-in: 6f167adf60 user: drh tags: trunk) | |
| 22:16 | Fix compiler warnings about unused code in spellfix. Fix the editDist3Core() routine to return the matchlen in characters instead of bytes. (Closed-Leaf check-in: f96d4e7bd7 user: drh tags: spellfix-matchlen) | |
| 14:52 | Fix a bug in the phonetic-hash routine in spellfix1: Even if the first character of a word is deemed to be "silent", do not apply the special handling intended for the first character of each word to the second. (check-in: 6333b42dd2 user: dan tags: spellfix-matchlen) | |
| 10:25 | Merge trunk changes. (check-in: 90df64ab80 user: dan tags: spellfix-matchlen) | |
| 10:06 | If a specific database is nominated as part of a "PRAGMA integrity_check" or "PRAGMA quick_check" command, search for problems in the nominated database only. i.e. "PRAGMA main.quick_check" now only scans the main database, not all attached databases as before. (check-in: 4353e40b74 user: dan tags: trunk) | |
|
2012-07-13
| ||
| 19:26 | Add the "matchlen" column to the spellfix1 virtual table. (check-in: f24b9d87f6 user: dan tags: spellfix-matchlen) | |
| 16:15 | Update test_spellfix.c with latest changes. (check-in: cba2a65870 user: dan tags: trunk) | |
| 11:09 | Fix bug in spellfix1 xUpdate() method introduced by the previous commit. (Closed-Leaf check-in: b31aafa5a3 user: dan tags: spellfix-matchlen) | |
|
2012-07-12
| ||
| 19:43 | Add the "matchlen" column to the spellfix virtual table. (check-in: 4a582c4d30 user: dan tags: spellfix-matchlen) | |
|
2012-06-30
| ||
| 22:22 | Setup the necessary library paths for cross-compilation with MSVC. (check-in: 7fac56ed9f user: mistachkin tags: trunk) | |
| 19:24 | Simplify usage of some linker options in the MSVC makefile. (check-in: 0301602066 user: mistachkin tags: trunk) | |
| 16:22 | Make use of the predefined nmake command macro CC when possible instead of the literal string 'cl.exe'. Improve support for cross-compilation. Eliminate problematic use of double quotes in macro preprocessing expressions. (check-in: 6c88229aa3 user: mistachkin tags: trunk) | |
|
2012-06-27
| ||
| 16:41 | Another changes to the shell in support of SQLITE_OMIT_AUTOINIT. (check-in: 3b4f5add04 user: drh tags: trunk) | |
| 16:12 | Update the shell so that it works with SQLITE_OMIT_FLOATING_POINT and SQLITE_OMIT_AUTOINIT. (check-in: 95c0c995fd user: drh tags: trunk) | |
|
2012-06-21
| ||
| 17:21 | Remove code that was incorrectly changing SQLITE_MISUSE errors into SQLITE_OK in sqlite3_finalize(). (check-in: d5e6880279 user: drh tags: trunk) | |
| 15:51 | Add the sqlite3_close_v2() interface (from the deferred-close branch) that allows close operations to happen out-of-order in bindings to garbage-collected langauges. (check-in: fb8893abee user: drh tags: trunk) | |
| 15:22 | Merge changes to trunk that ensure that floating point values are exactly preserved on a round-trip through ".dump". (check-in: 4cebd60704 user: drh tags: trunk) | |
| 15:12 | Fix spelling typo. (check-in: 6131a0002f user: mistachkin tags: trunk) | |
| 15:09 | Remove more references to OS/2. (check-in: eebd594d6b user: mistachkin tags: trunk) | |
| 15:02 | Disable the atof1.test module when compiling on MSVC. (Closed-Leaf check-in: 0f706acfc7 user: drh tags: floating-point-conversions) | |
| 14:31 | Increase the version number to 3.7.14 and rerun autoconf (check-in: 8c9f564a2a user: drh tags: trunk) | |
| 14:25 | Fix the SQLITE_ZERO_MALLOC compile-time option so that it works on windows. (check-in: b80bc52f89 user: drh tags: trunk) | |
| 14:05 | Merge several compiler compatibility fixes to trunk. (check-in: d3d491a546 user: mistachkin tags: trunk) | |
| 13:00 | Remove support for OS/2 from the source tree. (check-in: ff828c67e5 user: drh tags: trunk) | |
| 04:21 | When linking to the MSVC runtime library, use the debug library when necessary. Also, link dynamically to the MSVC runtime library when required (e.g. WinRT) or requested via the USE_CRT_DLL build macro. (check-in: f6be345ad5 user: mistachkin tags: trunk) | |
|
2012-06-19
| ||
| 06:35 | Add tests to check that the "unicode61" and "icu" tokenizers both identify white-space codepoints outside the ASCII range. (check-in: bfb2d4730c user: dan tags: trunk) | |
| 04:36 | Move variable declaration to fix compilation with MSVC. (check-in: d45f7a013f user: mistachkin tags: floating-point-conversions) | |
| 03:59 | Fix an incorrect testcase for the round() function. All tests are passing now, including new real->text->real round-trip tests. (check-in: 963eb24f73 user: drh tags: floating-point-conversions) | |
| 03:35 | Round-trip conversions of real->text->real are now lossless on x64 with GCC. Untested on other platforms so far. Still a corner-case problem with round(). (check-in: fd7bd4a593 user: drh tags: floating-point-conversions) | |
| 03:11 | Improved accuracy on text-to-real and real-to-text conversions. Most conversions now round-trip correctly. Still need to fix some corner cases. (check-in: 8ecffca900 user: drh tags: floating-point-conversions) | |
| 00:45 | Improved rounding accuracy on text-to-float conversions. (check-in: 699b792c6a user: drh tags: trunk) | |
|
2012-06-18
| ||
| 20:52 | Fix a problem with identifying white-space characters outside of the ascii range in the ICU tokenizer. (check-in: 892b74116a user: dan tags: trunk) | |
| 17:15 | Allow the SQLITE_API macro to apply to the sqlite3_win32_sleep function. (Closed-Leaf check-in: 21266c68af user: mistachkin tags: compiler-compat) | |
| 14:23 | Add the ieee754() SQL function that interprets a blob as a big-endian double. Arrange for the quote() SQL function to emit ieee754() functions in its output so that floating-point values in the database are exactly preserved by a ".dump" command in the shell. (Closed-Leaf check-in: 87597e988f user: drh tags: ieee754-func) | |
| 08:00 | Fix a few compilation issues that can occur with certain compilers (e.g. GCC 2.95.3, MSVC). (check-in: f970a3de61 user: mistachkin tags: compiler-compat) | |
|
2012-06-16
| ||
| 15:26 | In Lemon, when comparing the output to the *.h file to see if it has changed, make sure that the proposed new output and the preexisting output are the same size before deciding that they are the same. (check-in: 0c2fb18d25 user: drh tags: trunk) | |
|
2012-06-15
| ||
| 20:42 | Fix compiler warning. (Closed-Leaf check-in: 37d9bc061d user: mistachkin tags: deferred-close) | |
|
2012-06-11
| ||
| 02:05 | Version 3.7.13 (check-in: f5b5a13f73 user: drh tags: trunk, release, version-3.7.13) | |
|
2012-06-09
| ||
| 19:15 | Merge latest trunk changes with sessions branch. (check-in: 47f8f0711d user: dan tags: sessions) | |
| 18:52 | Add missing targets for fts3_unicode.lo and fts3_unicode2.lo to Makefile.in. (check-in: 0ae0ce630a user: dan tags: trunk) | |
|
2012-06-08
| ||
| 14:11 | Merge the vtab1 test script fix and the FTS3 memory leak fix from trunk into the apple-osx branch. (check-in: 892d8779cc user: drh tags: apple-osx) | |
| 14:01 | Fix an obscure memory leak in FTS3 that can come about when two memory allocations are immediately adjacent to one another. (check-in: 025227be54 user: drh tags: trunk) | |
| 11:48 | Fix a problem in vtab1.test causing it to fail when run with any permutation that executes SQL within the tcl "sqlite3" command. (check-in: 006db55526 user: dan tags: trunk) | |
| 01:13 | Merge trunk changes into the apple-osx branch. (check-in: 9d1b851562 user: drh tags: apple-osx) | |
|
2012-06-07
| ||
| 23:58 | Merge all trunk changes, including the WinRT enhancements, into the sessions branch. (check-in: c621403983 user: drh tags: sessions) | |
| 17:57 | Documentation and evidence mark updates. Remove a redundant assert(). (check-in: cfcbf9375f user: drh tags: trunk) | |
| 17:16 | Fix a problem preventing a shared in-memory database from being attached to a read-only connection. (check-in: 7caca1939c user: dan tags: trunk) | |
| 15:53 | Add the "tokenchars=" and "separators=" options, for customizing the set of characters considered to be token separators, to the unicode61 tokenizer. (check-in: e56fb462aa user: dan tags: trunk) | |
| 07:24 | Fix a malloc/free mismatch in pager.c (sqlite3_free() called on a buffer allocated by sqlite3DbMalloc()). (check-in: 506008f000 user: dan tags: trunk) | |
| 02:35 | Provide an (undocumented) compile-time option to disable the page cache overflow counter, in order to avoid a mutex. (check-in: 208825cd83 user: drh tags: trunk) | |
|
2012-06-06
| ||
| 23:59 | Fix harmless Clang warnings. (check-in: 31fe1985ad user: drh tags: trunk) | |
| 23:25 | Fix an #if that is applicable to WinRT, even thought it is currently disabled by another #if. (check-in: baa8b78307 user: mistachkin tags: trunk) | |
| 23:23 | Merge the changes need to compile on WinRT into trunk. (check-in: 61360ca6ca user: drh tags: trunk) | |
| 19:51 | Disable FTS unicode61 by default. It is enabled by specifying compile time option SQLITE_ENABLE_FTS4_UNICODE61. (check-in: eccd6b6580 user: dan tags: trunk) | |
| 19:30 | Have the FTS unicode61 strip out diacritics when tokenizing text. This can be disabled by specifying the tokenizer option "remove_diacritics=0". (check-in: 790f76a589 user: dan tags: trunk) | |
| 19:01 | Avoid resetting the shared-cache schema when on of the connections using the shared cache closes. Delay resetting the schema until the last connection closes. (check-in: 635e3a762d user: drh tags: trunk) | |
| 10:56 | Make sure the Index.azColl pointers do not point to connection-specific memory. Also, remove an unnecessary reinitialization to sqlite3.pDfltColl. (Closed-Leaf check-in: c469850b2e user: drh tags: shared-schema) | |
|
2012-06-05
| ||
| 19:20 | Merge the latest trunk changes into shared-schema branch. Also fix a C99-ism in that branch. (check-in: 42338e9e69 user: drh tags: shared-schema) | |
| 13:56 | Add sqlite3_quota_ferror() and sqlite3_quota_file_available() interfaces to test_quota.c. Change sqlite3_quota_fwrite() to use a const input buffer. (check-in: 61669c9585 user: drh tags: trunk) | |
| 02:24 | Correct docs regarding use of malloc and free by the Windows VFS layer. No changes to code. (Closed-Leaf check-in: 8e8590a4dc user: mistachkin tags: winrt) | |
|
2012-06-04
| ||
| 05:18 | When not compiling for WinRT, skip using a couple Win32 APIs unavailable when compiling with MinGW. (check-in: eb29e2d939 user: mistachkin tags: winrt) | |
|
2012-06-02
| ||
| 17:09 | Revert sqlite3_close() to legacy behavior. Create a new sqlite3_close_v2() interface that exhibits the deferred-close behavior. This minimizes the chance of breakage in legacy apps. (check-in: c4b8621125 user: drh tags: deferred-close) | |
| 14:32 | The sqlite3_close() interface returns SQLITE_OK even if there are outstanding sqlite3_stmt and sqlite3_backup objects. The connection becomes a zombie. Resource deallocation is deferred until the last sqlite3_stmt or sqlite3_backup object closes. This is intended to help SQLite play nicer with garbage collectors. (check-in: e276a02b7f user: drh tags: deferred-close) | |
|
2012-05-31
| ||
| 22:12 | Update several APIs to enable compilation with newer revisions of WinRT. (check-in: 54de739f05 user: mistachkin tags: winrt) | |
| 13:10 | Avoid calling fchown() if the process is not running as root. (check-in: 70c419a434 user: drh tags: trunk) | |
| 00:21 | Only call fchown when running as root and supporting files mismatch the database owner & perms (check-in: ed53b645cc user: adam tags: apple-osx) | |
|
2012-05-29
| ||
| 19:25 | Link the NDEBUG macro to SQLITE_DEBUG so that when SQLITE_DEBUG is defined, NDEBUG is automatically undefined an dwhen SQLITE_DEBUG is undefined NDEBUG is automatically defined. (check-in: 07935d10d3 user: drh tags: trunk) | |
| 17:59 | Fix a typo (a repeated "or") in the documentation. No changes to code. (check-in: 6fec6cf1fb user: drh tags: trunk) | |
| 17:02 | Changes some NDEBUG macros to SQLITE_DEBUG in os_unix.c. The is a notational change only and really should not effect the code. (check-in: 8e3025709e user: drh tags: trunk) | |
| 00:48 | Merge the 64-to-32-bit RTree rounding fixes from trunk into the sessions branch. (check-in: 7eff45c280 user: drh tags: sessions) | |
| 00:39 | In the RTree module, make sure all double-to-float conversions round in a direction to increase the size of element bounding boxes. (check-in: 0abdc2903d user: drh tags: trunk) | |
| 00:30 | Refactor the float-to-double rounding routines so that they compile without warnings. (Closed-Leaf check-in: f607ad27c1 user: drh tags: rtree-32bit-rounding) | |
|
2012-05-28
| ||
| 20:22 | Fix the MSVC makefile so that it works with the unicode61 tokenizer. (check-in: 480158143b user: drh tags: trunk) | |
| 20:16 | Simplification to the coordinate rounding logic in RTree. (check-in: df24072de2 user: drh tags: rtree-32bit-rounding) | |
| 19:19 | When converting 64-bit floating point coordinates to 32-bit in RTree, take care to round the values such that the size of the bounding box is enlarged. (check-in: f4e8ff03ea user: drh tags: rtree-32bit-rounding) | |
| 18:22 | Merge the unicode61 tokenizer and the shared-cache-memory database changes into the sessions branch. (check-in: df817e70af user: drh tags: sessions) | |
| 17:51 | Updates regarding URI query parameters and shared cache in the documentation derived from comments in sqlite.h.in. No changes to code. (check-in: bcc72d413e user: drh tags: trunk) | |
| 15:32 | Fix Makefile.in so that it works with the new unicode tokenizer of FTS3/4. Update the version number to 3.7.13. (check-in: b8720d0416 user: drh tags: trunk) | |
| 13:58 | Add the mode=memory option to URI filenames, which when present forces the database to be an in-memory database. This enables named in-memory databases. (check-in: 651520fa84 user: drh tags: trunk) | |
| 12:22 | Omit the fts3 unicode character class routines from the build if fts3/4 is disabled. (check-in: c00bb5d460 user: drh tags: trunk) | |
|
2012-05-27
| ||
| 22:42 | Merge into trunk the changes that permit :memory: databases to use shared cache. (check-in: e72179f3a4 user: drh tags: trunk) | |
| 01:19 | Have user interfaces report out the filename of in-memory databases as an empty string, as it always has. This simplifies the changes. (Closed-Leaf check-in: 595dfdbffe user: drh tags: shared-cache-memdb) | |
| 00:11 | Fix corner-case problems with shared-cache for in-memory databases. (Closed-Leaf check-in: 997ef5f61e user: drh tags: shared-cache-memdb) | |
|
2012-05-26
| ||
| 20:08 | Only allow :memory: databases to share cache if there are created using a URI filename. This minimizes the risk of breakages in legacy applications that have shared-cache enabled but also use :memory: databases which they expect to keep separate. (check-in: e3ad61e030 user: drh tags: shared-cache-memdb) | |
| 18:42 | Merge fts4-unicode branch with trunk. (check-in: 25ba1f84f2 user: dan tags: trunk) | |
| 18:28 | If SQLITE_DISABLE_FTS3_UNICODE is defined, do not build the "unicode61" tokenizer. (Closed-Leaf check-in: e71495a817 user: dan tags: fts4-unicode) | |
| 18:06 | Enable the use of shared cache for an in-memory database, so that separate database connections can share the same in-memory database. (check-in: 4590e433f2 user: drh tags: shared-cache-memdb) | |
| 17:57 | Change the format of the tables used by sqlite3FtsUnicodeTolower() to make them a little smaller. (check-in: b89d3834f6 user: dan tags: fts4-unicode) | |
| 16:22 | Add coverage tests for fts3_unicode.c. (check-in: 07d3ea8a3c user: dan tags: fts4-unicode) | |
| 15:44 | Add fault-injection tests that use the unicode61 tokenizer. Fix a problem revealed by the same. (check-in: ed28c48a3d user: dan tags: fts4-unicode) | |
| 14:54 | Change the name of the "unicode" tokenizer to "unicode61" to emphasize that the case folding and separator-character identification routines are based on unicode version 6.1. (check-in: 8f3e60aa22 user: dan tags: fts4-unicode) | |
|
2012-05-25
| ||
| 19:50 | Add special fast paths to sqlite3FtsUnicodeTolower() and Isalnum() for codepoints in the ASCII range. (check-in: cf7b25d476 user: dan tags: fts4-unicode) | |
| 18:48 | Fix comments in generated file fts3_unicode2.c. (check-in: 3dc567ef47 user: dan tags: fts4-unicode) | |
| 17:50 | Add an experimental tokenizer to fts4 - "unicode". This tokenizer works in the same way except that it understands unicode "simple case folding" and recognizes all characters not classified as "Letters" or "Numbers" by unicode as token separators. (check-in: 0c13570ec7 user: dan tags: fts4-unicode) | |
|
2012-05-22
| ||
| 19:25 | Use the new test suite helper procedure 'get_pwd' to query the current directory from tests. (check-in: 1dd01e4081 user: mistachkin tags: winrt) | |
| 17:39 | Merge the 3.7.12.1 trunk changes into the WinRT branch. (check-in: b9ed0b26de user: drh tags: winrt) | |
| 13:11 | Version 3.7.12.1 (check-in: 972e75bb5d user: drh tags: apple-osx) | |
| 13:01 | Version 3.7.12.1 (check-in: d07b7b67d1 user: drh tags: sessions) | |
| 02:45 | Version 3.7.12.1 (check-in: 6d326d44fd user: drh tags: trunk, release, version-3.7.12.1) | |
|
2012-05-21
| ||
| 22:45 | Increase the version number to 3.7.12.1. Minor changes to test scripts. (check-in: 5519cc5ef4 user: drh tags: trunk) | |
| 21:26 | Merge the nested aggregate query fix (ticket [c2ad16f997ee9c8ed]) unto trunk. (check-in: e459c3360b user: drh tags: trunk) | |
| 21:20 | Mark and always-true conditional as such. Add the fuzz-oss1.test test module. (Closed-Leaf check-in: bdc01fd0fa user: drh tags: nested-agg) | |
| 20:13 | Candidate fix for the nested aggregate query problem of ticket [c2ad16f997ee9c8e]. (check-in: f3dd1fafd4 user: drh tags: nested-agg) | |
| 19:11 | Convert the NameContext object from using u8 booleans to using individual bits in a single u8 as its booleans. This change might become a basis for a fix for [c2ad16f997ee9c]. (check-in: 7222609693 user: drh tags: nested-agg) | |
| 16:59 | Make sure lookaside memory allocations are unusable after they are freed. (check-in: 3869aef634 user: drh tags: trunk) | |
| 12:25 | Move some #defines earlier in the file for test_quota.c in order to avoid a use before definition. (check-in: fda1ea0bee user: drh tags: trunk) | |
| 05:02 | Allow the sqlite3ExplainBegin function to be compiled by MSVC. (check-in: 18555128f5 user: mistachkin tags: trunk) | |
| 03:15 | Change the ".schema" command of the shell to output VIEWs in declared order, rather than alphabetical order, so that nested views will appear in the correct order. Fix for ticket [cfe84e86839e59e8]. (check-in: e092ff69e2 user: drh tags: trunk) | |
|
2012-05-20
| ||
| 20:23 | Fix a test case so that it works even with very long pathnames. (check-in: ecd4a06359 user: drh tags: trunk) | |
| 20:14 | Check-in included unrelated debugging code by mistake. Was: Fix a test case in the shell1.test script so that it works even for very long pathnames. (Closed-Leaf check-in: 0c0a03987c user: drh tags: mistake) | |
|
2012-05-17
| ||
| 21:04 | Merge updates from trunk. (check-in: 224c65e4a5 user: mistachkin tags: winrt) | |
| 14:17 | Stylistic fixes: limit source code line length to 80 characters. C89-style comments only, not C++/C99 style. (check-in: 4068abe05c user: drh tags: apple-osx) | |
|
2012-05-16
| ||
| 22:08 | Improve error reporting from sqlite3_file_control, SQLITE_FCNTL_REPLACE_DATABASE shouldn't copy file security/ACL metadata, bad bit mask fixed (check-in: 92e7bb9078 user: adam tags: apple-osx) | |
| 14:29 | Return SQLITE_MISUSE if an application attempts to register a virtual table module with the same name as an existing module. (check-in: ea2cd55e09 user: dan tags: shared-schema) | |
| 01:24 | Avoid using sqlite3ResetAllSchemasOfConnection() purely for its side-effects. (check-in: 5587c73bad user: drh tags: shared-schema) | |
|
2012-05-15
| ||
| 18:28 | The former sqlite3ResetInternalSchema() routine was really two different routines, selected by parameter, each with a confused mission. So split this routine up into three separate smaller routines, calling each separately as needed. Hopefully this will make further refactoring and schema reset collateral damage containment easier. (check-in: aa0c3493d3 user: drh tags: shared-schema) | |
| 17:15 | When a connection disconnects from a shared-cache database, only delete the in-memory schema if there are no other connections. (check-in: 46f4eb5430 user: dan tags: shared-schema) | |
| 12:49 | Add assert()s to verify that Table objects in the schema never use lookaside memory. (check-in: 736d6ea677 user: drh tags: trunk) | |
|
2012-05-14
| ||
| 12:20 | Add an assert() that verifies that the statement pointer from the sqlite3_prepare() family of functions is always NULL if the routines return other than SQLITE_OK. (check-in: 0bb1cfc63f user: drh tags: trunk) | |
| 02:05 | Version 3.7.12 (check-in: d9348b2a4e user: drh tags: apple-osx) | |
| 01:58 | Version 3.7.12 (check-in: be71d2f667 user: drh tags: sessions) | |
| 01:41 | Version 3.7.12 (check-in: 8654aa9540 user: drh tags: trunk, release, version-3.7.12) | |
|
2012-05-12
| ||
| 22:36 | Fix a typo in a comment which is used to generate documentation. No changes to code. (check-in: af525b5d25 user: drh tags: trunk) | |
| 18:29 | Parser bug fix: Make sure the table constraints allowed by prior releases can still be parsed, even if they are technically not allowed by the syntax diagram. (check-in: e536ac0418 user: drh tags: trunk) | |
| 14:59 | Merge trunk changes with apple-osx branch. (check-in: bf57f0fb73 user: dan tags: apple-osx) | |
| 11:50 | Update sessions branch with trunk changes. (check-in: 3f4848a871 user: dan tags: sessions) | |
| 05:30 | Before running each test script, make sure the FTS enhanced query syntax is disabled. (check-in: f84d87bcc0 user: dan tags: trunk) | |
| 01:14 | Use the regexp result option for a test case in shell1.test. (check-in: 93061c6e06 user: drh tags: trunk) | |
|
2012-05-11
| ||
| 23:03 | Adjust some of the pager tests to accommodate longer database pathnames. (check-in: 22eef1d8a8 user: drh tags: trunk) | |
| 23:01 | Fix the wal2.test script so that it works on big-endian machines. (check-in: c4ab72f750 user: drh tags: trunk) | |
| 20:43 | Fix a bug in the wal.test script so that it works on big-endian systems. (check-in: 40fe9088fb user: drh tags: trunk) | |
| 15:53 | Fix a harmless compiler warning inside an assert() statement within test code. (check-in: e68a3527de user: drh tags: trunk) | |
| 15:31 | Fix an evidence-mark typo in the comments of sqlite3.h. No changes to code. (check-in: 2b07408591 user: drh tags: trunk) | |
| 11:28 | Fix a harmless compiler warning. (check-in: 2b77301b96 user: drh tags: trunk) | |
| 00:56 | Make sure the WAL file is deleted when changing to DELETE journal mode. (check-in: 6670868590 user: drh tags: apple-osx) | |
|
2012-05-10
| ||
| 17:43 | Have the FTS auxiliary functions correctly handle terms that appear in non-matching branches of the FTS expression. Fix for [bdc6bbbb38]. (check-in: 4d3e1673b3 user: dan tags: trunk) | |
| 13:03 | Merge the table constraint parser fixes from trunk. (check-in: 12bb31dd6f user: drh tags: winrt) | |
| 12:17 | Merge in the windows AV-defense enhancements for open() and the table constraint parser fixes for legacy schemas, all from trunk. (check-in: 323570b8bd user: drh tags: sessions) | |
| 12:09 | Merge in the legacy table constraint parsing fixes from trunk. (check-in: e87702834e user: drh tags: apple-osx) | |
|
2012-05-09
| ||
| 22:36 | Added support for SQLITE_ENABLE_PERSIST_WAL compile time macro, retrieving lastErrno from WAL file and setting last errno when writes fail due to space constraints (check-in: 6547929410 user: adam tags: apple-osx) | |
|
2012-05-08
| ||
| 11:17 | Further changes to constraint parsing to support legacy syntax. (check-in: 38bf90af1e user: drh tags: trunk) | |
|
2012-05-07
| ||
| 22:29 | Merge parser adjustments from the trunk. (check-in: 0d8b920b2c user: mistachkin tags: winrt) | |
| 20:28 | Merge Windows directory checking changes from trunk. (check-in: 7a7466f400 user: mistachkin tags: winrt) | |
| 19:21 | Adjust the parser so that certain legacy schema constructs (that are not valid according to the syntax diagram) continue to be accepted, so that older databases that happen to use those constructs are still readable. This fixes an issue introduced by check-in [1b75f301affac6] (check-in: a1c014d8a8 user: drh tags: trunk) | |
| 18:10 | Merge Windows directory checking changes to trunk. (check-in: a4555a53ea user: mistachkin tags: trunk) | |
| 17:16 | Simplify directory checking for winOpen and add checking to winDelete. (Closed-Leaf check-in: b08530e1a0 user: mistachkin tags: win-check-dir) | |
| 13:15 | Do not do the AV retry loop on open if the file that is attempting to be opened is really a directory. (check-in: 03875633f4 user: drh tags: win-check-dir) | |
|
2012-05-05
| ||
| 01:03 | Merge the latest trunk changes into the apple-osx branch. (check-in: 2a99c0074a user: drh tags: apple-osx) | |
|
2012-05-04
| ||
| 23:31 | Update the sessions branch with all the latest changes from trunk. (check-in: 0f347fbfc7 user: drh tags: sessions) | |
| 23:11 | Sync the latest trunk changes into the winRT branch. (check-in: be4ab188cf user: drh tags: winrt) | |
| 13:22 | Minor tweaks to the hebrew transliteration tables. (Leaf check-in: 7b6de5c35d user: drh tags: translit-tokenizer) | |
| 02:58 | Add an experimental tokenizer to FTS3/4: one that transliterates latin, greek, cyrillic, and hebrew characters into pure ascii. (check-in: 930115693a user: drh tags: translit-tokenizer) | |
|
2012-05-01
| ||
| 14:21 | Update a test in io.test to account for [05f98d4eec]. (check-in: bfa61e781c user: dan tags: trunk) | |
|
2012-04-27
| ||
| 16:38 | Fix a minor deviation from the coding style guidelines. (check-in: 1e51bffe77 user: drh tags: trunk) | |
| 01:09 | Enhance the processing of ORDER BY clauses on compound queries to better match terms of the order by against expressions in the result set, in order to enable better query optimization. (check-in: a49e909c87 user: drh tags: trunk) | |
| 01:08 | Enhance the do_test proc in the test suite so that if the expected result is of the form "/.../" or "~/.../" then regular expression matching is done between result and the "..." part of the expectation. In the ~/.../ case, we expect there to be no match. (check-in: c9a734406c user: drh tags: trunk) | |
|
2012-04-26
| ||
| 22:47 | Allow virtual table constructors to be invoked recursively. A test case for this has been added to TH3. (check-in: 696a5a40bb user: drh tags: trunk) | |
|
2012-04-24
| ||
| 13:14 | New test cases for the ".dump" and ".mode insert" commands of the shell. (check-in: dfce856976 user: drh tags: trunk) | |
| 12:46 | Move the shell test scripts into the test/ subfolder so that they are run automatically by "make test". (check-in: 9fb7da6904 user: drh tags: trunk) | |
| 12:12 | Fix a sign-extension problem for BLOB output in ".insert" mode of the command-line shell. (check-in: 282f2a74c2 user: drh tags: trunk) | |
|
2012-04-23
| ||
| 12:38 | Update the ".table" command in the shell to show all tables in all attached databases, and to avoid using the deprecated sqlite3_get_table() function. (check-in: ce2d06e253 user: drh tags: trunk) | |
|
2012-04-21
| ||
| 11:33 | If terminating interactive input to the command-line shell with ^D, issue an extra \n to move the cursor to the next line before exiting. This check-in also accidently adds the test_spellfix.c file to the source tree. (check-in: feff1ef0b8 user: drh tags: trunk) | |
| 00:31 | Merge the latest trunk changes into the WinRT branch (fixes for tickets [2a5629202f] and [385a5b56b9]). (check-in: 25478dcff5 user: mistachkin tags: winrt) | |
|
2012-04-20
| ||
| 16:59 | Do not consider a DISTINCT clause redundant unless a subset of the result-set is collectively subject to a UNIQUE constraint and it can be guaranteed that all columns of the subset are NOT NULL (either due to NOT NULL constraints WHERE clause terms). Fix for [385a5b56b9]. (check-in: 7b8548b187 user: dan tags: trunk) | |
| 15:24 | Fix for [2a5629202f]. When considering whether or not a UNIQUE index may be used to optimize an ORDER BY clause, do not assume that all index entries are distinct unless there is some reason to believe that the index contains no NULL values. (check-in: 9870e4c4fe user: dan tags: trunk) | |
| 12:02 | Remove obsolete art. (check-in: 372a90e226 user: drh tags: trunk) | |
| 08:23 | Merge the latest trunk changes into the WinRT branch (fixes various MSVC compiler warnings). (check-in: 294a5cca50 user: mistachkin tags: winrt) | |
|
2012-04-19
| ||
| 20:43 | Update the apple-osx branch so that it includes all of the latest trunk changes. (check-in: b72f07b4a2 user: drh tags: apple-osx) | |
| 20:00 | Merge the latest trunk changes into the sessions branch. (check-in: 2b7a91e617 user: drh tags: sessions) | |
| 18:04 | Fix harmless compiler warnings on x64 MSVC, mostly in test code, but also in tclsqlite.c and in the FTS4 module. (check-in: 3281972eaa user: drh tags: trunk) | |
| 17:19 | Fix a harmless compiler warning in tclsqlite.c for MSVC x64. Fix a test case associated with the FTS4 merge feature. (check-in: de3f7187eb user: drh tags: trunk) | |
| 15:49 | Fix harmless compiler warnings (unused parameter warnings) in the aggregate query analyzer. (check-in: 2d43562084 user: drh tags: trunk) | |
|
2012-04-18
| ||
| 10:29 | Merge build tool updates from trunk. Also, modify MSVC makefile to allow for debugging of build tool issues. (check-in: b2a2fdb0ac user: mistachkin tags: winrt) | |
| 10:13 | Fix a harmless compiler warning in the mkkeywordhash.c utility program. (check-in: 6015200beb user: drh tags: trunk) | |
| 09:59 | Fix a typecast problem in lemon that could cause problems on 64-bit machines. (check-in: 4a5641cc0a user: drh tags: trunk) | |
| 05:57 | Import all the latest trunk changes into the WinRT branch. Refactor and/or remove WinCE-specific macros and functions used for file locking to improve clarity of presentation. (check-in: ad5cd15f49 user: mistachkin tags: winrt) | |
| 01:41 | Import all the latest trunk changes into the sessions branch. (check-in: 87a0eab5d9 user: drh tags: sessions) | |
|
2012-04-17
| ||
| 21:00 | When compiling for WinRT, always use the 'appcontainer' linker option. (check-in: 300bcfe311 user: mistachkin tags: winrt) | |
| 16:38 | Improved handling of aggregate subqueries within an aggregate query. (check-in: 430bb59d79 user: drh tags: trunk) | |
| 09:09 | Add an undocumented and possibly ephemeral ".breakpoint" command to the command-line shell, to call a no-op routine on which it is convenient to set a symbolic debugger breakpoint. (check-in: 8e2363ad76 user: drh tags: trunk) | |
|
2012-04-16
| ||
| 17:22 | Fix a bug in the command-line shell logic that attempts to continue with a ".dump" even after encountering database corruption. (check-in: 020b5e90f9 user: drh tags: trunk) | |
|
2012-04-14
| ||
| 13:25 | In the unix VFS, always set every open file to close-on-exec using either O_CLOEXEC at open (preferred) or FD_CLOEXEC in an ioctl after opening. Before this changes, many files were done this way, but not all. (check-in: 9efbeb11ae user: drh tags: trunk) | |
| 11:48 | Fix a typo in a comment that is extracted for documentation. No changes to code. (check-in: e87371c508 user: drh tags: trunk) | |
|
2012-04-11
| ||
| 23:22 | Add a testcase() macro to ensure that the sqlite3AuthCheck() call inside the query flattener really is effective. (check-in: a134e6e739 user: drh tags: trunk) | |
| 11:38 | Fix harmless static-analysis warnings, mosting having to do with memory leaks in the command-line shell. Add a clang analysis of the command-line shell to the "warnings-clang.sh" script. Other minor cleanups to the command-line shell code. (check-in: 93a0f452a7 user: drh tags: trunk) | |
|
2012-04-10
| ||
| 17:53 | Add new interfaces to the test_quota.c module: sqlite3_quota_ftruncate(), sqlite3_quota_file_size(), sqlite3_quota_file_truesize(), and sqlite3_quota_file_mtime(). (check-in: 2fa9f54309 user: drh tags: trunk) | |
| 16:05 | Fix a copy/paste error in a comment in the fuzzer. No changes to code. (check-in: 7433f2b550 user: drh tags: trunk) | |
|
2012-04-07
| ||
| 00:09 | Fix the application-defined function logic so that functions with a variable number of parameters can be replaced or deleted correctly. Also refactor some of the function-finder code for clarity of presentation. (check-in: 09d5581c81 user: drh tags: trunk) | |
|
2012-04-06
| ||
| 00:09 | Update sqlite3_analyzer to correctly find all database files when the multiplexor is being used. (check-in: 1bfc30cb0f user: drh tags: trunk) | |
|
2012-04-05
| ||
| 20:04 | Ignore the value of SQLITE_FCNTL_CHUNK_SIZE if it is negative. (check-in: 1b08fef945 user: drh tags: trunk) | |
| 01:37 | Performance improvements for the RowSet object when it undergoes many cycles between RowSetInsert and RowSetTest. (check-in: 49d20ede5f user: drh tags: trunk) | |
|
2012-04-04
| ||
| 16:56 | Add the ".trace" option to the command-line shell. (check-in: b9ac3d7e34 user: drh tags: trunk) | |
| 13:58 | Fix the multiplexor logging so that it works with SQLITE_ENABLE_8_3_NAMES. (check-in: 9e1e2fe295 user: drh tags: trunk) | |
| 13:43 | In the multiplexor extension, improve the error logging when a chunk fails to open. (check-in: 781453c686 user: drh tags: trunk) | |
|
2012-04-03
| ||
| 19:43 | Cherrypick commit [1d5e744cc6] from the trunk in order to avoid leaving a file-descriptor open in test scripts capi3.test and capi3c.test. This is the version of SQLite that ships by default on the original Mountain Lion release. (check-in: 86b8481be7 user: dan tags: apple-osx, mountain-lion) | |
| 18:34 | Do not run attempt to run test file fts4merge3.test unless the build includes FTS. (check-in: 0506bf86d3 user: dan tags: trunk) | |
| 18:33 | Modify capi3.test and capi3c.test so that they work with SQLITE_OMIT_AUTORESET builds. (check-in: 1d5e744cc6 user: dan tags: trunk) | |
| 17:43 | Modify the integrity-check code to reduce the size of the large allocation from 4 bytes to 1 bit for each page in the database file. (check-in: fa3a498dfe user: dan tags: trunk) | |
| 17:05 | Fix a typo in the rtree6.test script that prevented it from running. (check-in: 221fe4a8ea user: drh tags: trunk) | |
| 17:01 | Rerun autoconf to update the configure script for version 3.7.12 (check-in: 6d73eb20e8 user: drh tags: trunk) | |
| 15:10 | If the SELECT that finds all root pages in the showdb fails, then report an error. (check-in: 4b16141501 user: drh tags: trunk) | |
| 14:59 | Enhance the "showdb" utility program with the "pgidx" option. Now requires linkage with the amalgamation. (check-in: 4b5737014c user: drh tags: trunk) | |
|
2012-04-02
| ||
| 23:42 | bad assert (check-in: 0c0150f2a3 user: adam tags: apple-osx) | |
| 23:35 | Merge in latest changes, autologging options, read only file system wal support, test config conditionalization, WAL frame write prebuffering (check-in: d51c086e5c user: adam tags: apple-osx) | |
| 21:35 | The SQLITE_RTREE_INT_ONLY compile-time option causes the RTree extension to use only integer math and store only integer coordinates. (check-in: 02b7640f51 user: drh tags: trunk) | |
| 17:18 | Add #ifdefs to allow a test build to succeed even if SQLITE_ENABLE_FTS3 is not defined. (check-in: fb121980e4 user: drh tags: trunk) | |
|
2012-03-31
| ||
| 19:12 | Fix a compiler warning by removing a redundant variable. (check-in: af602d8773 user: drh tags: trunk) | |
| 17:50 | Test cases for RELEASE and ROLLBACK TO of a nested savepoint while queries are pending. Ticket [27ca74af3c083] (check-in: d2bf0efa7d user: drh tags: trunk) | |
| 17:17 | Do not abort pending queries on a RELEASE of a nested SAVEPOINT. This is a candidate fix for ticket [27ca74af3c083f787]. (check-in: 79a4a3a84f user: drh tags: trunk) | |
| 15:08 | Modify selectColumnsFromExprList() to avoid ever incorrectly returning SQLITE_NOMEM. (check-in: e7cb6b73ac user: dan tags: trunk) | |
| 11:58 | Change the ICU tokenizer so that it does not attempt to call strlen(NULL). (check-in: 04298f1ac4 user: dan tags: trunk) | |
| 09:59 | Fix a bug in the EXPLAIN code for listing trigger programs that was causing an out-of-bounds read. (check-in: c9342ca581 user: dan tags: trunk) | |
| 02:46 | Merge all the latest trunk changes into the apple-osx branch. (check-in: 18ec60cacd user: drh tags: apple-osx) | |
| 02:34 | Do more aggressive optimization of the AND operator where one side or the other is always false. (check-in: f9a7e179cb user: drh tags: trunk) | |
|
2012-03-30
| ||
| 17:30 | Merge all recent trunk changes into the sessions branch. (check-in: fb9b9987de user: drh tags: sessions) | |
| 16:44 | Avoid using the OVERLAPPED struct on WinCE. (check-in: 196ca3a8b0 user: mistachkin tags: trunk) | |
| 15:57 | Simplify the winRead and winWrite VFS functions to reduce the number of system calls. (check-in: b34491869c user: drh tags: trunk) | |
| 15:48 | When a named CHECK constraint fails, include the name of the constraint in the error message. (check-in: 1b75f301af user: drh tags: trunk) | |
| 14:59 | Fix MSVC compiler warnings in test code. (check-in: cb7a850439 user: drh tags: trunk) | |
| 14:01 | Merge the latest trunk changes into the winrt branch. (check-in: a1a85b846a user: drh tags: winrt) | |
| 13:34 | Fix an FTS4 test script problem for windows. (check-in: 36aa6665e7 user: drh tags: trunk) | |
| 12:27 | Simplify the winRead and winWrite VFS functions to reduce the number of system calls. (check-in: 10ce846759 user: mistachkin tags: winrt) | |
| 12:10 | Change the name of a local variable from "not" to "bNot" to lessen the chances of it colliding with some prior #define in the appliation. (check-in: cbdd863876 user: drh tags: trunk) | |
| 00:05 | In the ".output" command of the shell, if the first character of the output filename is '|' then use popen() instead of fopen(). (check-in: fa82062c65 user: drh tags: trunk) | |
| 00:00 | Fix compiler warnings on GCC and MSVC and fix a C89-ism that broke the build for MSVC. (check-in: b451c0f97f user: drh tags: trunk) | |
|
2012-03-29
| ||
| 15:11 | Merge fts4-incr-merge with trunk. (check-in: 4d6de3e9be user: dan tags: trunk) | |
| 14:29 | Disable the LIKE optimization if the column on the left-hand-side of the LIKE operator belongs to a virtual table. (check-in: 0bacb879e1 user: dan tags: trunk) | |
| 07:51 | Fix an out of date comment on sqlite3ArrayAllocate(). (check-in: 4afdd5ae53 user: dan tags: trunk) | |
|
2012-03-28
| ||
| 18:08 | Do the accounting for incr-merge work in pages instead of blocks. (Closed-Leaf check-in: 83037d5844 user: dan tags: fts4-incr-merge-exp) | |
| 16:44 | Merge in the latest changes from trunk. (Closed-Leaf check-in: 66c4aaadda user: drh tags: fts4-incr-merge) | |
| 16:22 | Avoid loading overflow pages just to satisfy typeof() or length() functions if the correct result can be computed without the extra page fetches. (check-in: 0733c98c32 user: drh tags: trunk) | |
| 16:14 | Minor changes to the core of OP_Column for performance and to clarify the critical path. (Closed-Leaf check-in: 868394761e user: drh tags: faster-typeof-and-length) | |
| 15:44 | This change turned out to the code slower. Side track it. Was: Tweaks to the OP_Column opcode for clarity of presentation. (Closed-Leaf check-in: 4d516240d2 user: drh tags: mistake) | |
| 13:55 | Fix a problem in fts4merge3.test. (check-in: 64fc8b30f8 user: dan tags: fts4-incr-merge) | |
| 13:41 | Improvements to comments. Minor changes to code in the hot path of OP_Column - with the hope of get a few cycles of performance improvement. (check-in: ca09310343 user: drh tags: faster-typeof-and-length) | |
| 02:51 | Test cases for length() of a large blob in an aggregate query. (check-in: d095fa4bfa user: drh tags: faster-typeof-and-length) | |
| 02:43 | Fix the typeof() and length() optimization so that it works for aggregates as well as scalar queries. (check-in: bc18215a8a user: drh tags: faster-typeof-and-length) | |
| 01:34 | Evaluate typeof(X) and length(Y) where X is any column and Y is a blob column without actually loading X and Y from disk. (check-in: b899dbeb60 user: drh tags: faster-typeof-and-length) | |
|
2012-03-27
| ||
| 18:00 | Add output of PRAGMAs auto_vacuum and encoding to the "schema" command of the fts3view utility program. (check-in: e310763193 user: drh tags: fts4-incr-merge) | |
| 15:10 | Really delete the fts3merge.test script (should have been deleted by the previous commit). (check-in: 83838149d9 user: dan tags: fts4-incr-merge) | |
| 15:00 | Remove the fts3merge.test script in favour of changing the fts4merge.test script so that it runs tests using both fts4 and fts3. Fix some problems with incr-merge and FTS3 tables. (check-in: 5c447e226a user: dan tags: fts4-incr-merge) | |
| 14:54 | In the fts3view utility, label the blank segments used to mark the end of a segment sequence for a level/idx as "null". Improve the alignment of root segment names. (check-in: 04aea0245e user: drh tags: fts4-incr-merge) | |
| 13:51 | Enhance the fts3view tool with the big-segment command and fix a bug in the display of doclists. (check-in: e9436d8038 user: drh tags: fts4-incr-merge) | |
| 13:44 | Merge the fts4-incr-merge-exp branch with fts4-incr-merge. (check-in: eb00b95885 user: dan tags: fts4-incr-merge) | |
| 11:48 | Allow multiple incremental merges to proceed concurrently. This is required to prevent a large crisis-merge from occuring while an even larger incremental-merge is underway. (Closed-Leaf check-in: 7ed9d2f24a user: dan tags: fts4-incr-merge-exp) | |
| 00:38 | Minor correct errors in the file format description for FTS3/4 contained in the fts3.c header comment. (check-in: fb8aacdd8f user: drh tags: fts4-incr-merge) | |
| 00:34 | Enhance fts3view to show decodes of segments and doclists. (check-in: 6d09de231b user: drh tags: fts4-incr-merge) | |
|
2012-03-26
| ||
| 21:57 | Add the fts3view utility program. (check-in: f936c8ea16 user: drh tags: fts4-incr-merge) | |
| 14:36 | Fix FTS3 so that it works even without SQLITE_DEBUG. (check-in: a18c103121 user: drh tags: fts4-incr-merge) | |
| 10:57 | Modify the FTS integrity-check so that the checksums do not depend on the results of signed integer overflow, which is undefined in C. (check-in: f907fc3fb3 user: dan tags: fts4-incr-merge) | |
| 10:47 | Add a comment to explain how the FTS integrity-check works. (check-in: 64e8a116f3 user: dan tags: fts4-incr-merge) | |
| 10:36 | Add an experimental integrity-check function to FTS. (check-in: 40fc880474 user: dan tags: fts4-incr-merge) | |
|
2012-03-25
| ||
| 17:25 | Increase the version number to 3.7.12 (check-in: d95f9fb713 user: drh tags: trunk) | |
|
2012-03-24
| ||
| 20:09 | Add SQLITE_DBSTATUS_CACHE_WRITE to the command-line shell. (check-in: 30b8dd326d user: drh tags: trunk) | |
| 20:06 | Add SQLITE_DBSTATUS_CACHE_WRITE. Used to query a database connection for the cumulative number of database pages written. (check-in: 05f98d4eec user: drh tags: trunk) | |
| 19:44 | Add SQLITE_DBSTATUS_CACHE_WRITE. Used to query a database connection for the cumulative number of database pages written. (check-in: 3cb6a879f1 user: dan tags: fts4-incr-merge) | |
| 17:29 | Enable fts3 tables to use incremental merge by automatically creating the %_stat table when it is needed. (check-in: cc051fc0b2 user: drh tags: fts4-incr-merge) | |
| 17:09 | Fix a failing assert() in the FTS3_LOG_MERGES related code. (check-in: 4220d52cb3 user: dan tags: fts4-incr-merge) | |
| 16:43 | Add a comment to fts3SyncMethod() to justify the nMinMerge=64 constant. (check-in: af55ca5fc6 user: dan tags: fts4-incr-merge) | |
| 16:18 | Fix a bug in debugging code enabled when FTS3_LOG_MERGES is defined. (check-in: 2e06babf49 user: drh tags: fts4-incr-merge) | |
| 16:11 | Remove the Fts3Table.mxLevel variable. (check-in: 67a0cffc9d user: dan tags: fts4-incr-merge) | |
| 14:45 | Merge auto-incr-merge with incr-merge branch. (check-in: 1c68687ab6 user: dan tags: fts4-incr-merge) | |
| 14:45 | Modify the way the number of leaves written and the maximum relative level are calculated in the auto-incr-merge code. (Closed-Leaf check-in: 0d841c957c user: dan tags: fts4-auto-incr-merge) | |
| 02:20 | An attempt at automatic incremental merging for FTS4. (check-in: ed69434cd8 user: drh tags: fts4-auto-incr-merge) | |
|
2012-03-23
| ||
| 18:26 | Fix a spurious SQLITE_CONSTRAINT error that may be returned by an incr-merge operation. (check-in: ed7c17ea16 user: dan tags: fts4-incr-merge) | |
| 15:38 | Add a test to verify that sqlite3_total_changes() works with incr-merge operations. (check-in: 1c72cecc6b user: dan tags: fts4-incr-merge) | |
| 14:38 | Remove an incorrect assert() statement. Fix a const-related warning. (check-in: 96ed47493b user: dan tags: fts4-incr-merge) | |
| 14:23 | When an incremental blob cursor is invalidated (occurs when an SQL statement modifies or deletes the row the blob cursor points to) release all page references held by the cursor. Otherwise, the presence of these references may cause other code in btree.c to incorrectly infer that the database is corrupt. (check-in: 341b703ce1 user: drh tags: trunk) | |
| 13:40 | Fix another test case issue in trace2.test. (check-in: 02a8e4236c user: dan tags: fts4-incr-merge) | |
| 12:28 | Update MSVC makefile to support compiling for WinRT using one setting. (check-in: c10794bfac user: mistachkin tags: winrt) | |
| 11:09 | When an incremental blob cursor is invalidated (occurs when an SQL statement modifies or deletes the row the blob cursor points to) release all page references held by the cursor. Otherwise, the presence of these references may cause other code in btree.c to incorrectly infer that the database is corrupt. (check-in: 82c3f2ba42 user: dan tags: fts4-incr-merge) | |
| 11:07 | Update a couple of existing test cases. (check-in: dcb8fa0f77 user: dan tags: fts4-incr-merge) | |
|
2012-03-22
| ||
| 17:48 | Add test cases to fts4merge.test. (check-in: ecab208333 user: dan tags: fts4-incr-merge) | |
| 16:48 | Following an incr-merge operation that does not completely consume its input segments, store context in the rowid==1 row of the %_stat table that allows the next incr-merge to pick up where the previous left off. (check-in: ab0a4f44fb user: dan tags: fts4-incr-merge) | |
| 12:50 | Always quote the names of tables in the output of the shell's ".dump" command, even if the name is pure alphabetic text, in case the name is a keyword. (check-in: 638b711502 user: drh tags: trunk) | |
|
2012-03-21
| ||
| 14:34 | Add fts4merge3.test, for testing that older versions of FTS4 may interoperate with incr-merge capable versions. (check-in: 903ec5126d user: dan tags: fts4-incr-merge) | |
|
2012-03-20
| ||
| 17:04 | Merge trunk changes into the fts4-incr-merge branch. (check-in: f61d5fb028 user: drh tags: fts4-incr-merge) | |
| 15:10 | Remove the _SafeInit() entry points from the TCL interface. They have long been no-ops. Removing them completely avoids confusion as to why they don't work. (check-in: 0fb26c7bfa user: drh tags: trunk) | |
| 11:35 | Version 3.7.11 (check-in: 00bb9c9ce4 user: drh tags: trunk, release, version-3.7.11) | |
| 03:10 | Fix out-of-bounds array references in the "echo" virtual table module used for testing. No changes to the SQLite core. (check-in: 7b449b301e user: drh tags: trunk) | |
| 02:18 | Add WinRT comments to MSVC makefile. (check-in: ddea657bd8 user: mistachkin tags: winrt) | |
| 02:10 | Remove version information from the MSVC makefile as it is no longer necessary. (check-in: 6f0c1f9761 user: mistachkin tags: winrt) | |
|
2012-03-19
| ||
| 23:32 | Merge updates from trunk. (check-in: 4ab1ffd45d user: mistachkin tags: winrt) | |
| 23:28 | Fix typo, use the syscall table for osOutputDebugStringA. (check-in: 9598c2a398 user: mistachkin tags: winrt) | |
| 17:42 | Add additional test cases to e_insert.test. Update evidence marks. no changes to core code. (check-in: 036395c0a8 user: drh tags: trunk) | |
| 16:21 | Merge latest trunk changes into apple-osx branch. (check-in: f999197b75 user: dan tags: apple-osx) | |
| 14:57 | Fix one more compiler warning missed by the previous check-in. (check-in: bc03d99a78 user: drh tags: trunk) | |
| 14:51 | Suppress harmless compiler warnings on windows in FTS4 and RTREE. (check-in: 4fd68647c8 user: drh tags: trunk) | |
| 14:28 | Avoid a compiler warning (an incorrect compiler warning, at that) in vs2010. (check-in: 7dd97f12cd user: drh tags: trunk) | |
| 11:17 | Merge the latest trunk changes into the sessions branch. (check-in: 2277c70b6f user: dan tags: sessions) | |
| 10:21 | Ensure that compatible malloc and free functions are used with stat3 data if SQLITE_ENABLE_STAT3 is defined. (check-in: 32bb1ecee4 user: dan tags: trunk) | |
|
2012-03-18
| ||
| 03:22 | On Windows, when no temporary path is available, skip prepending the directory separator. (check-in: 32b5c20e54 user: mistachkin tags: winrt) | |
| 01:32 | Add SQLITE_OMIT_SHUTDOWN_DIRECTORIES compile-time option to disable clearing the sqlite3_data_directory and sqlite3_temp_directory variables during sqlite3_shutdown. Also, only clear the variables if the heap was actually shutdown. (check-in: 1ae9f9e4f7 user: mistachkin tags: winrt) | |
|
2012-03-17
| ||
| 16:56 | Fix various incorrect and missing comments and other style issues in and around the FTS incremental merge code. (check-in: 7aabb62c8c user: dan tags: fts4-incr-merge) | |
| 15:12 | In pager1.test, use "file attr test.db -readonly 0" before "file attr test.db -perm rw-rw-rw-", not after. (check-in: 4f5283f18f user: dan tags: trunk) | |
| 09:43 | Modify a test in ioerr2.test to account for the new SQLITE_ABORT_ROLLBACK extended error code. (check-in: affaebde10 user: dan tags: trunk) | |
|
2012-03-16
| ||
| 17:00 | Update the trace2.test script for languageid. (check-in: a11528ac57 user: drh tags: trunk) | |
| 16:52 | Cherrypick the [3475092cff] fix for 32-bit overflow with large language-ids into trunk. (check-in: 2755edc7f1 user: drh tags: trunk) | |
| 15:54 | Fix some integer overflow problems that can occur when using large langauge id values. (check-in: 3475092cff user: dan tags: fts4-incr-merge) | |
| 14:54 | Add a comment to the FTS getAbsoluteLevel() function. No actual code changes. (check-in: 7e0f861bed user: dan tags: fts4-incr-merge) | |
| 10:28 | Reset the sqlite3_data_directory and sqlite3_temp_directory variables when the sqlite3_shutdown function is called since they may refer to memory allocated by the heap subsystem that was just shutdown. (check-in: cd70bc4b78 user: mistachkin tags: winrt) | |
| 00:28 | Fix harmless compiler warnings. (check-in: 74eadeec34 user: drh tags: trunk) | |
|
2012-03-15
| ||
| 22:54 | Add the sqlite3_db_readonly() API to trunk. (check-in: fed134a5f3 user: drh tags: trunk) | |
| 21:28 | Add the sqlite3_db_readonly() interface. This is still tentative, pending a closer look at other ideas to accomplish the same thing. (Closed-Leaf check-in: 254f99ea9f user: drh tags: db-readonly-api) | |
| 17:45 | Modify incremental merge code to merge nMin segments at a time. (check-in: cd34bc1af4 user: dan tags: fts4-incr-merge) | |
| 03:40 | Add SQLITE_WIN32_HEAP_CREATE compiler define to control whether or not the Win32 native allocator will create an isolated heap for all allocated data. (check-in: 8693fb652e user: mistachkin tags: winrt) | |
|
2012-03-14
| ||
| 23:08 | Fix macro issues for osGetProcessHeap and sqlite3_win32_write_debug. (check-in: d3d071598a user: mistachkin tags: winrt) | |
| 20:20 | Fix typos, use #if instead of #ifdef when checking for the Win32 native heap validation define. (check-in: 845aa46f69 user: mistachkin tags: winrt) | |
| 20:17 | Avoid redefining macros. Enable use of the Win32 native heap on WinRT. Use the syscall table to call OutputDebugStringW and fix type casting warnings. (check-in: 46c412a8f6 user: mistachkin tags: winrt) | |
| 20:01 | Add tests for incremental merge code. (check-in: 570473729d user: dan tags: fts4-incr-merge) | |
| 12:17 | Avoid allocating a large object on the stack in the incremental merge code. Use sqlite3_malloc() instead. (check-in: 36ae510de4 user: dan tags: fts4-incr-merge) | |
| 11:51 | Fix another bug in the incremental merge code. (check-in: f97b12e095 user: dan tags: fts4-incr-merge) | |
| 03:41 | Remove SQLITE_OS_WINRT setting from MSVC makefile. (check-in: df4caf1326 user: mistachkin tags: winrt) | |
| 01:28 | Add warning to the docs about changing the data directory when a database connection is open. (check-in: c07cd85ca9 user: mistachkin tags: winrt) | |
| 00:44 | Add experimental support for resolving relative database file paths using a fixed user-defined directory. (check-in: 7354ae8fd3 user: mistachkin tags: winrt) | |
|
2012-03-13
| ||
| 19:56 | Fix some bugs in the incremental merge code. Some remain. (check-in: bff2168370 user: dan tags: fts4-incr-merge) | |
| 03:38 | Add assert to verify the number of characters to write in sqlite3_win32_write_debug. (check-in: 8083f6164f user: mistachkin tags: winrt) | |
| 03:35 | Defer creation of the sleep event object until it is needed. Added sqlite3_win32_write_debug and sqlite3_win32_sleep APIs to assist in portability to WinRT. (check-in: 7af88ad306 user: mistachkin tags: winrt) | |
| 01:30 | Cleanup the Windows syscall table, removing the unused CreateFileMapping entry. (check-in: fb7d8bf6ec user: mistachkin tags: winrt) | |
| 01:16 | More changes required to compile for WinRT using VS 11 beta. Also, replace more APIs with their WinRT alternatives. (check-in: 6b997d9c32 user: mistachkin tags: winrt) | |
|
2012-03-09
| ||
| 22:02 | Candidate fix for the optimizer problem described in ticket [b7c8682cc17f3] which can causes a LEFT JOIN to be changed into a INNER JOIN if there are OR terms in the WHERE clause. (check-in: 0dc4cb9355 user: drh tags: trunk) | |
| 12:52 | Minor commenting and stylistic changes only. (check-in: a1747086c5 user: drh tags: fts4-incr-merge) | |
|
2012-03-08
| ||
| 20:39 | Merge test current directory value fix from trunk and fix uri tests. (check-in: 88963c33c1 user: mistachkin tags: winrt) | |
| 20:28 | On Windows, make sure the returned test current directory value does not contain any backslashes. (check-in: efee39e64b user: mistachkin tags: trunk) | |
| 20:22 | Merge and manually resolve testing updates from trunk. (check-in: 5eecdb44dd user: mistachkin tags: winrt) | |
| 20:00 | On Windows, make sure the current directory value used by the test suite is 'normalized' to what the parent command shell sees. Also, clean the test directories used by the quota2.test file. (check-in: 82bcd7ec15 user: mistachkin tags: trunk) | |
| 18:39 | Add the 'merge=?,?' command to fts4. This still needs some work. (check-in: 741b8f8977 user: dan tags: fts4-incr-merge) | |
|
2012-03-07
| ||
| 20:11 | When compiled for WinRT, use the CreateFile2 and LoadPackagedLibrary functions instead of CreateFile and LoadLibrary. (check-in: 27d6942ca2 user: mistachkin tags: winrt) | |
| 19:13 | If a CHECK constraint is named, report that name on the error message when the constraint fails. (Closed-Leaf check-in: 9a0f90d9de user: drh tags: named-check-constraints) | |
| 16:52 | Merge in the latest trunk changes. (check-in: ca4708531a user: drh tags: winrt) | |
|
2012-03-06
| ||
| 03:00 | Fix for test issues when there is no current directory support due to being compiled for WinRT. (check-in: a811cb0152 user: mistachkin tags: winrt) | |
|
2012-03-05
| ||
| 22:52 | Add compile-time define to indicate if the VFS supports the concept of a current directory (as WinCE and WinRT do not). Avoid using the GetTempPath and GetFullPathName APIs on WinRT. Some tests still need adjustments. (check-in: 86c049a171 user: mistachkin tags: winrt) | |
| 16:39 | Pull in all the latest trunk changes. (check-in: 504bf49086 user: drh tags: apple-osx) | |
| 16:26 | Merge in the latest trunk changes. (check-in: ff86875ca3 user: drh tags: sessions) | |
| 16:24 | Fix a problem compiling the test code in fts3_test.c when SQLITE_ENABLE_FTS3 is not defined. (check-in: b00ccda307 user: dan tags: trunk) | |
| 15:33 | Merge the fts4-languageid branch with the trunk. (check-in: 99a9073b5e user: dan tags: trunk) | |
|
2012-03-04
| ||
| 02:56 | When creating the event used to sleep on WinRT, request the minimum access rights required for the desired operations on it (i.e. SYNCHRONIZE). (check-in: ed603d7594 user: mistachkin tags: winrt) | |
|
2012-03-03
| ||
| 18:46 | Add the xLanguageid method to sqlite3_fts3_tokenizer versions 1 and greater. (Closed-Leaf check-in: f8e9c445dd user: dan tags: fts4-languageid) | |
| 13:15 | When compiled for WinRT, avoid using MapViewOfFile and GetFileAttributes. Also, reset the private 'sleep' event handle when the VFS is cleaned up. (check-in: 38df8fc1b4 user: mistachkin tags: winrt) | |
| 01:44 | Add a test case for ticket [3557ad65a076c]. (check-in: 4f34d7077b user: drh tags: trunk) | |
| 00:34 | Fix a bug [3557ad65a07] that causes incorrect DISTINCT processing on an indexed query involving the IN operator. (check-in: dec9a995d7 user: drh tags: trunk) | |
|
2012-03-02
| ||
| 23:53 | When compiled for WinRT, avoid using the FORMAT_MESSAGE_ALLOCATE_BUFFER flag to FormatMessage (i.e. because LocalFree is unavailable). (check-in: 9eb331be7e user: mistachkin tags: winrt) | |
| 22:41 | Fix test pragma-19.5 so that it works on file names that may contain spaces and/or backslashes. (check-in: 9aaa1ab7c6 user: mistachkin tags: trunk) | |
| 22:38 | When running on Windows with an NT-based kernel, always use the LockFileEx/UnlockFileEx functions (with the correct flags). (check-in: 3e7ba3ddb9 user: mistachkin tags: winrt) | |
| 20:34 | Remove an obsolete comment from FTS3. No code changes. (check-in: 74d224b144 user: drh tags: trunk) | |
| 19:53 | Fix problems with combining content= and languageid= in a single fts4 table. (check-in: 22491e7bc3 user: dan tags: fts4-languageid) | |
| 16:18 | Add test for FTS 'rebuild' command. (check-in: 181bc35731 user: dan tags: fts4-languageid) | |
| 13:47 | Add new Win32 APIs used to the system call table. Add error handling code for SetFilePointerEx. Make sure the last error number is saved from the call to GetFileInformationByHandleEx. (check-in: a782d2dc3c user: mistachkin tags: winrt) | |
| 12:26 | Fix the FTS 'optimize' command on multi-lingual databases. (check-in: 65fa693729 user: dan tags: fts4-languageid) | |
| 11:48 | Fix a bug in merging FTS language tables for languages other than language 0. (check-in: d281cb8984 user: dan tags: fts4-languageid) | |
| 00:00 | Omit all ANSI APIs for winRT. (check-in: cbf23b461f user: drh tags: winrt) | |
|
2012-03-01
| ||
| 22:44 | Use GetInformationByHandleEx() instead of GetFileSize() on winRT. (check-in: 119f251de7 user: drh tags: winrt) | |
| 22:33 | Do not run the large file tests if a file named "skip-big-file" exists in the test directory. This enables tests to be run much faster on systems that lack sparse file support. (check-in: 5a83912352 user: drh tags: winrt) | |
| 22:06 | Use SetFilePointerEx() instead of SetFilePointer() on winRT. (check-in: 36efafc618 user: drh tags: winrt) | |
| 21:30 | Fix a typo in the header comment of sqlite3_commit_hook(). (check-in: 3784d1475b user: drh tags: trunk) | |
| 21:19 | Use WaitForSingleObjectEx() as a substitute for Sleep on winRT. (check-in: bf897be0da user: drh tags: winrt) | |
| 20:05 | Add recognition of the SQLITE_OS_WINRT compile-time option. Use InitializeCriticalSectionEx() under winRT. (check-in: 8b7ca8a09f user: drh tags: winrt) | |
| 19:44 | Add the "languageid=" option to fts4. This code is still largely untested and alsmost certainly buggy. (check-in: bea257f70f user: dan tags: fts4-languageid) | |
| 19:14 | Add back in some #includes that were removed incorrectly by the previous check-in. (check-in: 718905367f user: drh tags: winrt) | |
| 18:16 | Remove unused #defines from os.h. (check-in: c0891296b4 user: drh tags: winrt) | |
|
2012-02-28
| ||
| 17:57 | Fix spurious errors that may occur if an empty database is opened and then initialized as a WAL database by a second connection. (check-in: 16330a2f72 user: dan tags: trunk) | |
| 11:52 | Fix a case where an error code was being overwritten in multiplexDelete(). (check-in: c267893a08 user: dan tags: trunk) | |
|
2012-02-27
| ||
| 14:28 | Fix the xDelete implementation of the multiplexor VFS so that it correctly deletes overflow WAL files. (check-in: e44e26771e user: drh tags: trunk) | |
|
2012-02-24
| ||
| 16:13 | Separate multiplexor overflow pages for -wal and -journal files into separate namespaces when in 8+3 filename mode. (check-in: d6850667ea user: drh tags: trunk) | |
| 15:57 | Fix the multiplexor so that it works with WAL mode and 8+3 filenames. (check-in: a9fcb46bc0 user: drh tags: trunk) | |
| 14:33 | Add #ifdef SQLITE_ENABLE_ZIPVFS around those bits of code that are only used by ZIPVFS. (check-in: 3130275c64 user: drh tags: trunk) | |
| 00:03 | If the SQLITE_FCNTL_PRAGMA file control returns something other than SQLITE_NOTFOUND, then skip the rest of Pragma code generation. (check-in: 9e6d340f55 user: drh tags: trunk) | |
| 00:02 | A simple change that allows the SQLITE_32BIT_ROWID compile-time option to work better. (check-in: f9df4063fb user: drh tags: trunk) | |
|
2012-02-23
| ||
| 17:35 | Fix an obscure bug that causes a crash when parsing certain invalid SQL statements. (check-in: c8c7846fb9 user: drh tags: trunk) | |
| 16:45 | Fix a typo made inside an assert() statement in the previous commit. (check-in: f0640615f2 user: dan tags: trunk) | |
| 15:35 | Add the sqlite3PagerWalFramesize() function to pager.c. This is used by zipvfs. (check-in: 786e24dc56 user: dan tags: trunk) | |
| 14:28 | Expose the sqlite3_stricmp() interface. Add the SQLITE_FCNTL_PRAGMA file control. (check-in: c539cf21ef user: drh tags: trunk) | |
|
2012-02-22
| ||
| 20:08 | Move test logic for SQLITE_FCNTL_PRAGMA out of os_unix.c and into test_vfs.c. (Closed-Leaf check-in: c81fc40b2b user: drh tags: file-control-pragma) | |
| 19:56 | If the SQLITE_FCNTL_PRAGMA file-control returns anything other than SQLTIE_NOTFOUND and SQLITE_OK, then treat the result as an error. (check-in: 5643618108 user: drh tags: file-control-pragma) | |
| 19:03 | Disable the "filename" pragma implemented by os_unix.c except when compiled with SQLITE_TEST. (check-in: 9a1da91850 user: drh tags: file-control-pragma) | |
| 18:21 | Make benign any malloc failures inside the sqlite3_file_control() call within PRAGMA parsing. Add a couple simple tests for SQLITE_FCNTL_PRAGMA. (check-in: a1f29fa653 user: drh tags: file-control-pragma) | |
| 16:58 | Change the SQLITE_FCNTL_PRAGMA file-control so that it can return a string value. (check-in: fd8d744027 user: drh tags: file-control-pragma) | |
| 14:45 | Begin adding support for SQLITE_FCNTL_PRAGMA. (check-in: 5be07904ba user: drh tags: file-control-pragma) | |
|
2012-02-21
| ||
| 18:35 | Avoid redefining NDEBUG if the fuzzer is included in an amalagmated source file. (check-in: f8ac826f95 user: drh tags: trunk) | |
| 18:00 | Prevent the fuzzer from ever returning a string longer than 100 bytes. (check-in: 969095ca30 user: dan tags: trunk) | |
| 14:11 | Further fuzzer test cases. Fix a case in the fuzzer where an error code was being dropped. (check-in: 8b77d3953f user: dan tags: trunk) | |
| 10:36 | Add further test cases and minor fixes for the fuzzer. (check-in: 583dde93a9 user: dan tags: trunk) | |
|
2012-02-20
| ||
| 22:44 | Updates to the instructions in the header comment of the fuzzer implementation. New test cases for the fuzzer. (check-in: bf1dc7907c user: drh tags: trunk) | |
| 20:03 | Change the way the fuzzer (test_fuzzer.c) works so that it loads its configuration from a database table. (check-in: 90b7b957f8 user: dan tags: trunk) | |
| 19:36 | Fix a case in test_fuzzer.c causing transformations from the wrong ruleset to be applied in some cases. (check-in: cb5f5ebc56 user: dan tags: trunk) | |
|
2012-02-14
| ||
| 18:56 | Increase the maximum ruleset id in the fuzzer from 50 to 2^31-1. (check-in: 760e009adc user: drh tags: trunk) | |
| 15:34 | Enhance the fuzzer virtual table to support multiple rule sets. (check-in: a82938731b user: drh tags: trunk) | |
|
2012-02-13
| ||
| 21:24 | Merge the non-blocking ROLLBACK changes into trunk. (check-in: 9c572d424a user: drh tags: trunk) | |
| 20:28 | Fix a harmless compiler warning introduced by the previous check-in. (check-in: a8a042a751 user: drh tags: trunk) | |
| 20:16 | On unix, ignore the umask when creating journal files. That way, journal files will have exactly the same permissions as the original database and any process that has permission to write to the database can also recover hot journals. (check-in: 84b324606a user: drh tags: trunk) | |
| 17:01 | Add the new SQLITE_ABORT_ROLLBACK extended error code to be returned for statements that are cancelled due to a rollback. (Closed-Leaf check-in: 549f4fd00d user: drh tags: nonblocking-rollback) | |
| 16:43 | Change the ROLLBACK command so that pending statements to not block it. The pending statements instead return SQLITE_ABORT upon next access. Note: This causes separate shared-cache connections in read_uncommitted mode to abort as well. (check-in: 9b66c79e05 user: drh tags: nonblocking-rollback) | |
| 13:44 | Generalize the interrupt mechanism so that individual statements can be interrupted and so that codes other than just SQLITE_INTERRUPT can be returned as a consequence of an interrupt. (Closed-Leaf check-in: 922bcbb423 user: drh tags: generalize-interrupt) | |
| 10:00 | Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: 76bb649ee2 user: dan tags: trunk) | |
| 08:50 | Fix a typo in the type of the fchown() function in os_unix.c. (check-in: bfbfe05b81 user: dan tags: trunk) | |
|
2012-02-11
| ||
| 23:55 | Make fchown() an overrideable system call in os_unix.c. (check-in: 98efac9630 user: drh tags: trunk) | |
| 22:19 | Cleanup some directories and files left by the MinGW build, even when using the MSVC Makefile. (check-in: 3ab89e255d user: mistachkin tags: trunk) | |
| 21:56 | Revise the preprocessor directives used to handle malloc.h and _msize, in order to detect and handle the MSVC special-case automatically. (check-in: 90e73dc368 user: mistachkin tags: trunk) | |
| 21:21 | Silence GCC compiler warnings about unused return value from fchown(). (check-in: b022547389 user: drh tags: trunk) | |
| 19:53 | Another attempt to fix warnings in the randomFunc() function. (check-in: 768df4e116 user: drh tags: trunk) | |
| 19:23 | When creating journal files (including -wal and -shm files) try to set the ownership to be the same as the original database. This will prevent root from locking out the original owner of the file. (check-in: 1254dffe40 user: drh tags: trunk) | |
| 18:51 | Remove a redundant test from the shared-memory logic in os_unix.c. (check-in: 31142ca795 user: drh tags: trunk) | |
|
2012-02-10
| ||
| 20:43 | Fix a warning coming from the Solaris Studio compiler. (check-in: 33294bbd17 user: drh tags: trunk) | |
| 18:18 | Pull the latest trunk changes into the apple-osx branch. (check-in: e248598649 user: drh tags: apple-osx) | |
| 17:54 | Pull all the latest trunk changes into the sessions branch. (check-in: 361fb66a79 user: drh tags: sessions) | |
| 17:38 | Disable the ability to have multiple values in the VALUES clause of an INSERT statement when SQLITE_OMIT_COMPOUND_SELECT is used. (check-in: 92131195d0 user: drh tags: trunk) | |
| 03:10 | Fix an important bug in the handling of EINTR in unixRead(). Never came up on x86 but crashes on sparc. (check-in: 1a16db0bca user: drh tags: trunk) | |
| 01:25 | Fix a boundary case for the integer affinity routine for non-x86 processors. (check-in: bea05ddddf user: drh tags: trunk) | |
|
2012-02-08
| ||
| 12:13 | Add an autoconf test for malloc.h and use the results of that test to conditionally #include the malloc.h header file. (check-in: 16a471129d user: drh tags: trunk) | |
|
2012-02-07
| ||
| 14:13 | Command-line shell enhancements: Reorganize the "usage" comment so that options are in alphabetical order. Add the new "--cmd" option. Allow either "--option" or "-option" for options. (check-in: 9497893b1b user: drh tags: trunk) | |
|
2012-02-02
| ||
| 21:02 | More structure packing for smaller objects and less memory usage. (check-in: f14e7f29ff user: drh tags: trunk) | |
| 19:37 | Reduce the size of the MemPage object by about 32 bytes. Other structure size optimizations. (check-in: 21695c3476 user: drh tags: trunk) | |
| 18:46 | When non-aggregate columns occur in an aggregate query with a single min() or max(), then the values of the non-aggregate columns are taken from one of the rows that was the min() or max(). (check-in: fa13edd39c user: drh tags: trunk) | |
| 18:42 | Fix a problem with NULL handling in aggregate min/max when returning values from the row containing the min or max. (Closed-Leaf check-in: f27c7b4fb1 user: drh tags: output-minmax-row) | |
| 17:35 | For queries of the form "SELECT p, max(q) FROM t1", the value of column p returned is the one on the same row that holds the maximum value of q. (check-in: adb29232b6 user: drh tags: output-minmax-row) | |
| 15:50 | Data structure cleanup. Remove unused fields. Rearrange other files for tighter packing and reduced memory usage. (check-in: 0bc594e861 user: drh tags: trunk) | |
| 03:38 | Simplified array allocation in the IdList and AggInfo objects. (check-in: 25df2a7458 user: drh tags: trunk) | |
| 03:11 | Fix a possible segfault after an OOM fault. This has been in the code for ages but only expressed itself following the previous check-in. (check-in: a3553b8a03 user: drh tags: trunk) | |
| 01:58 | Remove the nAlloc field from the ExprList object. (check-in: 5963de303a user: drh tags: trunk) | |
|
2012-02-01
| ||
| 19:03 | Very small performance enhancement and reduction in size of the sqlite3_stmt object. (check-in: a38d57a4e5 user: drh tags: trunk) | |
| 01:13 | Fix ALTER TABLE RENAME so that it correctly handles triggers that attach to the table using the name in a different case. Ticket [ae6794effd404]. (check-in: 0d78ebb8e4 user: drh tags: trunk) | |
|
2012-01-31
| ||
| 23:34 | Fix a compiler warning in FTS4. (check-in: b4cad1ce78 user: drh tags: trunk) | |
| 14:24 | Futher pedantic fixes to the sqlite3_uri_boolean() interface. (check-in: 77b3430de6 user: drh tags: trunk) | |
| 13:35 | Improvements to the documentation for sqlite3_uri_boolean(). (check-in: b0a161791d user: drh tags: trunk) | |
| 05:11 | Change a comment in test script backup.test. (check-in: 313546b456 user: dan tags: trunk) | |
|
2012-01-30
| ||
| 18:40 | Bring the documentation and implementation of sqlite3_uri_boolean() into closer agreement. Ticket [5f41597f7c9c] (check-in: 7b053d699f user: drh tags: trunk) | |
| 18:00 | Fix compiler warnings in the TCL test harness. (check-in: c4cd38a0c7 user: drh tags: trunk) | |
| 16:02 | Do not rely on the _WIN32_WINNT macro as vs2005 does not define it by default. Instead, always assume winNT unless the makefile explicitly sets SQLITE_OS_WINNT=0. (check-in: 1ce4d21d52 user: drh tags: trunk) | |
|
2012-01-28
| ||
| 21:08 | Update the .dump command of the command-line shell so that it (1) avoids putting the semicolon of a DDL statement on the same line as a comment, (2) avoids long expression, even when dumping a table with many columns, and (3) avoids unnecessary quoting of the table name. This fixes tickets [c04a8b8a4f] and [232637c465]. Shell change only; no changes to the SQLite core. (check-in: e6eea8d50d user: drh tags: trunk) | |
| 19:44 | Remove a couple of unnecessary nonterminals from the grammar. (check-in: 2b2a7d8d73 user: drh tags: trunk) | |
| 19:41 | Add support for IF NOT EXISTS on CREATE VIRTUAL TABLE. (check-in: 230983e86a user: drh tags: trunk) | |
| 15:26 | Update the version number to 3.7.11 and rerun autoconf. (check-in: 6f9b265dd0 user: drh tags: trunk) | |
| 15:22 | Add support for multiple rows of VALUES in an INSERT statement. (check-in: eb3b6a0ceb user: drh tags: trunk) | |
|
2012-01-25
| ||
| 20:43 | Only invalidate the schema when the OP_ParseSchema opcode fails, not on any general failure of a vdbe program. (check-in: 11f68d997d user: drh tags: trunk) | |
| 16:29 | Fix an FTS problem triggered by querying for an N character prefix using an N+1 character prefix index after rows have been deleted from the FTS table. Fix for [edb497982c]. (check-in: c05c3fd20d user: dan tags: trunk) | |
|
2012-01-24
| ||
| 10:08 | Changes to the async-io module so that the xFileControl method returns SQLITE_NOTFOUND when a file-control is not recognized and so that it adds the second nul-terminator byte to filenames passed to the xOpen method of the underlying VFS. (check-in: 7036886e83 user: dan tags: trunk) | |
|
2012-01-19
| ||
| 16:57 | Make the use and function of SQLITE_DYNAMIC clearer. Add assert() statement to help ensure that SQLITE_DYNAMIC is not misused. (check-in: ab80f2c3b2 user: drh tags: trunk) | |
|
2012-01-18
| ||
| 18:22 | Avoid overriding the malloc_usable_size symbol using the C preprocessor as this might be confusing the build on some systems. (check-in: bbaec351dd user: drh tags: trunk) | |
| 12:46 | Add the SQLITE_WITHOUT_MSIZE and SQLITE_WITHOUT_ZONEMALLOC macros in mem1.c to disable the use of _msize() on windows and the zone memory allocator on Apple products, respectively. (check-in: 238e35a441 user: drh tags: trunk) | |
| 01:14 | Remove a redundant assignment from the VM. (check-in: d0dabe2f37 user: drh tags: trunk) | |
| 01:09 | Fix typo in comment. (check-in: 199edb6869 user: mistachkin tags: trunk) | |
|
2012-01-17
| ||
| 15:29 | Remove the undocumented PRAGMA omit_readlock hack. (check-in: 96900c47e4 user: drh tags: trunk) | |
|
2012-01-16
| ||
| 16:56 | Enhance the command-lin shell to interpret CSV files as described by the wikipedia article on CSV. (check-in: 93aa17d866 user: drh tags: trunk) | |
| 16:39 | Test the fts4 content and prefix options together. (check-in: de11cd5cc9 user: dan tags: trunk) | |
| 13:28 | Version 3.7.10 (check-in: ebd01a8def user: drh tags: trunk, release, version-3.7.10) | |
| 13:00 | Rebuild the configure script using autoconf 2.68 since autoconf 2.65 (previously used) appears to build incorrect scripts for Mac. (check-in: 9da1cd0a06 user: drh tags: trunk) | |
| 12:33 | Support building with SQLITE_ENABLE_SESSION under MSVC. (check-in: 2845654d42 user: mistachkin tags: sessions) | |
|
2012-01-14
| ||
| 14:13 | Merge the latest trunk changes into the apple-osx branch. (check-in: 2cc414cd14 user: drh tags: apple-osx) | |
| 13:50 | Update sessions branch with latest changes from trunk. (check-in: 01c84fd391 user: dan tags: sessions) | |
| 03:34 | Make sure the EXTERN macro is properly defined when building targets that require it (e.g. on MinGW). (check-in: 88ad2f23c5 user: mistachkin tags: trunk) | |
| 00:42 | In the multiplexor routine that determines the size of an overflow file, return 0 and leave the error code unchanges if there were prior errors. This prevents some I/O errors from going unreported in nx-devkit tests. (check-in: 6da0821a47 user: drh tags: trunk) | |
|
2012-01-13
| ||
| 16:48 | Fix documentation typos. No changes to code. (check-in: 0b857613e2 user: drh tags: trunk) | |
| 16:16 | Add the -uri option to the usage comment that is printed by the "sqlite3" TCL command when an unknown command-line option is supplied. (check-in: 7987e28578 user: drh tags: trunk) | |
| 15:50 | Update the documentation for the sqlite3_uri_*() routines to make it clear that there argument must be a database filename passed into xOpen(). No changes to code. (check-in: 08230a3a8c user: drh tags: trunk) | |
| 15:21 | Fix backup2.test so that it passes on OpenBSD (which produces a slightly different error message in one case). (check-in: 227cfe11c4 user: dan tags: trunk) | |
| 14:50 | Do not throw an error from within test_journal.c if a database file size is not an integer multiple of the page-size. (check-in: 3f4899a923 user: dan tags: trunk) | |
| 10:51 | Omit test file zerodamage.test from the inmemory_journal permutation. (check-in: 0c0051b1a5 user: dan tags: trunk) | |
| 10:04 | Fix test case issues related to errors in file-controls and the PSOW flag. (check-in: 5afbcd49f9 user: dan tags: trunk) | |
|
2012-01-12
| ||
| 16:41 | Fix issues in test cases so that they work with DEFAULT_AUTOVACUUM defined. And with a small default cache-size. (check-in: a298465c39 user: dan tags: trunk) | |
| 15:05 | Fix typos in a testcase() macro introduced by the previous commit. (check-in: 0467742fd6 user: dan tags: trunk) | |
| 14:25 | Remove some assert() statements that can fail with corrupt databases. (check-in: 7654ae71bd user: dan tags: trunk) | |
|
2012-01-11
| ||
| 16:16 | Remove code made unreachable by the enhancement of the previous check-in. (check-in: 9e31a275ef user: drh tags: trunk) | |
| 15:47 | Make the pager less vulnerable to problems caused by shifting sector sizes when rolling back a hot journal. (check-in: 629108c8e5 user: drh tags: trunk) | |
| 11:20 | Fix the sqlite3_quota_file() function in test_quota.c so that it adds the second nul-terminator to all file names that will be passed to a VFS xOpen method. (check-in: 3013f9a67c user: dan tags: trunk) | |
| 01:01 | Prevent winOpenSharedMemory from masking the real return code from its call to winOpen. Also, add asserts to check the double-zero termination of database file names. (check-in: 93a65776dc user: mistachkin tags: trunk) | |
| 00:38 | Make sure filenames handed to the VFS by the fake_big_file test procedure are double-zero terminated. (check-in: d0a868607e user: drh tags: trunk) | |
|
2012-01-10
| ||
| 23:18 | Only require double-zero terminators on database filenames, not any every files supplied to the xOpen method. This backs out [2544f233f1]. Also refactor the fillInUnixFile() routine in os_unix.c to reduce the number of parameters. (check-in: cb774b26e1 user: drh tags: trunk) | |
| 17:59 | Refactor sqlite3OsFileControlNoFail() into sqlite3FileControlHint(). (check-in: 722735a4f3 user: drh tags: trunk) | |
| 17:28 | Avoid passing strings with a single nul-terminator (two are required) to the VFS xOpen() method from within the code that checks to see if a master-journal file may be safely deleted. (check-in: 2544f233f1 user: dan tags: trunk) | |
| 16:56 | Add function sqlite3OsFileControlNoFail(), which is the same as sqlite3OsFileControl() except that it does not simulate OOM errors. This saves adding calls to the BenignMalloc() functions around each of the invocations of sqliteOsFileControl() that ignore the return code. (check-in: af59b182d7 user: dan tags: trunk) | |
| 16:40 | Check the return code from sqlite3OsFileControl() in sqlite3BtreeCopyFile() and report any errors that it generates. (check-in: 7f852ac643 user: drh tags: trunk) | |
| 00:24 | Remove the BenignMalloc() from around the call to FCNTL_OVERWRITE. Add new ones around sqlite3OsDelete(). Fix an assert that causes problems for the nx-devkit. (check-in: 38bc4236d5 user: drh tags: trunk) | |
|
2012-01-09
| ||
| 14:19 | Cosmetic changes to lemon. No changes to core functionality nor impact on SQLite. (check-in: 393fc78a18 user: drh tags: trunk) | |
| 13:41 | Make sure the multiplexor does not create unnecessary overflow files. (check-in: 1238619756 user: drh tags: trunk) | |
| 11:37 | Have test_multiplex.c add a second nul-terminator byte to the strings that it passes to the xOpen method of the underlying VFS, in case that VFS passes the string to sqlite3_uri_parameter() or similar. (check-in: 12f5b8c9c9 user: dan tags: trunk) | |
|
2012-01-08
| ||
| 22:18 | Fix typos in commands. Combine the ExpandBlob and expandBlob macros into one. (check-in: fc9179e154 user: drh tags: trunk) | |
| 12:32 | Make sure the shared-memory filename sythesized by os_win.c is double-zero terminated, so that it can be used with sqlite3_uri_parameter(). (check-in: 429380f99c user: drh tags: trunk) | |
| 00:54 | Fix harmless compiler warning seen with MSVC. (check-in: 9612bcd648 user: mistachkin tags: trunk) | |
|
2012-01-07
| ||
| 15:17 | Fix a bug in lemon in computation of which non-terminals can generate an empty string. This bug and the fix make absolutely no difference for the grammar used by SQLite, but it can make a difference when lemon is used in other grammars. (check-in: ce32775b23 user: drh tags: trunk) | |
|
2012-01-06
| ||
| 13:58 | Add missing finish_test to the end of the zerodamage.test module. Disable the zerodamage module if virtual tables are omitted from the build. (check-in: d2a5685b5e user: drh tags: trunk) | |
|
2012-01-05
| ||
| 23:32 | Combine various boolean variables in the BtShared structure into a single boolean vector. Also make performance improvement simplifications to sqlite3BtreeMovetoUnpacked(). (check-in: 119493318e user: drh tags: trunk) | |
| 21:19 | Make sure the name of the shared memory file has two zero-terminators in the UNIX VFS, so that sqlite3_uri_parameter() will work correctly on that name. (check-in: 3d088ba5e3 user: drh tags: trunk) | |
| 18:33 | Fix an incorrect assert() on the sqlite3FileSuffix3() function. (check-in: 24db54bd49 user: drh tags: trunk) | |
| 16:07 | Change the unix VFS so that it ignores all but the least-significant bit of the syncDir flag to xDelete. Add an assert to prove that the core only ever uses that one bit. (check-in: e75fd3b274 user: drh tags: trunk) | |
| 13:02 | Merge all of the latest trunk changes into the sessions branch. (check-in: a9bcb432f5 user: drh tags: sessions) | |
| 12:38 | Ensure 8-byte alignment of Index.aiRowEst elements even if the size of an Index object is not a multiple of 8 bytes. (check-in: 1378f905d3 user: drh tags: trunk) | |
| 11:43 | Remove the SQLITE_FCNTL_SYNC_OMITTED cases from the unix and windows VFSes as they are no longer needed because of check-in [fd3822f1f2]. (check-in: 7cf568a101 user: drh tags: trunk) | |
|
2012-01-04
| ||
| 12:57 | Fix typos and comments and make minor changes to a few function names, as suggested by readership. (check-in: e9d05cbb76 user: drh tags: trunk) | |
|
2012-01-03
| ||
| 21:54 | Pull all the latest trunk changes over into the apple-osx branch. (check-in: 8a048423f0 user: drh tags: apple-osx) | |
| 21:33 | Experimental changes to prevent buffer overreads when parsing a corrupt database file. (Closed-Leaf check-in: 9e5add51ee user: drh tags: no-overread) | |
| 14:50 | Make sure filenames passed into sqlite3OsOpen() always have the extra zero-terminators needed by sqlite3_uri_parameter(). (check-in: d73e93cfdc user: drh tags: trunk) | |
|
2012-01-02
| ||
| 18:20 | Remove the code that attempts to find the sector size from the OS and hardcode the xSectorSize methods of the unix and windows VFSes to return SQLITE_DEFAULT_SECTOR_SIZE, which is now set to 4096 unless overridden. (check-in: 03d8362cd2 user: drh tags: trunk) | |
| 18:00 | Change page quantities in pcache1.c to unsigned. (check-in: da52e6e8b4 user: drh tags: trunk) | |
| 16:38 | Remove an incorrect assert() in btree.c. (check-in: c1691d998a user: drh tags: trunk) | |
| 15:45 | Make sure large negative arguments to PRAGMA cache_size do not cause 32-bit signed integer overflow. Also correct a requirements mark. (check-in: 17c30634a7 user: drh tags: trunk) | |
| 14:50 | Have SQLITE_FCNTL_SYNC_OMITTED use the normal method of returning an error code. (check-in: fd3822f1f2 user: dan tags: trunk) | |
| 12:41 | Fix the build so that it works when SQLITE_ENABLE_8_3_NAMES=1. (check-in: d9761f15a1 user: drh tags: trunk) | |
|
2012-01-01
| ||
| 13:58 | Tweaks to improve testability. (check-in: e3a929e431 user: drh tags: trunk) | |
|
2011-12-31
| ||
| 21:51 | Fix typos in comments. No changes to code. (check-in: 6827338ecb user: drh tags: trunk) | |
| 10:18 | Add calls to the BenignMalloc() functions around the SQLITE_FCNTL_OVERWRITE call in backup.c. (check-in: 3e0833dbb7 user: dan tags: trunk) | |
|
2011-12-30
| ||
| 18:16 | Add calls to the BenignMalloc() functions around the SQLITE_FCNTL_SIZE_HINT call in pager.c. (check-in: c17a3f5e5d user: dan tags: trunk) | |
| 16:16 | Fix a typo in the documentation for PCACHE2. No changes to code. (check-in: 46e7903ab9 user: drh tags: trunk) | |
| 16:09 | Change dbstatus.test to account for the fact that the value reported by DBSTATUS_SCHEMA_USED may be slightly lower than the actual memory used on osx (check-in: 6f2010c862 user: dan tags: trunk) | |
| 16:07 | Fix up requirements marks for syntax diagrams to reflect the new and improved GIF renderings. (check-in: 1bb23a3b52 user: drh tags: trunk) | |
| 15:17 | Update the text of requirements associated with sqlite3_pcache_methods2. Update requirements marks embedded in code. All of the above are comment changes only; there are no changes to code in this check-in. (check-in: f945c41a72 user: drh tags: trunk) | |
| 11:43 | Hold the database handle mutex for the duration of sqlite3_db_release_memory(). (check-in: eeaf298800 user: dan tags: trunk) | |
| 10:54 | Minor changes to fix compilation with SQLITE_OMIT_WAL and SQLITE_OMIT_WSD defined. (check-in: 26a513a8d2 user: dan tags: trunk) | |
| 09:00 | Change an implicit i64-to-int cast in pager.c to an explicit cast. (check-in: 6a71ba9ce9 user: dan tags: trunk) | |
| 05:08 | Fix some typos in comments. No code changes. (check-in: 4edc5994b2 user: dan tags: trunk) | |
|
2011-12-23
| ||
| 20:49 | Documentation updates. No changes to code. (check-in: a8a1a639fe user: drh tags: trunk) | |
| 13:32 | Avoid excess syncs when padding a transaction in a WAL. (check-in: 1f24ae716d user: drh tags: trunk) | |
| 02:07 | Merge the POWERSAFE_OVERWRITE features and the use of statvfs() from the statvfs branch into trunk. (check-in: 2370d70eb5 user: drh tags: trunk) | |
| 01:04 | Change the name ZERO_DAMAGE to the more descriptive POWERSAFE_OVERWRITE. The query parameter used to control this device characteristic is now "psow". (Closed-Leaf check-in: 6191c5e451 user: drh tags: statvfs) | |
| 00:25 | Merge the latest trunk changes into the statvfs branch. (check-in: d5e36327c1 user: drh tags: statvfs) | |
| 00:07 | Add interfaces sqlite3_uri_boolean() and sqlite3_uri_int64() which are wrappers around sqlite3_uri_parameter() combined with internal routines for converting strings to booleans and 64-bit integers. (check-in: 83d26b9a91 user: drh tags: trunk) | |
|
2011-12-22
| ||
| 17:31 | Fix minor issues with FTS and RTREE discovered by coverity. (check-in: 1c27d84216 user: drh tags: trunk) | |
| 17:10 | Check the return code from sqlite3_initialize() called from within sqlite3_soft_heap_limit64() and return an error from sqlite3_soft_heap_limit64() if sqlite3_initialize() fails. (check-in: 676acce274 user: drh tags: trunk) | |
| 15:30 | Fix a problem in fts3_write.c causing stack memory to be referenced after it is out of scope. (check-in: f9c4a7c8f4 user: dan tags: trunk) | |
| 02:10 | Merge recent trunk changes into the statvfs branch. (check-in: 995ec8a41a user: drh tags: statvfs) | |
| 01:46 | Remove a redundant assignment operator. (check-in: 19a6852a1e user: drh tags: statvfs) | |
|
2011-12-21
| ||
| 18:04 | Fix other problems where 32-bit integer overflow may cause a problem. Two that require an improbably large sub-journal and two in test harness code. Ticket [ac0ff496b7e2] (check-in: c723e3e18a user: dan tags: trunk) | |
| 17:00 | Avoid 32-bit overflow when calculating the byte offset of an overflow page in SQLITE_DIRECT_OVERFLOW_READ code. Fix for [ac0ff496b7]. (check-in: c5256b59ad user: dan tags: trunk) | |
| 14:42 | Add the ability to enable or disable SQLITE_IOCAP_ZERO_DAMAGE using a URI parameter for both unix and windows. Add a file-control to query or disable the ZERO_DAMAGE setting. Add the -uri option to the "sqlite3" TCL command in tclsqlite3.c. Allow the sqlite3_uri_parameter() interface to accept a NULL pointer for its first parameter. (check-in: c83627b732 user: drh tags: statvfs) | |
|
2011-12-20
| ||
| 22:18 | Remove the code that tries to detect OOO header writes on a WAL recovery. The code is made obsolete by syncing the WAL header. (check-in: 7ac713a14e user: drh tags: statvfs) | |
| 20:13 | Refactor the sqlite3WalFrames() routine for clarity of presentation. Do the padded transaction sync as the write pointer crosses the final sector boundary instead of at the end, for efficiency. Always sync the WAL header immediately after it is written. (check-in: 92c73b421b user: drh tags: statvfs) | |
| 13:13 | Assert that the isCommit parameter to sqlite3WalFrames() is zero if and only if the nTruncate parameter is zero. (check-in: 979daf92e0 user: drh tags: trunk) | |
|
2011-12-19
| ||
| 15:46 | Add test for WAL mode to unixexcl.test. (check-in: 4d518bd480 user: dan tags: trunk) | |
| 11:57 | Merge [21b76af6ed] into statvfs branch. (check-in: e694f7b166 user: dan tags: statvfs) | |
| 11:16 | Fix a couple of test cases to account for the master-journal name related change in [cf3bccc2]. (check-in: 21b76af6ed user: dan tags: trunk) | |
| 10:07 | Modify test cases to account for the ZERO_DAMAGE change. (check-in: 68684495f1 user: dan tags: statvfs) | |
| 00:31 | Some fixes to the test suite so that it works with ZERO_DAMAGE set to true. Still lots more problems remain. (check-in: 41891b231e user: drh tags: statvfs) | |
|
2011-12-17
| ||
| 20:02 | For improved clarity of presentation, refactor some of the code associated with ZERO_DAMAGE and sector-size. (check-in: 1dde96c9ee user: drh tags: statvfs) | |
| 19:49 | Add SQLITE_IOCAP_ZERO_DAMAGE and enable it for both unix and windows. Use this device characteristic to reduce the required work in journaling. A side effect is that this changes the default page exists back to 1024 even with the use of statvfs(). (check-in: a0be6ea464 user: drh tags: statvfs) | |
| 16:25 | Fix a bad #endif with the previous check-in on this branch. (check-in: 915713ffe4 user: drh tags: statvfs) | |
| 16:09 | Add support for statvfs() in os_unix.c, for determining the sector size. This causes many TCL test failures under Linux. (check-in: e0d44450b9 user: drh tags: statvfs) | |
| 13:45 | Merge in changes that cause the first sector of the WAL file to be synced when the WAL restarts. This is a fix for the power-loss corruption problem described in ticket [ff5be73dee086] (check-in: 44ca4d1233 user: drh tags: trunk) | |
| 08:10 | Add tests to walcrash3.test. (check-in: d768804280 user: dan tags: trunk) | |
| 01:31 | Make sure the Salt-1 value in the WAL file is sequentially numbered at each checkpoint, as it says it should be in the documentation. (check-in: 7b63b11b93 user: drh tags: trunk) | |
|
2011-12-16
| ||
| 21:26 | Enhance the WAL header sync so that it honors the various synchronous pragmas, settings, and device characteristics. (Closed-Leaf check-in: 9799241f7d user: drh tags: wal-header-sync) | |
| 19:34 | Proposed changes that ensure that the WAL header is written prior to the first commit mark. (check-in: 91d0437c07 user: drh tags: wal-header-sync) | |
| 17:01 | Add code for a test that was failing before the persistent-wal related changes of [09ccc4a1be]. (check-in: 49d21ce50f user: dan tags: trunk) | |
| 15:38 | Merge the fix for [a1fa75cbdd02] from the experimental branch. Also fix the persistent-wal mode feature of truncating the WAL on close so that it always truncates the WAL to zero bytes. (check-in: 09ccc4a1be user: drh tags: trunk) | |
| 15:11 | Improved logging of master-journal name conflicts. (check-in: b1005ef46c user: drh tags: trunk) | |
| 13:42 | Merge the nx-devkit changes into trunk. (check-in: cf3bccc2e9 user: drh tags: trunk) | |
| 13:24 | Experimental fix for [a1fa75cbdd]. (Closed-Leaf check-in: 6492af76ea user: dan tags: experimental) | |
|
2011-12-15
| ||
| 17:44 | Add stdio support to the quota VFS. (check-in: 322bd15f97 user: drh tags: trunk) | |
|
2011-12-14
| ||
| 18:33 | Merge the nx-devkit changes into trunk. This includes the new SQLITE_FCNTL_VFSNAME file-control. (check-in: da118e02c0 user: drh tags: trunk) | |
| 00:37 | Treat a zero return value from the Win32 APIs MultiByteToWideChar and WideCharToMultiByte as an error condition. (check-in: c65e5a36f1 user: mistachkin tags: trunk) | |
|
2011-12-13
| ||
| 15:37 | Merge the nx-devkit changes into trunk. (check-in: 03a70c3dae user: drh tags: trunk) | |
| 12:10 | This branch merged with nx-devkit and from there into trunk. Was: In the multiplexor, instead of generating a unique file-name when SQLite opens a temp file, allow the underlying VFS to generate a different temp file for each chunk. Given the changes to the xFileSize method, it is no longer necessary for the different chunks of a temp file to use the same base name. (Closed-Leaf check-in: 199f52bced user: dan tags: experimental) | |
| 11:15 | Change the way IO errors are handled in the xFileSize method of the multiplexor VFS. Add test file multiplex3.test. (check-in: 255d21499b user: dan tags: experimental) | |
|
2011-12-12
| ||
| 19:48 | Fix os_unix.c so that, unless 8.3 filenames are actually in use, journal and wal file permissions are assigned correctly even if SQLITE_ENABLE_8_3_NAMES is defined. (check-in: 169e12295c user: dan tags: trunk) | |
| 18:55 | Change the multiplexor VFS so that xTruncate is a no-op on database files. (check-in: ee1e012256 user: dan tags: trunk) | |
| 18:21 | Fix for the xFileSize method of test_multiplex.c when used on a file opened with the DELETEONCLOSE flag set. (check-in: 713071c493 user: dan tags: trunk) | |
| 16:51 | Add magic comments to shell.c to make it easier for scripts to insert additional version information displays for custom builds. (check-in: 9b2691aa91 user: drh tags: trunk) | |
|
2011-12-11
| ||
| 22:44 | In the multiplexor shim, when using 8+3 filenames, begin numbering journal overflow files with 101 instead of 001 to avoid name collisions with the main database file. (check-in: 05bf8a0b17 user: drh tags: trunk) | |
| 21:51 | Update comments describing the flattening optimization in select.c. (check-in: dab4c137a8 user: drh tags: trunk) | |
| 02:30 | Fix STAT3 so that it works with the new uninitialized register logic of the VDBE. Ticket [7bbfb7d4422ff] (check-in: d11a57985c user: drh tags: trunk) | |
| 02:29 | Fix harmless compiler warnings. (check-in: 1e6a698aab user: drh tags: trunk) | |
|
2011-12-10
| ||
| 23:18 | Minor cleanups of the compound-subquery flattening logic. New test cases added for joins the compound subquery. (check-in: 5061d85ff9 user: drh tags: trunk) | |
| 17:17 | Allow UNION ALL compounds to be promoted up to replace a simple wrapper SELECT even if the compounds are joins. (check-in: 3d4b4f4fb7 user: drh tags: trunk) | |
| 15:55 | Import the experimental parse-tree explainer, with fixes, from the tree-explain branch. Disabled by default. Use SQLITE_ENABLE_TREE_EXPLAIN to turn it on. (check-in: bcbc7152d4 user: drh tags: trunk) | |
| 14:44 | Merge the latest trunk changes into tree-explain branch. (Closed-Leaf check-in: 1a360da0f8 user: drh tags: tree-explain) | |
| 13:49 | Always use _msize() to get memory allocation sizes on windows, without having to do anything special in the makefile. (check-in: 256e27bd11 user: drh tags: trunk) | |
|
2011-12-09
| ||
| 18:06 | Change the VDBE so that all registers are initialized to "Invalid" instead of NULL and report errors on any attempted read of an Invalid register. This will help prevent future bugs similar to [7bbfb7d442]. (check-in: 0064bab771 user: drh tags: trunk) | |
| 17:51 | Remove an unnecessary condition. (Closed-Leaf check-in: d9ba023c60 user: drh tags: uninit-vdbe-mem) | |
| 17:38 | Remove an unnecessary initialization of Vdbe.aOnceFlag. (check-in: 421714dad3 user: drh tags: uninit-vdbe-mem) | |
| 17:27 | Take out the OP_JumpOnce opcode. Revert compound SELECT to use OP_IfNot, which is the correct behavior. Mark trigger registers as initially invalid. (check-in: 6a9fb47d50 user: drh tags: uninit-vdbe-mem) | |
| 16:59 | Previous check-in broke auto-increment. This check-in appears to fix it. (check-in: 28ffd39c71 user: drh tags: uninit-vdbe-mem) | |
| 16:21 | Make no assumptions about the initial state of VDBE registers. (check-in: 521d72bdf6 user: drh tags: uninit-vdbe-mem) | |
| 13:24 | Modify the OP_Once opcode so that it works correctly in trigger sub-programs. This is a candidate fix for [7bbfb7d442]. (check-in: 557c69055a user: dan tags: trunk) | |