Hemant Shah <hj...@yahoo.com> wrote: > I ran .dump command to dump the data to a file, and ran .read command to read > it into a different database. Now, I could do a > select based upon MD5Sum column. > > Next I edited the output file and changed the table name. I ran .read and > loaded the data into new table in original database. > Now, I could do a select based upon MD5Sum column. > > Any idea what could be wrong?
Does this statement return any rows on the "bad" database file: select * from find_retransmissions where length(MD5Sum) != 32; My guess is, you managed to insert strings into MD5Sum column complete with the trailing NUL byte. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users