7 use DBIC::SqlMakerTest;
9 my $schema = DBICTest->init_schema();
10 $schema->storage->sql_maker->quote_char ('"');
11 $schema->storage->sql_maker->name_sep ('.');
13 my $rs = $schema->resultset('CD')->search({}, {
16 { -length => 'me.title' },
19 count => 'tracks.trackid',
31 SELECT "me"."cdid", "me"."artist", "me"."title", "me"."year", "me"."genreid", "me"."single_track"
33 LEFT JOIN "track" "tracks" ON "tracks"."cd" = "me"."cdid"
34 GROUP BY "me"."cdid", "me"."artist", "me"."title", "me"."year", "me"."genreid", "me"."single_track"
36 LENGTH( "me"."title" ),
37 COUNT( "tracks"."trackid" ) DESC
41 'order by with func query',
44 ok($rs->count_rs->next == 2, 'amount of rows return in order by func query');
46 [ $rs->get_column ('me.title')->all ],
47 [ "Caterwaulin' Blues", "Come Be Depressed With Us" ],
48 'Correctly ordered stuff by title-length',