On Saturday, 26 March, 2016 09:09, Eduardo Morras <emorrasg at yahoo.es> wrote:
Clearly the tables were created, however (see the output from .tables). This *only* occurs if you wrap the "create virtual table" in an explicit transaction but does not occur if an implicit transaction is used. The tables are persistent in the file and cannot be dropped ... (ie, if you exit the shell and run again with the same database file, the tables are there according to .tables, and cannot be dropped). The same issue exists with the current head of trunk. > On Sat, 26 Mar 2016 16:37:18 +0200 > John Found <johnfound at asm32.info> wrote: > > Why cannot drop the table test? > > > > sqlite> begin transaction; > > sqlite> create virtual table test using fts5; > > Error: vtable constructor failed: test > > sqlite> commit; > > sqlite> > > sqlite> drop table test; > > Error: vtable constructor failed: test > > sqlite> .tables > > test test_content test_docsize > > test_config test_data test_idx > > $sqlite3 --version > > 3.11.1 2016-03-03 16:17:53 f047920ce16971e573bc6ec9a48b118c9de2b3a7 > > Because table test was not created. You get an error when create virtual > table. Check you sqlite3 shell has fts5 compiled in. You can do that > executing "pragma compile_options". > > > > -- > > http://fresh.flatassembler.net > > http://asm32.info > > John Found <johnfound at asm32.info> > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > --- --- > Eduardo Morras <emorrasg at yahoo.es> > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
