8 use DBICTest ':DiffSQL';
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)',
25 my $s = DBICTest->connect_schema (DBICTest->_database);
26 $s->storage->sql_maker_class ('DBICTest::SQLMaker::CustomDialect');
28 my $rs = $s->resultset ('CD');
30 warnings_exist { is_same_sql_bind (
31 $rs->search ({}, { rows => 1, offset => 3,columns => [
33 { 'artist.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'
49 qr/\Qthe legacy emulate_limit() mechanism inherited from SQL::Abstract::Limit has been deprecated/,