Arch Linux User Repository

@jazztickets Could you please update the checksum in the PKGBUILD?

i think the checksum is wrong with the recent update. i consistently get 39116c94e76630f22d54cd82c3cea308565f1715f716d1b2527f1c9c969ba4d9 for the source archive.

@Martchus. Thanks for testing. I think there is probably something wrong on my end. Downgrading this package (or mingw-w64-gcc) has no effect. The same packages built on my laptop seem to work fine (although I need to add -lspp to link my example code). Maybe something in my makepkg.conf? I'll need to investigate, but I do not think there is any issue with this package at least.

Thanks again, sorry for the noise.

EDIT Yeah, I had some overly clever default options set in my makepkg.conf. So I fixed it on my end. Apologies again.

Your example compiles/links here without errors:

source mingw-env x86_64-w64-mingw32
x86_64-w64-mingw32-g++ $CXXFLAGS -static -static-libgcc -static-libstdc++ sqlite.cpp -lsqlite3 $LDFLAGS

[~] $ x86_64-w64-mingw32-nm /usr/x86_64-w64-mingw32/lib/libsqlite3.a | "grep" -E "sqlite3_open|sqlite3_close"
00000000 T sqlite3_close
00000000 T sqlite3_close_v2
00000000 T sqlite3_open
00000000 T sqlite3_open16
00000000 T sqlite3_open_v2

Thanks again. I'll just wait a bit and see if it becomes a problem for more people.

I haven't read your message correctly. So the problem happens when linking against the static library. I can try to reproduce it later; otherwise I'll find it out anyways when building the static Qt packages. I'm wondering whether x86_64-w64-mingw32-nm /usr/x86_64-w64-mingw32/lib/libsqlite3.a shows these symbols.

Maybe some of these upstream changes is responsible: https://github.com/sqlite/sqlite/compare/version-3.35.4...version-3.36.0

@Martchus Thanks. Maybe I should clarify that I'm using static linking.

 $ cat main23.cc
extern "C"
{
#include <sqlite3.h>
}

int main()
{
  sqlite3 *db;
  int r = sqlite3_open("databasename", &db);
  if (r == 0)
    sqlite3_close(db);
  return 0;
}
[~] $ x86_64-w64-mingw32-g++ -static main23.cc -L/usr/x86_64-w64-mingw32/lib/ -lsqlite3
/usr/lib/gcc/x86_64-w64-mingw32/11.2.0/../../../../x86_64-w64-mingw32/bin/ld: /tmp/ccnhZKUs.o:main23.cc:(.text+0x1f): undefined reference to `sqlite3_open'
/usr/lib/gcc/x86_64-w64-mingw32/11.2.0/../../../../x86_64-w64-mingw32/bin/ld: /tmp/ccnhZKUs.o:main23.cc:(.text+0x34): undefined reference to `sqlite3_close'
collect2: error: ld returned 1 exit status
[~] $ 

Removing the -static flag results in a succesful compile, but then the exe will not run on Windows because 'sqlite3-0.dll was not found'.

I was able to build it just fine and also didn't get the warning.

Thanks for maintaining this package. Since the latest update, I can't seem to compile against this library anymore. Suddenly I keep getting undefined reference to 'sqlite3_[...]' errors when linking. Neither the project, nor the build process has changed. Anyone else having trouble?

I noticed when building, I get

==> WARNING: Package contains reference to $srcdir
usr/x86_64-w64-mingw32/lib/libsqlite3.a
usr/i686-w64-mingw32/lib/libsqlite3.a

Probably unrelated? But I thought I'd mention it anyway.