[Dbix-class] SQLite: So someone else can learn from my pain...

[Christopher H. Laco]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> (01:26:39 AM) claco: Just because I keep forgetting and pissing away hours of tinkering....
> (01:27:05 AM) claco: always always ALWAYS do ' USE_LOCAL_SQLITE=1 perl Makefile.PL' when making DBD::SQLite
> (01:27:30 AM) claco: otherwise, some system version of the lib are just plain jacked...breaking joins, even on 1.12

Specifically, libsqlite 3.3.13 breaks some joins under DBD::SQlite 1.12.
When 1.12 is compiled using USE_LOCAL_SQLITE (aka, DON"T USE SYSTEM
LIB), things work just fine. 1.13 doesn't have this problem, which may
mean it is smarter about not using the system lib, or some other bug is
fixed. However, DBD::SQlite 1.13 is also broken on some platforms: the
statement immediately following a pk failure, also fails.

Sometimes, SQLite sucks. Thank god for tests.

- -=Chris


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGhe5I+66dLHM50ssRApzEAJ9h864y6Ca7Ktrg8+Kc+tRc1FaLSwCgm0m0
jXhcJ0iIqIO40y6r0vibiYw=
=MNuH
-----END PGP SIGNATURE-----