DBIish icon indicating copy to clipboard operation
DBIish copied to clipboard

Missing data bug on 32 bit boxes

Open zoffixznet opened this issue 7 years ago • 1 comments

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

zoffixznet avatar Jun 09 '17 19:06 zoffixznet

Is this still an issue on recent DBIish/Raku combinations?

rbt avatar Jun 01 '20 15:06 rbt