Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)

On 12/04/2010 12:54 AM, Philip Graham Willoughby wrote: > 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 ";" >>

Re: [sqlite] WAL file size

header and the frames own contents? Dan. On 12/02/2010 11:04 PM, Yoni Londner wrote: > Hi, > > I will start out by stating that I am not deeply familiar with the > sqlite& WAL file layout, but I will try anyway, from my current > understanding: > > The general proble

Re: [sqlite] EXPLAIN QUERY PLAN

On 11/30/2010 11:38 PM, Duquette, William H (316H) wrote: > I've just discovered EXPLAIN QUERY PLAN; it looks quite useful, but one part > of the output is somewhat opaque. > > The command returns three columns: order, from, and detail. "order" is > evidently the order in which the indices are

Re: [sqlite] WAL mode and backup API

> BTW: > Is there any chance that in the future the wal mode > will avoid that the backup API will restart on DB > changes during the backup loop ? > Currently, even in wal mode, it does restart when changes > are detected while the backup is ongoing. What happens if you open a read transaction

Re: [sqlite] WAL mode and backup API

On 11/30/2010 05:03 PM, Marco Bambini wrote: > Hello, > > if a running sqlite database is in WAL mode and a backup is performed on that > db using the sqlite3_backup API, does that process is considered like a > reader and can proceed concurrently with other readers and with the other > writer?

Re: [sqlite] searching with like on FTS3

On 11/30/2010 12:09 AM, boscowitch wrote: > Hi recently I noticed that i can't search with the like '%searchword%' > syntax on an FTS3 virtual table. > > And with "match" i can't search on example sentences (the indexed data > is a japanese dictionary an therefore has no spaces in example

Re: [sqlite] WAL, durability, and synchronous=NORMAL

On 11/25/2010 09:04 PM, Simon Slavin wrote: > > On 25 Nov 2010, at 2:00pm, Dan Kennedy wrote: > >> In WAL mode with synchronous=NORMAL, when the user commits >> a transaction, it is written into the WAL file. No sync >> until a checkpoint happens. So if the power f

Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)

On 11/25/2010 03:45 PM, Philip Graham Willoughby wrote: > Hi all, > > I'm noticing a new failure with SQLite 3.7.3 as compared to the previous > version I was using, 3.6.23.1. Are you able to share the database and the query that causes the assert() to fail?

Re: [sqlite] WAL, durability, and synchronous=NORMAL

On 11/25/2010 08:49 PM, Simon Slavin wrote: > > On 25 Nov 2010, at 8:36am, Dan Kennedy wrote: > >> On 11/25/2010 03:24 PM, Twylite wrote: >>> > > Argh. Trevor, I'm going to find Stephenie Meyer and do something she doesn't > like. > >>> I am se

Re: [sqlite] autoindex1 test fail on linux debian

On 11/25/2010 02:43 PM, Yoni wrote: > Hi, > > I get the following fail when running sqlite3 tests, under linux debian, > with TCL 8.4. > Code is latest from fossil. > Any help appreciated. Try with 8.5 or newer. ___ sqlite-users mailing list

Re: [sqlite] WAL, durability, and synchronous=NORMAL

On 11/25/2010 03:24 PM, Twylite wrote: > Hi, > > I am seeking technical information on the durability of transactions > with journal_mode=WAL and synchronous=NORMAL. > > Specifically, in the event of a power failure, can the following ever > happen: > (1) Loss of the last transaction completed. >

Re: [sqlite] NO_GETTOD

On 11/22/2010 11:48 PM, Black, Michael (IS) wrote: > Bug in 3.7.3? > gcc -c -DNO_GETTOD sqlite3.c > sqlite3.c: In function âunixCurrentTimeInt64â: > sqlite3.c:27870: error: âiâ undeclared (first use in this function) > sqlite3.c:27870: error: (Each undeclared identifier is reported only once >

Re: [sqlite] Compile 64bit version of SQLIte on Solaris?

On 11/22/2010 03:25 PM, Lynton Grice wrote: > Hi there, > > That does not work, I tried that already. > > # /usr/local/bin/gcc -m64 -D_FILE_OFFSET_BITS=64 -c -fPIC -DHAVE_USLEEP > sqlite3.c > sqlite3.c:1: sorry, unimplemented: 64-bit mode not compiled in > # > > And I am on a 64-bit Solaris box...

Re: [sqlite] Custom collating sequences and performance

x b-tree. You do need to have the collation sequence registered when compiling the query though. Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Trouble with TRIGGERS

triggers might be needed is the type of statement (UPDATE, DELETE, INSERT) and for UPDATES, the columns updated. Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Strange WAL mode on 5GB+ database

sqlite> pragma journal_mode=delete; > Error: database is locked > sqlite> pragma integrity_check; > ok > sqlite> pragma journal_mode=delete; > delete Is this a repeatable problem? Any other processes accessing the database when you run the test? Dan. __

Re: [sqlite] INSERT OR IGNORE with rtree virtual tables

> >> Is this a bug, or operating as designed? Virtual tables (like r-tree and fts3) ignore ON CONFLICT clauses. Just the way it is unfortunately. Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Query planner bug on "distinct" clause

) clause identifies a small number of rows, then the last assumption will be incorrect - using the rowid index would be much faster. But SQLite doesn't know this when formulating a query plan. Regards, Dan. > The correct plan may be: > sqlite> drop INDEX object_id_ts_idx; > CPU T

