Hello, we are using sqlite 3.12.1 on Android device and we are tring to copy content of the one table into another table using
INSERT OR REPLACE INTO <dst_table> SELECT * FROM <src_table> This commad will fail on Android with error code SQLITE_CANTOPEN when - <dst_table> has any triggers configured (also empty one like "select 1" ) - and the amount of row to be inserted is larger (currently it fails if it's 9226 rows but not with 9225 rows) the same code works perfectly on Windows or Mac OS o iOS, when we dropped the trigger it works also perfectly on Android ? Any hints ? Martin