From 8785871844d646f0bee869cf2edc2f19ced5f05a Mon Sep 17 00:00:00 2001 From: adam Date: Fri, 8 Jan 2016 14:43:10 +0000 Subject: Changes 3.10.0: General improvements: --------------------- Added support for LIKE, GLOB, and REGEXP operators on virtual tables. Added the colUsed field to sqlite3_index_info for use by the sqlite3_module.xBestIndex method. Enhance the PRAGMA cache_spill statement to accept a 32-bit integer parameter which is the threshold below which cache spilling is prohibited. On unix, if a symlink to a database file is opened, then the corresponding journal files are based on the actual filename, not the symlink name. Added the "--transaction" option to sqldiff. Added the sqlite3_db_cacheflush() interface. Added the sqlite3_strlike() interface. When using memory-mapped I/O map the database file read-only so that stray pointers and/or array overruns in the application cannot accidently modify the database file. Added the experimental sqlite3_snapshot_get(), sqlite3_snapshot_open(), and sqlite3_snapshot_free() interfaces. These are subject to change or removal in a subsequent release. Enhance the 'utc' modifier in the date and time functions so that it is a no-op if the date/time is known to already be in UTC. (This is not a compatibility break since the behavior has long been documented as "undefined" in that case.) Added the json_group_array() and json_group_object() SQL functions in the json extension. Added the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option. Many small performance optimizations. Portability enhancements: ------------------------- Work around a sign-exension bug in the optimizer of the HP C compiler on HP/UX. (details) Enhancements to the command-line shell: --------------------------------------- Added the ".changes ON|OFF" and ".vfsinfo" dot-commands. Translate between MBCS and UTF8 when running in cmd.exe on Windows. Enhancements to makefiles: -------------------------- Added the --enable-editline and --enable-static-shell options to the various autoconf-generated configure scripts. Omit all use of "awk" in the makefiles, to make building easier for MSVC users. Important fixes: ---------------- Fix inconsistent integer to floating-point comparison operations that could result in a corrupt index if the index is created on a table column that contains both large integers and floating point values of similar magnitude. Ticket 38a97a87a6. Fix an infinite-loop in the query planner that could occur on malformed common table expressions. Various bug fixes in the sqldiff tool. --- databases/sqlite3-docs/PLIST | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'databases/sqlite3-docs/PLIST') diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST index 6eb17ad3637..26bcea01a8f 100644 --- a/databases/sqlite3-docs/PLIST +++ b/databases/sqlite3-docs/PLIST @@ -1,4 +1,4 @@ -@comment $NetBSD: PLIST,v 1.47 2015/11/04 06:32:25 adam Exp $ +@comment $NetBSD: PLIST,v 1.48 2016/01/08 14:43:10 adam Exp $ share/doc/sqlite3/34to35.html share/doc/sqlite3/35to36.html share/doc/sqlite3/about.html @@ -84,6 +84,7 @@ share/doc/sqlite3/c3ref/create_function.html share/doc/sqlite3/c3ref/create_module.html share/doc/sqlite3/c3ref/data_count.html share/doc/sqlite3/c3ref/data_directory.html +share/doc/sqlite3/c3ref/db_cacheflush.html share/doc/sqlite3/c3ref/db_config.html share/doc/sqlite3/c3ref/db_filename.html share/doc/sqlite3/c3ref/db_handle.html @@ -143,6 +144,10 @@ share/doc/sqlite3/c3ref/result_blob.html share/doc/sqlite3/c3ref/result_subtype.html share/doc/sqlite3/c3ref/set_authorizer.html share/doc/sqlite3/c3ref/sleep.html +share/doc/sqlite3/c3ref/snapshot.html +share/doc/sqlite3/c3ref/snapshot_free.html +share/doc/sqlite3/c3ref/snapshot_get.html +share/doc/sqlite3/c3ref/snapshot_open.html share/doc/sqlite3/c3ref/soft_heap_limit.html share/doc/sqlite3/c3ref/soft_heap_limit64.html share/doc/sqlite3/c3ref/sql.html @@ -157,6 +162,7 @@ share/doc/sqlite3/c3ref/stmt_scanstatus_reset.html share/doc/sqlite3/c3ref/stmt_status.html share/doc/sqlite3/c3ref/strglob.html share/doc/sqlite3/c3ref/stricmp.html +share/doc/sqlite3/c3ref/strlike.html share/doc/sqlite3/c3ref/table_column_metadata.html share/doc/sqlite3/c3ref/temp_directory.html share/doc/sqlite3/c3ref/test_control.html @@ -316,6 +322,7 @@ share/doc/sqlite3/images/foreignlogos/bloomberg.gif share/doc/sqlite3/images/foreignlogos/bosch_logo1.gif share/doc/sqlite3/images/foreignlogos/dropbox.gif share/doc/sqlite3/images/foreignlogos/expensify.png +share/doc/sqlite3/images/foreignlogos/fb.gif share/doc/sqlite3/images/foreignlogos/firefox.gif share/doc/sqlite3/images/foreignlogos/flame.gif share/doc/sqlite3/images/foreignlogos/ge.gif @@ -332,6 +339,7 @@ share/doc/sqlite3/images/foreignlogos/philips.gif share/doc/sqlite3/images/foreignlogos/php.gif share/doc/sqlite3/images/foreignlogos/python.gif share/doc/sqlite3/images/foreignlogos/realbasic.gif +share/doc/sqlite3/images/foreignlogos/rpm_logo.png share/doc/sqlite3/images/foreignlogos/skype.gif share/doc/sqlite3/images/foreignlogos/sony.gif share/doc/sqlite3/images/foreignlogos/sunmicro.gif @@ -529,6 +537,7 @@ share/doc/sqlite3/releaselog/3_0_5.html share/doc/sqlite3/releaselog/3_0_6.html share/doc/sqlite3/releaselog/3_0_7.html share/doc/sqlite3/releaselog/3_0_8.html +share/doc/sqlite3/releaselog/3_10_0.html share/doc/sqlite3/releaselog/3_1_0.html share/doc/sqlite3/releaselog/3_1_1.html share/doc/sqlite3/releaselog/3_1_2.html -- cgit v1.2.3