Re: [sqlite] A question about transactions

error occurs the transaction may be rolled back automatically. Or sometimes if the file-system is full. Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mistake in threadtest3.c

e second instance? Fair question. But in this case no. The idea was to have one thread modifying the triggers. Then several other reader threads using the database with the reader threads using both shared and unshared caches. Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] BUG

On Oct 26, 2010, at 2:22 PM, Alexey Pechnikov wrote: >> But view_user statement makes no attempt to select the last >> version. It > picks some arbitrary random version. You might want to consider > something > like this: > > Why you wrote about "some arbitrary random version" when we have

Re: [sqlite] Foreign key on different database - possible?

On Oct 20, 2010, at 4:47 PM, Frank Millman wrote: > Dan Kennedy wrote: >> >> 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

Re: [sqlite] Foreign key on different database - possible?

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

Re: [sqlite] Scaling of Cache

() limit), then when a page is required one connection, it can steal the buffer space from some other connections page cache. Dan. > Thanks > Doug > > >> -Original Message- >> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >> boun...@sqlite.o

Re: [sqlite] Attach on disk database to memory database

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 >

Re: [sqlite] TestFixture 3.7.2 - Some WAL tests fail on QNX OS

second mmap() call is zeroing the memory mapped by the first mmap() call. Which is, as you might expect, confusing SQLite. I guess it could also be the second ftruncate() call that is zeroing our mapped memory. That would be even odder though... Dan. > May just need some QNX logic that say

Re: [sqlite] Just want to double check on index need

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) >>> ); > >

Re: [sqlite] Just want to double check on index need

> separately. It should be clearer. Basically the index would be redundant if it contains the same columns in the same order as the primary key. Or a prefix thereof. i.e. the following indexes would be all be redundant (pure overhead for no benefit):

Re: [sqlite] TestFixture 3.7.2 - Some WAL tests fail on QNX OS

On Oct 14, 2010, at 5:53 PM, Raj, Praveen wrote: > Hi Dan, > > I did some more investigation on the issue and i feel there is > synchronization problem happening here. > > After mmapping the shm (wal index) file to process memory, the WAL > indexes are written

Re: [sqlite] handling of BLOB bound parameters

a problem, maybe you can clear the hook (by passing NULL to sqlite3_trace()) temporarily while executing queries that use large blobs. Or don't use it at all, if you can live without SQL tracing. Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] TestFixture 3.7.2 - Some WAL tests fail on QNX OS

ust need to dig into memory mapping to find whats happening > and hopefully find a solution. > > Dan - Do you have any idea on why this could be happening? Sounds like a bug in QNX to me. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [BUG] JOIN subquery in FROM with FTS3 table

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

Re: [sqlite] TestFixture 3.7.2 - Some WAL tests fail on QNX OS

On Oct 6, 2010, at 9:39 PM, Raj, Praveen wrote: > Hi Dan, > > For debugging purpose we use the QNX Momentics which is the IDE > provided by QNX. I believe to certain extent > we should be able to debug the issue using IDE. In what situations > does the shared memory bl

Re: [sqlite] TestFixture 3.7.2 - Some WAL tests fail on QNX OS

