Hi All, I ran two queries: 1) select * from signature; I didn't see the "SQL error: database disk image is malformed"
2) But if I ran the "select * from sig order by peerid;" then I have seen the malformed ....................................... 11020876449360377856|345049073990|1276|368|230383|1857|1245183730|2|0 SQL error: database disk image is malformed Is the index corruped some where? Your help is greatly appreciated. Thanks, JP ________________________________ From: Joanne Pham <[email protected]> To: General Discussion of SQLite Database <[email protected]> Sent: Tuesday, June 16, 2009 3:26:37 PM Subject: [sqlite] NULL data .dump command Hi All, I have the table is defined as below: CREATE TABLE `signature` ( `sig` char(50) NOT NULL, `id' bigint(20) default '0', .... But I have ran the folowing command: .output mySelect select * from signature; then I didn't see NULL values in the mySelect file at all But I ran the following command: .output myDump .dump signature then I viewed the file it has the following NULL values INSERT INTO "signature" VALUES('573535428650752000',345049073990,1294,365,230296,414,1245183707,2,'0'); INSERT INTO "signature" VALUES(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); even though sig is defined as NOT NULL but why I have NULL for some of these insert statement in my dump but not in select. Thanks, JP _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
