25417136 Upgrade Sqlite3 to 3.17.0
authorJingning Ji <jingning.ji@oracle.com>
Fri, 27 Jan 2017 16:34:13 -0800
changeset 7770 5efbd9a35bd0
parent 7769 96a1241fc627
child 7771 46912a8a1f29
25417136 Upgrade Sqlite3 to 3.17.0 25453780 problem in DATABASE/SQLITE3
components/sqlite-3/Makefile
components/sqlite-3/sqlite-3-doc.p5m
components/sqlite-3/sqlite.license
--- a/components/sqlite-3/Makefile	Thu Mar 16 12:51:08 2017 -0700
+++ b/components/sqlite-3/Makefile	Fri Jan 27 16:34:13 2017 -0800
@@ -26,13 +26,13 @@
 include ../../make-rules/shared-macros.mk
 
 COMPONENT_NAME=		sqlite
-TARBALL_VERSION=	3120200
-COMPONENT_VERSION=	3.12.2
+TARBALL_VERSION=	3170000
+COMPONENT_VERSION=	3.17.0
 COMPONENT_PROJECT_URL=	http://www.sqlite.org/
 COMPONENT_SRC=		$(COMPONENT_NAME)-autoconf-$(TARBALL_VERSION)
 COMPONENT_ARCHIVE_HASH= \
-    sha256:fd00770c9afd39db555c78400e52f55e8bd6568c78be23561abb472a22d09abb
-COMPONENT_ARCHIVE_URL=	$(COMPONENT_PROJECT_URL)2016/$(COMPONENT_ARCHIVE)
+    sha256:a4e485ad3a16e054765baf6371826b5000beed07e626510896069c0bf013874c
+COMPONENT_ARCHIVE_URL=	$(COMPONENT_PROJECT_URL)2017/$(COMPONENT_ARCHIVE)
 COMPONENT_BUGDB=	database/sqlite3
 COMPONENT_ANITYA_ID=	4877
 
@@ -41,11 +41,11 @@
 COMPONENT_SRC_1=        $(COMPONENT_NAME)-doc-$(DOC_VERSION)
 COMPONENT_ARCHIVE_1=    $(COMPONENT_SRC_1).zip
 COMPONENT_ARCHIVE_HASH_1=       \
-    sha256:67c640c4b01b961016717db61e3e43c63c33248c78ce0de9f10b88ea7ce97670
-COMPONENT_ARCHIVE_URL_1=         $(COMPONENT_PROJECT_URL)2016/$(COMPONENT_ARCHIVE_1)
+    sha256:3102d9eab879074776216357e4c9e272f63d0cda975a0819ec5baba5e0922ff6
+COMPONENT_ARCHIVE_URL_1=         $(COMPONENT_PROJECT_URL)2017/$(COMPONENT_ARCHIVE_1)
 PKG_PROTO_DIRS +=       $(COMPONENT_SRC_1)
 
-TPNO=			27892
+TPNO=			34078
 
 TEST_TARGET= $(NO_TESTS)
 include $(WS_MAKE_RULES)/common.mk
--- a/components/sqlite-3/sqlite-3-doc.p5m	Thu Mar 16 12:51:08 2017 -0700
+++ b/components/sqlite-3/sqlite-3-doc.p5m	Fri Jan 27 16:34:13 2017 -0800
@@ -20,7 +20,7 @@
 #
 
 #
-# Copyright (c) 2015, Oracle and/or its affiliates. All rights reserved.
+# Copyright (c) 2015, 2017, Oracle and/or its affiliates. All rights reserved.
 #
 
 <transform file path=usr/share/doc/sqlite3/(.+)$ -> \
@@ -55,9 +55,9 @@
 file path=usr/share/doc/sqlite3/autoinc.html
 file path=usr/share/doc/sqlite3/backup.html
 file path=usr/share/doc/sqlite3/books.html
-file path=usr/share/doc/sqlite3/btreemodule.html
 file path=usr/share/doc/sqlite3/c3ref/aggregate_context.html
 file path=usr/share/doc/sqlite3/c3ref/aggregate_count.html
