9 my $schema = DBICTest->init_schema( no_populate => 1, quote_names => 1 );
11 $schema->resultset('CD')->create({
14 artist => { name => 'JMJ' },
15 genre => { name => 'electro' },
26 artist => { name => 'JMJ' },
31 my $cd = $schema->resultset('CD')->search({ single_track => { '!=', undef } })->first;
33 $schema->is_executed_sql_bind(
34 sub { is( eval{$cd->single_track_opaque->title}, 'o1', 'Found correct single track' ) },
37 'SELECT "me"."trackid", "me"."cd", "me"."position", "me"."title", "me"."last_updated_on", "me"."last_updated_at"
40 ON me.trackid = cd__row.single_track
41 WHERE "cd__row"."cdid" = ?
44 { dbic_colname => "cd__row.cdid", sqlt_datatype => "integer" }