don't gensym for unqualified versions of already selected columns

[dbsrgits/Data-Query.git] / lib / Data / Query / Renderer / SQL / Slice / FetchFirst.pm

diff --git a/lib/Data/Query/Renderer/SQL/Slice/FetchFirst.pm b/lib/Data/Query/Renderer/SQL/Slice/FetchFirst.pm
index 0bb96e0..3cea06e 100644 (file)
--- a/lib/Data/Query/Renderer/SQL/Slice/FetchFirst.pm
+++ b/lib/Data/Query/Renderer/SQL/Slice/FetchFirst.pm
@@ -15,6 +15,10 @@ sub _render_slice_limit {
   ];
 }
 
+sub slice_subquery {
+  (offset => 1);
+}
+
 sub slice_stability {
   (offset => 'requires');
 }
@@ -72,7 +76,7 @@ sub _render_slice {
               : (),
           ],
           compose {
-            Order($b->{by}, !$b->{reverse}, -$b->{nulls}, $a)
+            Order($b->{by}, !$b->{reverse}, -($b->{nulls}||0), $a)
           } (
             @outside_order,
             Alias(