The lock4-1.3 problem happens ONLY when lock4.test is run after lock3.test:
=
[EMAIL PROTECTED] arcturus | sqlite.arcturus.gcc > ./testfixture
../sqlite/test/lock4.test
lock4-1.1... Ok
lock4-1.2... Ok
lock4-1.3...
The string "integer value too large to represent" is not found in
sqlite sources, so I assume it is an error in either in Tcl or the tcl
test harness.
I have no idea why the checksum of the databases in malloc2-1.1.28.5
is different, or whether it is harmless.
As for the malloc2.1.5 failure,
Ahh, that's it.
On the ODBC driver information page I see "So far it has been tested
with SQLite 2.8.17 and SQLite 3.3.13"
Darn!
Thanks Joe!
On 8/3/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
> rtrim was introduced on 17-Mar-07, and was in the sqlite 3.3.14 release.
>
>
rtrim was introduced on 17-Mar-07, and was in the sqlite 3.3.14 release.
http://www.sqlite.org/cvstrac/chngview?cn=3698
What sqlite version is your ODBC driver?
select sqlite_version();
--- Mitchell Vincent <[EMAIL PROTECTED]> wrote:
> If I use sqlite3.exe to execute the query "Select
>
If I use sqlite3.exe to execute the query "Select
customer_id,customer_number FROM customers where customer_number !=
rtrim(customer_number);" it works great but as soon as I run that
query through using the SQLite ODBC driver (using the latest
available) I get "no such function: rtrim (1)"
I
-Original Message-
From: Luís Santos [mailto:[EMAIL PROTECTED]
Sent: Friday, August 03, 2007 2:41 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Strange behaviour on Update
Hi, Ppl
We have found a strange behaviour on SQLite 3.4.1 (We have also tested against
versions 3.0.8, 3.2.5
update test set FieldOne = '1';
--- Luís Santos <[EMAIL PROTECTED]> wrote:
> sqlite> CREATE TABLE test (
>...> id INT NOT NULL,
>...> FieldOne TEXT NOT NULL,
>...> FieldTwo TEXT,
>...> "1" TEXT
>...> );
> sqlite> insert into
Luís Santos wrote:
When we create a field with a name composed exclusively of numeric
algarisms, we cannot perform an update.
We have only noticed this odd behaviour because of a NOT NULL field.
See the code example:
sqlite> CREATE TABLE test (
...> id INT NOT NULL,
...>
At 11:23 03/08/2007 -0700, Robert Simpson wrote:
Download the System.Data.SQLite.DLL I maintain from
http://sqlite.phxsoftware.com
Thanks, I'll check it out :-)
G.
-
To unsubscribe, send email to [EMAIL PROTECTED]
On Fri, Aug 03, 2007 at 11:38:57AM -0700, Joe Wilson wrote:
> > Of course I'm not. The PHP4 module uses sqlite2.x, and - besides - it
>
> :-)
>
> "Of course"? That's rich.
"Of course" - just because I haven't any possibility to do that.
> > OK, I'll try to ask maintainers about that.
>
>
Hi, Ppl
We have found a strange behaviour on SQLite 3.4.1 (We have also tested
against versions 3.0.8, 3.2.5 and 3.4.0)
When we create a field with a name composed exclusively of numeric
algarisms, we cannot perform an update.
We have only noticed this odd behaviour because of a NOT NULL
--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> On Fri, Aug 03, 2007 at 09:27:22AM -0700, Joe Wilson wrote:
>
> > You are not checking the return code of the sqlite3 connection close.
>
> Of course I'm not. The PHP4 module uses sqlite2.x, and - besides - it
:-)
"Of course"? That's rich.
On Fri, 3 Aug 2007 09:35:49 -0400, you wrote:
>Sounds like Wikipedia. I understand that Wikipedia's software is Open
>Source and available. Do you know of other Wiki servers that would suffice
>or be more on target?
There are several wiki software packages avaialble.
The wiki server behind
> -Original Message-
> From: Gilles Ganault [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 03, 2007 11:12 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] [VC++ 6] Error compiling VBified source
>
> At 09:53 03/08/2007 -0700, Joe Wilson wrote:
> >This has come up before on the
At 09:53 03/08/2007 -0700, Joe Wilson wrote:
This has come up before on the list. The instructions are wrong:
Sorry, should have thought someone had already tried.. and failed :-/
Browsing through the archives, it looks like the code might not be 100%
reliable, so I'll probably look for
./testfixture test/select1.test
> Is there a way to run a single test of my choice?
Luggage? GPS? Comic books?
Check out fitting gifts for grads at Yahoo! Search
> -Original Message-
> From: Stephen Sutherland [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 03, 2007 10:33 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] How to Speed of Inserts
>
[snip]
>
>So it makes me a bit concerned that when I have to drop my
> XML repository
1. Use bind vars... prepare the statement once, execute it many times
binding values each time.
1a. Drop the index.
2. Use a transaction.
3. Commit every . In your case with only
10,000 recs, I would commit only at the very end.
4. Build the index at the end.
Really, 10k recs should insert in
Regarding:
"Is there away to maximize this speed dramatically ...?"
Yes, be sure to surround your inserts with a single transaction (i.e.,
"BEGIN", "END").
If you were doing millions of inserts, you might want to use a new
transaction after each, say, 5 thousand inserts.
If you don't
Hi
Here's My Situation:
-
I have an XML file which contains user created data. It can have maybe 10,000
or more nodes. The XML needs to be queried infrequently for use in the
application, in a way that lends itself more to SQL. For example the only
On Fri, Aug 03, 2007 at 09:27:22AM -0700, Joe Wilson wrote:
> You are not checking the return code of the sqlite3 connection close.
Of course I'm not. The PHP4 module uses sqlite2.x, and - besides - it
doesn't return any value when using sqlite_close.
> I have no idea if the PHP sqlite3 wrapper
Is there a way to run a single test of my choice?
Victor Secarin
Joe Wilson wrote:
Can you post the output for the failed tests?
i.e.:
footest-13.1...
Expected: [10]
Got: [0]
--- Victor Secarin <[EMAIL PROTECTED]> wrote:
Hello, everyone. I just started to look at the software and
Here are the fulltest errors I get trying to build sqlite 3.4.1 with the
included gcc on Enterprise 3, 4 and Fedora 5.
After building tcl8.4.7 and installing it in /usr/local, I was able to
configure with "--with-tcl=/usr/local/lib" and build the two libraries
completely and then run the
Mark and Richard:
Thank you all for your well considered comments. I've got enough
information to decide to spend some time evaluating SQLite as a replacement
DB. I'll cook up some test code as a next step. The example code will be
a good starting point.
The comments about the added safety
--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> > Your trace seems to indicate it has 20 or so open
> > connections to the same database file in the same process.
>
> I think, at last I've traced the problem:
>
> One of the scripts doesn't make use out of database contents at all. But at
>
Joe Wilson wrote:
--- [EMAIL PROTECTED] wrote:
Joe Wilson <[EMAIL PROTECTED]> wrote:
--- John Stanton <[EMAIL PROTECTED]> wrote:
Sqlite3 will get into a tangle with certain sequences where it does not
accept a semicolon as a terminator or obey a CTL c.
To reproduce:
1. build sqlite3
Hi,
When I create a 3.4.1 SQLite database on Red Hat (2.6.9 kernel) and
try to create a table, I get a "database is locked" error. I don't
have any problem with a non-NFS filesystem, and I also don't have any
problem with version 3.3.3.
Does anyone have any hints, or any thoughts on changes
Igor Tandetnik wrote:
Paul Harris <[EMAIL PROTECTED]> wrote:
anyway, this is what i'm trying to do:
eg 1
select @somevar := column1 from table1;
update table2 set column2 = @somevar;
update table2 set column2 = (select column1 from table1);
Igor Tandetnik
A note to the original poster.
Paul Harris wrote:
On 03/08/07, Nikola Miljkovic <[EMAIL PROTECTED]> wrote:
[In the message "Re: [sqlite] Re: Re: how do i declare and use variables in sqlite?" on
Aug 3, 11:47, "Paul Harris" writes:]
create temporary table vars (name text, value something);
--
insert into vars set
Scott Derrick uttered:
are you saying this is a memory leak?
sqlite never gives back the unused memory?
No, libc never gives back the memory.
It is not leaked because the malloc implementation keeps a reference to
all the free'd heap memory in tracking it for future requests.
Is there a roadmap of major planned features in upcoming releases? I didn't
see anything on the wiki or site..
Thanks,
Sam
---
We're Hiring! Seeking a passionate developer to join our team building
products. Position is in the Washington D.C. metro
john s wolter wrote:
SQLite.org in my opinion, needs to have online community forms. I first
used majordomo ten years ago which is like the list manager being used for
sqlite-users@sqlite.org but in today's Internet it can be mistaken for
SPAM. I do not know if SQLite would qualify because of
--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> On Wed, Aug 01, 2007 at 03:04:35PM -0700, Joe Wilson wrote:
>
> > Maybe the php wrapper is not closing sqlite connections correctly
> > (or at all).
> >
> > See if you can get the stack traces of all threads in the php process
> > 162 via
Sounds like Wikipedia. I understand that Wikipedia's software is Open
Source and available. Do you know of other Wiki servers that would suffice
or be more on target?
On 8/3/07, Paul Harris <[EMAIL PROTECTED]> wrote:
>
> On 03/08/07, john s wolter <[EMAIL PROTECTED]> wrote:
> > Wiki's. I have
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > --- John Stanton <[EMAIL PROTECTED]> wrote:
> > > Sqlite3 will get into a tangle with certain sequences where it does not
> > > accept a semicolon as a terminator or obey a CTL c.
> >
> > To reproduce:
> >
> > 1. build
I expect that for most of us, we prefer to get our information "pushed" to
us rather than having to go check laboriously each of the subject area's
forums that we are interested in.
Life is too short, otherwise.
Hello,
I recently got some debug logs from my users that indicate problems
with VACUUM command. The error message is:
SQL logic error or missing database (1).
This is using the latest SQLite (3.4.1) Windows DLL.
I tried to rule out my coding mistakes, at the moment of the problem
there is only
Joe Wilson <[EMAIL PROTECTED]> wrote:
> --- John Stanton <[EMAIL PROTECTED]> wrote:
> > Sqlite3 will get into a tangle with certain sequences where it does not
> > accept a semicolon as a terminator or obey a CTL c.
>
> To reproduce:
>
> 1. build sqlite3 without readline support.
> 2. run
"john s wolter" <[EMAIL PROTECTED]> wrote:
> I have an old Clipper DBF type application Clipper DBF file
> indexes are a simple key-value and a pointer into a DBF file's
> records. That is why these lookups are so fast
>
> I am of the opinion that full SQL engine's set based
Bharath Booshan L
<[EMAIL PROTECTED]> wrote:
Consider the following schema
Create table Library(LibraryID INTEGER PRIMARY KEY AUTOINCRMENT,
LibraryName
TEXT);
Create table Book(LibraryID INTEGER REFERENCES Library, BookID TEXT
PRIMARY
KEY, BookName TEXT);
Now I believe Library(LibraryID) is
Paul Harris <[EMAIL PROTECTED]> wrote:
anyway, this is what i'm trying to do:
eg 1
select @somevar := column1 from table1;
update table2 set column2 = @somevar;
update table2 set column2 = (select column1 from table1);
Igor Tandetnik
Hi Chase,
it connects fine. no errors. but then i try to create a temp
table (which, like i said, works if the db is local) it fails
immediately with SQLITE_BUSY "database is locked".
It's some Mac vs SQLite bug. You can recompile SQLite to fix it. See
the old post below. And search
Paul Harris wrote:
ok, so a subselect can be used. not bad, but not as powerful as the
mysql @ variables, which can then be used in all sorts of scenarios
later, without inducing the same query over and over to get the value.
SQLite is (mostly) intended to be a library for SQL execution,
On 03/08/07, john s wolter <[EMAIL PROTECTED]> wrote:
> Wiki's. I have not used them myself. What's the general idea? Is there a
> form type that would be easy to use?
>
wikis are very easy to use. in short, its basically a "forum" where
people can write and store information in a form that
44 matches
Mail list logo