SQLite Release 3.7.17

SQLite 버전이 업데이트 되었다.


SQLite Release 3.7.17 On 2013-05-20 (3.7.17)

Add support for memory-mapped I/O.

Add the sqlite3_strglob() convenience interface.

Assigned the integer at offset 68 in the database header as the
Application ID for when SQLite is used as an application file-format.
Added the PRAGMA application_id command to query and set the Application ID.

Report rollback recovery in the error log as SQLITE_NOTICE_RECOVER_ROLLBACK.
Change the error log code for WAL recover from
SQLITE_OK to SQLITE_NOTICE_RECOVER_WAL.

Report the risky uses of unlinked database files and
database filename aliasing as SQLITE_WARNING messages in the error log.

Added the SQLITE_TRACE_SIZE_LIMIT compile-time option.

Increase the default value of SQLITE_MAX_SCHEMA_RETRY to 50 and make sure
that it is honored in every place that a schema change might force a statement
retry.

Add a new test harness called "mptester" used to verify correct operation
when multiple processes are using the same database file at the same time.

Enhance the extension loading mechanism to be more flexible (while
still maintaining backwards compatibility) in two ways:

1. If the default entry point "sqlite3_extension_init" is not present in
   the loadable extension, also try an entry point "sqlite3_X_init" where
   "X" is based on the shared library filename. This allows every extension
   to have a different entry point, which allows them to be statically linked
   with no code changes.
   


2. The shared library filename passed to sqlite3_load_extension() may
   omit the filename suffix, and an appropriate architecture-dependent
   suffix (".so", ".dylib", or ".dll") will be added automatically.
   

Added many new loadable extensions to the source tree, including
amatch, closure, fuzzer, ieee754, nextchar, regexp, spellfix,
and wholenumber. See header comments on each extension source file
for further information about what that extension does.

Enhance FTS3 to avoid using excess stack space when there are a huge
number of terms on the right-hand side of the MATCH operator. A side-effect
of this change is that the MATCH operator can only accommodate 12 NEAR
operators at a time.

Enhance the fts4aux virtual table so that it can be a TEMP table.

Added the fts3tokenize virtual table to the full-text search logic.

Query planner enhancement: Use the transitive property of constraints
to move constraints into the outer loops of a join whenever possible,
thereby reducing the amount of work that needs to occur in inner loops.

Discontinue the use of posix_fallocate() on unix, as it does not work on all
filesystems.

Improved tracing and debugging facilities in the Windows VFS.

Bug fix: Fix a potential database corruption bug
in shared cache mode when one
database connection is closed while another is in the middle of a write
transaction.
Ticket e636a050b7

Bug fix:
Only consider AS names from the result set as candidates for resolving
identifiers in the WHERE clause if there are no other matches. In the
ORDER BY clause, AS names take priority over any column names.
Ticket 2500cdb9be05

Bug fix: Do not allow a virtual table to cancel the ORDER BY clause unless
all outer loops are guaranteed to return no more than one row result.
Ticket ba82a4a41eac1.

Bug fix: Do not suppress the ORDER BY clause on a virtual table query if
an IN constraint is used.
Ticket f69b96e3076e.

Bug fix: The command-line shell gives an exit code of 0 when terminated
using the ".quit" command.

Bug fix: Make sure PRAGMA statements appear in sqlite3_trace() output.

Bug fix: When a compound query that uses an ORDER BY clause
with a COLLATE operator, make sure that the sorting occurs
according to the specified collation and that the comparisons associate with
the compound query use the native collation. Ticket
6709574d2a8d8.

Bug fix: Makes sure the authorizer callback gets
a valid pointer to the string "ROWID" for the column-name parameter when
doing an UPDATE that changes the rowid. Ticket
0eb70d77cb05bb2272

Bug fix: Do not move WHERE clause terms inside OR expressions that are
contained within an ON clause of a LEFT JOIN. Ticket
f2369304e4

Bug fix: Make sure an error is always reported when attempting to preform
an operation that requires a collating sequence that is missing.
Ticket 0fc59f908b

SQLITE_SOURCE_ID:
"2013-05-20 00:56:22 118a3b35693b134d56ebd780123b7fd6f1497668"

SHA1 for sqlite3.c: 246987605d0503c700a08b9ee99a6b5d67454aab


Original Post : http://neodreamer-dev.tistory.com/710

SQLite Release 3.7.14

SQLite Release 3.7.14 On 2012-09-03 (3.7.14)

• Drop built-in support for OS/2. If you need to upgrade an OS/2 application to use this or a later version of SQLite, then add an application-defined VFS using the sqlite3_vfs_register() interface. The code removed in this release can serve as a baseline for the application-defined VFS.
  


• Ensure that floating point values are preserved exactly when reconstructing a database from the output of the ".dump" command of the command-line shell.
  


• Added the sqlite3_close_v2() interface.
  


• Updated the command-line shell so that it can be built using SQLITE_OMIT_FLOATING_POINT and SQLITE_OMIT_AUTOINIT.
  


• Improvements to the windows makefiles and build processes.
  


• Enhancements to PRAGMA integrity_check and PRAGMA quick_check so that they can optionally check just a single attached database instead of all attached databases.
  


• Enhancements to WAL mode processing that ensure that at least one valid read-mark is available at all times, so that read-only processes can always read the database.
  


