On Sun Jan 12, 2020 at 08:44:26AM +0100, Rafael Sadowski wrote:
> For the upcoming Qt5 update I need sqlite3_column_table_name16:
>
> qhelpgenerator:/usr/local/lib/qt5/plugins/sqldrivers/libqsqlite.so:
> undefined symbol 'sqlite3_column_table_name16'
> ld.so: qhelpgenerator: lazy binding failed!
> Killed
>
> Turns out we're missing those symbols but installing the manpages
> (SQLITE3_COLUMN_DATABASE_NAME(3)):
>
> objdump -tT /usr/local/lib/libsqlite3.so.37.8 | grep sqlite3_column_table
>
> The following diff enables column metadata:
>
> objdump -tT /usr/local/lib/libsqlite3.so.37.9 | grep sqlite3_column_table
> 00000000000426b0 g F .text 0000000000000110 sqlite3_column_table_name
> 00000000000427c0 g F .text 0000000000000110 sqlite3_column_table_name16
> 00000000000427c0 g DF .text 0000000000000110 sqlite3_column_table_name16
> 00000000000426b0 g DF .text 0000000000000110 sqlite3_column_table_name
>
> OK or is there any showstopper here?
>
> Rafael Sadowski
>
Sorry, here is the correct diff:
Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/sqlite3/Makefile,v
retrieving revision 1.105
diff -u -p -u -p -r1.105 Makefile
--- Makefile 9 Nov 2019 10:09:04 -0000 1.105
+++ Makefile 12 Jan 2020 07:55:51 -0000
@@ -4,9 +4,10 @@ COMMENT= embedded SQL implementation
DISTNAME = sqlite-autoconf-3300100
PKGNAME= sqlite3-3.30.1
+REVISION= 0
# XXX needs bumps every time :-
-SHARED_LIBS += sqlite3 37.8 # 8.6
+SHARED_LIBS += sqlite3 37.9 # 8.6
# sqlite suggests that users might like to assert() that library and header
# versions match, so bumps are needed even if function signatures don't change.
# ... at the current time the only one noticed is a < check (in subversion)
@@ -34,7 +35,8 @@ CONFIGURE_ARGS += --enable-fts5
# for mozilla
CFLAGS+= -DSQLITE_ENABLE_UNLOCK_NOTIFY \
-DSQLITE_ENABLE_FTS3 \
- -DSQLITE_ENABLE_DBSTAT_VTAB
+ -DSQLITE_ENABLE_DBSTAT_VTAB \
+ -DSQLITE_ENABLE_COLUMN_METADATA=1
# update p5-DBD-SQLite's Makefile.PL if enabling
-DSQLITE_ENABLE_COLUMN_METADATA
BUILD_DEPENDS = converters/sqlite2mdoc
Index: pkg/PLIST
===================================================================
RCS file: /cvs/ports/databases/sqlite3/pkg/PLIST,v
retrieving revision 1.6
diff -u -p -u -p -r1.6 PLIST
--- pkg/PLIST 16 Jan 2019 20:09:12 -0000 1.6
+++ pkg/PLIST 12 Jan 2020 07:55:51 -0000
@@ -3,7 +3,7 @@
@bin bin/sqlite3
include/sqlite3.h
include/sqlite3ext.h
-lib/libsqlite3.a
+@static-lib lib/libsqlite3.a
lib/libsqlite3.la
@lib lib/libsqlite3.so.${LIBsqlite3_VERSION}
lib/pkgconfig/sqlite3.pc
@@ -102,6 +102,7 @@ lib/pkgconfig/sqlite3.pc
@man man/man3/sqlite3_declare_vtab.3
@man man/man3/sqlite3_deserialize.3
@man man/man3/sqlite3_destructor_type.3
+@man man/man3/sqlite3_drop_modules.3
@man man/man3/sqlite3_enable_load_extension.3
@man man/man3/sqlite3_enable_shared_cache.3
@man man/man3/sqlite3_errcode.3
@@ -165,6 +166,7 @@ lib/pkgconfig/sqlite3.pc
@man man/man3/sqlite3_step.3
@man man/man3/sqlite3_stmt.3
@man man/man3/sqlite3_stmt_busy.3
+@man man/man3/sqlite3_stmt_isexplain.3
@man man/man3/sqlite3_stmt_readonly.3
@man man/man3/sqlite3_stmt_scanstatus.3
@man man/man3/sqlite3_stmt_scanstatus_reset.3
