[sqlite] Compiling on SCO OSR5

2005-09-05 Thread Nigel Ball
Hello: I have compiled sqlite3.2.5 on OSR5 using gcc 2.95 and run the fulltest set. This results in a large number of failures of the crash tests all of which have the following format crash-4.2.1036.1... Expected: [1 {child process exited abnormally}] Got: [1

[sqlite] bug in sqlite 3.2.5 compilation and ANALYZE

2005-09-05 Thread Cariotoglou Mike
I tried the ANALYZE statement with sqlite 3.2.5 in dll form, (both the pre-compiled version downloaded from the site, AND a local compilation). in both cases, the statement fails with an ACCESS VIOLATION. however, the same statement, when run from the pre-compiled sqlite3.exe, works. further,

RE: [sqlite] bug in sqlite 3.2.5 compilation and ANALYZE

2005-09-05 Thread Ned Batchelder
Perhaps you could provide the exact SQL that crashed. The code seems to be very well tested automatically, so it is very unlikely that all ANALYZE executions fail. --Ned. http://nedbatchelder.com -Original Message- From: Cariotoglou Mike [mailto:[EMAIL PROTECTED] Sent: Monday, 05

RE: [sqlite] bug in sqlite 3.2.5 compilation and ANALYZE

2005-09-05 Thread Cariotoglou Mike
ok. I use sqlite3Explorer (which should not matter), I create a new database, then I run : create table test1(id integer); analyze this crashes immediately, with dll 3.2.5. it works fine from the command-line. > -Original Message- > From: Ned Batchelder [mailto:[EMAIL PROTECTED] >

Re: [sqlite] Problems with threadsafe opt correction #2623

2005-09-05 Thread Ian Monroe
I do not see how such a major change can be justified in a minor point release. For instance, currently amaroK does not work when using a sqlite database on Debian Sid since they package it with sqlite 3.2.5. Shouldn't this have waited for 4.0? On Wed, 31 Aug 2005 05:38:05 -0700 D. Richard Hipp

RE: [sqlite] bug in sqlite 3.2.5 compila tion and ANALYZE

2005-09-05 Thread Miha Vrhovnik
"Cariotoglou Mike" <[EMAIL PROTECTED]> je ob 5.9.2005 14:49:54 napisal(a): >ok. >I use sqlite3Explorer (which should not matter), I create a new >database, then I run : > >create table test1(id integer); >analyze > >this crashes immediately, with dll 3.2.5. it works fine from the >command-line. >

RE: [sqlite] Null values in Primary Key

2005-09-05 Thread Matt Froncek
Thanks, and sorry on a good day I knew that. My real issue is: CREATE TABLE "Test" ("A" VARCHAR(36) COLLATE NOCASE, "B" VARCHAR(36) COLLATE NOCASE, PRIMARY KEY("A", "B")) INSERT INTO Test("A", "B") VALUES ('1', '1') --> No Error INSERT INTO Test("A", "B") VALUES ('1', '1') --> Duplicate Error

Re: [sqlite] Problems with threadsafe opt correction #2623

2005-09-05 Thread D. Richard Hipp
On Mon, 2005-09-05 at 10:57 -0500, Ian Monroe wrote: > I do not see how such a major change can be justified in a minor point > release. For instance, currently amaroK does not work when using a > sqlite database on Debian Sid since they package it with sqlite 3.2.5. > > Shouldn't this have

Re: [sqlite] Problems with threadsafe opt correction #2623

2005-09-05 Thread D. Richard Hipp
On Mon, 2005-09-05 at 18:36 +0200, Tobias Rundström wrote: > How "expensive" is it to open a new sqlite3 handler? The schema has to be read and parsed. Usually that is very quick - SQLite has an efficient parser and can process tens of thousands of SQL statements per second. > This seems to

Re: [sqlite] Problems with threadsafe opt correction #2623

2005-09-05 Thread Kiel W.
Ian Monroe wrote: I do not see how such a major change can be justified in a minor point release. For instance, currently amaroK does not work when using a sqlite database on Debian Sid since they package it with sqlite 3.2.5. Just my two cents, but if this change is breaking things in

Re: [sqlite] Problems with threadsafe opt correction #2623

2005-09-05 Thread René Tegel
D. Richard Hipp wrote: This is not a design change. This is not an API change. It does not break backwards compatibility. All that changed is that certain errors in the way SQLite is used are now detected sooner rather than later. May be you can add some pragma to disable this check? Also,

Re: [sqlite] Problems with threadsafe opt correction #2623

2005-09-05 Thread Ian Monroe
On 9/5/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > On Mon, 2005-09-05 at 10:57 -0500, Ian Monroe wrote: > > I do not see how such a major change can be justified in a minor point > > release. For instance, currently amaroK does not work when using a > > sqlite database on Debian Sid since

Re: [sqlite] Problems with threadsafe opt correction #2623

2005-09-05 Thread René Tegel
René Tegel wrote: this does only affect linux? Forgive me that i said linux where i ment unix...

Re: [sqlite] Problems with threadsafe opt correction #2623

2005-09-05 Thread Guillaume Fougnies
Mon, Sep 05, 2005 at 12:45:42PM -0400: D. Richard Hipp wrote: > On Mon, 2005-09-05 at 10:57 -0500, Ian Monroe wrote: > > I do not see how such a major change can be justified in a minor point > > release. For instance, currently amaroK does not work when using a > > sqlite database on Debian Sid

Re: [sqlite] Problems with threadsafe opt correction #2623

2005-09-05 Thread Tobias Rundström
Kiel W. wrote: Ian Monroe wrote: I do not see how such a major change can be justified in a minor point release. For instance, currently amaroK does not work when using a sqlite database on Debian Sid since they package it with sqlite 3.2.5. Just my two cents, but if this change is breaking

Re: [sqlite] Problems with threadsafe opt correction #2623

2005-09-05 Thread Miha Vrhovnik
"D. Richard Hipp" <[EMAIL PROTECTED]> je ob 5.9.2005 18:45:42 napisal(a): >SQLite has *never* supported the ability of a handle to be used >by more than one thread. By luck, such use would sometimes work on >some operating systems. But it would fail on others. Such a >situation is very

Re: [sqlite] Problems with threadsafe opt correction #2623

2005-09-05 Thread Ian Monroe
On 9/5/05, Kiel W. <[EMAIL PROTECTED]> wrote: > Ian Monroe wrote: > > >I do not see how such a major change can be justified in a minor point > >release. For instance, currently amaroK does not work when using a > >sqlite database on Debian Sid since they package it with sqlite 3.2.5. > > > > >

Re: [sqlite] Problems with threadsafe opt correction #2623

2005-09-05 Thread D. Richard Hipp
On Mon, 2005-09-05 at 19:23 +0200, Tobias Rundström wrote: > Well in this case it broke all the currently installed applications that > was installed and where MISSUSING the API. We have corrected this now > but it will take a while before we can make a release out of it. In the > meantime

Re: [sqlite] Problems with threadsafe opt correction #2623

2005-09-05 Thread Ian Monroe
On 9/5/05, Tobias Rundström <[EMAIL PROTECTED]> wrote: > Kiel W. wrote: > > Ian Monroe wrote: > > > >> I do not see how such a major change can be justified in a minor point > >> release. For instance, currently amaroK does not work when using a > >> sqlite database on Debian Sid since they

Re: [sqlite] Problems with threadsafe opt correction #2623

2005-09-05 Thread René Tegel
Miha Vrhovnik wrote: So what does that mean. On windows I'm protecting database handle with MREWS. Should I rewrite about 10.000 lines of code. And Check other 30.000. To fix that? As far as i can tell now the windows version of 3.2.5 seems not affected. For other os maybe you can extend

[sqlite] What is this extraneous table?

2005-09-05 Thread R S
Hi, I have a DB containing a table called MyTable which is about 3Gb in size currently. When my process is writing to it, it seems to create a table something likeMyTable-vmhyimo41pq82sw63ip0 with an associated journal table.I seem to have quite a few of these tables.I cannot use the Command

Re: [sqlite] Problems with threadsafe opt correction #2623

2005-09-05 Thread D. Richard Hipp
On Mon, 2005-09-05 at 19:58 +0200, René Tegel wrote: > As far as i can tell now the windows version of 3.2.5 seems not affected. > The restriction that a DB handle can only be used from a single thread is currently only enforced on Unix, because Unix boxes are the only place where using DB

Re: [sqlite] Null values in Primary Key

2005-09-05 Thread Kurt Welgehausen
> I tried to see what MS SQL would do but it does not allow creation of the > tables primary key with any NULL segments. This is the correct behavior; I thought SQLite enforced that. You can duplicate the correct behavior by adding to the spec for each PK column. > Does that mean I need to do

[sqlite] Please test on Win95/98/ME

2005-09-05 Thread D. Richard Hipp
Can somebody with access to Win95/98/ME please test check-in [2656] for me to make sure it didn't break anything? http://www.sqlite.org/cvstrac/chngview?cn=2656 -- D. Richard Hipp <[EMAIL PROTECTED]>

[sqlite] sql help

2005-09-05 Thread Cory Nelson
Hey guys, I'm hoping to get some help with this: create table uses(userid integer, typeid integer); insert into uses values(1, 1); insert into uses values(1, 1); insert into uses values(2, 1); insert into uses values(2, 2); now i'm trying to build a select that gives the result: userid | percent

Re: [sqlite] sql help

2005-09-05 Thread Michael Gross
SELECT userid, SUM(CASE WHEN typeid=1 THEN 1 ELSE 0 END)/COUNT(*) AS percent FROM uses GROUP BY userid Cory Nelson wrote: Hey guys, I'm hoping to get some help with this: create table uses(userid integer, typeid integer); insert into uses values(1, 1); insert into uses values(1, 1);

[sqlite] how to check the file is a sqlite database file?

2005-09-05 Thread YOGESH
Hello All, Is there any way to know whether a certain file is sqlite database file or not? I am using sqlite 2.8.16. My requirement is , I give user an option to select a file as a sqlite database file, so if user makes a mistake in selecting a proper sqlite database file,I want to prevent

Re: [sqlite] how to check the file is a sqlite database file?

2005-09-05 Thread Kurt Welgehausen
Read the first 31 bytes of the file (or the first 15 bytes in V3). Regards

[sqlite] PHP 5.1 PDO Objects

2005-09-05 Thread Robert L Cochran
I compiled one of the snapshots of PHP 5.1 available at http://snaps.php.net/ and I notice that phpinfo() recognizes that I have Sqlite 3.2.5 installed for PHP Data Objects (PDO) purposes. I have not experimented to see whether it actually works for Sqlite databases. Is anyone using PDOs with