+file path=usr/share/doc/sqlite3/c3ref/api_routines.html
 file path=usr/share/doc/sqlite3/c3ref/auto_extension.html
 file path=usr/share/doc/sqlite3/c3ref/backup.html
 file path=usr/share/doc/sqlite3/c3ref/backup_finish.html
@@ -104,6 +104,7 @@
 file path=usr/share/doc/sqlite3/c3ref/c_stmtstatus_counter.html
 file path=usr/share/doc/sqlite3/c3ref/c_sync_dataonly.html
 file path=usr/share/doc/sqlite3/c3ref/c_testctrl_always.html
+file path=usr/share/doc/sqlite3/c3ref/c_trace.html
 file path=usr/share/doc/sqlite3/c3ref/c_vtab_constraint_support.html
 file path=usr/share/doc/sqlite3/c3ref/cancel_auto_extension.html
 file path=usr/share/doc/sqlite3/c3ref/changes.html
@@ -139,6 +140,7 @@
 file path=usr/share/doc/sqlite3/c3ref/enable_shared_cache.html
 file path=usr/share/doc/sqlite3/c3ref/errcode.html
 file path=usr/share/doc/sqlite3/c3ref/exec.html
+file path=usr/share/doc/sqlite3/c3ref/expanded_sql.html
 file path=usr/share/doc/sqlite3/c3ref/experimental.html
 file path=usr/share/doc/sqlite3/c3ref/extended_result_codes.html
 file path=usr/share/doc/sqlite3/c3ref/file.html
@@ -176,6 +178,7 @@
 file path=usr/share/doc/sqlite3/c3ref/pcache_methods2.html
 file path=usr/share/doc/sqlite3/c3ref/pcache_page.html
 file path=usr/share/doc/sqlite3/c3ref/prepare.html
+file path=usr/share/doc/sqlite3/c3ref/preupdate_count.html
 file path=usr/share/doc/sqlite3/c3ref/profile.html
 file path=usr/share/doc/sqlite3/c3ref/progress_handler.html
 file path=usr/share/doc/sqlite3/c3ref/randomness.html
@@ -186,9 +189,14 @@
 file path=usr/share/doc/sqlite3/c3ref/result_subtype.html
 file path=usr/share/doc/sqlite3/c3ref/set_authorizer.html
 file path=usr/share/doc/sqlite3/c3ref/sleep.html
+file path=usr/share/doc/sqlite3/c3ref/snapshot.html
+file path=usr/share/doc/sqlite3/c3ref/snapshot_cmp.html
+file path=usr/share/doc/sqlite3/c3ref/snapshot_free.html
+file path=usr/share/doc/sqlite3/c3ref/snapshot_get.html
+file path=usr/share/doc/sqlite3/c3ref/snapshot_open.html
+file path=usr/share/doc/sqlite3/c3ref/snapshot_recover.html
 file path=usr/share/doc/sqlite3/c3ref/soft_heap_limit.html
 file path=usr/share/doc/sqlite3/c3ref/soft_heap_limit64.html
-file path=usr/share/doc/sqlite3/c3ref/sql.html
 file path=usr/share/doc/sqlite3/c3ref/sqlite3.html
 file path=usr/share/doc/sqlite3/c3ref/status.html
 file path=usr/share/doc/sqlite3/c3ref/step.html
@@ -205,6 +213,7 @@
 file path=usr/share/doc/sqlite3/c3ref/test_control.html
 file path=usr/share/doc/sqlite3/c3ref/threadsafe.html
 file path=usr/share/doc/sqlite3/c3ref/total_changes.html
+file path=usr/share/doc/sqlite3/c3ref/trace_v2.html
 file path=usr/share/doc/sqlite3/c3ref/unlock_notify.html
 file path=usr/share/doc/sqlite3/c3ref/update_hook.html
 file path=usr/share/doc/sqlite3/c3ref/uri_boolean.html
@@ -226,6 +235,7 @@
 file path=usr/share/doc/sqlite3/c_interface.html
 file path=usr/share/doc/sqlite3/capi3.html
 file path=usr/share/doc/sqlite3/capi3ref.html
+file path=usr/share/doc/sqlite3/carray.html
 file path=usr/share/doc/sqlite3/changes.html
 file path=usr/share/doc/sqlite3/chronology.html
 file path=usr/share/doc/sqlite3/cintro.html
