X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FData%2FQuery%2FRenderer%2FSQL%2FNaive.pm;fp=lib%2FData%2FQuery%2FRenderer%2FSQL%2FNaive.pm;h=a84981bc36e120c0a4ab915edcc06e2be7538084;hb=db628d9ab39bf80f88432a1c2cc749152e5ff13d;hp=dbe4b80473482be9293b360db3b37695b55d2127;hpb=9ee59b74604a36e63fed2056db7770342aa0a478;p=dbsrgits%2FData-Query.git diff --git a/lib/Data/Query/Renderer/SQL/Naive.pm b/lib/Data/Query/Renderer/SQL/Naive.pm index dbe4b80..a84981b 100644 --- a/lib/Data/Query/Renderer/SQL/Naive.pm +++ b/lib/Data/Query/Renderer/SQL/Naive.pm @@ -379,8 +379,8 @@ sub _order_chunk { ($dq->{reverse} ? $self->_format_keyword('DESC') : ()), - ($dq->{nulls} - ? $self->_format_keyword('NULLS '.('', qw(FIRST LAST))[$dq->{nulls}]) + ($dq->{nulls} && $dq->{nulls} =~ /^(first|last)$/i + ? $self->_format_keyword('NULLS '.$dq->{nulls}) : ()), ); }