On 29 Mar 2017, at 1:33am, Mark Brand <mabr...@mabrand.nl> wrote: >> The point isn't about which table one expects to receive the update, it's >> that *both* tables get updated.
No. Just the one table is updated: the temp.t table. Both rows of data are in that table. Try repeating your experiment but replace this line insert into t select 'main', 'original'; with this: insert into main.t select 'main', 'original'; Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