@@ -237,12 +247,17 @@
 file path=usr/share/doc/sqlite3/copyright-release.html
 file path=usr/share/doc/sqlite3/copyright-release.pdf
 file path=usr/share/doc/sqlite3/copyright.html
+file path=usr/share/doc/sqlite3/cpu.html
 file path=usr/share/doc/sqlite3/crew.html
+file path=usr/share/doc/sqlite3/csv.html
 file path=usr/share/doc/sqlite3/custombuild.html
 file path=usr/share/doc/sqlite3/cvstrac.css
 file path=usr/share/doc/sqlite3/datatype3.html
 file path=usr/share/doc/sqlite3/datatypes.html
+file path=usr/share/doc/sqlite3/dbhash.html
 file path=usr/share/doc/sqlite3/dbstat.html
+file path=usr/share/doc/sqlite3/debugging.html
+file path=usr/share/doc/sqlite3/deterministic.html
 file path=usr/share/doc/sqlite3/dev.html
 file path=usr/share/doc/sqlite3/different.html
 file path=usr/share/doc/sqlite3/doc_backlink_crossref.html
@@ -267,7 +282,9 @@
 file path=usr/share/doc/sqlite3/formatchng.html
 file path=usr/share/doc/sqlite3/fts3.html
 file path=usr/share/doc/sqlite3/fts5.html
+file path=usr/share/doc/sqlite3/fullsql.html
 file path=usr/share/doc/sqlite3/getthecode.html
+file path=usr/share/doc/sqlite3/hirely.html
 file path=usr/share/doc/sqlite3/howtocompile.html
 file path=usr/share/doc/sqlite3/howtocorrupt.html
 file path=usr/share/doc/sqlite3/hp1.html
@@ -303,6 +320,7 @@
 file path=usr/share/doc/sqlite3/images/arch.png
 file path=usr/share/doc/sqlite3/images/arch2.gif
 file path=usr/share/doc/sqlite3/images/books/aditya.jpg
+file path=usr/share/doc/sqlite3/images/books/darocha2016.jpg
 file path=usr/share/doc/sqlite3/images/books/das.jpg
 file path=usr/share/doc/sqlite3/images/books/droessler.jpg
 file path=usr/share/doc/sqlite3/images/books/haldar.gif
@@ -319,6 +337,7 @@
 file path=usr/share/doc/sqlite3/images/btreemodule_delete1.svg
 file path=usr/share/doc/sqlite3/images/btreemodule_overview.svg
 file path=usr/share/doc/sqlite3/images/chw.jpg
+file path=usr/share/doc/sqlite3/images/cpu-usage.jpg
 file path=usr/share/doc/sqlite3/images/dan1.jpg
 file path=usr/share/doc/sqlite3/images/direct1b.gif
 file path=usr/share/doc/sqlite3/images/drh1.jpg
@@ -374,13 +393,12 @@
 file path=usr/share/doc/sqlite3/images/foreignlogos/philips.gif
 file path=usr/share/doc/sqlite3/images/foreignlogos/php.gif
 file path=usr/share/doc/sqlite3/images/foreignlogos/python.gif
-file path=usr/share/doc/sqlite3/images/foreignlogos/realbasic.gif
 file path=usr/share/doc/sqlite3/images/foreignlogos/skype.gif
 file path=usr/share/doc/sqlite3/images/foreignlogos/sony.gif
 file path=usr/share/doc/sqlite3/images/foreignlogos/sunmicro.gif
 file path=usr/share/doc/sqlite3/images/foreignlogos/symbian.gif
 file path=usr/share/doc/sqlite3/images/foreignlogos/tcl.gif
-file path=usr/share/doc/sqlite3/images/foreignlogos/toshiba.gif
+file path=usr/share/doc/sqlite3/images/foreignlogos/xojo.png
 file path=usr/share/doc/sqlite3/images/fts3_doclist.png
 file path=usr/share/doc/sqlite3/images/fts3_doclist.svg
 file path=usr/share/doc/sqlite3/images/fts3_doclist2.png
@@ -435,6 +453,7 @@
 file path=usr/share/doc/sqlite3/images/shared.gif
 file path=usr/share/doc/sqlite3/images/sqlite370.jpg
 file path=usr/share/doc/sqlite3/images/sqlite370_banner.gif
+file path=usr/share/doc/sqlite3/images/sqlitepie.jpg
 file path=usr/share/doc/sqlite3/images/src_logo.gif
 file path=usr/share/doc/sqlite3/images/sw.gif
 file path=usr/share/doc/sqlite3/images/sw.png
@@ -444,6 +463,7 @@
 file path=usr/share/doc/sqlite3/images/syntax/begin-stmt.gif
 file path=usr/share/doc/sqlite3/images/syntax/column-constraint.gif
 file path=usr/share/doc/sqlite3/images/syntax/column-def.gif
+file path=usr/share/doc/sqlite3/images/syntax/column-name-list.gif
 file path=usr/share/doc/sqlite3/images/syntax/comment-syntax.gif
 file path=usr/share/doc/sqlite3/images/syntax/commit-stmt.gif
 file path=usr/share/doc/sqlite3/images/syntax/common-table-expression.gif
@@ -499,6 +519,7 @@
 file path=usr/share/doc/sqlite3/images/syntax/with-clause.gif
 file path=usr/share/doc/sqlite3/images/table-ex1b2.gif
 file path=usr/share/doc/sqlite3/images/vfs1.gif
+file path=usr/share/doc/sqlite3/imposter.html
 file path=usr/share/doc/sqlite3/index.html
 file path=usr/share/doc/sqlite3/inmemorydb.html
 file path=usr/share/doc/sqlite3/intern-v-extern-blob.html
@@ -541,12 +562,13 @@
 file path=usr/share/doc/sqlite3/limits.html
 file path=usr/share/doc/sqlite3/loadext.html
 file path=usr/share/doc/sqlite3/lockingv3.html
+file path=usr/share/doc/sqlite3/lts.html
 file path=usr/share/doc/sqlite3/malloc.html
 file path=usr/share/doc/sqlite3/mingw.html
 file path=usr/share/doc/sqlite3/mmap.html
 file path=usr/share/doc/sqlite3/mostdeployed.html
 file path=usr/share/doc/sqlite3/news.html
-file path=usr/share/doc/sqlite3/not-found.html
+file path=usr/share/doc/sqlite3/np1queryprob.html
 file path=usr/share/doc/sqlite3/nulls.html
 file path=usr/share/doc/sqlite3/oldnews.html
 file path=usr/share/doc/sqlite3/omitted.html
@@ -557,6 +579,7 @@
 file path=usr/share/doc/sqlite3/pragma.html
 file path=usr/share/doc/sqlite3/pressrelease-20071212.html
 file path=usr/share/doc/sqlite3/privatebranch.html
+file path=usr/share/doc/sqlite3/prosupport.html
 file path=usr/share/doc/sqlite3/psow.html
 file path=usr/share/doc/sqlite3/queryplanner-ng.html
 file path=usr/share/doc/sqlite3/queryplanner.html
@@ -571,6 +594,24 @@
 file path=usr/share/doc/sqlite3/releaselog/3_0_6.html
 file path=usr/share/doc/sqlite3/releaselog/3_0_7.html
 file path=usr/share/doc/sqlite3/releaselog/3_0_8.html
+file path=usr/share/doc/sqlite3/releaselog/3_10_0.html
+file path=usr/share/doc/sqlite3/releaselog/3_10_1.html
+file path=usr/share/doc/sqlite3/releaselog/3_10_2.html
+file path=usr/share/doc/sqlite3/releaselog/3_11_0.html
+file path=usr/share/doc/sqlite3/releaselog/3_11_1.html
+file path=usr/share/doc/sqlite3/releaselog/3_12_0.html
+file path=usr/share/doc/sqlite3/releaselog/3_12_1.html
+file path=usr/share/doc/sqlite3/releaselog/3_12_2.html
+file path=usr/share/doc/sqlite3/releaselog/3_13_0.html
+file path=usr/share/doc/sqlite3/releaselog/3_14.html
+file path=usr/share/doc/sqlite3/releaselog/3_14_1.html
+file path=usr/share/doc/sqlite3/releaselog/3_14_2.html
+file path=usr/share/doc/sqlite3/releaselog/3_15_0.html
+file path=usr/share/doc/sqlite3/releaselog/3_15_1.html
+file path=usr/share/doc/sqlite3/releaselog/3_15_2.html
+file path=usr/share/doc/sqlite3/releaselog/3_16_0.html
+file path=usr/share/doc/sqlite3/releaselog/3_16_1.html
+file path=usr/share/doc/sqlite3/releaselog/3_16_2.html
 file path=usr/share/doc/sqlite3/releaselog/3_1_0.html
 file path=usr/share/doc/sqlite3/releaselog/3_1_1.html
 file path=usr/share/doc/sqlite3/releaselog/3_1_2.html
