10 my $schema = DBICTest->init_schema();
12 my $rs = $schema->resultset ('CD')->search ({}, {
14 { substr => [ 'title', 1, 1 ], -as => 'initial' },
17 as => [qw/title_initial cnt/],
18 group_by => ['initial'],
19 order_by => { -desc => 'initial' },
20 result_class => 'DBIx::Class::ResultClass::HashRefInflator',
26 { title_initial => 'S', cnt => '1' },
27 { title_initial => 'G', cnt => '1' },
28 { title_initial => 'F', cnt => '1' },
29 { title_initial => 'C', cnt => '2' },
34 is ($rs->count, 4, 'Correct count');