7 use DBIC::SqlMakerTest;
9 my $schema = DBICTest->init_schema;
11 delete $schema->storage->_sql_maker->{_cached_syntax};
12 $schema->storage->_sql_maker->limit_dialect ('RowNumberOver');
14 my $rs_selectas_rno = $schema->resultset ('BooksInLibrary')->search ({}, { '+select' => ['owner.name'], '+as' => ['owner_name'], join => 'owner', rows => 1 });
16 is_same_sql_bind( $rs_selectas_rno->search({})->as_query,
18 me.id, me.source, me.owner, me.title, me.price,
22 ROW_NUMBER() OVER( ) AS rno__row__index
24 (SELECT me.id, me.source, me.owner, me.title, me.price, owner.name
26 JOIN owners owner ON owner.id = me.owner
30 JOIN owners owner ON owner.id = me.owner
31 WHERE rno__row__index BETWEEN 1 AND 1 )",
32 [ [ 'source', 'Library' ] ],