Should Unstable sqlite3 file look like maint ?

John Ralls jralls at
Mon Oct 30 16:57:41 EDT 2017


The Budget is still there, it just has the redundant parent frame name chopped off. Both Budget and counter_format are empty KvpFrames so ISTM they *should* be missing. I checked a new book saved to xml with 2.7.1 and see that it too is missing the options/counter_formats frame. 

The missing double_vals might be a bug in the slots sql code, I'll check that.

The time spec format change is IIRC a correction to match the format specified in one of the databases that's transparent to the others. As long as 2.6 can read a database written by 2.7 (aside from something guarded by features) it's OK.

John Ralls

> On Oct 30, 2017, at 12:50 PM, Robert Fewell <14ubobit at> wrote:
> I understand the guids will be different, I was more interested in the
> missing counter_formats, options/Budgets, double_val's missing and
> timespec_val being a different format.
> As these were effectively empty brand new files, was sort of expecting to
> have the same information. Just trying to understand what maybe different
> while trying to diagnose some issues in other tables.
> Bob
> On 30 October 2017 at 15:53, Derek Atkins <warlord at> wrote:
>> Hi,
>> Robert Fewell <14ubobit at> writes:
>>> Hi,
>>> I would like to ask if the contents / format of data in an unstable
>> sqlite3
>>> file be the same as one created by maint along with default values ?
>> I would not expect the 2.7 data file to be the same as 2.6.  In fact I
>> would have been shocked if they WERE the same.
>>> I have started Gnucash with the --nofile option on maint and unstable,
>>> taken all the default options and saved to sqlite3 files. Looking at them
>>> in SQLite Manager there are some differences so  just trying to decide
>> what
>>> needs further investigating and possible causes.
>> I'm not sure specifically what you're looking at.  The GUIDs would
>> absolutely be different, but this would be the case even if you did the
>> test twice with the same version of GnuCash.  So what, specifically, are
>> you trying to point out by your image?
>>> I have attached a screen shot showing the differences.
>>> Regards,
>>>  Bob
>> -derek
>> --
>>       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>>       Member, MIT Student Information Processing Board  (SIPB)
>>       URL:    PP-ASEL-IA     N1NWH
>>       warlord at MIT.EDU                        PGP key available
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at

More information about the gnucash-devel mailing list