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

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

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

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

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

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

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

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

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

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

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

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

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