Hi!

I'm trying to access a readonly database without locks, using the 
amalgamation of SQLite 3.6.14.2

After I opened the database with flags = SQLITE_OPEN_READONLY I perform

sqlite3_exec (db, "PRAGMA omit_readlock=ON", 0, 0, 0);

I traced that down into the amalgamation to the point where the database 
flag is set in flagPragma...

db->flags |= p-mask;

So I can be sure the pragma syntax is correct.


Now when I execute a SELECT statement, it is parsed and I run into 
pagerSharedLock, but
the pager->noReadlock variable is 0. As a result the database file gets 
locked.


It look like the initialization of the pager->noReadlock flag, but that 
happens when the database is
opened.

Am I doing something wrong or did this ("Very experimental") feature got 
lost in past refactorings?


Thanks for listening & in advance to any hints
Joerg



- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
- - - - - - - - - - - - - - - - - - - - - - - - - - -
Steinberg Media Technologies GmbH, Neuer Hoeltigbaum 22-32, D-22143 Hamburg, 
Germany
Phone: +49 (40) 21035-0 | Fax: +49 (40) 21035-300 | www.steinberg.net 
Managing Director: Andreas Stelling, Kazunori Kobayashi, Takuya Nakata
Registration Court: Hamburg HRB 86534
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
- - - - - - - - - - - - - - - - - - - - - - - - - - -

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to