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. I know Sqlite to be considered an ubiquitous database if any, so I was surprised to see this sort of behavior. Can anyone else duplicate or explain what may be wrong with either Sqlite or my expectations from my SQL statement? Thanks, Tim _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
