use Test::More;
use Test::Exception;
+use Test::Warn;
use lib qw(t/lib);
use DBICTest;
-use DBIC::SqlMakerTest;
-use DBIC::DebugObj;
my $schema = DBICTest->init_schema();
is($cd8->title, $cd1->title, 'title is correct');
is($cd8->year, $cd1->year, 'year is correct');
+# Add an extra row to potentially confuse the query
+$schema->resultset('CD')->create ({
+ artist => 2,
+ title => $title,
+ year => 2022,
+});
my $cd9 = $artist->cds->update_or_create(
{
cdid => $cd1->cdid,
# make sure the ident condition is assembled sanely
{
- my $artist = $schema->resultset('Artist')->next;
-
- my ($sql, @bind);
- $schema->storage->debugobj(DBIC::DebugObj->new(\$sql, \@bind)),
- $schema->storage->debug(1);
-
- $artist->discard_changes;
-
- is_same_sql_bind (
- $sql,
- \@bind,
- 'SELECT me.artistid, me.name, me.rank, me.charfield FROM artist me WHERE me.artistid = ?',
- [qw/'1'/],
- );
-
- $schema->storage->debug(0);
- $schema->storage->debugobj(undef);
+ my $artist = $schema->resultset('Artist')->find(1);
+
+ $schema->is_executed_sql_bind( sub { $artist->discard_changes }, [
+ [
+ 'SELECT me.artistid, me.name, me.rank, me.charfield FROM artist me WHERE me.artistid = ?',
+ [ { dbic_colname => "me.artistid", sqlt_datatype => "integer" } => 1 ],
+ ]
+ ], 'Expected query on discard_changes');
}
{
} qr/\Qadd_unique_constraint() does not accept multiple constraints, use add_unique_constraints() instead\E/,
'add_unique_constraint throws when more than one constraint specified';
}
+# make sure NULL is not considered condition-deterministic
+my $art_rs = $schema->resultset('Artist')->search({}, { order_by => 'artistid' });
+$art_rs->create ({ artistid => $_ + 640, name => "Outranked $_" }) for (1..2);
+warnings_are {
+ is(
+ $art_rs->find ({ artistid => 642, rank => 13, charfield => undef })->name,
+ 'Outranked 2',
+ 'Correct artist retrieved with find'
+ );
+ is (
+ $art_rs->search({ charfield => undef })->find ({ artistid => 642, rank => 13 })->name,
+ 'Outranked 2',
+ 'Correct artist retrieved with find'
+ );
+} [], 'no warnings';
done_testing;