Both SQlite.exe and lsm.dll are compiled on Win10 with Mingwin64. Lsm by copying sqlite3.h and sqlite3ext.h to the lsm1 directory and then: make lsm.so TCCX="gcc -g -O2" and rename to lsm.dll
Creating a lsm table with an INT key results in the following: SQLite version 3.28.0 2019-04-16 19:49:53 [...] sqlite> .load lsm sqlite> CREATE VIRTUAL TABLE test USING lsm1 ( ...> 'test.lsm', idx, INT, d ...> ); Error: key type should be INT, TEXT, or BLOB sqlite> CREATE VIRTUAL TABLE test USING lsm1 ( ...> 'test.lsm', idx, INTEGER, d ...> ); Error: key type should be INT, TEXT, or BLOB Using TXT or BLOB there is no error. Did I go wrong somewhere? Ingo _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users