Re: [sqlite] Problem with a SELECT DISTINCT query in Version : 3.7.8

On 29 Sep 2011, at 9:27am, Patrick Villette wrote: > select distinct IdProjet, IdActivite from Taches where Deleted=0 order by > Debut desc limit 5 > > With Version 3.7.7.1 the result ( which seems correct ) is : > > IdProjet IdActivite > 53 23 > 23 9 > 5 17 >

[sqlite] Problem with a SELECT DISTINCT query in Version : 3.7.8

Hi, I noticed differences in the result of a "SELECT DISTINCT" query between version 3.7.7.1 and 3.7.8 The query is : select distinct IdProjet, IdActivite from Taches where Deleted=0 order by Debut desc limit 5 With Version 3.7.7.1 the result ( which seems correct ) is : IdProjet