On Sat, 26 Mar 2016 16:08:33 +0100 Eduardo Morras <emorrasg at yahoo.es> wrote:
> 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". > Is that means FTS5 is enabled? sqlite> pragma compile_options; ENABLE_COLUMN_METADATA ENABLE_DBSTAT_VTAB ENABLE_FTS3 ENABLE_FTS4 ENABLE_FTS5 ENABLE_JSON1 ENABLE_RTREE ENABLE_UNLOCK_NOTIFY HAVE_ISNAN SECURE_DELETE SYSTEM_MALLOC THREADSAFE=1 But the problem is not about working FTS5 or not. The created table is persistent and can't be dropped or fixed somehow. > > > --- --- > 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 -- http://fresh.flatassembler.net http://asm32.info John Found <johnfound at asm32.info>