On 4/22/16, Martin Trnovec <martin.trnovec at pipelinersales.com> wrote: > 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)
My guess: unable to open a transient file to store the statement journal. Have you tried activating the error and warning log for more details: https://www.sqlite.org/errlog.html > > 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 > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp drh at sqlite.org
