Fix PubSub RSM on get_items (#1147)

1 files changed, 4 insertions, 7 deletions

diff --git a/src/node_flat_sql.erl b/src/node_flat_sql.erl
index 7b8ee552c..0869f531c 100644
--- a/src/node_flat_sql.erl
+++ b/src/node_flat_sql.erl
@@ -686,13 +686,10 @@ get_items(Nidx, _From,
 	    #rsm_in{max = M, direction = Direction, id = I, index = IncIndex}) ->
     Max = ejabberd_sql:escape(jlib:i2l(M)),
     {Way, Order} = case Direction of
-	%     aft -> {<<"<">>, <<"desc">>};
-	%     before when I == <<>> -> {<<"is not">>, <<"asc">>};
-	%     before -> {<<">">>, <<"asc">>};
-	%     _ when IncIndex =/= undefined ->
-	%         {<<"<">>, <<"desc">>}; % using index
-	_ ->
-	    {<<"is not">>, <<"desc">>}% Can be better
+	     aft when I == <<>> -> {<<"is not">>, <<"desc">>};
+	     aft -> {<<"<">>, <<"desc">>};
+	     before when I == <<>> -> {<<"is not">>, <<"asc">>};
+	     before -> {<<">">>, <<"asc">>}
     end,
     SNidx = integer_to_binary(Nidx),
     [AttrName, Id] = case I of