X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F61findnot.t;h=b8b0d31c29bd1b2595f0e598693d8301729858ea;hb=dbcd18a7224e70a2b1fe0a369397819569376c85;hp=6d23dc9ced50449cd86535eb728968a56e0944cf;hpb=cf48da0c9ecff776e12d1f194c3be24b8079f1f4;p=dbsrgits%2FDBIx-Class.git diff --git a/t/61findnot.t b/t/61findnot.t index 6d23dc9..b8b0d31 100644 --- a/t/61findnot.t +++ b/t/61findnot.t @@ -52,19 +52,38 @@ 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 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 requested constraint 'primary'/;