@@ -705,24 +746,62 @@
 file path=usr/share/doc/sqlite3/releaselog/3_9_0.html
 file path=usr/share/doc/sqlite3/releaselog/3_9_1.html
 file path=usr/share/doc/sqlite3/releaselog/3_9_2.html
+file path=usr/share/doc/sqlite3/releaselog/3_9_3.html
 file path=usr/share/doc/sqlite3/releaselog/current.html
 file path=usr/share/doc/sqlite3/requirements.html
 file path=usr/share/doc/sqlite3/rescode.html
 file path=usr/share/doc/sqlite3/robots.txt
+file path=usr/share/doc/sqlite3/rowidtable.html
+file path=usr/share/doc/sqlite3/rowvalue.html
 file path=usr/share/doc/sqlite3/rtree.html
 file path=usr/share/doc/sqlite3/selfcontained.html
+file path=usr/share/doc/sqlite3/series.html
 file path=usr/share/doc/sqlite3/serverless.html
 file path=usr/share/doc/sqlite3/session.html
+file path=usr/share/doc/sqlite3/session/c_changeset_abort.html
+file path=usr/share/doc/sqlite3/session/c_changeset_conflict.html
+file path=usr/share/doc/sqlite3/session/changegroup.html
+file path=usr/share/doc/sqlite3/session/changeset_iter.html
 file path=usr/share/doc/sqlite3/session/constlist.html
 file path=usr/share/doc/sqlite3/session/funclist.html
 file path=usr/share/doc/sqlite3/session/intro.html
 file path=usr/share/doc/sqlite3/session/objlist.html
+file path=usr/share/doc/sqlite3/session/session.html
+file path=usr/share/doc/sqlite3/session/sqlite3changegroup_add.html
+file path=usr/share/doc/sqlite3/session/sqlite3changegroup_add_strm.html
+file path=usr/share/doc/sqlite3/session/sqlite3changegroup_delete.html
+file path=usr/share/doc/sqlite3/session/sqlite3changegroup_new.html
+file path=usr/share/doc/sqlite3/session/sqlite3changegroup_output.html
+file path=usr/share/doc/sqlite3/session/sqlite3changeset_apply.html
+file path=usr/share/doc/sqlite3/session/sqlite3changeset_concat.html
+file path=usr/share/doc/sqlite3/session/sqlite3changeset_conflict.html
+file path=usr/share/doc/sqlite3/session/sqlite3changeset_finalize.html
+file path=usr/share/doc/sqlite3/session/sqlite3changeset_fk_conflicts.html
+file path=usr/share/doc/sqlite3/session/sqlite3changeset_invert.html
+file path=usr/share/doc/sqlite3/session/sqlite3changeset_new.html
+file path=usr/share/doc/sqlite3/session/sqlite3changeset_next.html
+file path=usr/share/doc/sqlite3/session/sqlite3changeset_old.html
+file path=usr/share/doc/sqlite3/session/sqlite3changeset_op.html
+file path=usr/share/doc/sqlite3/session/sqlite3changeset_pk.html
+file path=usr/share/doc/sqlite3/session/sqlite3changeset_start.html
+file path=usr/share/doc/sqlite3/session/sqlite3session_attach.html
+file path=usr/share/doc/sqlite3/session/sqlite3session_changeset.html
+file path=usr/share/doc/sqlite3/session/sqlite3session_create.html
+file path=usr/share/doc/sqlite3/session/sqlite3session_delete.html
+file path=usr/share/doc/sqlite3/session/sqlite3session_diff.html
+file path=usr/share/doc/sqlite3/session/sqlite3session_enable.html
+file path=usr/share/doc/sqlite3/session/sqlite3session_indirect.html
+file path=usr/share/doc/sqlite3/session/sqlite3session_isempty.html
+file path=usr/share/doc/sqlite3/session/sqlite3session_patchset.html
+file path=usr/share/doc/sqlite3/session/sqlite3session_table_filter.html
+file path=usr/share/doc/sqlite3/sessionintro.html
 file path=usr/share/doc/sqlite3/sharedcache.html
 file path=usr/share/doc/sqlite3/shortnames.html
 file path=usr/share/doc/sqlite3/sitemap.html
 file path=usr/share/doc/sqlite3/speed.html
 file path=usr/share/doc/sqlite3/spellfix1.html
 file path=usr/share/doc/sqlite3/sqldiff.html
