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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users