On Jul 30, 2008, at 7:14 PM, Tim Dao wrote: > I ran into strange behavior in dealing with Sqlite 3.5.9 on a 6 > million > record table I was using in development and wanted to see if I could > duplicate the error in an entirely separate instance so I tried it > from > Firefox 3.0 + SqliteManager Plugin much to the same effect. > > Basically when running a group by query where you want to attain > counts of > dupes, i.e. > ==== > select fieldname, count(1) from moz_formhistory > where fieldname is not null > group by fieldname having count(1) > 1; > ==== > I get corrupted fieldnames with correct counts. > > ==== > select fieldname, count(1) from moz_formhistory > --where fieldname is not null > group by fieldname having count(1) > 1; > ==== > Running the above yields correct results.
This is the same problem reported by ticket #3201 http://www.sqlite.org/cvstrac/tktview?tn=3201 which would fixed by check-in [5341] http://www.sqlite.org/cvstrac/chngview?cn=5341 on 2008-07-04. The fix appears in SQLite release 3.6.0. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
