INNER JOIN `artist` `artist` ON `artist`.`artistid` = `me`.`artist`
)',
[],
- 'overriden default join type works',
- );
-}
-
-{
- # Test support for straight joins
- my $cdsrc = $schema->source('CD');
- my $artrel_info = $cdsrc->relationship_info ('artist');
- $cdsrc->add_relationship(
- 'straight_artist',
- $artrel_info->{class},
- $artrel_info->{cond},
- { %{$artrel_info->{attrs}}, join_type => 'straight' },
- );
- is_same_sql_bind (
- $cdsrc->resultset->search({}, { prefetch => 'straight_artist' })->as_query,
- '(
- SELECT `me`.`cdid`, `me`.`artist`, `me`.`title`, `me`.`year`, `me`.`genreid`, `me`.`single_track`,
- `straight_artist`.`artistid`, `straight_artist`.`name`, `straight_artist`.`rank`, `straight_artist`.`charfield`
- FROM cd `me`
- STRAIGHT_JOIN `artist` `straight_artist` ON `straight_artist`.`artistid` = `me`.`artist`
- )',
- [],
- 'straight joins correctly supported for mysql'
+ 'overridden default join type works',
);
}
my $artist = $artist2_rs->single;
- is $artist => undef
+ is $artist => undef,
=> 'Nothing Found!';
}