Hi Richard, That helped a lot and got me passed that point. However, I didn't go very far from where I were...
It now compiles fine, however the program segfaults within the sqlite3_step() of the "create virtual table foo using vtable_module1;" statement. Using valgrind, I get this interesting message: ==31748== Jump to the invalid address stated on the next line ==31748== at 0x0: ??? ==31748== by 0x5A0D119: vtabCallConstructor (in /usr/lib64/libsqlite3.so.0.8.6) ==31748== by 0x5A3D499: sqlite3VdbeExec (in /usr/lib64/libsqlite3.so.0.8.6) ==31748== by 0x5A3E969: sqlite3_step (in /usr/lib64/libsqlite3.so.0.8.6) [...] This looks (to me) like one of the NULL function pointers in struct sqlite3_module is being called. I added a valid xRename() function as I had initially thought it was optionnal, but still not working. I then tried creating a dummy function for every one of these pointers, but I get the same result. I even tried changing the "create virtual..." statement to include module params (which my module ignores) but again it didn't change anything. Where should I look at next? Thanks again for your help, Simon On Fri, Oct 4, 2013 at 10:54 AM, Richard Hipp <d...@sqlite.org> wrote: > > > > On Fri, Oct 4, 2013 at 10:07 AM, Simon <turne...@gmail.com> wrote: > >> >> 3) I call sqlite3_create_module() with module name "vtable1" >> >> 4) I call sqlite3_declare_vtab() with this statement: "CREATE TABLE foo ( >> x >> integer, y integer );" >> > > > The application must never invoke sqlite3_declare_vtab(). The > sqlite3_declare_vtab() interface can only be called from within the xCreate > and xConnect methods of the virtual table implementation. If called from > any other context, sqlite3_declare_vtab() returns the error you describe. > > When you run "CREATE VIRTUAL TABLE name USING module;" the xCreate method > is called to create the new virtual table. The xCreate method needs to > tell the SQLite core what the schema for the virtual table is and it uses > sqlite3_declare_vtab() to do so. > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
