Bug#766501: libdbd-sqlite3-perl: 'order by random limit 1' not random

[Pablo Virgo]

Package: libdbd-sqlite3-perl
Version: 1.40-2
Severity: important

Dear Maintainer,

I'm working on a small perl script that pulls random records from an sqlite3
database.  Typically, as with the sqlite interface or cpan installations of
this module, I can do this with a simple "ORDER BY RANDOM() LIMIT 1" clause.
For some reason, when I use the .deb package version of the library, the result
of that clause is always the first matching database record rather than a
random one.



-- System Information:
Debian Release: jessie/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.11-2-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages libdbd-sqlite3-perl depends on:
ii  libc6                         2.17-97
ii  libdbi-perl [perl-dbdabi-94]  1.630-1
ii  libsqlite3-0                  3.8.1-1
ii  perl                          5.18.1-4
ii  perl-base [perlapi-5.18.1]    5.18.1-4

libdbd-sqlite3-perl recommends no packages.

libdbd-sqlite3-perl suggests no packages.

-- no debconf information