X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F61findnot.t;h=b8b0d31c29bd1b2595f0e598693d8301729858ea;hb=people%2Fabraxxa%2Fhas_relationship_loaded;hp=e7f4249a8e7cc8843accfa42fb45c53575601396;hpb=b7743dabe3354b4a43954ec44a226dc1c44722ac;p=dbsrgits%2FDBIx-Class.git diff --git a/t/61findnot.t b/t/61findnot.t index e7f4249..b8b0d31 100644 --- a/t/61findnot.t +++ b/t/61findnot.t @@ -52,21 +52,40 @@ ok($art, 'Artist found by key in the resultset'); # collapsing and non-collapsing are separate codepaths, thus the separate tests + $artist_rs = $schema->resultset("Artist"); + warnings_exist { $artist_rs->find({}) -} qr/\QDBIx::Class::ResultSet::find(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single/ +} qr/\QQuery returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single/ => "Non-unique find generated a cursor inexhaustion warning"; + throws_ok { $artist_rs->find({}, { key => 'primary' }) -} qr/Unable to satisfy constraint 'primary'/; +} qr/Unable to satisfy requested constraint 'primary'/; + +for (1, 0) { + local $ENV{DBIC_NULLABLE_KEY_NOWARN}; + warnings_like + sub { + $artist_rs->find({ artistid => undef }, { key => 'primary' }) + }, + $_ ? [ + qr/undef values supplied for requested unique constraint.+almost certainly not what you wanted/, + ] : [], + 'One warning on NULL conditions for constraint' + ; +} + $artist_rs = $schema->resultset("Artist")->search({}, { prefetch => 'cds' }); + warnings_exist { $artist_rs->find({}) } qr/\QDBIx::Class::ResultSet::find(): Query returned more than one row/, "Non-unique find generated a cursor inexhaustion warning"; + throws_ok { $artist_rs->find({}, { key => 'primary' }) -} qr/Unable to satisfy constraint 'primary'/; +} qr/Unable to satisfy requested constraint 'primary'/; done_testing;