DBIish
DBIish copied to clipboard
Missing data bug on 32 bit boxes
This is a bit of a weird bug. The SQLite table contains 1663 rows, but when I fetch all with DBIish, only 12 to 155 rows get fetched.
I couldn't repro the bug on 64-bit boxes or with a golfed module. The bug also disappears if I make this line be eager
.
The number of rows occasionally varies per iteration or if I set --optimize=off
or if I run it from a different directory, suggesting this may be some Rakudo bug.
Here are the steps to repro that include the links to database and the module that uses DBIish. If you get 1663 after running the last line, try running it a couple more times.
cd $(mktemp -d)
wget https://temp.perl6.party/2017-06-09.toast.sqlite.db
mkdir -p 'lib/Toaster'
(cd 'lib/Toaster';
wget https://raw.githubusercontent.com/zoffixznet/perl6-Toaster/563cb36df331c85b0737033d7ceaea98fdc5de8a/lib/Toaster/DB.pm6)
perl6 -Ilib -MToaster::DB -e 'Toaster::DB.new(:db("2017-06-09.toast.sqlite.db")).all.elems.say'
I'm on:
$ perl6 -v
This is Rakudo version 2017.05-363-gf974dcc built on MoarVM version 2017.05-59-gf17adad
implementing Perl 6.c.
$ lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description: Debian GNU/Linux 7.2 (wheezy)
Release: 7.2
Codename: wheezy
$ uname -a
Linux b-webdev-dt 3.2.0-4-686-pae #1 SMP Debian 3.2.51-1 i686 GNU/Linux
$ zef info DBIish
- Info for: DBIish
- Identity: DBIish:ver('0.5.10')
- Recommended By: /home/zoffix/.rakudobrew/moar-nom/install/share/perl6/site
Description: Database connectivity for Perl 6
License: BSD-2-Clause
Source-url: git://github.com/perl6/DBIish.git
Provides: 27 modules
Depends: 1 items
Is this still an issue on recent DBIish/Raku combinations?