And only when commit is used to end the transaction, an explicit rollback works properly.
> 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 > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
