(also see http://trac.edgewall.org/ticket/9885)
this is reproducable on:
CentOS 5.5 (x86_64)
sqlite 3.3.6-5
create a file 'testdump.txt' with:
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE test( t text );
INSERT INTO test VALUES(' -
/
I duplicated your problem on 3.6.23.1
But it works fine under 3.7.3
SQLite version 3.7.3
Enter .help for instructions
Enter SQL statements terminated with a ;
sqlite PRAGMA foreign_keys=OFF;
sqlite BEGIN TRANSACTION;
sqlite CREATE TABLE test( t text );
sqlite INSERT INTO test VALUES('
Roger Binns wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/22/2010 06:58 PM, Chris Wolf wrote:
Hmm, if you mean apsw,
Yes, I did. (I'm the author of APSW if that wasn't clear.)
that's actually one of the things I wanted to
do: change the
Connection
Hi,
Recently prepared triggers for semi-automatic working with fts3 when every
change triggers the corresponding actions (insert/delete/update). It appears
that I can use my also a user function (instead of a tokenizer) preparing
the content of insert/update queries and this function can do
On 2 Dec 2010, at 20:43, Sylvain Pointeau wrote:
Hi,
I am on macosx sqlite 3.7.3
$ /usr/local/bin/sqlite3 test.db3
SQLite version 3.7.3
Enter .help for instructions
Enter SQL statements terminated with a ;
sqlite .read ./testSchema.sql
sqlite .read ./TestValues.sql
sqlite .read
Hello,
I've got a question: Is it correct, that using FTS3 with virtual tables that
these tables need to be build everytime from scratch?
Or are they persisted in one way or the other?
Thanks
Ralf
___
sqlite-users mailing list
sqlite-users@sqlite.org
Can sqlite3_exec and/or sqlite3_prepare be re-entered? I notice that
data dictionary updates are done
directly with the Vdbe engine rather then the public API - will I have
to resort to that?
I tried using sqlite3NestedParse, but changes to the db don't seem to be
reflected immediately.
I want
Chris Wolf cw10...@gmail.com wrote:
Can sqlite3_exec and/or sqlite3_prepare be re-entered?
sqlite3_prepare can't be reentered since it doesn't call back. You can have
several prepared statements doing traversal with sqlite3_step at the same time,
interleaved, if that's what you are asking.
Igor Tandetnik wrote:
Chris Wolf cw10...@gmail.com wrote:
Can sqlite3_exec and/or sqlite3_prepare be re-entered?
sqlite3_prepare can't be reentered since it doesn't call back. You can have
several prepared statements doing traversal with sqlite3_step at the same
time,
no FTS3 is no real virtual table and can be saved into the database
file if you open it the index is already generated.
but if you add ne entrys these have to be processed and added to the
index.
so if you crate a new FTS3 virtual table and insert all the entrys of a
normla table it will generate
I need a bit of SQL expertise here...I'm close but not close enough and joins
kind of confuse me.
Given the following table of 1-degree separations I want to get the 2-degree
separations
CREATE TABLE know(p1 varchar,p2 varchar);
CREATE INDEX know_idx on know(p1,p2);
INSERT INTO know
Quoth Black, Michael (IS) michael.bla...@ngc.com, on 2010-12-03 17:07:23
-0600:
INSERT INTO know VALUES('a','b');
INSERT INTO know VALUES('a','c');
INSERT INTO know VALUES('a','d');
INSERT INTO know VALUES('aa','b');
INSERT INTO know VALUES('b','bb');
INSERT INTO know VALUES('b','cc');
On 3 Dec 2010, at 11:14pm, Drake Wilson wrote:
Another would be to
rewrite the query to union the two directions together
You could do this with a VIEW, of course. Have a VIEW that reflects the UNION
of the 'know' table with its elements in the opposite order. Then query this
VIEW instead
Phobic
- Original Message -
From: Simon Slavin [mailto:slav...@bigfraud.org]
Sent: Friday, December 03, 2010 06:36 PM
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Subject: Re: [sqlite] Degrees of separation
On 3 Dec 2010, at 11:14pm, Drake Wilson wrote:
Another
Quoth Dariusz Matkowski dmatkow...@rim.com, on 2010-12-03 18:46:20 -0500:
Phobic
What?
--- Drake Wilson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi all,
If I prepare a statement using sqlite3_prepare_v2() and then bind parameters to
it using the sqlite3_bind_* functions, is there then a way to get the human
readable form of the statement?
For example, if I have:
select * from MyTable where IntColumn = ? and TextColumn = ?
to which I
BareFeetWare list@barefeetware.com wrote:
If I prepare a statement using sqlite3_prepare_v2() and then bind parameters
to it using the sqlite3_bind_* functions, is there
then a way to get the human readable form of the statement?
No. That's not how binding works.
--
Igor Tandetnik
Some small but usefull changes implemented, as per user request:
get latest version here : http://www.singular.gr/sqlite/
Mike Cariotoglou
Disclaimer Notice: This communication may be confidential. If you are not an
intended recipient please note that any form of distribution, copying or use of
On Sat, Dec 04, 2010 at 01:17:00PM +1100, BareFeetWare scratched on the wall:
Hi all,
If I prepare a statement using sqlite3_prepare_v2() and then bind
parameters to it using the sqlite3_bind_* functions, is there then a
way to get the human readable form of the statement?
Kind of.
You
19 matches
Mail list logo