> 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