From owner-freebsd-ports-bugs@FreeBSD.ORG Tue May 15 10:50:07 2012 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 2976B106567F for ; Tue, 15 May 2012 10:50:07 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id F0D108FC20 for ; Tue, 15 May 2012 10:50:06 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.5/8.14.5) with ESMTP id q4FAo600005797 for ; Tue, 15 May 2012 10:50:06 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.5/8.14.5/Submit) id q4FAo60k005796; Tue, 15 May 2012 10:50:06 GMT (envelope-from gnats) Resent-Date: Tue, 15 May 2012 10:50:06 GMT Resent-Message-Id: <201205151050.q4FAo60k005796@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Pavel I Volkov Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 520EF106566C for ; Tue, 15 May 2012 10:49:51 +0000 (UTC) (envelope-from pol@admbank.ru) Received: from osiris.dns4soho.net (osiris.dns4soho.net [IPv6:2a01:230:2::41]) by mx1.freebsd.org (Postfix) with ESMTP id EF8478FC0C for ; Tue, 15 May 2012 10:49:49 +0000 (UTC) Received: from pol.adm.ru ([193.169.92.86]) by osiris.dns4soho.net (8.14.5/8.14.5) with ESMTP id q4FAnl7l041581 for ; Tue, 15 May 2012 14:49:47 +0400 (MSK) (envelope-from pol@admbank.ru) Received: from pol.adm.ru (localhost [127.0.0.1]) by pol.adm.ru (8.14.5/8.14.5) with ESMTP id q4FAnfWO004690 for ; Tue, 15 May 2012 14:49:41 +0400 (MSK) (envelope-from pol@pol.adm.ru) Received: (from pol@localhost) by pol.adm.ru (8.14.5/8.14.5/Submit) id q4FAnfsI004689; Tue, 15 May 2012 14:49:41 +0400 (MSK) (envelope-from pol) Message-Id: <201205151049.q4FAnfsI004689@pol.adm.ru> Date: Tue, 15 May 2012 14:49:41 +0400 (MSK) From: Pavel I Volkov To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Cc: Subject: ports/167913: [MAINTAINER] databases/sqlite3: update to 3.7.12 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 15 May 2012 10:50:07 -0000 >Number: 167913 >Category: ports >Synopsis: [MAINTAINER] databases/sqlite3: update to 3.7.12 >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: maintainer-update >Submitter-Id: current-users >Arrival-Date: Tue May 15 10:50:06 UTC 2012 >Closed-Date: >Last-Modified: >Originator: Pavel I Volkov >Release: FreeBSD 9.0-STABLE amd64 >Organization: >Environment: System: FreeBSD pol.***.ru 9.0-STABLE FreeBSD 9.0-STABLE #4: Mon Apr 9 12:25:53 MSK >Description: - Update to 3.7.12 - Change OPTIONS. - Changes method of distribution of source code. - Delete TCL dependencies. Thanks Baptiste Daroussin. (http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/155908) Added file(s): - files/patch-Makefile.in Removed file(s): - files/example.tcl - files/patch-src-os_unix.c - files/patch-src_shell.c - files/patch-test-backup2.test Generated with FreeBSD Port Tools 0.99_6 (mode: update, diff: suffix) >How-To-Repeat: >Fix: --- sqlite3-3.7.12.patch begins here --- diff -ruN --exclude=CVS ../sqlite3.orig/Makefile ./Makefile --- ../sqlite3.orig/Makefile 2012-04-09 19:44:52.000000000 +0400 +++ ./Makefile 2012-05-15 14:12:24.000000000 +0400 @@ -6,219 +6,137 @@ # PORTNAME= sqlite3 -PORTVERSION= 3.7.11 +PORTVERSION= 3.7.12 CATEGORIES= databases MASTER_SITES= http://www.sqlite.org/ http://www2.sqlite.org/ -DISTNAME= sqlite-src-3071100 +DISTNAME= sqlite-autoconf-3071200 MAINTAINER= pavelivolkov@googlemail.com COMMENT= An SQL database engine in a C library -LICENSE= unknown +LICENSE= public LICENSE_NAME= Public Domain LICENSE_TEXT= Description of the license can be obtained from the following URL: http://www.sqlite.org/copyright.html LICENSE_PERMS= ${_LICENSE_PERMS_DEFAULT} CONFLICTS= sqlite34-[0-9]* -USE_ZIP= YES -USE_GMAKE= YES -USE_GNOME= pkgconfig gnomehack +USE_GNOME= pkgconfig USE_LDCONFIG= YES GNU_CONFIGURE= YES -USE_TCL_BUILD= 84+ -CONFIGURE_ENV+= TCLSH_CMD="${TCLSH}" \ - TCLLIBDIR="${PREFIX}/lib/${PORTNAME}" \ - ac_cv_search_pthread_create="" -CPPFLAGS+= -I. -I./src - -# Use an in-ram database for temporary tables (never,no,yes,always), -# which is equivalent of SQLITE_TEMP_STORE=[0,1,2,3] -RAMTABLE?= yes - # Compilation Options For SQLite http://www.sqlite.org/compile.html OPTIONS= \ FTS3 "Enable FTS3/4 (Full Text Search) module" on \ ICU "Enable built with ICU" off \ - RTREE "Enable R*Tree module" off \ - RAMTABLE "Store temporary tables in RAM = ${RAMTABLE}" off \ + RTREE "Enable R*Tree module (${RTREE_INT})" off \ + RAMTABLE "Store temporary tables in RAM = ${TEMP_STORE}" off \ UPD_DEL_LIMIT "ORDER BY and LIMIT on UPDATE and DELETE" off \ URI "Enable use the URI filename" off \ - POWERSAFE "Enable powersafe overwrite" on \ SOUNDEX "Enables the soundex() SQL function" off \ METADATA "Enable column metadata" on \ STAT3 "Help SQLite to chose a better query plan" off \ DIRECT_READ "File is read directly from disk" off \ MEMMAN "Allows it to release unused memory" off \ - MEMSTATUS "Enable memory statistics" on \ SECURE_DELETE "Overwrite deleted information with zeros" on \ UNLOCK_NOTIFY "Enable notification on unlocking" on \ THREADSAFE "Build thread-safe library" on \ EXTENSION "Allow loadable extensions" on \ - TCLWRAPPER "Enable TCL wrapper" off \ .include PLIST_FILES= bin/sqlite3 include/sqlite3.h include/sqlite3ext.h \ lib/libsqlite3.a lib/libsqlite3.la lib/libsqlite3.so \ lib/libsqlite3.so.8 libdata/pkgconfig/sqlite3.pc -PORTDOCS= * .if !defined(NO_INSTALL_MANPAGES) MAN1= sqlite3.1 .endif -# DEBUG "Enable debugging & verbose explain" off \ -# This options used only for debug and is not required during normal work -# applications or its libraries. -# This options can be specified on the command line. -# Execute: make -D WITH_DEBUG ... -.if defined(WITH_DEBUG) -CONFIGURE_ARGS+= --enable-debug -CFLAGS+= -Wall -.endif - -# GCOV "Enable coverage testing using gcov/gprof" off \ -# These options are only used for debugging, profiling the application. -# And can cause errors when using the application or its libraries in other -# products (for example build security/nss is BROKEN). -# This options can be specified on the command line. -# Execute: make -D WITH_GCOV ... -.if defined(WITH_GCOV) -CONFIGURE_ARGS+= --enable-gcov -LDFLAGS+= -fstack-protector -.endif - -# By default, the sqlite3_step() interface will automatically invoke -# sqlite3_reset() to reset the prepared statement if necessary. This -# compile-time option changes that behavior so that sqlite3_step() will -# return SQLITE_MISUSE if it called again after returning anything other -# than SQLITE_ROW, SQLITE_BUSY, or SQLITE_LOCKED unless there was an -# intervening call to sqlite3_reset(). -# A detailed description of this option, the compile can be found here: -# http://www.sqlite.org/compile.html#omit_autoreset -# This options can be specified on the command line. -# Execute: make -D WITH_OMIT_AUTORESET ... -.if defined(WITH_OMIT_AUTORESET) -CFLAGS+= -DSQLITE_OMIT_AUTORESET=1 -.endif - # NAME83 "Enable use 8.3 filename for temp files" off \ # Some devices are compelled to use an older file system with 8+3 filename # restrictions for backwards compatibility, or due to other non-technical factors. # http://www.sqlite.org/shortnames.html .if defined(WITH_NAME83) -CFLAGS+= -DSQLITE_ENABLE_8_3_NAMES=1 +CPPFLAGS+= -DSQLITE_ENABLE_8_3_NAMES=1 .endif # The default numeric file permissions for newly created database files under unix. # If not specified, the default is 0644 which means that the files is globally # readable but only writable by the creator. .ifdef DEFAULT_FILE_PERMISSIONS -CFLAGS+= -DSQLITE_DEFAULT_FILE_PERMISSIONS=${DEFAULT_FILE_PERMISSIONS} +CPPFLAGS+= -DSQLITE_DEFAULT_FILE_PERMISSIONS=${DEFAULT_FILE_PERMISSIONS} .endif # This macro sets the default size of the page-cache for temporary files # created by SQLite to store intermediate results, in pages. .ifdef TEMP_CACHE_SIZE -CFLAGS+= -DSQLITE_DEFAULT_TEMP_CACHE_SIZE=${TEMP_CACHE_SIZE} -.endif - -# http://www.sqlite.org/wal.html#ckpt -.ifdef WAL_AUTOCHECKPOINT -CFLAGS+= -DSQLITE_DEFAULT_WAL_AUTOCHECKPOINT=${WAL_AUTOCHECKPOINT} -.endif - -.ifdef SCHEMA_RETRY -CFLAGS+= -DSQLITE_MAX_SCHEMA_RETRY=${SCHEMA_RETRY} -.endif - -# http://www.sqlite.org/psow.html -.if defined(WITH_POWERSAFE) -# SQLite to assume that application-level writes cannot changes bytes outside the range -# of bytes written even if the write occurs just before a power loss. -CFLAGS+= -DSQLITE_POWERSAFE_OVERWRITE=1 -.else -# SQLite assumes that other bytes in the same sector with a written byte might be changed -# or damaged by a power loss. -CFLAGS+= -DSQLITE_POWERSAFE_OVERWRITE=0 +CPPFLAGS+= -DSQLITE_DEFAULT_TEMP_CACHE_SIZE=${TEMP_CACHE_SIZE} .endif .if defined(WITH_MEMMAN) -CFLAGS+= -DSQLITE_ENABLE_MEMORY_MANAGEMENT=1 -.endif - -# Disable memory statistics. -.if defined(WITHOUT_MEMSTATUS) -CFLAGS+= -DSQLITE_DEFAULT_MEMSTATUS=0 +CPPFLAGS+= -DSQLITE_ENABLE_MEMORY_MANAGEMENT=1 .endif .if defined(WITH_UPD_DEL_LIMIT) -CFLAGS+= -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT=1 +CPPFLAGS+= -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT=1 .endif .if defined(WITH_URI) -CFLAGS+= -DSQLITE_USE_URI=1 +CPPFLAGS+= -DSQLITE_USE_URI=1 .endif .if defined(WITH_SOUNDEX) -CFLAGS+= -DSQLITE_SOUNDEX=1 +CPPFLAGS+= -DSQLITE_SOUNDEX=1 .endif .if defined(WITH_STAT3) -CFLAGS+= -DSQLITE_ENABLE_STAT3=1 +CPPFLAGS+= -DSQLITE_ENABLE_STAT3=1 .endif .if defined(WITH_DIRECT_READ) -CFLAGS+= -DSQLITE_DIRECT_OVERFLOW_READ=1 +CPPFLAGS+= -DSQLITE_DIRECT_OVERFLOW_READ=1 .endif .if defined(WITH_FTS3) -CFLAGS+= -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_FTS4=1 +CPPFLAGS+= -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_FTS4=1 .endif .if defined(WITH_RTREE) -CFLAGS+= -DSQLITE_ENABLE_RTREE=1 +CPPFLAGS+= -DSQLITE_ENABLE_RTREE=1 +.ifdef RTREE_INT +CPPFLAGS+= -DSQLITE_RTREE_INT_ONLY=1 +RTREE_INT= "int" +.else +RTREE_INT= "float" +.endif .endif .if defined(WITH_ICU) BUILD_DEPENDS+= ${LOCALBASE}/bin/icu-config:${PORTSDIR}/devel/icu LIB_DEPENDS+= icudata:${PORTSDIR}/devel/icu -CFLAGS+= -DSQLITE_ENABLE_ICU=1 +CPPFLAGS+= -DSQLITE_ENABLE_ICU=1 CPPFLAGS+= `${LOCALBASE}/bin/icu-config --cppflags` LDFLAGS+= `${LOCALBASE}/bin/icu-config --ldflags` .endif +# Use an in-ram database for temporary tables (never,no,yes,always), +# which is equivalent of TEMP_STORE=[0,1,2,3], default = 1. .if defined(WITH_RAMTABLE) -CONFIGURE_ARGS+= --enable-tempstore=${RAMTABLE} +TEMP_STORE?= 2 +CPPFLAGS+= -DSQLITE_TEMP_STORE=${TEMP_STORE} .endif .if defined(WITH_SECURE_DELETE) -CFLAGS+= -DSQLITE_SECURE_DELETE=1 +CPPFLAGS+= -DSQLITE_SECURE_DELETE=1 .endif .if defined(WITH_UNLOCK_NOTIFY) -CFLAGS+= -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 -.endif - -.if defined(WITH_TCLWRAPPER) -CATEGORIES+= lang tcl -COMMENT+= with TCL Wrapper -USE_TCL_RUN= yes -ALL_TARGET= all tclsqlite3 -INSTALL_TARGET= install tcl_install -CONFIGURE_ARGS+= --with-tcl=${TCL_LIBDIR} -PORTEXAMPLES+= example.tcl -PLIST_DIRS+= lib/sqlite3 -PLIST_FILES+= bin/tclsqlite3 lib/sqlite3/libtclsqlite3.so \ - lib/sqlite3/pkgIndex.tcl -.else -CONFIGURE_ARGS+= --disable-tcl +CPPFLAGS+= -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 .endif .if !defined(WITHOUT_METADATA) -CFLAGS+= -DSQLITE_ENABLE_COLUMN_METADATA=1 +CPPFLAGS+= -DSQLITE_ENABLE_COLUMN_METADATA=1 .endif .if !defined(WITHOUT_THREADSAFE) @@ -229,72 +147,16 @@ .endif .if !defined(WITHOUT_EXTENSION) -CONFIGURE_ARGS+= --enable-load-extension +CONFIGURE_ARGS+= --enable-dynamic-extensions .else -CONFIGURE_ARGS+= --disable-load-extension +CONFIGURE_ARGS+= --disable-dynamic-extensions .endif .include -.if defined(TCL_VER) && ${TCL_VER} > 8.4 -BUILD_DEPENDS+= ${LOCALBASE}/lib/tcl8/${TCL_VER}:${PORTSDIR}/lang/tcl-modules -.if defined(WITH_TCLWRAPPER) -RUN_DEPENDS+= ${LOCALBASE}/lib/tcl8/${TCL_VER}:${PORTSDIR}/lang/tcl-modules -.endif -.endif - -.ifmake test -# To test you must specify the value of TESTUSER variable. -# It must correspond to a normal (not root) user, from which it will be tested. -# Execute: make TESTUSER=ordinary_user_login_name test -.ifndef TESTUSER -IGNORE= set the value of the variable TESTUSER corresponding normal (not root) user, from which will be tested -.endif -.ifndef WITH_TCLWRAPPER -IGNORE= for the purpose of test you want to include TCL wrapper -.endif -.ifdef WITH_NAME83 -IGNORE= use 8.3 file name limit is violated during testing -# ${WRKSRC} contains the names of "databases" and "sqlite-src-3070700" violation of the agreement 8.3 file names and directories. -# You can test by running mount in the place where the restriction of 8.3 is observed. -# mount -t nullfs ${WRKSRC} /mnt -# cd /mnt -# chown -R ${TESTUSER} /mnt -# su ${TESTUSER} -c "limits -n 1999 make test" -# chown -R ${USER} /mnt -# cd -# umount /mnt -.endif -.endif - -test: build - @(cd ${WRKSRC} && ${CHOWN} -R ${TESTUSER} ${WRKSRC} && su ${TESTUSER} -c "limits -n 1999 ${MAKE} test"; ${CHOWN} -R ${USER} ${WRKSRC}) - -post-build: - @${ECHO_CMD} - @${ECHO_CMD} "You can test sqlite using supplied with the him tests." - @${ECHO_CMD} "Execute: make TESTUSER=ordinary_user_login_name test" - post-install: -.if defined(WITH_TCLWRAPPER) - @${INSTALL_PROGRAM} ${WRKSRC}/.libs/tclsqlite3 ${PREFIX}/bin - @${MKDIR} ${EXAMPLESDIR} - @${INSTALL_DATA} ${FILESDIR}/example.tcl ${EXAMPLESDIR} -.endif .if !defined(NO_INSTALL_MANPAGES) @${INSTALL_MAN} ${WRKSRC}/sqlite3.1 ${MANPREFIX}/man/man1 .endif -.ifndef NOPORTDOCS - @${MKDIR} ${DOCSDIR} -.ifdef WITH_FTS3 - @${INSTALL_DATA} ${WRKSRC}/ext/fts3/README.syntax ${WRKSRC}/ext/fts3/README.tokenizers ${DOCSDIR} -.endif -.ifdef WITH_RTREE - @${INSTALL_DATA} ${WRKSRC}/ext/rtree/README ${DOCSDIR} -.endif -.ifdef WITH_ICU - @${INSTALL_DATA} ${WRKSRC}/ext/icu/README.txt ${DOCSDIR} -.endif -.endif .include diff -ruN --exclude=CVS ../sqlite3.orig/distinfo ./distinfo --- ../sqlite3.orig/distinfo 2012-04-09 19:44:52.000000000 +0400 +++ ./distinfo 2012-05-15 10:51:40.000000000 +0400 @@ -1,2 +1,2 @@ -SHA256 (sqlite-src-3071100.zip) = 939262fe70b5e4dcd04f29d6f1d8221542f24e71adf72f0d4a8c671d8b6d9441 -SIZE (sqlite-src-3071100.zip) = 4705421 +SHA256 (sqlite-autoconf-3071200.tar.gz) = ca1735d13975be84cba87ea1b62ae0ab01fdc01ef21d7547982a2b118c9fc649 +SIZE (sqlite-autoconf-3071200.tar.gz) = 1827241 diff -ruN --exclude=CVS ../sqlite3.orig/files/example.tcl ./files/example.tcl --- ../sqlite3.orig/files/example.tcl 2004-08-31 23:06:39.000000000 +0400 +++ ./files/example.tcl 1970-01-01 03:00:00.000000000 +0300 @@ -1,14 +0,0 @@ -package require sqlite - -if {$argc!=2} { - puts stderr "Usage: %s DATABASE SQL-STATEMENT" - exit 1 -} -sqlite db [lindex $argv 0] -db eval [lindex $argv 1] x { - foreach v $x(*) { - puts "$v = $x($v)" - } - puts "" -} -db close diff -ruN --exclude=CVS ../sqlite3.orig/files/patch-Makefile.in ./files/patch-Makefile.in --- ../sqlite3.orig/files/patch-Makefile.in 1970-01-01 03:00:00.000000000 +0300 +++ ./files/patch-Makefile.in 2012-05-15 12:42:43.000000000 +0400 @@ -0,0 +1,11 @@ +--- ./Makefile.in.orig 2012-05-15 12:26:47.000000000 +0400 ++++ ./Makefile.in 2012-05-15 12:41:54.000000000 +0400 +@@ -219,7 +219,7 @@ + sqlite3_DEPENDENCIES = $(top_builddir)/libsqlite3.la + include_HEADERS = sqlite3.h sqlite3ext.h + EXTRA_DIST = sqlite3.1 tea +-pkgconfigdir = ${libdir}/pkgconfig ++pkgconfigdir = ${prefix}/libdata/pkgconfig + pkgconfig_DATA = sqlite3.pc + man_MANS = sqlite3.1 + all: all-am diff -ruN --exclude=CVS ../sqlite3.orig/files/patch-src-os_unix.c ./files/patch-src-os_unix.c --- ../sqlite3.orig/files/patch-src-os_unix.c 2010-09-01 21:49:49.000000000 +0400 +++ ./files/patch-src-os_unix.c 1970-01-01 03:00:00.000000000 +0300 @@ -1,11 +0,0 @@ ---- src/os_unix.c.orig 2010-08-31 10:44:29.000000000 +0400 -+++ src/os_unix.c 2010-08-31 10:44:48.000000000 +0400 -@@ -4841,7 +4841,7 @@ - char *zErr; - UNUSED_PARAMETER(NotUsed); - unixEnterMutex(); -- zErr = dlerror(); -+ zErr = (char *)dlerror(); - if( zErr ){ - sqlite3_snprintf(nBuf, zBufOut, "%s", zErr); - } diff -ruN --exclude=CVS ../sqlite3.orig/files/patch-src_shell.c ./files/patch-src_shell.c --- ../sqlite3.orig/files/patch-src_shell.c 2011-12-22 22:10:22.000000000 +0400 +++ ./files/patch-src_shell.c 1970-01-01 03:00:00.000000000 +0300 @@ -1,11 +0,0 @@ ---- src/shell.c.orig 2011-11-01 16:31:18.000000000 +0400 -+++ src/shell.c 2011-11-10 22:45:11.000000000 +0400 -@@ -490,7 +490,7 @@ - */ - static void output_hex_blob(FILE *out, const void *pBlob, int nBlob){ - int i; -- char *zBlob = (char *)pBlob; -+ unsigned char *zBlob = (unsigned char *)pBlob; - fprintf(out,"X'"); - for(i=0; iRelease-Note: >Audit-Trail: >Unformatted: