Attachment #190291 for bug #225627




# $FreeBSD: head/databases/sqlite3/Makefile 453790 2017-11-09 02:31:47Z jbeich $

PORTNAME=	sqlite3
PORTVERSION=	3.22.0
PORTREVISION=	1
CATEGORIES=	databases
MASTER_SITES=	https://www.sqlite.org/2018/ http://www2.sqlite.org/2018/ http://www3.sqlite.org/2018/
DISTNAME=	sqlite-autoconf-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00

MAINTAINER=	pavelivolkov@gmail.com

# Compilation Options For SQLite https://www.sqlite.org/compile.html
OPTIONS_DEFINE=	FTS4 UPD_DEL_LIMIT URI URI_AUTHORITY SOUNDEX METADATA \
		DIRECT_READ MEMMAN SECURE_DELETE UNLOCK_NOTIFY THREADS \
		EXTENSION ARMOR STMT FTS5 JSON1 RBU NULL_TRIM \
		OFFSET LIKENOTBLOB STSHELL FTS3_TOKEN SESSION UNKNOWN_SQL
OPTIONS_SINGLE=	RAMT
OPTIONS_RADIO=	STAT RL
OPTIONS_GROUP=	UNICODE RTREEG

# https://sqlite.org/compile.html#enable_null_trim
NULL_TRIM_DESC=		Omits NULL columns at the ends of rows

# http://www.sqlite.org/compile.html#enable_offset_sql_func
OFFSET_DESC=		Enabled the sqlite_offset() SQL function

# https://www.sqlite.org/sessionintro.html
SESSION_DESC=		Enable the Session Extension


STAT3_DESC=		collect histogram data from leftmost column
STAT4_DESC=		collect histogram data from all columns

# https://sqlite.org/compile.html#enable_dbpage_vtab
DBPAGE_DESC=		Enable DBPAGE Virtual Table

# https://www.sqlite.org/dbstat.html
DBSTAT_DESC=		Enable DBSTAT Virtual Table

# https://www.sqlite.org/fts3.html#tokenizer
OPTIONS_GROUP_UNICODE=	ICU UNICODE61
UNICODE_DESC=		Unicode support
UNICODE61_DESC=		Unicode Version 6.1 tokenizer

# https://www.sqlite.org/rtree.html
OPTIONS_GROUP_RTREEG=	RTREE_INT
RTREEG_DESC=		Index type for range queries
RTREE_DESC=		Enable R*Tree module
RTREE_INT_DESC=		Store 32-bit sig int (no float) coordinates

OPTIONS_GROUP_RL=	LIBEDIT READLINE
RL_DESC=		Command line editing library (may be off)

OPTIONS_DEFAULT=	FTS4 URI METADATA SECURE_DELETE UNLOCK_NOTIFY THREADS \
			EXTENSION TS1 UNICODE61 STSHELL READLINE \
			FTS3_TOKEN FTS5
# SECURE_DELETE, UNLOCK_NOTIFY, DBSTAT (since 41.0) used by www/firefox et al.
# RTREE used by graphics/mapnik, databases/spatialite

TS2_CPPFLAGS=	-DSQLITE_TEMP_STORE=2
TS3_CPPFLAGS=	-DSQLITE_TEMP_STORE=3

RTREE_CPPFLAGS=	-DSQLITE_ENABLE_RTREE=1
RTREE_INT_CPPFLAGS=	-DSQLITE_RTREE_INT_ONLY=1

FTS4_CPPFLAGS=	-DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_FTS4=1
FTS5_CONFIGURE_ENABLE=	fts5
FTS5_LIBS=		-lm
FTS3_TOKEN_CPPFLAGS=	-DSQLITE_ENABLE_FTS3_TOKENIZER=1

METADATA_CPPFLAGS=	-DSQLITE_ENABLE_COLUMN_METADATA=1
STAT3_CPPFLAGS=	-DSQLITE_ENABLE_STAT3=1
STAT4_CPPFLAGS=	-DSQLITE_ENABLE_STAT4=1
DBPAGE_CPPFLAGS=	-DSQLITE_ENABLE_DBPAGE_VTAB=1
DBSTAT_CPPFLAGS=	-DSQLITE_ENABLE_DBSTAT_VTAB=1
URI_CPPFLAGS=	-DSQLITE_USE_URI=1
URI_AUTHORITY_CPPFLAGS=	-DSQLITE_ALLOW_URI_AUTHORITY=1
DIRECT_READ_CPPFLAGS=	-DSQLITE_DIRECT_OVERFLOW_READ=1


NULL_TRIM_CPPFLAGS=	-DSQLITE_ENABLE_NULL_TRIM=1

OFFSET_CPPFLAGS=	-DSQLITE_ENABLE_OFFSET_SQL_FUNC=1

.include <bsd.port.options.mk>

# Platform Configuration

Lines 1-3 Link Here

(-)databases/sqlite3/distinfo (-3 / +3 lines)
1	TIMESTAMP = 1509525928	1	TIMESTAMP = 1517654018
2	SHA256 (sqlite-autoconf-3210000.tar.gz) = d7dd516775005ad87a57f428b6f86afd206cb341722927f104d3f0cf65fbbbe3	2	SHA256 (sqlite-autoconf-3220000.tar.gz) = 2824ab1238b706bc66127320afbdffb096361130e23291f26928a027b885c612
3	SIZE (sqlite-autoconf-3210000.tar.gz) = 2568942	3	SIZE (sqlite-autoconf-3220000.tar.gz) = 2644649

Lines 1-9 Link Here

(-)databases/sqlite3/files/patch-Makefile.am (-9 lines)
1	--- Makefile.am.orig 2016-05-29 06:03:15 UTC
2	+++ Makefile.am
3	@@ -1,5 +1,5 @@
4
5	-AM_CFLAGS = @THREADSAFE_FLAGS@ @DYNAMIC_EXTENSION_FLAGS@ @FTS5_FLAGS@ @JSON1_FLAGS@ @SESSION_FLAGS@ -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE
6	+AM_CFLAGS = @THREADSAFE_FLAGS@ @DYNAMIC_EXTENSION_FLAGS@ @FTS5_FLAGS@ @JSON1_FLAGS@ @SESSION_FLAGS@
7
8	lib_LTLIBRARIES = libsqlite3.la
9	libsqlite3_la_SOURCES = sqlite3.c

Lines 1-11 Link Here

(-)databases/sqlite3/files/patch-Makefile.in (-11 lines)
1	--- Makefile.in.orig 2016-05-29 06:04:20 UTC
2	+++ Makefile.in
3	@@ -363,7 +363,7 @@ target_alias = @target_alias@
4	top_build_prefix = @top_build_prefix@
5	top_builddir = @top_builddir@
6	top_srcdir = @top_srcdir@
7	-AM_CFLAGS = @THREADSAFE_FLAGS@ @DYNAMIC_EXTENSION_FLAGS@ @FTS5_FLAGS@ @JSON1_FLAGS@ @SESSION_FLAGS@ -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE
8	+AM_CFLAGS = @THREADSAFE_FLAGS@ @DYNAMIC_EXTENSION_FLAGS@ @FTS5_FLAGS@ @JSON1_FLAGS@ @SESSION_FLAGS@
9	lib_LTLIBRARIES = libsqlite3.la
10	libsqlite3_la_SOURCES = sqlite3.c
11	libsqlite3_la_LDFLAGS = -no-undefined -version-info 8:6:8

Return to bug 225627

Lines 2-11 Link Here

(-)databases/sqlite3/Makefile (-18 / +12 lines)
2	# $FreeBSD: head/databases/sqlite3/Makefile 453790 2017-11-09 02:31:47Z jbeich $	2	# $FreeBSD: head/databases/sqlite3/Makefile 453790 2017-11-09 02:31:47Z jbeich $
3		3
4	PORTNAME= sqlite3	4	PORTNAME= sqlite3
5	PORTVERSION= 3.21.0	5	PORTVERSION= 3.22.0
6	PORTREVISION= 1
7	CATEGORIES= databases	6	CATEGORIES= databases
8	MASTER_SITES= https://www.sqlite.org/2017/ http://www2.sqlite.org/2017/ http://www3.sqlite.org/2017/	7	MASTER_SITES= https://www.sqlite.org/2018/ http://www2.sqlite.org/2018/ http://www3.sqlite.org/2018/
9	DISTNAME= sqlite-autoconf-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00	8	DISTNAME= sqlite-autoconf-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00
10		9
11	MAINTAINER= pavelivolkov@gmail.com	10	MAINTAINER= pavelivolkov@gmail.com
Lines 23-30 Link Here
23	# Compilation Options For SQLite https://www.sqlite.org/compile.html	22	# Compilation Options For SQLite https://www.sqlite.org/compile.html
24	OPTIONS_DEFINE= FTS4 UPD_DEL_LIMIT URI URI_AUTHORITY SOUNDEX METADATA \	23	OPTIONS_DEFINE= FTS4 UPD_DEL_LIMIT URI URI_AUTHORITY SOUNDEX METADATA \
25	DIRECT_READ MEMMAN SECURE_DELETE UNLOCK_NOTIFY THREADS \	24	DIRECT_READ MEMMAN SECURE_DELETE UNLOCK_NOTIFY THREADS \
26	EXTENSION ARMOR STMT DBPAGE DBSTAT FTS5 JSON1 RBU NULL_TRIM \	25	EXTENSION ARMOR STMT FTS5 JSON1 RBU NULL_TRIM \
27	LIKENOTBLOB STSHELL FTS3_TOKEN SESSION UNKNOWN_SQL	26	OFFSET LIKENOTBLOB STSHELL FTS3_TOKEN SESSION UNKNOWN_SQL
28	OPTIONS_SINGLE= RAMT	27	OPTIONS_SINGLE= RAMT
29	OPTIONS_RADIO= STAT RL	28	OPTIONS_RADIO= STAT RL
30	OPTIONS_GROUP= UNICODE RTREEG	29	OPTIONS_GROUP= UNICODE RTREEG
Lines 44-49 Link Here
44	# https://sqlite.org/compile.html#enable_null_trim	43	# https://sqlite.org/compile.html#enable_null_trim
45	NULL_TRIM_DESC= Omits NULL columns at the ends of rows	44	NULL_TRIM_DESC= Omits NULL columns at the ends of rows
46		45
		46	# http://www.sqlite.org/compile.html#enable_offset_sql_func
		47	OFFSET_DESC= Enabled the sqlite_offset() SQL function
		48
47	# https://www.sqlite.org/sessionintro.html	49	# https://www.sqlite.org/sessionintro.html
48	SESSION_DESC= Enable the Session Extension	50	SESSION_DESC= Enable the Session Extension
49		51
Lines 90-117 Link Here
90	STAT3_DESC= collect histogram data from leftmost column	92	STAT3_DESC= collect histogram data from leftmost column
91	STAT4_DESC= collect histogram data from all columns	93	STAT4_DESC= collect histogram data from all columns
92		94
93	# https://sqlite.org/compile.html#enable_dbpage_vtab
94	DBPAGE_DESC= Enable DBPAGE Virtual Table
95
96	# https://www.sqlite.org/dbstat.html
97	DBSTAT_DESC= Enable DBSTAT Virtual Table
98
99	# https://www.sqlite.org/fts3.html#tokenizer	95	# https://www.sqlite.org/fts3.html#tokenizer
100	OPTIONS_GROUP_UNICODE= ICU UNICODE61	96	OPTIONS_GROUP_UNICODE= ICU UNICODE61
101	UNICODE_DESC= Unicode support	97	UNICODE_DESC= Unicode support
102	UNICODE61_DESC= Unicode Version 6.1 tokenizer	98	UNICODE61_DESC= Unicode Version 6.1 tokenizer
103		99
104	# https://www.sqlite.org/rtree.html	100	# https://www.sqlite.org/rtree.html
105	OPTIONS_GROUP_RTREEG= RTREE RTREE_INT	101	OPTIONS_GROUP_RTREEG= RTREE_INT
106	RTREEG_DESC= Index type for range queries	102	RTREEG_DESC= Index type for range queries
107	RTREE_DESC= Enable R*Tree module
108	RTREE_INT_DESC= Store 32-bit sig int (no float) coordinates	103	RTREE_INT_DESC= Store 32-bit sig int (no float) coordinates
109		104
110	OPTIONS_GROUP_RL= LIBEDIT READLINE	105	OPTIONS_GROUP_RL= LIBEDIT READLINE
111	RL_DESC= Command line editing library (may be off)	106	RL_DESC= Command line editing library (may be off)
112		107
113	OPTIONS_DEFAULT= FTS4 URI METADATA SECURE_DELETE UNLOCK_NOTIFY THREADS \	108	OPTIONS_DEFAULT= FTS4 URI METADATA SECURE_DELETE UNLOCK_NOTIFY THREADS \
114	EXTENSION TS1 UNICODE61 RTREE DBSTAT STSHELL READLINE \	109	EXTENSION TS1 UNICODE61 STSHELL READLINE \
115	FTS3_TOKEN FTS5	110	FTS3_TOKEN FTS5
116	# SECURE_DELETE, UNLOCK_NOTIFY, DBSTAT (since 41.0) used by www/firefox et al.	111	# SECURE_DELETE, UNLOCK_NOTIFY, DBSTAT (since 41.0) used by www/firefox et al.
117	# RTREE used by graphics/mapnik, databases/spatialite	112	# RTREE used by graphics/mapnik, databases/spatialite
Lines 136-145 Link Here
136	TS2_CPPFLAGS= -DSQLITE_TEMP_STORE=2	131	TS2_CPPFLAGS= -DSQLITE_TEMP_STORE=2
137	TS3_CPPFLAGS= -DSQLITE_TEMP_STORE=3	132	TS3_CPPFLAGS= -DSQLITE_TEMP_STORE=3
138		133
139	RTREE_CPPFLAGS= -DSQLITE_ENABLE_RTREE=1
140	RTREE_INT_CPPFLAGS= -DSQLITE_RTREE_INT_ONLY=1	134	RTREE_INT_CPPFLAGS= -DSQLITE_RTREE_INT_ONLY=1
141		135
142	FTS4_CPPFLAGS= -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_FTS4=1	136	FTS4_CPPFLAGS= -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_FTS4=1
143	FTS5_CONFIGURE_ENABLE= fts5	137	FTS5_CONFIGURE_ENABLE= fts5
144	FTS5_LIBS= -lm	138	FTS5_LIBS= -lm
145	FTS3_TOKEN_CPPFLAGS= -DSQLITE_ENABLE_FTS3_TOKENIZER=1	139	FTS3_TOKEN_CPPFLAGS= -DSQLITE_ENABLE_FTS3_TOKENIZER=1
Lines 154-161 Link Here
154	METADATA_CPPFLAGS= -DSQLITE_ENABLE_COLUMN_METADATA=1	148	METADATA_CPPFLAGS= -DSQLITE_ENABLE_COLUMN_METADATA=1
155	STAT3_CPPFLAGS= -DSQLITE_ENABLE_STAT3=1	149	STAT3_CPPFLAGS= -DSQLITE_ENABLE_STAT3=1
156	STAT4_CPPFLAGS= -DSQLITE_ENABLE_STAT4=1	150	STAT4_CPPFLAGS= -DSQLITE_ENABLE_STAT4=1
157	DBPAGE_CPPFLAGS= -DSQLITE_ENABLE_DBPAGE_VTAB=1
158	DBSTAT_CPPFLAGS= -DSQLITE_ENABLE_DBSTAT_VTAB=1
159	URI_CPPFLAGS= -DSQLITE_USE_URI=1	151	URI_CPPFLAGS= -DSQLITE_USE_URI=1
160	URI_AUTHORITY_CPPFLAGS= -DSQLITE_ALLOW_URI_AUTHORITY=1	152	URI_AUTHORITY_CPPFLAGS= -DSQLITE_ALLOW_URI_AUTHORITY=1
161	DIRECT_READ_CPPFLAGS= -DSQLITE_DIRECT_OVERFLOW_READ=1	153	DIRECT_READ_CPPFLAGS= -DSQLITE_DIRECT_OVERFLOW_READ=1
Lines 196-201 Link Here
196		188
197	NULL_TRIM_CPPFLAGS= -DSQLITE_ENABLE_NULL_TRIM=1	189	NULL_TRIM_CPPFLAGS= -DSQLITE_ENABLE_NULL_TRIM=1
198		190
		191	OFFSET_CPPFLAGS= -DSQLITE_ENABLE_OFFSET_SQL_FUNC=1
		192
199	.include <bsd.port.options.mk>	193	.include <bsd.port.options.mk>
200		194
201	# Platform Configuration	195	# Platform Configuration