[sqlite-dev] problem using sqldiff.exe with fts table

77 views
Skip to first unread message

Gianpaolo Marin

unread,
Feb 16, 2017, 10:38:22 AM2/16/17
to sqlit...@mailinglists.sqlite.org
Hi, i dowload the latest version of sqldiff 3170000 for compare two db with fts4 table. But if i lunch the command

sqldiff.exe --primarykey --vtab "db1.sqlite" "db2.sqlite" > diff.txt

it returns

sqldiff.exe: SQL statement error: no such module: fts4
"PRAGMA main.table_info='v_images'"

I have this error with fts3, fts4 or fts5 table but in this version there is witen in the documentation that the virtual table are supported.

Best regards


Gianpaolo MarinArcoda s.r.l.  

    tel. +39 0461 1920144 fax +39 0461 1860888 - www.arcoda.it - via del Brennero 139 - 38121 Trento, ITALY

Bernardino Ramos

unread,
Feb 16, 2017, 11:54:54 AM2/16/17
to sqlit...@mailinglists.sqlite.org

It supports but they must be enabled when compiling. Check this out:

https://www.sqlite.org/fts3.html#compiling_and_enabling_fts3_and_fts4

For more questions like this use the sqlite-users mailing list.

Bernardo Ramos

_______________________________________________
sqlite-dev mailing list
sqlit...@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-dev

Reply all
Reply to author
Forward
0 new messages