[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    RE: [sqlite] ANN: Sqlite3Explorer.exe version 1.6
From:       hgibson () cix ! co ! uk (Hugh Gibson)
Date:       2005-06-23 5:52:00
Message-ID: memo.20050623065224.1296I () abc ! mail ! cix ! co ! uk
[Download RAW message or body]

Mike, 

> which version of the dll are you using ? 

I was using 3.2.1. I upgraded to 3.2.2 and got:

---------------------------
sqlite3explorer
---------------------------
Access violation at address 00402E29 in module 'sqlite3Explorer.exe'. 
Write of address 0133CA7D.
---------------------------
OK   
---------------------------

> do you have REFERENCES declarations ? 

No, it's nothing that we use. I'm not even sure what it does! I see it's a 
keyword in the SQLite list but a full search for it doesn't show it 
anywhere else in the SQLite pages.

> can you send me a sample of the data ? 

Well, I can get SQLite3Explorer to crash by creating a new database:

CREATE TABLE t (sValue TEXT);
INSERT INTO T (sValue) VALUES ('HELLO');
// Note: VALUES isn't highlighted as a keyword; VALUE is (bug)
SELECT * FROM T;
INSERT INTO T (sValue) VALUES 
('012345678901234567890123456789012345678901234567890123456789012345678901
2345678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789');

That's 1000 characters (plus odd CRLF) and is OK when doing another 
SELECT, but note that the saved query can't be recalled from history.
Now continue in that way, creating 10,000+ characters in the insert. The 
insert runs OK, but you get crashes when selecting the table and doing 
Show Data. There are also problems when you close the program.

At one point I got problems in the query editor creating a big query. I 
wasn't able to repeat that, with a query up to 1 MB big.

Hugh
 
> > -----Original Message-----
> > From: Hugh Gibson [mailto:hgibson@cix.co.uk] 
> > Sent: Wednesday, June 22, 2005 4:22 PM
> > To: sqlite-users@sqlite.org
> > Subject: Re: [sqlite] ANN: Sqlite3Explorer.exe version 1.6
> > 
> > Just got a crash when viewing table data using SQLite3Explorer version
> > 1.6:
> >  <snip>
> > The only thing that could affect this is that I had some 
> > fields with lots of data, probably around 100k.
[prev in list] [next in list] [prev in thread] [next in thread]