--- Jeff Godfrey <[EMAIL PROTECTED]> wrote:
> Thanks for the pointer. I should have mentioned, my application is
> running under Windows (Win2000 and WinXP). A quick look at the
> mentioned code makes me believe that it targets Unix-only systems
> (though there are a few brief mentions of Wind
--- Jeff Godfrey <[EMAIL PROTECTED]> wrote:
> Joe Wilson wrote:
> > If your database storage device cannot guarantee an exclusive file
> > lock, then any database write can potentially result in corruption.
> >
> > If you control all SQLite clients' code, you
If your database storage device cannot guarantee an exclusive file
lock, then any database write can potentially result in corruption.
If you control all SQLite clients' code, you could recompile sqlite
to use the file-based dotlockLockingStyle convention via
-DSQLITE_ENABLE_LOCKING_STYLE=1
Hi Liam,
In func_ext.c and map.h you're including private sqlite3 header
files: sqliteInt.h, os.h and vdbeInt.h, which change from release
to release.
If you only use the public sqlite3.h header file instead, it has
a greater chance of being compatible with new releases.
--- Liam Healy <[EMAI
You're using a third-party C++ SQL wrapper library, not sqlite directly.
#include "Database.h"
#include "Query.h"
You have to link with that library directly, possibly in addition to
libsqlite3.a. You might get a clue as to its name by looking in the
sample makefile provided, or examining th
Did you trying linking against kernel32.dll/lib ?
http://msdn2.microsoft.com/en-us/library/ms686857.aspx
--- Daniel Önnerby <[EMAIL PROTECTED]> wrote:
> Tried upgrading to the 3.5.0 alpha from 3.4.2 using VS 2005 on XP. I
> downloaded the ZIP with preprocessed C code.
> Compiling SQLite to a .li
--- "B V, Phanisekhar" <[EMAIL PROTECTED]> wrote:
> I wanted to know how SQLITE works internally. Assume I am doing
Try using the EXPLAIN command on your queries:
EXPLAIN SELECT foo from bar;
EXPLAIN SELECT * from bar;
http://www.sqlite.org/lang_explain.html
> But if SQLITE uses some othe
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> In 3.5, cache can be shared between
> all threads, but shared cache is still disabled by default. You have to
> invoke sqlite3_enable_shared_cache() to turn it on. I put a comment in
> the documentation that we might turn shared cache on by defau
> In our tests, the overhead of mutexing is not negligible. It slows
> down the
> database by about 8%. Nevertheless, we recognize that many people want
> to run multiple threads (despite my heartfelt pleas to abstain from
> that dreadful
> practice) so we probably will make the prebuilt libr
--- Aviad Harell <[EMAIL PROTECTED]> wrote:
> Regarding only to select statements, is there a known limit of number of
> concurrent connections to Sqlite DB?
>
> What about concurrent connections to the same table in the sqlite DB?
In sqlite 3.4.2 and earlier, each connection - even to the same d
e definitions. If anyone has a suggestion
> I'd appreciate hearing about it.
>
> Liam
>
>
> On 8/31/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
> >
> > --- Liam Healy <[EMAIL PROTECTED]> wrote:
> > > I was the one who packaged up extension-funct
--- Liam Healy <[EMAIL PROTECTED]> wrote:
> I was the one who packaged up extension-functions.tgz and posted on
> contrib. I didn't author the original code but I'd like to fix this up.
> I'm not clear on what needs to be changed. I gather that sqlite3utf8CharLen
> and sqlite3CreateFunc shouldn't
--- venkata ramana <[EMAIL PROTECTED]> wrote:
> I am using SQLite 3_3_17with the default configuration of SQLite.
> Using Windows XP C++ API.
> 50,000 inserts into Table (with primary key and no other index as single
> transaction commit) is taking 4.609000 sec.
> 50,000 selects from Table ( having
Using SELECT * will be slower. How much slower depends on your table.
Why don't you test it and see?
--- "B V, Phanisekhar" <[EMAIL PROTECTED]> wrote:
> Assume I have a table with 40 columns. I would like to know the
> difference between
>
> Select * from table
>
> Select column1, column2, colu
--- Ralf Junker <[EMAIL PROTECTED]> wrote:
> This one just came to my mind:
>
> CREATE TABLE (rowid INTEGER PRIMARY KEY, t TEXT);
>
> This promotes "rowid" to a visible column "rowid" which does not change
> during a VACUUM. "rowid"
> is already a reserved word in SQLite. Maybe this option is
--- Dan Kennedy <[EMAIL PROTECTED]> wrote:
> On Thu, 2007-08-30 at 19:13 -0700, Joe Wilson wrote:
> > I see what's going on now. I incorrectly assumed that both configure
> > builds and the amalgamation were both threadsafe by default in the
> > 3.4.x sources.
&g
> > > latest CVS:
> > >
> > > #if SQLITE_THREADSAFE
> > > # include
> > > # define SQLITE_UNIX_THREADS 1
> > > #endif
> > >
> >
> > I don't know where you are seeing this. The latest is
> >
> >
> > http://www.sqlite.org/cvstrac/filediff?f=sqlite/src/sqliteInt.h&v1=1.592&v2=1.593
>
> Look
--- [EMAIL PROTECTED] wrote:
> This problem will likely come up again. To try and work
> around it, I have added a new (experimental) API to the
> latest version in CVS. Call
>
> sqlite3_threadsafe()
>
> To get back a boolean to indicate whether or not your
> build is threadsafe.
Could you
--- [EMAIL PROTECTED] wrote:
> Ken <[EMAIL PROTECTED]> wrote:
> > Recompiled with:
> > gcc -DSQLITE_THREADSAFE -I. -I../src
> ^^^
>
> Should be -DSQLITE_THREADSAFE=1
>
> The =1 is important in this case.
-DSQLITE_THREADSAFE is equivalent to -DSQLITE_THREADSAFE=1
$ cat t
--- [EMAIL PROTECTED] wrote:
> Amazingly enough, the test program works OK most of
> the time even with mutexes all disabled. But every
> now and then I get the segfault.
>
> It's a weak thread-test that works OK must of the
> time with mutexes disabled. :-) Or perhaps it is
> a very robust d
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> >
> > latest CVS:
> >
> > #if SQLITE_THREADSAFE
> > # include
> > # define SQLITE_UNIX_THREADS 1
> > #endif
> >
>
> I don't know where you are seeing this
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> I thought there was a checkin a few months ago that made sqlite3
> threadsafe by default.
>
> os_unix.c
> revision 1.128
> date: 2007/04/01 18:46:19; author: drh; state: Exp; lines: +4 -1
> Make unix builds th
--- Dan Kennedy <[EMAIL PROTECTED]> wrote:
> On Thu, 2007-08-30 at 10:13 -0700, Joe Wilson wrote:
> > Compiled without -DSQLITE_DEBUG=1 which presumably changes the timing.
> >
> > cvs up -A
> > make distclean
> > # thrd35.c = http://marc.info/?l=sqlite-user
Upon further thought, such a scheme would not exercise concurrent access
to the same database files, so it would not exercise the shared cache code.
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> Is it feasible to change testfixture in such a way to run the same tests
> in N seperate th
Is it feasible to change testfixture in such a way to run the same tests
in N seperate threads at the same time? This could potentially expose
a lot of thread-related bugs.
Among other things, you'd have to change some low level sqlite open()
calls to use a different directory for databases for e
Compiled without -DSQLITE_DEBUG=1 which presumably changes the timing.
cvs up -A
make distclean
# thrd35.c = http://marc.info/?l=sqlite-users&m=118848741522192&w=2
cp thrd35.c src/shell.c
./configure --disable-shared && make LIBPTHREAD=-lpthread sqlite3
./sqlite3
valgrind -v ./sqlite3 2>&1 | tee v
Another unique valgrind stack trace.
http://marc.info/?l=sqlite-users&m=118848741522192&w=2
==14918== Thread 2:
==14918== Invalid read of size 4
==14918==at 0x80534F9: sqlite3OsWrite (os.c:38)
==14918==by 0x8056C06: syncJournal (pager.c:2765)
==14918==by 0x80581A8: sqlite3PagerCommitP
by 0x403A561: start_thread (in /lib/i686/libpthread-2.4.so)
==14673==by 0x418D4DD: clone (in /lib/i686/libc-2.4.so)
==14673==by 0xA: ???
==14673==by 0x38134192: (within /usr/lib/valgrind/x86-linux/memcheck)
==14673==by 0x2: ???
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
I also see random crashes with sources from CVS as of
Thu Aug 30 12:20:43 EDT 2007 using Ken's program below.
http://marc.info/?l=sqlite-users&m=118848741522192&w=2
It's timing dependent.
On a single core Pentium4 machine it crashes once in 10 runs.
Sometimes it produces this valgrind error:
--- [EMAIL PROTECTED] wrote:
> =?ISO-8859-1?Q?Daniel_=D6nnerby?= <[EMAIL PROTECTED]> wrote:
> >
> > The new multithread-features will be great.
> > Do you think that it will be better to share one connection between all
> > theads in an application or is better to have each thread open a new
> >
--- Dennis Cote <[EMAIL PROTECTED]> wrote:
> > sqlite3_vfs *sqlite3_vfs_find(const char *zVfsName);
> >
> >
> > The argument is the symbolic name for the desired VFS. If the argument
> > is a NULL pointer, then the default VFS is returned. The function
> > returns a pointer to the *sqlite3_vf
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > --- [EMAIL PROTECTED] wrote:
> > > The transition from 3.4.2 to 3.5.0 will perhaps be the
> >
> > > The SQLite code currently in CVS HEAD is not ready for
> > > producti
--- [EMAIL PROTECTED] wrote:
> The transition from 3.4.2 to 3.5.0 will perhaps be the
...
> The SQLite code currently in CVS HEAD is not ready for
> production use. We know that. We know what many of the
> problems are and Dan and I are working long hours to fix
> them. It's the problems that we
This is a question for the author of the SQLite driver for Ruby,
or the ruby mailing list.
Typically when you cannot open a file, you either have the wrong filename
or insufficient file/directory permissions.
--- agus_ramos <[EMAIL PROTECTED]> wrote:
> Hi i'm using Ruby and Sqlite3, the program h
--- "Bruno S. Oliveira" <[EMAIL PROTECTED]> wrote:
> Is there any sort of expression inside a query that needs to be
> surrounded by parenthesis?
>
> My program will receive queries built to run in MySQL, Oracle and
> Postgrees. The problem, as posted before, is that SQLite has problems
> with par
--- Doug <[EMAIL PROTECTED]> wrote:
> I have an application that attaches 7 databases and then does
> MANY updates to those databases (maybe a million or two inserts
> in a day, spread out over maybe 10,000 separate transactions).
>
> For some reason the client is seeing many master journal file
--- "Gauthier, Dave" <[EMAIL PROTECTED]> wrote:
> But how can I ".mode column" and ".header on" as well as run the query
If you're using bash (ksh and sh might work as well):
$ echo -e ".header on\n.mode column\nselect * from sqlite_master;" | ./sqlite3
abc.db
typenametbl_name
--- Mina R Waheeb <[EMAIL PROTECTED]> wrote:
> Do you mean the LIMIT in SQLite is not optimized? and the performance
> of selecting from table contains 1000 rows match the query condation
> equal selecting the same condation with limit 990,10?
Pretty much, yes, as it should be.
LIMIT is optimized
source code is available. You can modify it as see you fit.
--- "Bruno S. Oliveira" <[EMAIL PROTECTED]> wrote:
> As I told you, I know how to avoid this. But I can't rewrite these
> queries. That's my problem...
>
> Thanks for your attention.
>
> Regards,
--- Mina R Waheeb <[EMAIL PROTECTED]> wrote:
> I have some questions about the behavior of aggregate functions and
> the result LIMIT.
> After register TEST function and executing query (SELECT TEST() FROM
> objects group by id LIMIT 30,3)
>
> I was expect calling back TEST() only 3 times but wh
SELECT t_dados.id
FROM Points1 LEFT JOIN t_dados ON Points1.object_id = t_dados.id
ORDER BY t_dados.id, Points1.geom_id;
--- "Bruno S. Oliveira" <[EMAIL PROTECTED]> wrote:
> I'm having problems with the following query (and, in general, in
> queries using left joins):
>
> [EMAIL PROTECTED]:~
http://www.google.com/
--- "Rachmel, Nir (Nir)" <[EMAIL PROTECTED]> wrote:
> Tried without this line - it still doesn't work.
> Any ideas?
>
> Thanks, Nir.
>
> -Original Message-
> From: Joe Wilson [mailto:[EMAIL PROTECTED]
> Sent: Thursda
> We're Hiring! Seeking a passionate developer to join our team building
> products. Position is in the Washington D.C. metro area. If interested
> contact [EMAIL PROTECTED]
>
> -Original Message-
> From: Joe Wilson [mailto:[EMAIL PROTECTED]
>
--- Ralf Junker <[EMAIL PROTECTED]> wrote:
> >Your product is not useful to a few users like me who require custom
> >sqlite functions for their databases.
>
> I am not sure I understand currectly. Only loadable extensions are currently
> omited from
> DISQLite3.
>
> sqlite3_create_function() i
You want to enable readline to allow command history editting, not disable it.
--- "Rachmel, Nir (Nir)" <[EMAIL PROTECTED]> wrote:
> I recently upgraded from sqlite 3.2.8 to sqlite 3.4.0.
> I have only made minor changes in my system to get the new version up
> and running, however I encountered a
--- Adam Megacz <[EMAIL PROTECTED]> wrote:
> Hello, I need to create a perpetually-unique column in an FTS2 table.
> For example:
>
> create virtual table t using fts2(c);
> insert into t (c) values ('a');
> select rowid,c from t;
> 1|a
> delete from t;
> insert into t (c) values ('b')
--- Scott Hess <[EMAIL PROTECTED]> wrote:
> On 8/15/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
> > If you find a way to get sqlite3 to re-parse the schema after your direct
> > sqlite_master change, please post it to the list. I don't think it can
> > be done
--- Mark Brown <[EMAIL PROTECTED]> wrote:
> There is a .lock file for each database. From my understanding, that should
> prohibit 2 connections from using the same database at the same time.
> However, that is not the situation I am wondering about. I am specifically
> wondering if database acti
--- T&B <[EMAIL PROTECTED]> wrote:
> > Even if you got the sqlite_master table entries right, the in-
> > memory sqlite schema data structures would not be in sync.
>
> Yes, but my point/question was, would that not only apply to tables
> and indexes? I expect that views and triggers have no da
--- Ralf Junker <[EMAIL PROTECTED]> wrote:
> >Does it support external sqlite loadable extensions?
>
> Loadable extensions are currently omitted. FTS1 and FTS2 extensions are
> provided as built-in
> modules. User-aware collations sequences using the Windows sorting functions
> are provided in
>
--- T&B <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
>
> > It appears that you can set
> >
> > PRAGMA writable_schema=ON;
> >
> > Then do a manual UPDATE of the sqlite_master table to insert
>
> > I tried it and it seems to work. But it is dangerous. If you mess
> > up, you corrupt
--- [EMAIL PROTECTED] wrote:
> "Scott Hess" <[EMAIL PROTECTED]> wrote:
> > I was getting ready to checkin the rowid-versus-fts2 fix, and wanted
> > to add one last bit, to upgrade older tables.
> >
> > Unfortunately, code of the form:
> >
> >ALTER TABLE x_segments ADD id INTEGER PRIMARY KEY;
--- Scott Hess <[EMAIL PROTECTED]> wrote:
> This may mean that I'll need to branch fts2 to fts3 and deprecate
> fts1/2 as being not safe for use. If the code is going to have to
> create new tables and populate them, then there's not a lot of gain
> versus just having the developer do that.
Is it
--- Ralf Junker <[EMAIL PROTECTED]> wrote:
> DISQLite3 Personal is free for non-commercial use. Source code is available
> after registering
> DISQLite3 Pro. Both editions benefit from 'register' calling conventions,
> include full text
> search (FTS1 and FTS2) as well as ample Delphi additions l
--- Mikey C <[EMAIL PROTECTED]> wrote:
> John Stanton wrote:
> > We have
> > added a DECIMAL type to Sqlite. This stores fixed point numbers in
> > ASCII display format and performs accurate artithmetic and presents
> > nicely from HTML.
>
> In which release was the DECIMAL affinity added to
--- T&B <[EMAIL PROTECTED]> wrote:
> As mentioned, all the associated triggers are deleted. IS there a way
> to systematically locate and keep them? Such as:
>
> set viewDefinition to SQLExec( "select sql || ';' from sqlite_master
> where type = 'view' and name = 'MyView';" )
> set triggerDefi
Rather than count the number of connections which would be prone
to failure due to race conditions, you should do this instead:
BEGIN EXCLUSIVE;
-- run whatever SQL statements you want here,
-- or copy the database file.
COMMIT;
Just schedule this job off-hours when people are not likely usi
Forget about the alternate insert statements I suggested.
Assuming "id" is declared INTEGER PRIMARY KEY in all tables,
you can't get better performance than this in a single
insert statement:
insert into x select x1.* from a.x x1, y where x1.id = y.id;
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> This should be faster:
>
> insert into x
> select * from a.x x1
> where exists (select 1 from Y where x1.id = y.id);
>
> See if adding an order by statement will make it faster by speeding
> up the inserts:
>
&g
This should be faster:
insert into x
select * from a.x x1
where exists (select 1 from Y where x1.id = y.id);
See if adding an order by statement will make it faster by speeding
up the inserts:
insert into x
select * from a.x x1
where exists (select 1 from Y where x1.id = y.id)
orde
You probably have another shared sqlite library in your path somewhere.
Explicitly link with /absolute/directory/to/your/libsqlite.a rather than
-lsqlite.
--- Daniel Berenguer <[EMAIL PROTECTED]> wrote:
> I've downloaded the sqlite-2.8.17 source code in order to create my own
> static library for
Workaround for 3.3.13:
select distinct bar, baz as z from foo where bar in ((
select bar from foo where baz==z order by length(bar) desc limit 1
));
It's just different enough to prevent sqlite 3.3.13 from choking on
the "order by" clause in the "in" subquery.
--- Christopher Backhouse <[EM
> sqlite> INSERT INTO "foo" VALUES('432','13');
> sqlite> INSERT INTO "foo" VALUES('7654321','13');
> sqlite> INSERT INTO "foo" VALUES('1234567','345');
> sqlite> select * from fo
--- Christopher Backhouse <[EMAIL PROTECTED]> wrote:
> I have a table:
> create table foo(bar text,baz text);
>
> I want to produce a list of all bar's paired with the longest baz they
> are ever associated with. I came up with the following query:
>
> select distinct bar,baz as z from foo where
If you recompile sqlite3 with -DSQLITE_DEBUG=1, run sqlite3 in a
debugger, and set a breakpoint on sqlite3Corrupt you can get
a stack trace showing what led up to SQLITE_CORRUPT.
But although this will show you roughly where the file is corrupt,
it probably won't help you with why.
If your OS
--- Trevor Talbot <[EMAIL PROTECTED]> wrote:
> On 8/11/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
>
> > You can put any command seen in ".help" in the sqlite3 shell
> > or any SQL command in ~/.sqliterc, such as:
>
> ...and of course, I would comple
Not much you can do.
You could examine the output of EXPLAIN QUERY PLAN for those statements.
Hard to know without knowing the schema, but try making the "id" an
INTEGER PRIMARY KEY, assuming it's appropriate for your data.
Try to have as few indexes as possible on the table being inserted into.
--- Brickl Roland <[EMAIL PROTECTED]> wrote:
> where can i find information about how the config-file should look like and
> what is possible?
You can put any command seen in ".help" in the sqlite3 shell
or any SQL command in ~/.sqliterc, such as:
select 'no place like home';
.mode column
.head
--- mos <[EMAIL PROTECTED]> wrote:
> At 01:42 PM 8/9/2007, you wrote:
> >--- mos <[EMAIL PROTECTED]> wrote:
> > > Is there no way to allocate more memory to SQLite index buffers like you
> > > can with MySQL and most other databases? I suspect SQLite is building the
> > > index on disk which will b
--- mos <[EMAIL PROTECTED]> wrote:
> Is there no way to allocate more memory to SQLite index buffers like you
> can with MySQL and most other databases? I suspect SQLite is building the
> index on disk which will be 100x slower than if it used RAM. The indexing
> process has used 400MB of RAM so
Do you also intend to use just a single file descriptor for all
connections to the same database file in the same process?
--- [EMAIL PROTECTED] wrote:
> We are considering a change to the SQLite API which is
> technically not backwards compatible. On the other hand,
> it is difficult to imagine
--- "Babu, Lokesh" <[EMAIL PROTECTED]> wrote:
> Does anybody knows the exact code, a little hack where can I free up the
> memory, I don't want it to use it for future requests.
>
> Even drop table consumes memory. :-(.
>
> If we are doing in-memory database operation, why do we want to maintain
--- mos <[EMAIL PROTECTED]> wrote:
> At 10:19 AM 8/9/2007, you wrote:
> >If your database file is less than the size of your RAM,
> >then do this before the create index to speed it up:
> >
> > cat your.db > /dev/null
>
> Using Windows XP. :-0
Anyone know a simple Windows command line equival
--- [EMAIL PROTECTED] wrote:
> We are considering a change to the SQLite API which is
> technically not backwards compatible. On the other hand,
> it is difficult to imagine a situation where the change
> would cause anyone any serious hardship. We suspect that
> most people will consider this ch
If your database file is less than the size of your RAM,
then do this before the create index to speed it up:
cat your.db > /dev/null
See also:
PRAGMA cache_size = number-of-pages;
and
PRAGMA page_size = bytes; -- recommend at least 8192
http://www.sqlite.org/pragma.html
--- mos <[EMA
--- Lee Crain <[EMAIL PROTECTED]> wrote:
> I've queried it in both the command line interface and via an
> sqlite3_exec() call in a C++ environment.
You must have a typo somewhere.
SQLite version 3.4.1
Enter ".help" for instructions
sqlite> CREATE TABLE Items(items_idx, name, active);
sqlite> INS
There's nothing wrong with your query.
It works fine against this schema in sqlite 3.4.1:
CREATE TABLE Items(items_idx, name, active);
CREATE TABLE RelatedItems(item, related_item);
What language/tool are you using to query sqlite?
--- Lee Crain <[EMAIL PROTECTED]> wrote:
> The query at the bott
Any particular reason why you're using 3.3.13?
I don't plan to compile it.
--- karthikeyan <[EMAIL PROTECTED]> wrote:
> Ah yes, in the sqlite3_bind_int, I need to pass id, thanks. Also, please try
> compiling, the sqlite code (3.3.13) with "-DSQLITE_OMIT_SHARED_CACHE=1". It
> should crash with the
It is not reasonable to change a database file to read-only in the
middle of a transaction. I suppose sqlite could be changed to detect it,
but why bother?
By the same logic, if another process wrote random bytes in the middle
of an sqlite database file, should sqlite be responsible for recovering
--- Chase <[EMAIL PROTECTED]> wrote:
> here's the deal. i want this trigger to fire -- and insert valid guids
> into a table -- even outside the context of my app.
>
> using sqlite3_create_function(), i can create a sort of temporary
> function that only works from with my app (or other running
= end ==
>
> ****
>
> This e-mail and attachments contain confidential information from HUAWEI,
> which is intended only for the person or entity whose address
--- Alain Bertrand <[EMAIL PROTECTED]> wrote:
> In a Qt4 application, I have the following bit of code :
>
> QString s;
> bool b;
> QSqlQuery q;
> QSqlError err;
> s= "CREATE TABLE ttd_bdata (sheetId integer primary key,";
> s+="creation_date date, modif_date date,";
>
It should be possible to do what you're trying to do as of 3.3.8.
See the Tcl examples at the bottom of this patch:
Allows UPDATE, INSERT, and DELETEs to occur while
a SELECT is pending on the same table.
http://www.sqlite.org/cvstrac/chngview?cn=3355
Post a complete self-contained C program
> 3 errors out of 110199 tests
> Failures on these tests: lock4-1.3 malloc2-1.1.34.5 malloc2.1.5
>
> lock4-1.3...
> Error: database is locked
> malloc2-1.1.34.5...
> Expected: [7150405b58e993f161c43b93edd13553]
> Got: [bc598bca7e7514b7f
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
> cus
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 t
--- 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
:
./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
http://search.yahoo.com/search?fr=oni_on
--- Gilles Ganault <[EMAIL PROTECTED]> wrote:
> As I'd like to be able to build my own SQLite DLL for use with Visual
> Basic Classic, I followed Todd Tanner's instructions at
> www.tannertech.net/sqlite3vb/ to make the (few) required changes and
> compile with Visual C++ 6.0.
This has co
--- 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
> t
--- 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 thr
--- [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.
&
You already have the answer to your question.
There's no need for badgering.
--- Rohit Mordani <[EMAIL PROTECTED]> wrote:
> Hi Ken,
>Do you have an answer to what external api we can use to get the
> Select parse tree?
>
> Rohit
>
> On 7/31/07, Joe
--- 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 sqlite3 in an xterm
3. at the prompt, press cursor up
4. hit
> This is probably a stupid question but has frustrated me a couple of times.
>
> When using the command line interface sqlite3, a couple of times I have
> forgotten to use the "." before a command. After that I get a "...>"
> prompt that I can't seem to escape from and accepts no commands? M
--- Paul Harris <[EMAIL PROTECTED]> wrote:
> I wanted to get a LOG10() function in sqlite3, and I found the
> extension-functions.tgz file in http://sqlite.org/contrib
>
> I am using the all-in-one sqlite3.h/c version of sqlite3, and the
> extension-functions files don't seem to fit at all.
>
> F
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 I have two
> questions:
> > Question 1:
> >
> > Building sqlite-3.4.1, as obta
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 pstack, lsstack or by attaching gdb to it at runtime.
> COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
> php
--- Ken <[EMAIL PROTECTED]> wrote:
> You should be using the external API calls not the internal sqlite calls and
> types.
Please point us to where you can get the Select parse tree from the external
API.
>
> See: http://www.sqlite.org/capi3ref.html
__
--- Rohit Mordani <[EMAIL PROTECTED]> wrote:
> So just to confirm - the Select structure (Select *p) is populated after the
> call to sqlite3Select() method right?
No. sqlite3Select() uses the Select tree - it does not produce it.
See parse.y for the parser that builds the Select tree.
See also
201 - 300 of 764 matches
Mail list logo