WAL mode also cannot preserve transactions across multiple ATTACHed database files. Transactions on WAL mode databases must use only a single database file to

WAL mode also cannot preserve transactions across multiple ATTACHed database files. Transactions on WAL mode databases must use only a single database file to maintain ACID.