separate mapping for each 32KB block) is zeroing the first. Somehow. Do you have a good debugger for the platform? Dan. > Any insights on whats happening here would be of great help. > > Thanks, > Praveen > > -Original Message- > From: sqlite-users-boun...@sqlite.org [ma

Re: [sqlite] TestFixture 3.7.2 - Some WAL tests fail on QNX OS

ts [file size test.db-wal] puts [file size test.db-shm] or similar after the test case. Here the files are 1024, 4333512 and 65536 bytes. From what you are saying it sounds like the problem is occurring when the -shm file grows from 32KB to 64KB. Dan. ___

Re: [sqlite] Referential integrity based on a view.

testing the FK constraint. More details here: http://www.sqlite.org/foreignkeys.html#fk_indexes Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Help: Required help/guidance for the segmentation fault in sqlite3 library to proceed further...

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

Re: [sqlite] COUNT very slow

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

Re: [sqlite] Overflow Page

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

Re: [sqlite] cast from pointer to integer of different size

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,

Re: [sqlite] Understanding Shared-Cache Mode

each and every time the module code gets a > connection, it simply calls int sqlite3_enable_shared_cache(int) to > make sure that connection is in the shared-pool. Am I correct in > assuming that the cost of calling int sqlite3_enable_shared_cache

Re: [sqlite] memory wasted shm mapped file (3.7.2)

ernal logic that requires this, but on > Windows 350 > regions is a maximum in this case. Does it mean that linux share > address > space for superset/subset regions in contrary to Windows logic? It is separate. This bug was in the OS specific win32 layer Dan. __

Re: [sqlite] memory wasted shm mapped file (3.7.2)

On Sep 9, 2010, at 10:04 PM, Max Vlasov wrote: > On Thu, Sep 9, 2010 at 11:37 AM, Dan Kennedy <danielk1...@gmail.com> > wrote: > >> >> On Sep 9, 2010, at 1:12 PM, Michele Pradella wrote: >> >>> Hi, do you have some news about the wasted m

Re: [sqlite] "create table as" syntax

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. > >

Re: [sqlite] memory wasted shm mapped file (3.7.2)

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

Re: [sqlite] FTS3 finds too much: Slash special meaning? Something else?

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

[sqlite] iCalendar (*.ics) import ?

I have Google-ed references to a utility called ical2sqlite, which claims to be able to make a database out of an iCalendar data file. Anyone on this list have any experience with it ? “Sometimes I think the surest sign that intelligent life exists elsewhere in the universe is that none of it

Re: [sqlite] upstreaming Chromium patches for file handle passing support

or where to create a master journal file if the client writes to the database? Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Upon table creation, multiple CHECK constraints do not work with FTS3

nstructor failed Maybe it thinks the two "CHECK(1)" identifiers represent a duplicate column name. CHECK constraints will not work with either fts3 or rtree virtual tables. If they are parsed at all, they will probably not do what you are expecting. Dan. _

Re: [sqlite] Why the deadlock?

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 >

Re: [sqlite] Why the deadlock?

the statement. Maybe somebody somewhere forgot to set autocommit to 0 > when select started executing? > > Dan, can you shed some light on this strange behavior? When you commit a transaction, SQLite upgrades to an EXCLUSIVE lock so that it can write to the database file. Once it has finished c

Re: [sqlite] errors running test suite (couldn't execute "testfixture")

d I do to make it pass? Either add "." to the PATH variable or do another update. Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug in FTS3 when trying to rename table within a transaction

fts3 tables should only renamed outside of transactions. Dan. > > See below: > > D:\temp>sqlite3 tmp.db > SQLite version 3.6.23.1 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> create table NonFts (docid

Re: [sqlite] EXTERNAL: Record corruption on Mac OS X 10.6 (Snow Leopard)

> 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.

Re: [sqlite] Why the deadlock?

hat it releases all locks. Cannot obtain the required EXCLUSIVE lock, due to the PENDING lock held by thread 2. http://www.sqlite.org/lockingv3.html#pending_lock > - Now thread 2 can execute statement 3. This would be true, but we don't get this far because the progr

Re: [sqlite] Why the deadlock?

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

Re: [sqlite] Distinct Bug

1 > > I'd have thought it should return > 1 > 1 > 1 Thanks for this report. Now fixed in fossil tip. Bug here: http://www.sqlite.org/src/info/e4b8a2ba6e Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there a table that show all the available function from sqlite3?

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

Re: [sqlite] Reserve database pages

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 >>>

Re: [sqlite] Backup API, .backup command, and writing to handle live backups?

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

Re: [sqlite] performance, transactions and wal checkpoints

as part of the first SQL statement run). Are things any different if you change the sqlite3_wal_checkpoint() to sqlite3_exec(conn, "PRAGMA wal_checkpoint", 0, 0, 0)? Dan. > #include "sqlite3.h" > #include "stdio.h" > #include "stdlib.h"

Re: [sqlite] performance, transactions and wal checkpoints

tion (but in the same thread). > It only worked if I do the checkpoint on the same connection. You cannot run a checkpoint from within a transaction. If you are in shared-cache mode, this means you cannot run a checkpoint while any connection to the same database has an open transaction. Does tha

Re: [sqlite] Process memory space exhausted in 3.7.0

o chunks > _and_close_the_connection_between_chunks_ then the error does not > occur. Does this imply that if you add an sqlite3_exec("COMMIT;BEGIN") every 10,000 inserts the program still does not run to completion? Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] foreign key the true error - sqlite 3.7.0.1

conclusion of your two insert statements, table "a" contains (1, 1) and table "b" contains (1, 2). Since the contents of table "b" violate the FK constraint, an exception is thrown. Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Write-ahead logging and database locking

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 >> a

Re: [sqlite] Write-ahead logging and database locking

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

Re: [sqlite] Backup API, .backup command, and writing to handle live backups?

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

Re: [sqlite] how to clone revision 3.2.6 using fossil

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

Re: [sqlite] "database disk image is malformed" while using WAL

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. >

Re: [sqlite] "database disk image is malformed" while using WAL

checkpoint finished. Thanks for this report. If possible, can you try your test with the latest from fossil (newer than e75b52d156)? Thanks. http://www.sqlite.org/src/zip/SQLite-016486c7d544dcf9.zip?uuid=016486c7d544dcf9b7422cb0fb9804aa1c418f68 Please post if you need an ama

Re: [sqlite] WAL still detects deadlock

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 >&g

Re: [sqlite] WAL still detects deadlock

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 >

Re: [sqlite] [PATCH] Verify number of arguments in icuRegexpFunc

On Jul 30, 2010, at 12:44 PM, Scott Hess wrote: > On Thu, Jul 29, 2010 at 10:05 PM, Dan Kennedy > <danielk1...@gmail.com> wrote: >> On Jul 30, 2010, at 8:39 AM, Paweł Hajdan, Jr. wrote: >>> I'm attaching a suggested patch to verify number of arguments >>

Re: [sqlite] [PATCH] 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=markup > >

Re: [sqlite] Couple of questions about WAL

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 co

Re: [sqlite] Couple of questions about WAL

> 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

Re: [sqlite] Couple of questions about WAL

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

Re: [sqlite] SQLite version 3.7.0

ontinue writing without causing an error. You cannot delete a file while it is open on windows, so this doesn't come up on win32. This happened with a couple of Tcl tests too. Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] "Unable to Open DB" on Win-7 & Vista (64 bitt) on UAC -ON

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

Re: [sqlite] Nested set "make space" query, sum(column) returns NULL with no match

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

Re: [sqlite] sqlite database handle caching and write permissions

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_aut

Re: [sqlite] sqlite database handle caching and write permissions

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

Re: [sqlite] SQLITE_CANTOPEN returned from sqlite3_step

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

Re: [sqlite] Documentation error in explanation of "IN subquery" (lang_expr.html)

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

Re: [sqlite] FTS3 - NEAR operator

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

Re: [sqlite] database corruption problem

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 by cha

Re: [sqlite] database corruption problem

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

Re: [sqlite] Bug and possible fix: Access violation in rtree.c:nodeGetRowid()

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

Re: [sqlite] Bug and possible fix: Access violation in rtree.c:nodeGetRowid()

ications. Better than crashing anyhow. On the other hand, it isn't a particularly pleasant thought that this can happen... Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] on delete no action

itself (example 2 below) > equivalent to specifying "ON DELETE NO ACTION?" What concept am I > missing from the docs? ;) Could be that you need SQLite version 3.6.19 or later. Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_OMIT_WSD (3.6.23.1)

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

Re: [sqlite] No conflict clause in foreign key clause?

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

Re: [sqlite] Using cache stats to balance transaction size for optimal performance

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.

Re: [sqlite] SQLITE_OMIT_WSD (3.6.23.1)

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

Re: [sqlite] Using cache stats to balance transaction size for optimal performance

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-since-3.5.9--t

Re: [sqlite] File locking with BEGIN/END

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;

Re: [sqlite] Index not used in simple alias-like views

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

Re: [sqlite] sqlite3_prepare_v2 && SQLITE_BUSY

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

Re: [sqlite] Can an online backup happen during a nested transaction?

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

Re: [sqlite] DB files are different between PC side and instrument side.

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

<    6   7   8   9   10   11   12   13   14   15   >