> 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.
I messed up the last sentence, better:
It looks like the initialization of the pager->noReadlock flag only
happens
when the database is opened, but by that time the omit_readlock pragma is
not active.
>
> 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
