On Oct 20, 2010, at 3:59 PM, Frank Millman wrote:
> Hi all
>
> I am using SQLite 3.7.2 on Fedora 10.
>
> I have multiple databases, which I can access concurrently by using
> the
> 'attach' command, and then referring to each table using
> 'database.tablename'. It works well.
>
> Now I want to
On Oct 19, 2010, at 9:01 AM, Doug wrote:
> I'm not going to pretend to understand the SQLite source, but it seems
> like having a mutex per PCache1 (ie the param passed in to
> pcache1Fetch
> and other cache functions) would be a good approach instead of the
> global
> mutex. But that approa
On Oct 15, 2010, at 11:40 PM, Schoinya wrote:
>
> Hello everybody
>
> I'm trying to attach on disk database to in memory database.
>
> But I get the strange error : SQLite error unrecognized token: ":"
>
> The following is the code:
>
>SQLiteConnection connInMemory = new
> SQLit
call is executed.
>
>while(pShmNode->nRegion<=iRegion){
> int ret = msync( apNew[0], iRegion*szRegion, MS_SYNC);
> void *pMem = mmap(0, szRegion, PROT_READ|PROT_WRITE,
> MAP_SHARED, pShmNode->h, pShmNode->nRegion*szRegion
> );
>
> Wit
On Oct 14, 2010, at 11:56 PM, Alan Chandler wrote:
> On 14/10/10 17:28, Dan Kennedy wrote:
>>
>> On Oct 14, 2010, at 10:43 PM, Alan Chandler wrote:
>>> CREATE TABLE div_winner_pick (
> ...
>>> PRIMARY KEY (cid,confid,divid,uid)
>>> );
>
> .
On Oct 14, 2010, at 10:43 PM, Alan Chandler wrote:
> I am porting an application (American Football Results Picking
> Competition) over from a Postgres databaseo to SQLite which involves
> some fairly intense queries. I am doing this partially to do some
> performance comparisons although I have
around
the mmap() problem. Hard to be really confident though - there
may be race conditions lurking...
Thanks for looking into this.
Dan.
>
> This is all my understanding and not sure if this is causing the
> actual issue. Please guide me if my approach/understanding is
> incor
On Oct 14, 2010, at 5:43 PM, Jens Miltner wrote:
> I just stumbled across a problem where sqlite would be stuck for
> quite a long time inside sqlite3VdbeExpandSql when using bound BLOB
> parameters, i.e. my query looks like
>
> INSERT INTO foo VALUES (?,?,?,?...)
>
> and one of the parameter
On Oct 8, 2010, at 9:44 PM, Raj, Praveen wrote:
> Hello,
>
> I debugged the SQLite functions and here is my finding:
>
> The call to "mmap" in the function "unixShmMap" is causing the issue.
> void *pMem = mmap(0, szRegion, PROT_READ|PROT_WRITE,
> MAP_SHARED, pShmNode->h, iRegion*szRegio
On Oct 7, 2010, at 5:50 PM, Shopsland gmail wrote:
> Hi,
>
> Given this simple query with a subquery in FROM and a join with a
> FTS3 table:
>
> SELECT news1.number, fts_news.title
> FROM (SELECT number FROM news LIMIT 50) as news1, fts_news
> WHERE news1.number=fts_news.docid
>
> The query run
ay, you're looking
for the point where that buffer pWal->apWiData[0] is
overwritten with zeroes.
Dan.
> Thanks,
> Praveen
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org
> ] On Behalf Of Dan Kennedy
> Sent
eases?
>
> Please suggest some tips to find out the root cause for this issue.
>
> Thanks,
> Praveen
>
> From: sqlite-users-boun...@sqlite.org [sqlite-users-
> boun...@sqlite.org] On Behalf Of Dan Kennedy [danielk1...@gmail.com]
> Se
On Oct 1, 2010, at 2:20 PM, Raj, Praveen wrote:
> Hi,
>
> I'm validating SQLite test suite version 3.7.2 on QNX operating
> system. I have built the testfixture using SQLite amalgation file
> and other related files/libraries.
>
> I ran the full test suite and most of the test cases are passi
On Sep 30, 2010, at 3:30 PM, Muthuveerappan Alagappan wrote:
> Hi
>
> I am a newbie to sqlite, I am having difficulty in trying to
> build
> referential integrity based on a view.
>
> sqlite allows me to create referential integrity based on a
> view
On Sep 23, 2010, at 9:57 PM, Borra, Kishore Babu wrote:
> Hi,
>
> I require some help in getting the fix for some memory corruption
> issues, occurring while using the sqlite3 library. It would be very
> helpful, if you can guide to fix the below issues or atleast provide
> some info on thi
On Sep 24, 2010, at 3:13 PM, Michele Pradella wrote:
> I have an SQLite DB of about 9GB with about 2.500.000 records.
> I can't understand why the "select COUNT(*) from log" statement is
> extremely slow, it takes me about 9-10 minutes!
In SQLite, count() is obliged to traverse the entire table
On Sep 22, 2010, at 12:23 PM, Scott Weigand wrote:
>
> Hello List,
> Apologies if this is the wrong list to post to. Can anyone tell me
> if an overflow page is encapsulated within a B-Tree page or if it
> starts on a standard page boundary and has its first 4 bytes as the
> next overflow
On Sep 16, 2010, at 2:09 AM, jagjeet singh nain wrote:
> Hi,
> I was compiling sqlite on 64 bit OS and i got following warning
> message.
>
> sqlite3.c: In function 'rtreeInit':
> sqlite3.c:118698:20: warning: cast from pointer to integer of
> different size
> Two versions were tried, 3.6.23.
On Sep 11, 2010, at 9:19 AM, Sam Carleton wrote:
> I just read the page on Shared-Cache Mode and it left me with some
> questions...
>
> Q1: Is my understanding correct: Shared-Cache Mode is used within a
> process to gain table locking, as compared to the normal file locking.
Fair enough. Th
> Michele, thanks for pointing out to vmmap, sysinternals made them so
> fast, I
> can not track them all. This is an excellent utility.
> I think that the development team already knows that is going on,
> just my
> speculation.
>
> As long as I see, every next file mapping wants to see not o
On Sep 9, 2010, at 10:04 PM, Max Vlasov wrote:
> On Thu, Sep 9, 2010 at 11:37 AM, Dan Kennedy
> wrote:
>
>>
>> On Sep 9, 2010, at 1:12 PM, Michele Pradella wrote:
>>
>>> Hi, do you have some news about the wasted memory? have you found
>>> the
&g
On Sep 9, 2010, at 3:56 PM, thomas veymont wrote:
> hello,
>
> I'm trying to use the "CREATE TABLE AS" syntax to create a table and
> insert
> in the same time a default row.
>
> e.g :
>
> sqlite> CREATE TABLE test (x NUMERIC) AS (SELECT 25 AS x);
> Error: near "AS": syntax error
>
> oops.
>
>
On Sep 9, 2010, at 1:12 PM, Michele Pradella wrote:
> Hi, do you have some news about the wasted memory? have you found the
> reason for the windows backend?
Fixed here:
http://www.sqlite.org/src/ci/f213e133f6
Does the problem still show up for you using fossil tip?
> do you think it
On Sep 2, 2010, at 6:37 PM, Lukas Haase wrote:
> Hi,
>
> I use FTS3 (SQLITE_ENABLE_FTS3) with enhanced query syntax
> (SQLITE_ENABLE_FTS3_PARENTHESIS).
>
> Now if I search for a string like '2002/91/AH' there are lots of items
> which do NOT contain this string. This is a query:
>
> SELECT rowid,
>
> What do you think about extending the SQLite VFS to make it possible
> to open
> a database having a file handle (fd on Unix, HANDLE on Windows)?
> Opening
> based on file path would still be there (to preserve compatibility).
How do you know which journal file to open or where to create
a
On Aug 30, 2010, at 12:22 PM, Benoit Mortgat wrote:
> Hello,
>
> The following table creation fails under latest release :
>
> CREATE VIRTUAL TABLE foo USING FTS3
> (
> bar TEXT, othercolumns TEXT,
> CHECK(1), CHECK(1)
> );
>
> Error message: vtable constructor failed
Maybe it thinks the two
On Aug 30, 2010, at 5:44 AM, Gilles wrote:
> Hello,
>
> When sqlite3async ("Asynchronous I/O Module For SQLite" -
> http://www.sqlite.org/asyncvfs.html) is used, is it possible to keep
> running
> SQLite in the Single-thread mode (as described in
> http://www.sqlite.org/threadsafe.html) or does
On Aug 25, 2010, at 11:04 PM, Pavel Ivanov wrote:
>> Prior to version 3.6.5 SQLite used to delay committing the
>> transaction until all SELECT statements had finished. But that
>> behavior was deemed to be less intuitive.
>
> But this is the current 3.7.1 documentation
> (http://www.sqlite.org/l
On Aug 25, 2010, at 10:40 PM, Pavel Ivanov wrote:
> Nikolaus,
>
> I've traced your application a bit (with SQLite 3.6.18 sources) and
> it looks like SQLite does some nasty thing nobody in this thread
> expected. For some reason while doing first delete SQLite actually
> commits transaction and
On Aug 20, 2010, at 6:07 AM, Paweł Hajdan, Jr. wrote:
> I updated to latest fossil version, ran make distclean, ./configure,
> make,
> make test and got this:
Thanks for this report. The test code was assuming that "."
was in your PATH variable. Fixed now.
> What should I do to make it pass?
On Aug 19, 2010, at 1:21 AM, Nasron Cheong wrote:
> I'm getting a db error when trying to alter an fts table within a
> transaction.
>
> This only happens if the statement before the alter is an insert.
Thanks for the report. This won't get fixed until after
3.7.1 though. For now, fts3 tables sh
> I'm using SQLITE_STATIC since the memory buffer returned by
> cStringUsingEncoding should be valid until the object is deallocated,
> which doesn't happen until after the statement is executed.
You could try using SQLITE_TRANSIENT instead to verify this.
Or just go straight to valgrind. Good
On Aug 17, 2010, at 1:48 AM, Nikolaus Rath wrote:
> Hello,
>
> The script below fails with
>
> Deadlock detected when executing 'DELETE FROM foo WHERE id=2'
>
> What I think should be happening instead is this:
>
> - When executing statement 1, the main thread obtains a SHARED lock.
> - When exe
On Aug 17, 2010, at 1:48 AM, Nikolaus Rath wrote:
> Hello,
>
> The script below fails with
>
> Deadlock detected when executing 'DELETE FROM foo WHERE id=2'
>
> What I think should be happening instead is this:
>
> - When executing statement 1, the main thread obtains a SHARED lock.
>
> - When ex
On Aug 13, 2010, at 10:34 PM, Andy Chambers wrote:
> Is this a bug?
>
> create table t_distinct_bug (
> a,
> b,
> c
> );
>
> insert into t_distinct_bug values ('1', '1', 'a');
> insert into t_distinct_bug values ('1', '2', 'b');
> insert into t_distinct_bug values ('1', '3', 'c');
> insert int
On Aug 13, 2010, at 11:37 PM, Peng Yu wrote:
> Hi,
>
> http://www.sqlite.org/docs.html
>
> I don't see a table that shows all the available functions in sqlite3.
> Would you please let me know if there is such a table?
http://www.sqlite.org/lang_corefunc.html
http://www.sqlite.org/lang_dat
On Aug 13, 2010, at 8:41 PM, Max Vlasov wrote:
> On Fri, Aug 13, 2010 at 1:38 PM, Max Vlasov
> wrote:
>
>>
>> I can approximately calculate, how big the new database will grow. Is
>>> there a way to tell SQLite to reserve an inital space or numer of
>>> pages
>>> instead of letting the datab
On Aug 11, 2010, at 1:25 AM, David Barrett wrote:
> On 08/08/2010 10:00 PM, Dan Kennedy wrote:
>>
>> On Aug 9, 2010, at 11:17 AM, David Barrett wrote:
>>> 3) When an application performs read/write queries on the database
>>> in
>>> parallel to the
GMA synchronous=normal");
>sql_exec(conn, "PRAGMA temp_store=memory");
> sql_exec(conn, "PRAGMA wal_autocheckpoint=-1");
>sql_exec(conn, "create table tbl1 (one varchar(20), two
> varchar(20))");
>while (1)
>{
>if (!(i++%1000))
&
> Hi,
> I just wanted to add that I changed the program a little bit to not
> use
> transactions and threads, and I still get the same problem (huge WAL
> file).
> All I do is endless loop of insert, and every X insert, I perform a
> checkpoint on another sqlite connection (but in the same th
On Aug 10, 2010, at 11:55 AM, Victor Morales-Duarte wrote:
> As it turns out, I can reproduce the failure using a single huge
> insert.
> The code that I'm including below compiles under bcc32 from
> Embarcadero's C++ Builder 2007 and cl from vs2005. Since it's more
> likely that people have MS
> why returns the "INSERT INTO a" not an error while the "INSERT INTO
> b" does? How
> corresponds this behaviour to the concept of FOREIGN KEYS?
> CREATE TABLE a(
>idINTEGER PRIMARY
> KEY
> AUTOINCREMENT,
>id_staff_editor
On Aug 9, 2010, at 12:07 PM, Dan Kennedy wrote:
>
> On Aug 9, 2010, at 11:30 AM, David Barrett wrote:
>
>> I'm reading up on the new write-ahead logging feature, and I'm
>> unclear
>> on one point: does WAL only help alleviate multi-threaded locking (by
On Aug 9, 2010, at 11:30 AM, David Barrett wrote:
> I'm reading up on the new write-ahead logging feature, and I'm unclear
> on one point: does WAL only help alleviate multi-threaded locking (by
> allowing other threads to continue reading while one is writing), or
> does WAL also help between mu
On Aug 9, 2010, at 11:17 AM, David Barrett wrote:
> I *think* I know the answers these questions, but can you please
> confirm
> them for me?
>
> 1) Does the sqlite3 command-line app .backup command use the
> http://www.sqlite.org/backup.html API, and thus only read-lock the
> database for brie
On Aug 3, 2010, at 1:38 PM, Belisko Marek wrote:
> Hi,
>
> I will need to clone sqlite3 version 3.2.6.
> Could you please give me some commands how to do it in fossil?
fossil clone http://www.sqlite.org/src sqlite.fossil
fossil open sqlite.fossil
fossil update 1cdfe66714
__
On Aug 2, 2010, at 6:13 PM, Dan Kennedy wrote:
>
> On Aug 2, 2010, at 1:42 PM, Yoni Londner wrote:
>
>> Hi,
>> Forgot to mention that the inserting should be inside a
>> transactions, so
>> complete repro steps are:
>> 1. open sqlite connection.
>
On Aug 2, 2010, at 1:42 PM, Yoni Londner wrote:
> Hi,
> Forgot to mention that the inserting should be inside a
> transactions, so
> complete repro steps are:
> 1. open sqlite connection.
> 2. PRAGMA journal_mode=WAL
> 3. PRAGMA synchronous=full
> 4. PRAGMA temp_store=memory
> 5. sqlite3_enable
On Jul 31, 2010, at 10:47 PM, Edzard Pasma wrote:
> Op 31-jul-2010, om 14:16 heeft Dan Kennedy wrote:
>
>>
>> On Jul 31, 2010, at 12:02 AM, Edzard Pasma wrote:
>>
>>> Hello,
>>>
>>> The following scenario raises a BUSY error immediately
>>
On Jul 31, 2010, at 12:02 AM, Edzard Pasma wrote:
> Hello,
>
> The following scenario raises a BUSY error immediately
>
> process A. keeps a write lock
> process B keeps a read-lock and tries to promote this to a write-lock
>
> This is the traditional SQLite deadlock situation, detected by the
>
On Jul 30, 2010, at 12:44 PM, Scott Hess wrote:
> On Thu, Jul 29, 2010 at 10:05 PM, Dan Kennedy
> wrote:
>> On Jul 30, 2010, at 8:39 AM, Paweł Hajdan, Jr. wrote:
>>> I'm attaching a suggested patch to verify number of arguments
>>> in icuRegexpFunc
On Jul 30, 2010, at 8:39 AM, Paweł Hajdan, Jr. wrote:
> I'm attaching a suggested patch to verify number of arguments
> in icuRegexpFunc. Please review it.
>
> This is upstreaming of
> http://src.chromium.org/viewvc/chrome/trunk/src/third_party/sqlite/icu-regexp.patch?revision=34807&view=markup
>
On Jul 23, 2010, at 8:56 PM, Doug wrote:
> Thanks for your explanations Dan. The new WAL feature sounds great
> and I'm
> excited to try it. Two questions below:
>
>> When in WAL mode, clients use file-locks to implement a kind of
>> robust (crash-proof) reference counting for each database f
> If I do a BEGIN, SELECT1 and at that point a writer does BEGIN
> IMMEDIATE, SELECT3, UPDATE, COMMIT, and then I continue with SELECT2
> COMMIT, will SELECT1 and SELECT2 have a consistent view of the
> database
> unaffected by the UPDATE in the middle. In other words, is the
> Readers
> view
On Jul 22, 2010, at 6:07 PM, Alan Chandler wrote:
> I have been reading about WAL, and there are a few questions I would
> like to ask.
>
> 1) I am slightly confused about readers building the WAL index. It
> says
> way down the page
>
> quote:
>
> Using an ordinary disk file to provide shared
On Jul 22, 2010, at 1:08 PM, Darren Duncan wrote:
> Roger Binns wrote:
>> On 07/21/2010 08:01 PM, Darren Duncan wrote:
>>> Simply substituting in 3.7.0 causes a few new test failures for me
>>> with the Perl
>>> binding, DBD::SQLite, citing "disk I/O error".
>>
>> I can't speak for the Perl bin
On Jul 21, 2010, at 11:12 AM,
wrote:
>
> In my case, the DB is created by the older version of application and
> now the new version of application is installed and End user has
> option
> to see old data with selecting old version of DB so its completely on
> end user wish to choose the loc
On Jul 17, 2010, at 8:17 PM, Graham Leggett wrote:
> Hi all,
>
> I have been trying to find an efficient way of shifting the left and
> right values for multiple insertions of new nodes in the nested set
> model in one go, and I have been struggling to do this with sqlite.
>
> I have populated a
On Jul 16, 2010, at 2:05 PM, JT Olds wrote:
>> Unsafe. Using the authorizer callback instead to figure out if a
>> statement may write the database is a better way:
>>
>> http://www.sqlite.org/c3ref/c_alter_table.html
>> http://www.sqlite.org/c3ref/set_authorizer.html
>
> Beautiful Dan, thank
On Jul 16, 2010, at 6:33 AM, JT Olds wrote:
> I really would rather not depend on what is in the SQL itself, as the
> concern I have has nothing to do with whether or not the user runs
> SELECT, but whether or not this will cause the library to write to
> disk. I'd love to decouple those two thin
On Jul 15, 2010, at 8:35 PM, Yoav Apter wrote:
> Hi
>
> We are building a Windows application using a read-only Sqlite
> database. When executing many queries in a short time, we sometimes
> get SQLITE_CANTOPEN from sqlite3_step. Checking GetLastError gives
> us error code 123: The filename
On Jul 15, 2010, at 12:25 AM, Simon Slavin wrote:
>
> On 14 Jul 2010, at 5:13pm, Richard Hipp wrote:
>
>> Improvements to the IN operator documentation can be found here:
>>
>>http://www.sqlite.org/draft/lang_expr.html#in_op
>
> I find that table difficult to understand: you have some mutuall
On Jul 3, 2010, at 2:37 AM, Patel, Vinit wrote:
> Hi :
>
> I was wondering how the NEAR operator works for the SQL database.
> In the SQLite test suite, in test file fts3near.test, One of the
> test case is as follows
>
> //fts3near-3.1 test case
>
> db eval {
> DELETE FROM t1;
> INSERT INTO
On Jun 9, 2010, at 12:51 AM, Dave Segleau wrote:
>
> On 6/8/2010 9:25 AM, Dan Kennedy wrote:
>>
>> Those pragmas should not cause a problem. Simon's referring
>> to "PRAGMA synchronous". The docs for which explain the
>> risks assumed b
On Jun 8, 2010, at 10:54 PM, Daniel Stutzbach wrote:
> On Tue, Jun 8, 2010 at 10:02 AM, Simon Slavin
> wrote:
>
>> I'm not sure whether a power-cut at a particularly bad time could
>> cause
>> something like this. The journaling mechanism built into SQLite
>> should be
>> avoiding it, but
On Jun 2, 2010, at 7:19 PM, Simon Slavin wrote:
>
> On 2 Jun 2010, at 10:12am, Dan Kennedy wrote:
>
>> The fix you propose would ignore the (suspected) corruption
>> and continue without reporting it to the user. Which might be
>> the best thing for some
>
> bu
On Jun 1, 2010, at 10:21 AM, Peter Kolbus wrote:
> I am getting an access violation in rtree.c::nodeGetRowid() using a
> database image of questionable integrity (the application the database
> was last updated on shut down abnormally, but executing PRAGMA
> integrity_check returns "ok" and there
On Jun 2, 2010, at 11:41 AM, Scott Frankel wrote:
>
> Hi all,
>
> I've been lurking for a few days while I explore SQLite and find
> myself now with a question.
>
> What's the correct usage for the "ON DELETE NO ACTION" statement?
>
> I'm converting a schema file to SQLite. Executing a create ta
On May 29, 2010, at 10:19 AM, Albert Kim wrote:
>
> Hi Dan,
> It doesn't matter that it will never be written to. Since the
> variable is a
> non-const static it will get mapped into the WSD portion of memory.
Is a problem in practice? Or just messy?
_
On May 28, 2010, at 10:54 PM, Robert Nickel wrote:
> I notice that the foreign key clause
> (http://www.sqlite.org/syntaxdiagrams.html#foreign-key-clause) does
> not
> include a conflict clause
> (http://www.sqlite.org/syntaxdiagrams.html#conflict-clause). I always
> specify "ON CONFLICT ROLLBA
On May 28, 2010, at 5:42 PM, Pavel Ivanov wrote:
>> It will retry the EXCLUSIVE lock each time a page that is not
>> in the cache is required by SQLite (a "cache-miss").
>
> If SQLite doesn't require to read any pages but only adds new pages to
> the file does it count as cache-miss?
Yes.
_
On May 28, 2010, at 1:11 AM, Kim, Albert wrote:
> Hi,
>
> We are compiling sqlite 3.6.23.1 with the SQLITE_OMIT_WSD compile
> time flag turned on. We are using the amalgamation. We found that
> this didn't completely eliminate the writable static data in our
> binary, and some investigat
On May 27, 2010, at 8:07 PM, Pavel Ivanov wrote:
>> That's true, except for the case when exclusive lock fails; at
>> least that's
>> what Dan Kennedy says to my question from a couple of years ago:
>> http://old.nabble.com/changes-in-cache-spill-locking-sinc
On May 25, 2010, at 10:24 PM, Nick Shaw wrote:
> Hi all,
>
>
>
> I've got a database that is accessed by two processes on the same PC.
> When I add a large number of records to a table from one process (all
> records wrapped in a BEGIN DEFERRED / END so it's committed to disk
> all
> at once; a
On May 24, 2010, at 6:14 PM, Edzard Pasma wrote:
> Hello, I found a blind spot of the query optimizer. This appears when
> a table is accessed as a view. I think the problem can be phrased as
> "the optimizer failing to push an outer join predicate into a
> view"... This simply means that the fol
On May 18, 2010, at 10:18 AM, Sam Carleton wrote:
> For those of you following along my life (which I hope none of you
> are), I
> am working on cleaning up my code to handle SQLITE_BUSY correctly.
> The
> first issue I think I just successfully overcame was how to lock the
> DB to
> get m
On May 12, 2010, at 2:53 AM, Shaun Seckman (Firaxis) wrote:
> Hello,
>
>I'm attempting to save a backup of my in-memory
> database
> using the online backup routines. I noticed that I cannot seem to
> make
> backups of the database when there is a pending save point. The err
On May 11, 2010, at 2:54 PM, Lei, Rick (GE EntSol, SensInsp) wrote:
>
> Hi,
>
> I ported Sqlite3 to my instrument. The database file is stored in a
> SDHC
> card. Sqlite3 runs ok. However I found the database file generated on
> instrument side is much bigger than the file on PC side. I checked
On May 5, 2010, at 8:32 PM, myomancer wrote:
> Dear Users
>
> I've spent hours reading various web-based documents, examined lots of
> code snippets, written some code of my own, but I still patently do
> not understand SQLite locks.
4th paragraph of this page (The presence of a busy...) describ
Now fixed here:
http://www.sqlite.org/src/ci/f660be615a
For those playing at home, this is an example of how to write
a great bug report. Clear, concise explanation and a
self-contained minimal example.
Dan.
On Apr 30, 2010, at 8:51 AM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESS
On Apr 28, 2010, at 10:20 PM, Guillaume Duranceau wrote:
> Hello all,
>
> While running a SQLite transaction writing into the DB (thus holding
> the
> RESERVED lock), in case the memory cache becomes full, SQLite will
> try to
> write the content of a dirty page into the DB. To do so, it prom
On Apr 26, 2010, at 11:09 AM, Tom Broadbent wrote:
>
> thanks for the replies.
>
> understood. i was informed that our underlying (EMMC??) FS will do
> this w/ FS pages, i.e. read the entire 256k FS page, modify some
> small portion of it, and write it out again. i'm higher in the
> stack
On Apr 23, 2010, at 2:34 PM, liubin liu wrote:
>
> Is there any memory leak in the code?
The buffers returned by sqlite3_mprintf().
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Would the
> returning type matter in the overall execution of these look-ups?
>
> Thanks!
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org
> ] On Behalf Of Dan Kennedy
> Sent: Tuesday, April 13, 2010 2:11 PM
On Apr 14, 2010, at 1:05 AM, wrote:
> Hello,
>
> I have a question regarding the query-optimizer. I've tested SQLite
> with the following situation:
>
> 1 table defined as
>
> CREATE TABLE MyTable (ElementID INTEGER CONSTRAINT ElementID_PK
> PRIMARY KEY AUTOINCREMENT, Label VARCHAR(255))
>
>
On Apr 10, 2010, at 1:51 AM, Adam DeVita wrote:
> Is this a 1 off import? If so, perhaps the command line tool
> can .read it.
>
> On Fri, Apr 9, 2010 at 2:13 PM, Shaun Seckman (Firaxis) <
> shaun.seck...@firaxis.com> wrote:
>
>> Greetings,
>>
>> I've got a .SQL file that contains multiple SQL
On Apr 8, 2010, at 3:38 PM, Kent Boogaart wrote:
> BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px;
> }Thanks to all respondents.
> A RAM disk is a good idea, but would require me to jump through too
> many hoops to get it approved. Corporate environment, you see :(
> For now, I'
On Apr 8, 2010, at 4:33 AM, P Kishor wrote:
> On Wed, Apr 7, 2010 at 4:24 PM, Pavel Ivanov
> wrote:
>>> I get a "Error: constraint failed". I have no constraint other than
>>> INTEGER PRIMARY KEY on id.
>>
>> You should have something other than integer primary key, otherwise
>> it works:
>>
On Apr 7, 2010, at 3:23 AM, Chris verBurg wrote:
> Hehe, okay, here I go. :)
>
>
> I'm trying to replace an existing flex/bison parser with an re2c/lemon
> parser, but I'm running into a methodological problem. I have a
> hypothetical grammar like this:
>
> file ::= FOO str .
> file ::= BAR s
> Currently if an interrupt
> arrives during a long commit I have no way to know whether the commit
> was successful, and thus whether to commit or roll back the filesystem
> journal.
Maybe you can read the database to see if the new data
is there in this scenario.
> If I could flush the dirty p
On Apr 1, 2010, at 2:39 PM, Radovan Antloga wrote:
> I did not find any info about my situation in page
> http://www.sqlite.org/lockingv3.html
>
> I would just like a confirmation if this is expected
> behaviour.
>
> I have locking mode = normal. Steps are:
>
> 1. open database
> 2. open statemen
On Mar 31, 2010, at 10:23 AM, Kirill Simonov wrote:
> Hi,
>
> I encountered a weird bug. My query has the form
> SELECT col_x, ... FROM my_table ... GROUP BY 1
> but the output of the query looks as if it was produced by a query of
> the form
> SELECT col_y, ... FROM my_table ... GROUP B
Begin forwarded message:
> From: "Periasamy, Karthikeyan"
> Date: March 31, 2010 7:52:55 PM GMT+07:00
> To: "danielk1...@gmail.com"
> Subject: Re: [sqlite] Sqlite3 crashing on multithreaded program
>
> Hi,
>
> Thanks for your reply.
>
> In our application the block of code which access the DB
On Mar 30, 2010, at 8:53 PM, Pavel Ivanov wrote:
>> The segfault is now fixed here:
>>
>> http://www.sqlite.org/src/info/ca359a3e80
>
> Does the comment to commit mean that in the same test case if view has
> no triggers then compilation of the statement will still segfault?
No.
_
On Mar 30, 2010, at 6:29 PM, Alexey Pechnikov wrote:
> Hello!
>
> CREATE TABLE test (
> id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL
> );
> CREATE VIEW view_test as select * from test;
> CREATE TRIGGER view_test_insert instead of insert on view_test
> begin
> insert into test (id) values (NULL
On Mar 30, 2010, at 7:37 PM, Periasamy, Karthikeyan wrote:
> Hi,
>
> Our application is a multithreaded program running on Powerpc e300
> mpc8343 embedded board. There are 8 threads running which are
> querying and updating DB parallelly and continuously. We are using
> libdbi-0.8.2 and sq
On Mar 29, 2010, at 4:55 PM, Rickard Utgren wrote:
> I've managed to break a database, and I think it's related to defining
> new text collating sequences in Tcl. If I run "VACUUM" on it, it works
> fine again. I was told that this would likely be a bug in SQLite.
This database was created with
On Mar 29, 2010, at 10:48 AM, P Kishor wrote:
> On Sun, Mar 28, 2010 at 10:45 PM, Roger Binns
> wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> sub sk79 wrote:
>>> How So? Is SQLite getting a high concurrency module from BDB in
>>> exchange for its SQL API?
>>
>> I believe the
> ### PROBLEM
>
> With Sqlite 3.6.17 the following query executes in 12ms.
>
> ---
> SELECT a.number
> FROM a, fts
> WHERE
> a.number=fts.docid
> ORDER BY a.date desc
> LIMIT 20
> ---
>
>
> With Sqlite version 3.6.23 the same q
On Mar 24, 2010, at 7:24 PM, Andrew Sutherland wrote:
>
>
> As reported on https://bugzilla.mozilla.org/show_bug.cgi?id=551260#c17
> The binaries used below were all downloaded from sqlite.org.
>
> $ cat fts3-offsets-asplode.sql
> CREATE VIRTUAL TABLE ft USING fts3(tokenize=porter, fulltextOne,
1001 - 1100 of 1526 matches
Mail list logo