Skip Menu |

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBIx-Class-Helpers CPAN distribution.

Report information
The Basics
Id: 91977
Status: resolved
Priority: 0/
Queue: DBIx-Class-Helpers
People
Owner: Nobody in particular
Requestors: zefram [...] fysh.org
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Thu Jan 09 10:19:46 2014 zefram [...] fysh.org - Ticket created
Subject: warning from test suite
Date: Thu, 9 Jan 2014 15:19:30 +0000
To: bug-DBIx-Class-Helpers [...] rt.cpan.org
From: Zefram <zefram [...] fysh.org>
Test generates warning: Use of uninitialized value $count in numeric lt (<) at /opt/perl-5.18.2/lib/site_perl/5.18.2/DBIx/Class/ResultSet.pm line 1619. t/schema/lint-contents.t ............... ok -zefram
  Fri Jan 10 08:47:43 2014 frioux [...] gmail.com - Correspondence added
Subject: Re: [rt.cpan.org #91977] warning from test suite
Date: Fri, 10 Jan 2014 07:47:29 -0600
To: Zefram via RT <bug-DBIx-Class-Helpers [...] rt.cpan.org>
From: fREW Schmidt <frioux [...] gmail.com>
This is actually a bug in DBIx::Class and/or SQLite. Basically if you have a resultset and call count on it, if there were no rows, SQLite returns NULL/undef (which I think is standard) and DBIx::Class does this, which warns: https://metacpan.org/source/RIBASUSHI/DBIx-Class-0.08250/lib/DBIx/Class/ResultSet.pm#L1619 Will close this when I can log into RT. -- fREW Schmidt http://blog.afoolishmanifesto.com
Download (untitled)
application/pgp-signature 836b

Message body not shown because it is not plain text.

  Fri Jan 10 08:47:43 2014 The RT System itself - Status changed from 'new' to 'open'
  Fri Jan 10 08:55:41 2014 zefram [...] fysh.org - Correspondence added
Subject: Re: [rt.cpan.org #91977] warning from test suite
Date: Fri, 10 Jan 2014 13:55:28 +0000
To: Frew Schmidt via RT <bug-DBIx-Class-Helpers [...] rt.cpan.org>
From: Zefram <zefram [...] fysh.org>
Frew Schmidt via RT wrote: Show quoted text
>This is actually a bug in DBIx::Class and/or SQLite.
Thanks for the explanation. I've rereported it as a bug in DBIx-Class, <https://rt.cpan.org/Ticket/Display.html?id=92028>. -zefram
  Fri Jan 10 09:39:27 2014 ribasushi [...] leporine.io - Correspondence added
Subject: Re: [rt.cpan.org #91977] warning from test suite
Date: Fri, 10 Jan 2014 14:39:14 +0000
To: Zefram via RT <bug-DBIx-Class-Helpers [...] rt.cpan.org>
From: Peter Rabbitson <ribasushi [...] cpan.org>
Frew Schmidt via RT wrote: Show quoted text
> This is actually a bug in DBIx::Class and/or SQLite. Basically if you > have a resultset and call count on it, if there were no rows, SQLite > returns NULL/undef (which I think is standard)
Nonsense. A COUNT() function always returns an integer, not only in SQLite but any RDBMS I've ever seen (a lot of stuff would break if this was not the case). The problem is that ::AutoRemoveColumns is broken (and evidently undertested). It does not allow one to specify an explicit selection list (which is what the DBIC core code correctly does here [1]) - it will always add the default list on its own (since it does not do a proper secondary ->search() chain). The result is: perl -Ilib -It/lib -MTestSchema -e 'my $s = TestSchema->deploy_or_connect; $s->storage->debug(1); $s->resultset("Bloaty")->count' SELECT "me"."id", COUNT( * ) FROM "Bloaty" "me": Use of uninitialized value $count in numeric lt (<) at /home/rabbit/perl5/perlbrew/perls/5.16.2/lib/site_perl/5.16.2/DBIx/Class/ResultSet.pm line 1619. Not a DBIC bug, will close 92028 when PAUSE is back. [1] https://github.com/dbsrgits/dbix-class/blob/master/lib/DBIx/Class/ResultSet.pm#L1673
  Sun Jan 12 14:35:55 2014 ribasushi [...] leporine.io - Reference by ticket #92028 added
  Sun Apr 06 12:45:07 2014 frioux [...] gmail.com - Correspondence added
Fixed in 2.021001
  Sun Apr 06 12:45:08 2014 frioux [...] gmail.com - Status changed from 'open' to 'resolved'