Bug#819782: libdatabase-dump-perl: FTBFS: t/dumptruck.t failure

[László Böszörményi (GCS)]

Hi Niko,

On Sat, Apr 2, 2016 at 11:02 AM, Niko Tyni <ntyni at debian.org> wrote:
> Package: libdatabase-dumptruck-perl
> Version: 1.2-2
[...]
> As noticed by the ci.debian.net test setup, this package
> currently fails its test suite, making it fail to build.
>
>  https://ci.debian.net/packages/libd/libdatabase-dumptruck-perl/unstable/amd64/
>
>   #   Failed test 'Array variable retrieved'
>   #   at t/dumptruck.t line 133.
>   #     Structures begin differing at:
>   #          $got = '[666]'
>   #     $expected = ARRAY(0x29fbef8)
>   # Looks like you failed 1 test of 43.
[...]
> I don't see anything clearly fitting in the SQLite 3.12 release notes at
>  http://sqlite.org/releaselog/3_12_0.html
> so maybe it's a regression?
>
> Needs further investigation, but cc'ing the sqlite3 maintainer as a heads-up.
 I think the reason can be two things, quoting SQLite3 upstream:
- The SQLITE_DEFAULT_PAGE_SIZE is increased from 1024 to 4096.
- The SQLITE_DEFAULT_CACHE_SIZE is changed from 2000 to -2000 so the
same amount of cache memory is used by default.

There's a detailed description[1] on these, but upstream emphasize:
"Not a Compatibility Break" / "The only thing that is changing is some
default settings. This should result in a performance increase for
many applications.".
I think libdatabase-dumptruck-perl upstream should be noted about this
issue. May check it locally, but please don't take my word on it.

Regards,
Laszlo/GCS
[1] http://sqlite.org/pgszchng2016.html