• Performance enhancements in the sorter used by ORDER BY and CREATE INDEX.
  


• Added the SQLITE_DISABLE_FTS4_DEFERRED compile-time option.
  


• Better handling of aggregate queries where the aggregate functions are contained within subqueries.
  


• Enhance the query planner so that it will try to use a covering index on queries that make use of or optimization.
  


• SQLITE_SOURCE_ID: "2012-09-03 15:42:36 c0d89d4a9752922f9e367362366efde4f1b06f2a"
  


• SHA1 for sqlite3.c: 5fdf596b29bb426001f28b488ff356ae14d5a5a6
  

SQLite 3.7.14 Release Note<

Original Post : http://neodreamer-dev.tistory.com/679

SQLite Release 3.7.13

SQLite 가 버전업을 하였다.

이번 배포판부터는 Metro style 응용프로그램을 위한 WinRT API 를 사용한 Dll 파일을 배포하고 있다.




SQLite Release 3.7.13 On 2012-06-11 (3.7.13)

• In-memory databases that are specified using URI filenames are allowed to use shared cache, so that the same in-memory database can be accessed from multiple database connections.
  


• Recognize and use the mode=memory query parameter in URI filenames.
  


• Avoid resetting the schema of shared cache connections when any one connection closes. Instead, wait for the last connection to close before reseting the schema.
  


• In the RTREE extension, when rounding 64-bit floating point numbers to 32-bit for storage, always round in a direction that causes the bounding box to get larger.
  


• Adjust the unix driver to avoid unnecessary calls to fchown().
  


• Add interfaces sqlite3_quota_ferror() and sqlite3_quota_file_available() to the test_quota.c module.
  


• The sqlite3_create_module() and sqlite3_create_module_v2() interfaces return SQLITE_MISUSE on any attempt to overload or replace a virtual table module. The destructor is always called in this case, in accordance with historical and current documentation.
  


• SQLITE_SOURCE_ID: "2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc"
  


• SHA1 for sqlite3.c: ff0a771d6252545740ba9685e312b0e3bb6a641b
  

SQLite Homepage&

Original Post : http://neodreamer-dev.tistory.com/661

SQLite Release 3.7.12.1

SQLite 가 3.7.12 버전을 공개한지 얼마 되지 않아 다시 3.7.12.1 버전을 공개하였다.



SQLite Release 3.7.12.1 On 2012 May 22 (3.7.12.1)

• Fix a bug (ticket c2ad16f997) in the 3.7.12 release that can cause a segfault for certain obscure nested aggregate queries.
  


• Fix various other minor test script problems.
  


• SQLITE_SOURCE_ID: "2012-05-22 02:45:53 6d326d44fd1d626aae0e8456e5fa2049f1ce0789"
  


• SHA1 for sqlite3.c: d494e8d81607f0515d4f386156fb0fd86d5ba7df
  

SQLite Homepage

SQLite Download pag

Original Post : http://neodreamer-dev.tistory.com/656

SQLite Release 3.7.12

Release 3.7.12 On 2012 May 14

• Add the SQLITE_DBSTATUS_CACHE_WRITE option for sqlite3_db_status().
  


• Optimize the typeof() and length() SQL functions so that they avoid unnecessary reading of database content from disk.
  


• Add the FTS4 "merge" command, the FTS4 "automerge" command, and the FTS4 "integrity-check" command.
  


• Report the name of specific CHECK constraints that fail.
  


• In the command-line shell, use popen() instead of fopen() if the first character of the argument to the ".output" command is "|".
  


• Make use of OVERLAPPED in the windows VFS to avoid some system calls and thereby obtain a performance improvement.
  


• More aggressive optimization of the AND operator when one side or the other is always false.
  


• Improved performance of queries with many OR-connected terms in the WHERE clause that can all be indexed.
  


• Add the SQLITE_RTREE_INT_ONLY compile-time option to force the R*Tree Extension Module to use integer instead of floating point values for both storage and computation.
  


• Enhance the PRAGMA integrity_check command to use much less memory when processing multi-gigabyte databases.
  


• New interfaces added to the test_quota.c add-on module.
  


• Added the ".trace" dot-command to the command-line shell.
  


• Allow virtual table constructors to be invoked recursively.
  


• Improved optimization of ORDER BY clauses on compound queries.
  


• Improved optimization of aggregate subqueries contained within an aggregate query.
  


• Bug fix: Fix the RELEASE command so that it does not cancel pending queries. This repairs a problem introduced in 3.7.11.
  


• Bug fix: Do not discard the DISTINCT as superfluous unless a subset of the result set is subject to a UNIQUE constraint and it none of the columns in that subset can be NULL. Ticket 385a5b56b9.
  


• Bug fix: Do not optimize away an ORDER BY clause that has the same terms as a UNIQUE index unless those terms are also NOT NULL. Ticket 2a5629202f.
  


• SQLITE_SOURCE_ID: "2012-05-14 01:41:23 8654aa9540fe9fd210899d83d17f3f407096c004"
  


• SHA1 for sqlite3.c: 57e2104a0f7b3f528e7f6b7a8e553e2357ccd2e1
  

SQLite 3 Homepage

SQLite 3 Download Page&

Original Post : http://neodreamer-dev.tistory.com/652