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 > 53 9 > 53 37 > > With Version 3.7.8 the result is : > > IdProjet IdActivite > 53 23 > 50 17 > 16 -1 > 20 35 > 20 10
Please tell us what is wrong with one of these sets of output. For instance, if you have lots of rows with the same value in the 'debut' column, both sets of answers might be correct. > You will find enclosed the database for the test : "test.db". You cannot attach files to messages on the mailing list. Ideally create a very small amount of data which demonstrates the problem and give us the commands needed to create it. If your existing data file is short you can use the sqlite3 shell tool on it, issue the command .dump and paste the results into a message. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users