X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=dbsrgits%2FDBIx-Class.git;a=blobdiff_plain;f=t%2Fresultset%2Fbind_attr.t;h=62f4791f2e3173785bef43073b3c949fe236ae4a;hp=e3fccc98745d8c62aa937733d3ed5adff61a889a;hb=8273e845426f0187b4ad6c4a1b42286fa09a648f;hpb=33eafbfd322ab48a2697c0ea9fadfb182fb22a36 diff --git a/t/resultset/bind_attr.t b/t/resultset/bind_attr.t index e3fccc9..62f4791 100644 --- a/t/resultset/bind_attr.t +++ b/t/resultset/bind_attr.t @@ -49,7 +49,7 @@ TODO: { $new_source->source_name('Complex'); $new_source->name(\<<''); - ( SELECT a.*, cd.cdid AS cdid, cd.title AS title, cd.year AS year + ( SELECT a.*, cd.cdid AS cdid, cd.title AS title, cd.year AS year FROM artist a JOIN cd ON cd.artist = a.artistid WHERE cd.year = ?) @@ -71,7 +71,7 @@ TODO: { $rs->as_query, "(SELECT me.artistid, me.name, me.rank, me.charfield FROM (SELECT a.*, cd.cdid AS cdid, cd.title AS title, cd.year AS year FROM artist a JOIN cd ON cd.artist = a.artistid WHERE cd.year = ?) me WHERE title LIKE ?)", [ - [ {} => '1999' ], + [ {} => '1999' ], [ {} => 'Spoon%' ] ], 'got correct SQL' @@ -100,7 +100,7 @@ TODO: { $rs->as_query, "(SELECT me.artistid, me.name, me.rank, me.charfield FROM (SELECT a.*, cd.cdid AS cdid, cd.title AS title, cd.year AS year FROM artist a JOIN cd ON cd.artist = a.artistid WHERE cd.year = ?) me WHERE title LIKE ?)", [ - [ {} => '1999' ], + [ {} => '1999' ], [ {} => 'Spoon%' ] ], 'got correct SQL (cookbook arbitrary SQL, in separate file)'