X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FSQLMaker%2FLimitDialects.pm;h=294c57924784ee4da0c52ea069e3d8a06c6d84f0;hb=4c2b30d6e53cd05e570ad112e87ad6f96355f695;hp=846cab7f753f03d88b891ab183ca856ac8d63393;hpb=3f5b99fea8b445c7a61057f4210a715ffb8e677e;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/SQLMaker/LimitDialects.pm b/lib/DBIx/Class/SQLMaker/LimitDialects.pm index 846cab7..294c579 100644 --- a/lib/DBIx/Class/SQLMaker/LimitDialects.pm +++ b/lib/DBIx/Class/SQLMaker/LimitDialects.pm @@ -202,7 +202,6 @@ SELECT $out_sel FROM ( EOS - $sql =~ s/\s*\n\s*/ /g; # easier to read in the debugger return $sql; } @@ -307,7 +306,6 @@ EOS EOS } - $sql =~ s/\s*\n\s*/ /g; # easier to read in the debugger return $sql; } @@ -390,9 +388,9 @@ sub _Top { # since whatever order bindvals there are, they will be realiased # and need to show up in front of the entire initial inner subquery - # Unshift *from_bind* to make this happen (horrible, horrible, but - # we don't have another mechanism yet) - unshift @{$self->{from_bind}}, @{$self->{order_bind}}; + # *unshift* the selector bind stack to make this happen (horrible, + # horrible, but we don't have another mechanism yet) + unshift @{$self->{select_bind}}, @{$self->{order_bind}}; } # and this is order re-alias magic @@ -433,7 +431,6 @@ sub _Top { $order_by_requested, ) if ( ($offset && $order_by_requested) || ($mid_sel ne $out_sel) ); - $sql =~ s/\s*\n\s*/ /g; # easier to read in the debugger return $sql; } @@ -579,7 +576,6 @@ EOS , ); - $sql =~ s/\s*\n\s*/ /g; # easier to read in the debugger return $sql; }