9 use DBIC::SqlMakerTest;
11 # This is legacy stuff from SQL::Absract::Limit
12 # Keep it around just in case someone is using it
15 package DBICTest::SQLMaker::CustomDialect;
16 use base qw/DBIx::Class::SQLMaker/;
18 my ($self, $sql, $rs_attrs, $limit, $offset) = @_;
19 return sprintf ('shiny sproc ((%s), %d, %d)',
26 my $s = DBICTest::Schema->connect (DBICTest->_database);
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'