X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fsearch%2Fselect_chains.t;h=58b6ff0d66618e425684503832396113181f31f5;hb=6b2fbbf0102269df6dac9178697467eb5d3dd8e6;hp=aa428cc5585796b5af41f88a73d45be1993c1053;hpb=442363e5a2a0d2b9c19d55985c35f6c3b9d90149;p=dbsrgits%2FDBIx-Class.git diff --git a/t/search/select_chains.t b/t/search/select_chains.t index aa428cc..58b6ff0 100644 --- a/t/search/select_chains.t +++ b/t/search/select_chains.t @@ -23,7 +23,7 @@ my @chain = ( '+columns' => [ { max_year => { max => 'me.year' }}, ], '+select' => [ { count => 'me.cdid' }, ], '+as' => [ 'cnt' ], - } => 'SELECT me.cdid, MAX( me.year ), LOWER( title ), me.genreid, COUNT( me.cdid ) FROM cd me', + } => 'SELECT me.cdid, LOWER( title ), MAX( me.year ), me.genreid, COUNT( me.cdid ) FROM cd me', { select => [ { min => 'me.cdid' }, ], @@ -32,7 +32,7 @@ my @chain = ( { '+columns' => [ { cnt => { count => 'cdid' } } ], - } => 'SELECT COUNT ( cdid ), MIN( me.cdid ) FROM cd me', + } => 'SELECT MIN( me.cdid ), COUNT ( cdid ) FROM cd me', { columns => [ 'year' ], @@ -58,4 +58,4 @@ while (@chain) { $testno++; } -done_testing; \ No newline at end of file +done_testing;