Use connect_by OR connect_by_nocycle

[dbsrgits/DBIx-Class.git] / t / search / select_chains.t

diff --git a/t/search/select_chains.t b/t/search/select_chains.t
index aa428cc..58b6ff0 100644 (file)
--- 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;