On Wed, Aug 1, 2018 at 10:39 AM Hick Gunter <h...@scigames.at> wrote:
> Are you sure it is not the special case documented in the ATTACH command? > (see https://sqlite.org/lang_attach.html) > Good point. OP will tell us if it applies to his/her case. > " Transactions involving multiple attached databases are atomic, assuming > that the main database is not ":memory:" and the journal_mode is not WAL. > If the main database is ":memory:" or if the journal_mode is WAL, then > transactions continue to be atomic within each individual database file. > But if the host computer crashes in the middle of a COMMIT where two or > more database files are updated, some of those files might get the changes > where others might not." > Still, why would UNION behave differently from UNION ALL? That's the puzzling part IMHO. --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users