1 2 3 Previous Next 37 Replies Latest reply on Jun 7, 2015 1:34 AM by gcatnine

    BUG ? Distinct destroys order in FQL statements

    Vincent_L

      Hi here's a table

       

      value     order

      A              2

      B              1

      A              1

       

      SELECT DISTINCT value FROM Table ORDER BY "order" DESC

       

      I expect

       

      A

      B

       

      But I get

       

      B

      A

       

      So Disctinct doesn't respect the ORDER BY clause. That's very bad IMHO, am I wrong.

       

      P.S : I think it order by recordid internally I guess, rather than from the order clause

        1 2 3 Previous Next