[sqlite] Re: Migration from sqlite2 to sqlite3 - no tablename in p3 of Open* rows when explaining sql?

2006-11-14 Thread Igor Tandetnik
Mario Wolff wolfshoehle-gM/[EMAIL PROTECTED] wrote: i try to migrate my (alpha-state) project from sqlite2 to sqlite3. To realize table based acl's i call explain and take the OpenRead/OpenWrite lines and check for p3 entry which gives the affected table. With sqlite3 the p3 is not set! I

Re: [sqlite] Re: Migration from sqlite2 to sqlite3 - no tablename in p3 of Open* rows when explaining sql?

2006-11-14 Thread Mario Wolff
2006/11/14, Igor Tandetnik [EMAIL PROTECTED]: I trust you have read http://sqlite.org/opcode.html . For OpenRead and OpenWrite, P2 identifies the root page of the table to open. The root pages for each table and index can be found in sqlite_master table. Oh no, Murphy got me! I´ve testet with