8 use DBIC::SqlMakerTest;
10 # This is legacy stuff from SQL::Absract::Limit
11 # Keep it around just in case someone is using it
14 package DBICTest::SQLMaker::CustomDialect;
15 use base qw/DBIx::Class::SQLMaker/;
17 my ($self, $sql, $rs_attrs, $limit, $offset) = @_;
18 return sprintf ('shiny sproc ((%s), %d, %d)',
26 my $s = DBICTest::Schema->connect ('dbi:SQLite::memory:');
27 $s->storage->sql_maker_class ('DBICTest::SQLMaker::CustomDialect');
29 my $rs = $s->resultset ('CD');
31 $rs->search ({}, { rows => 1, offset => 3,columns => [
33 { 'bar.id' => 'bar.id' },
34 { bleh => \ 'TO_CHAR (foo.womble, "blah")' },
39 SELECT foo.id, bar.id, TO_CHAR (foo.womble, "blah")
47 'Rownum subsel aliasing works correctly'