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>

Reply via email to