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