AnsweredAssumed Answered

BUG ? Distinct destroys order in FQL statements

Question asked by Vincent_L on Jun 1, 2015
Latest reply on Jun 7, 2015 by gcatnine

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

Outcomes