Hello, I had a closer look at the data Gnucash 2.3.3 was writing into it`s MySQL-tables and I noticed that the entry for the root-account on the "accounts"-table is missing.
All the accounts directly below root have the same parent_guid but there is no entry for that guid in the "accounts"-table. This is a serious architectural difference to the XML -datastructures where the root-account can have a currency and slots. It also means that referential integrity is never given. (Even when Gnucash is done and no longer connected. This is... not exactly acceptable behavior for a financial application.) 1) Is this a bug in the gnucash-version I used? 2) How is one to find the root-account without doing such expensive queries as "select parent_guid from accounts there parent_guid not in (select guid from accounts)" 3) Where are the properties of the root-account stored when importing an existing XML-file or exporting it again? For a financial application I would expect it to guarantee 100% semantically identical content in that roundtrip. Marcus _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
