> Hi All, > We have been using SQLite 3.4.2 for some time. On investigating > upgrading to 3.6.2, we found that different results were produced for > one query. > The following illustrates: >
... > > On 3.4.2 we get: > 3.0|3660.5|3 > 6.0|1360.3|6 > > On 3.6.2 we get: > |5020.8|3 > 3.6.2 has a bug involving DISTINCT or GROUP BY queries that use expression aliases (AS clauses) in the select-list. Problem is fixed in cvs: http://www.sqlite.org/cvstrac/chngview?cn=5712 Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users