Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Missing data bug on 32 bit boxes #93

Open
zoffixznet opened this issue Jun 9, 2017 · 1 comment
Open

Missing data bug on 32 bit boxes #93

zoffixznet opened this issue Jun 9, 2017 · 1 comment

Comments

@zoffixznet
Copy link
Contributor

zoffixznet commented Jun 9, 2017

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
@rbt
Copy link
Collaborator

rbt commented Jun 1, 2020

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants