10 use DBIC::SqlMakerTest;
12 # This is legacy stuff from SQL::Absract::Limit
13 # Keep it around just in case someone is using it
16 package DBICTest::SQLMaker::CustomDialect;
17 use base qw/DBIx::Class::SQLMaker/;
19 my ($self, $sql, $rs_attrs, $limit, $offset) = @_;
20 return sprintf ('shiny sproc ((%s), %d, %d)',
27 my $s = DBICTest::Schema->connect (DBICTest->_database);
28 $s->storage->sql_maker_class ('DBICTest::SQLMaker::CustomDialect');
30 my $rs = $s->resultset ('CD');
32 warnings_exist { is_same_sql_bind (
33 $rs->search ({}, { rows => 1, offset => 3,columns => [
35 { 'artist.id' => 'bar.id' },
36 { bleh => \ 'TO_CHAR (foo.womble, "blah")' },
41 SELECT foo.id, bar.id, TO_CHAR (foo.womble, "blah")
49 'Rownum subsel aliasing works correctly'
51 qr/\Qthe legacy emulate_limit() mechanism inherited from SQL::Abstract::Limit has been deprecated/,