+file path=usr/share/doc/sqlite3/sqlite.css
 file path=usr/share/doc/sqlite3/sqlite.html
 file path=usr/share/doc/sqlite3/support.html
 file path=usr/share/doc/sqlite3/syntax.html
@@ -732,6 +811,7 @@
 file path=usr/share/doc/sqlite3/syntax/begin-stmt.html
 file path=usr/share/doc/sqlite3/syntax/column-constraint.html
 file path=usr/share/doc/sqlite3/syntax/column-def.html
+file path=usr/share/doc/sqlite3/syntax/column-name-list.html
 file path=usr/share/doc/sqlite3/syntax/comment-syntax.html
 file path=usr/share/doc/sqlite3/syntax/commit-stmt.html
 file path=usr/share/doc/sqlite3/syntax/common-table-expression.html
--- a/components/sqlite-3/sqlite.license	Thu Mar 16 12:51:08 2017 -0700
+++ b/components/sqlite-3/sqlite.license	Fri Jan 27 16:34:13 2017 -0800
@@ -2,14 +2,16 @@
 
 SQLite Copyright
 
+SQLite Is Public Domain
 All of the code and documentation in SQLite has been dedicated to the public domain by the authors. All code authors, and representatives of the companies they work for, have signed affidavits dedicating their contributions to the public domain and originals of those signed affidavits are stored in a firesafe at the main offices of Hwaci. Anyone is free to copy, modify, publish, use, compile, sell, or distribute the original SQLite code, either in source code form or as a compiled binary, for any purpose, commercial or non-commercial, and by any means.
 The previous paragraph applies to the deliverable code and documentation in SQLite - those parts of the SQLite library that you actually bundle and ship with a larger application. Some scripts used as part of the build process (for example the "configure" scripts generated by autoconf) might fall under other open-source licenses. Nothing from these build scripts ever reaches the final deliverable SQLite library, however, and so the licenses associated with those scripts should not be a factor in assessing your rights to copy and use the SQLite library.
 All of the deliverable code in SQLite has been written from scratch. No code has been taken from other projects or from the open internet. Every line of code can be traced back to its original author, and all of those authors have public domain dedications on file. So the SQLite code base is clean and is uncontaminated with licensed code from other projects.
-Obtaining An Explicit License To Use SQLite
+Obtaining An License To Use SQLite
 Even though SQLite is in the public domain and does not require a license, some users want to obtain a license anyway. Some reasons for obtaining a license include:
+•	Your company desires warranty of title and/or indemnity against claims of copyright infringement.
 •	You are using SQLite in a jurisdiction that does not recognize the public domain.
 •	You are using SQLite in a jurisdiction that does not recognize the right of an author to dedicate their work to the public domain.
 •	You want to hold a tangible legal document as evidence that you have the legal right to use and distribute SQLite.
 •	Your legal department tells you that you have to purchase a license.
-If you feel like you really have to purchase a license for SQLite, Hwaci, the company that employs the architect and principal developers of SQLite, will sell you one.
+If you feel like you really need to purchase a license for SQLite, Hwaci, the company that employs all the developers of SQLite, will sell you one. All proceeds from the sale of SQLite licenses are used to fund continuing improvement and support of SQLite.