Date: Tue, 28 Jun 2011 20:52:40 +0400 (MSD) From: Pavel I Volkov <pavelivolkov@googlemail.com> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/158400: [MAINTAINER] databases/sqlite3: update to 3.7.7 Message-ID: <201106281652.p5SGqelq018329@cvs0.catervaska.dyndns.org> Resent-Message-ID: <201106281700.p5SH0IM1063545@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 158400 >Category: ports >Synopsis: [MAINTAINER] databases/sqlite3: update to 3.7.7 >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 Jun 28 17:00:18 UTC 2011 >Closed-Date: >Last-Modified: >Originator: Pavel I Volkov >Release: FreeBSD 8.2-STABLE i386 >Organization: >Environment: System: FreeBSD cvs0.catervaska.dyndns.org 8.2-STABLE FreeBSD 8.2-STABLE #0: Sat Apr 9 20:20:05 MSD >Description: - Update to 3.7.7 Generated with FreeBSD Port Tools 0.99 >How-To-Repeat: >Fix: --- sqlite3-3.7.7.patch begins here --- diff -ruN --exclude=CVS /usr/ports/databases/sqlite3.orig/Makefile /usr/ports/databases/sqlite3/Makefile --- /usr/ports/databases/sqlite3.orig/Makefile 2011-05-26 18:46:47.000000000 +0400 +++ /usr/ports/databases/sqlite3/Makefile 2011-06-28 19:31:21.000000000 +0400 @@ -6,18 +6,18 @@ # PORTNAME= sqlite3 -PORTVERSION= 3.7.6.3 +PORTVERSION= 3.7.7 CATEGORIES= databases MASTER_SITES= http://www.sqlite.org/ http://www2.sqlite.org/ -DISTNAME= sqlite-src-3070603 +DISTNAME= sqlite-src-3070700 MAINTAINER= pavelivolkov@googlemail.com COMMENT= An SQL database engine in a C library LICENSE= unknown LICENSE_NAME= Public Domain -LICENSE_PERMS= ${_LICENSE_PERMS_DEFAULT} 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]* @@ -43,6 +43,7 @@ RTREE "Enable R*Tree module" off \ RAMTABLE "Store temporary tables in RAM = ${RAMTABLE}" off \ UPD_DEL_LIMIT "ORDER BY and LIMIT on UPDATE and DELETE" off \ + URI "Enable use the URI filename" off \ SOUNDEX "Enables the soundex() SQL function" off \ METADATA "Enable column metadata" on \ STAT2 "Help SQLite to chose a better query plan" off \ @@ -103,6 +104,21 @@ 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 +.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} +.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 @@ -117,6 +133,10 @@ CFLAGS+= -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT=1 .endif +.if defined(WITH_URI) +CFLAGS+= -DSQLITE_USE_URI=1 +.endif + .if defined(WITH_SOUNDEX) CFLAGS+= -DSQLITE_SOUNDEX=1 .endif @@ -126,7 +146,7 @@ .endif .if defined(WITH_FTS3) -CFLAGS+= -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 +CFLAGS+= -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_FTS4=1 .endif .if defined(WITH_RTREE) @@ -197,16 +217,28 @@ .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 -.ifmake 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 diff -ruN --exclude=CVS /usr/ports/databases/sqlite3.orig/distinfo /usr/ports/databases/sqlite3/distinfo --- /usr/ports/databases/sqlite3.orig/distinfo 2011-05-23 18:38:17.000000000 +0400 +++ /usr/ports/databases/sqlite3/distinfo 2011-06-27 10:41:53.000000000 +0400 @@ -1,2 +1,2 @@ -SHA256 (sqlite-src-3070603.zip) = f40dbcfed53853727cec0135b527d209170f8703c1013b24d066a0df9b82cdc9 -SIZE (sqlite-src-3070603.zip) = 4470530 +SHA256 (sqlite-src-3070700.zip) = f7b54c72cdbab09938a313ad94a5a15d8ebdef683200805e63e0374632255e6e +SIZE (sqlite-src-3070700.zip) = 4562266 --- sqlite3-3.7.7.patch ends here --- >Release-Note: >Audit-Trail: >Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201106281652.p5SGqelq018329>