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 IdActivite
53 23
23 9
5 17
53 9
53 37
With Version 3.7.8 the result is :
IdProjet IdActivite
53 23
50 17
16 -1
20 35
20 10
You will find enclosed the database for the test : "test.db".
Regards.
Patrick.
--
*Patrick Villette*
*Innovation Net*
courriel : patrick.ville...@innovation-net.fr
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users