Re: [sqlite] NULL data .dump command
Hi All,
Any hints!
I have no problem with executing the followng sql : select * from signature
but if I run this : select * from sig order by peerid; then I got the error
message:
SQL error: database disk image is malformed
I have index on peerid and I don't know why the second select has problem?
Any idea!
Thanks,
JP
From: Joanne Pham
To: General Discussion of SQLite Database
Sent: Tuesday, June 16, 2009 3:41:17 PM
Subject: Re: [sqlite] NULL data .dump command
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
To: General Discussion of SQLite Database
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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] NULL data .dump command
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
To: General Discussion of SQLite Database
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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
