2.4 and sqlite...

[David G. Hamblen]

On 01/02/2011 02:23 AM, Gour wrote:
> On Sat, 1 Jan 2011 16:17:06 -0500
>>>>>>> "Derek" == wrote:
> Derek>  Because it's not *our* bug, it's a bug in libdbi,
>
> I'm aware it's not Gnucash bug...
>
> Derek>  and it's a bug Derek>  that only affects certain builds of libdbi,
>
> but I didn't know about the latter.
>
> Derek>  I don't know enough about the bug to tell you whether it's
> Derek>  something that we can easily detect at runtime.  But it's
> Derek>  certainly the case that you can build GnuCash against the
> Derek>  working version and then upgrade the library to the broken
> Derek>  version and GnuCash will stop working.  Similarly, if you build
> Derek>  GnuCash against the broken version of libdbi and then replace it
> Derek>  with a working version then it should start working again.
>
> This is something I do not understand fully...Based on what I see at
> libdbi site, it looks that it's not in such a rapid development
> producing new releases so often, iow the site says:
>
> libdbi-0.8.4  2010-09-01
> libdbi-0.8.3  2008-02-06
>

I simply downloaded libdbi0 (0.8.2-3) from 
packages.ubuntu.com/lucid/libdbi0.  Similarly for libdbi0-dev.  Both 
packages seem to work with the 10.10 maverick distribution.  I then 
needed to lock or hold the versions in aptitude so that they didn't get 
updated to the 0.8.3 version.  Seems to work with 
sqlite3/gnucash-2.4/ubuntu-10.10.  I don't have any other sqlite 
applications; so YMMV.



> which means there are two releases in last (almost) three years.
>
> Now, which version of the libdbi is broken?
>
> Derek>  Again, this is *not* a bug in GnuCash, but a bug where libdbi
> Derek>  does not return valid data when compiled with fast math.
>
> That's clear.
>
> otoh, based on the links in this thread, it seems that the bug is
> present in 0.8.3 version which is not the newest one.
>
> I'll try to build gnucash on my Archlinux system, but for now I can
> only say that libdbi is built with:  ./configure --prefix=/usr
> so I do not know what does it mean in regard to '-fast-math' option.
>
> Still (although I very much admire Gnucash and its devs), I believe
> that it could be that not-too-many devs were testing with Sqlite
> back-end which is important considering that SQL storage is some of
> the 'hot stuff' proudly announced as 'major changes' in 2.4.0.
>
> Please, take my post just as constructive criticism meant to help
> improve Gnucash. (Finally, I'm the one wanting to use it.)
>
>
> Sincerely,
> Gour
>
>
>
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel