X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F88result_set_column.t;h=615d8aa4bd0e05d379f0428daa86b88b4dcee2ec;hb=0bf5c67eb6282d2efdd43652643a3f3d80ed7e66;hp=dde817c2186ec974f6d2c1a8afbb93b895f7cf5b;hpb=b7c7995572f865613e5a1907189ac23d8b52c690;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/t/88result_set_column.t b/t/88result_set_column.t index dde817c..615d8aa 100644 --- a/t/88result_set_column.t +++ b/t/88result_set_column.t @@ -1,14 +1,22 @@ use strict; -use warnings; +use warnings; use Test::More; +use Test::Warn; use Test::Exception; use lib qw(t/lib); use DBICTest; my $schema = DBICTest->init_schema(); -my $rs = $schema->resultset("CD")->search({}, { order_by => 'cdid' }); +my $rs = $schema->resultset("CD"); + +cmp_ok ( + $rs->count, + '!=', + $rs->search ({}, {columns => ['year'], distinct => 1})->count, + 'At least one year is the same in rs' +); my $rs_title = $rs->get_column('title'); my $rs_year = $rs->get_column('year'); @@ -31,6 +39,18 @@ is($rs_year->next, 1999, "reset okay"); is($rs_year->first, 1999, "first okay"); +warnings_exist (sub { + is($rs_year->single, 1999, "single okay"); +}, qr/Query returned more than one row/, 'single warned'); + + +# test distinct propagation +is_deeply ( + [$rs->search ({}, { distinct => 1 })->get_column ('year')->all], + [$rs_year->func('distinct')], + 'distinct => 1 is passed through properly', +); + # test +select/+as for single column my $psrs = $schema->resultset('CD')->search({}, {