/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

117 check-ins using file src/expr.c version 06a7733d

2012-08-06
23:21
Backport VSIX packaging support and related changes. Closed-Leaf check-in: 0620285d user: mistachkin tags: vsix-3.7.13
2012-07-26
09:21
Update some comments in vdbesort.c. check-in: f4b3fded user: dan tags: sorter-coalesce-writes
2012-07-23
20:10
Fix an edge case in vdbesort.c. check-in: 4ba266fc 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: 55e47ef3 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: ed3dc7a8 user: mistachkin tags: threads
02:00
Enhance implementation of the Win32 thread wait function. check-in: 049b0411 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: 793195d3 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: 0e4d977a user: drh tags: threads
2012-07-19
20:27
Further tweaks to malloc paths. Closed-Leaf check-in: 0a334441 user: dan tags: calloc
2012-07-18
16:07
Remove another branch from the DbMalloc() paths. check-in: defd828e 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: 75c095ee 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: 8752237d 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: 65035912 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: e4163596 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: 8c9ee1d7 user: drh tags: trunk
2012-07-16
23:13
Merge the spellfix1 changes for supporting matchlen into trunk. check-in: 6f167adf 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: f96d4e7b 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: 6333b42d user: dan tags: spellfix-matchlen
10:25
Merge trunk changes. check-in: 90df64ab 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: 4353e40b user: dan tags: trunk
2012-07-13
19:26
Add the "matchlen" column to the spellfix1 virtual table. check-in: f24b9d87 user: dan tags: spellfix-matchlen
16:15
Update test_spellfix.c with latest changes. check-in: cba2a658 user: dan tags: trunk
11:09
Fix bug in spellfix1 xUpdate() method introduced by the previous commit. Closed-Leaf check-in: b31aafa5 user: dan tags: spellfix-matchlen
2012-07-12
19:43
Add the "matchlen" column to the spellfix virtual table. check-in: 4a582c4d user: dan tags: spellfix-matchlen
2012-06-30
22:22
Setup the necessary library paths for cross-compilation with MSVC. check-in: 7fac56ed user: mistachkin tags: trunk
19:24
Simplify usage of some linker options in the MSVC makefile. check-in: 03016020 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: 6c88229a user: mistachkin tags: trunk
2012-06-27
16:41
Another changes to the shell in support of SQLITE_OMIT_AUTOINIT. check-in: 3b4f5add user: drh tags: trunk
16:12
Update the shell so that it works with SQLITE_OMIT_FLOATING_POINT and SQLITE_OMIT_AUTOINIT. check-in: 95c0c995 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: d5e68802 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: fb8893ab 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: 4cebd607 user: drh tags: trunk
15:12
Fix spelling typo. check-in: 6131a000 user: mistachkin tags: trunk
15:09
Remove more references to OS/2. check-in: eebd594d user: mistachkin tags: trunk
15:02
Disable the atof1.test module when compiling on MSVC. Closed-Leaf check-in: 0f706acf user: drh tags: floating-point-conversions
14:31
Increase the version number to 3.7.14 and rerun autoconf check-in: 8c9f564a user: drh tags: trunk
14:25
Fix the SQLITE_ZERO_MALLOC compile-time option so that it works on windows. check-in: b80bc52f user: drh tags: trunk
14:05
Merge several compiler compatibility fixes to trunk. check-in: d3d491a5 user: mistachkin tags: trunk
13:00
Remove support for OS/2 from the source tree. check-in: ff828c67 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: f6be345a 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: bfb2d473 user: dan tags: trunk
04:36
Move variable declaration to fix compilation with MSVC. check-in: d45f7a01 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: 963eb24f 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: fd7bd4a5 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: 8ecffca9 user: drh tags: floating-point-conversions
00:45
Improved rounding accuracy on text-to-float conversions. check-in: 699b792c 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: 892b7411 user: dan tags: trunk
17:15
Allow the SQLITE_API macro to apply to the sqlite3_win32_sleep function. Closed-Leaf check-in: 21266c68 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: 87597e98 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: f970a3de 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: 0c2fb18d user: drh tags: trunk
2012-06-15
20:42
Fix compiler warning. Closed-Leaf check-in: 37d9bc06 user: mistachkin tags: deferred-close
2012-06-11
02:05
Version 3.7.13 check-in: f5b5a13f user: drh tags: trunk, release, version-3.7.13
2012-06-09
19:15
Merge latest trunk changes with sessions branch. check-in: 47f8f071 user: dan tags: sessions
18:52
Add missing targets for fts3_unicode.lo and fts3_unicode2.lo to Makefile.in. check-in: 0ae0ce63 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: 892d8779 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: 025227be 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: 006db555 user: dan tags: trunk
01:13
Merge trunk changes into the apple-osx branch. check-in: 9d1b8515 user: drh tags: apple-osx
2012-06-07
23:58
Merge all trunk changes, including the WinRT enhancements, into the sessions branch. check-in: c6214039 user: drh tags: sessions
17:57
Documentation and evidence mark updates. Remove a redundant assert(). check-in: cfcbf937 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: 7caca193 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: e56fb462 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: 506008f0 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: 208825cd user: drh tags: trunk
2012-06-06
23:59
Fix harmless Clang warnings. check-in: 31fe1985 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: baa8b783 user: mistachkin tags: trunk
23:23
Merge the changes need to compile on WinRT into trunk. check-in: 61360ca6 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: eccd6b65 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: 790f76a5 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: 635e3a76 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: c469850b 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: 42338e9e 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: 61669c95 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: 8e8590a4 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: eb29e2d9 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: c4b86211 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: e276a02b user: drh tags: deferred-close
2012-05-31
22:12
Update several APIs to enable compilation with newer revisions of WinRT. check-in: 54de739f user: mistachkin tags: winrt
13:10
Avoid calling fchown() if the process is not running as root. check-in: 70c419a4 user: drh tags: trunk
00:21
Only call fchown when running as root and supporting files mismatch the database owner & perms check-in: ed53b645 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: 07935d10 user: drh tags: trunk
17:59
Fix a typo (a repeated "or") in the documentation. No changes to code. check-in: 6fec6cf1 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: 8e302570 user: drh tags: trunk
00:48
Merge the 64-to-32-bit RTree rounding fixes from trunk into the sessions branch. check-in: 7eff45c2 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: 0abdc290 user: drh tags: trunk
00:30
Refactor the float-to-double rounding routines so that they compile without warnings. Closed-Leaf check-in: f607ad27 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: 48015814 user: drh tags: trunk
20:16
Simplification to the coordinate rounding logic in RTree. check-in: df24072d 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: f4e8ff03 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: df817e70 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: bcc72d41 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: b8720d04 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: 651520fa user: drh tags: trunk
12:22
Omit the fts3 unicode character class routines from the build if fts3/4 is disabled. check-in: c00bb5d4 user: drh tags: trunk
2012-05-27
22:42
Merge into trunk the changes that permit :memory: databases to use shared cache. check-in: e72179f3 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: 595dfdbf user: drh tags: shared-cache-memdb
00:11
Fix corner-case problems with shared-cache for in-memory databases. Closed-Leaf check-in: 997ef5f6 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: e3ad61e0 user: drh tags: shared-cache-memdb
18:42
Merge fts4-unicode branch with trunk. check-in: 25ba1f84 user: dan tags: trunk
18:28
If SQLITE_DISABLE_FTS3_UNICODE is defined, do not build the "unicode61" tokenizer. Closed-Leaf check-in: e71495a8 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: 4590e433 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: b89d3834 user: dan tags: fts4-unicode
16:22
Add coverage tests for fts3_unicode.c. check-in: 07d3ea8a 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: ed28c48a 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: 8f3e60aa 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: cf7b25d4 user: dan tags: fts4-unicode
18:48
Fix comments in generated file fts3_unicode2.c. check-in: 3dc567ef 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: 0c13570e 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: 1dd01e40 user: mistachkin tags: winrt
17:39
Merge the 3.7.12.1 trunk changes into the WinRT branch. check-in: b9ed0b26 user: drh tags: winrt
13:11
Version 3.7.12.1 check-in: 972e75bb user: drh tags: apple-osx
13:01
Version 3.7.12.1 check-in: d07b7b67 user: drh tags: sessions
02:45
Version 3.7.12.1 check-in: 6d326d44 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: 5519cc5e user: drh tags: trunk
21:26
Merge the nested aggregate query fix (ticket [c2ad16f997ee9c8ed]) unto trunk. check-in: e459c336 user: drh tags: trunk
21:20
Mark and always-true conditional as such. Add the fuzz-oss1.test test module. Closed-Leaf check-in: bdc01fd0 user: drh tags: nested-agg