2.4 and sqlite...

[John Gray]

On a positive note, I have our android implementation working with the
sqlite now (that's not to say the android implementation is usable yet).

I'm really hope someone gets a working version libdbi working for ubuntu
10.10.  I'm going to trying to put together one myself.

John

On 01/01/2011 03:03 PM, Jeff Kletsky wrote:
> It isn't just numbers that have problems -- here's a diff of Ubuntu
> 10.10 and FreeBSD output from the driver test code distributed with source
>
> The Ubuntu bug #673307 link is
> https://bugs.launchpad.net/ubuntu/+source/libdbi-drivers/+bug/673307
>
>
>
>
> jeff at fx:~$ diff -u test_dbi.output*
> --- test_dbi.output 2011-01-01 10:42:03.707828037 -0800
> +++ test_dbi.output.freebsd 2011-01-01 10:43:55.856451151 -0800
> @@ -2,15 +2,15 @@
>  Driver information:
>  -------------------
>   Name: sqlite3
> - Filename: /usr/lib/dbd/libdbdsqlite3.so
> + Filename: /usr/local/lib/dbd/libdbdsqlite3.so
>   Desc: SQLite3 database support (using libsqlite3)
>   Maintainer: Markus Hoenicka <mhoenicka at users.sourceforge.net>
>   URL: http://libdbi-drivers.sourceforge.net
> <http://libdbi-drivers.sourceforge.net>
>   Version: dbd_sqlite3 v0.8.3-1
> - Compiled: Aug 7 2010
> + Compiled: Jan 1 2011
>
>  Successfully connected!
> - Using database engine version 30702 (numeric) and 3.7.2 (string)
> + Using database engine version 30704 (numeric) and 3.7.4 (string)
>
>  Test 1: List databases:
>   Got result, try to access rows
> @@ -47,10 +47,10 @@
>  the_ushort: in:32767 out:32767<<
>  the_long: in:-2147483648 out:-2147483648<<
>  the_ulong: in:2147483647 out:2147483647<<
> -the_longlong: in:-9223372036854775807 out:0<<
> -the_ulonglong: in:9223372036854775807 out:0<<
> +the_longlong: in:-9223372036854775807 out:-9223372036854775807<<
> +the_ulonglong: in:9223372036854775807 out:9223372036854775807<<
>  the_float: in:3.402823466E+38 out:3.402823e+38<<
> -the_double: in:1.7976931348623157E+307 out:0.000000e+00<<
> +the_double: in:1.7976931348623157E+307 out:1.797693e+307<<
>  the_driver_string: in:'Can 'we' "quote" this properly?' out:'Can 'we'
> "quote" this properly?'<<
>  the_quoted_string: in:'Can 'we' "quote" this properly?' out:'Can 'we'
> "quote" this properly?'<<
>  the_quoted_string_copy: in:'Can 'we' "quote" this properly?' out:'Can
> 'we' "quote" this properly?'<<
> @@ -58,11 +58,11 @@
>  the_escaped_string_copy: in:'Can 'we' "escape" this properly?'
> out:'Can 'we' "escape" this properly?'<<
>  the_empty_string: out:''<<
>  the_null_string: out:'(null)'
> -the_datetime: in:'2001-12-31 23:59:59' out:2001-12-31 0:0:0
> -the_datetime_tz: in:'2001-12-31 23:59:59 -10:00' out:2001-12-31 0:0:0
> +the_datetime: in:'2001-12-31 23:59:59' out:2001-12-31 23:59:59
> +the_datetime_tz: in:'2001-12-31 23:59:59 -10:00' out:2002-1-1 9:59:59
>  the_date: in:'2001-12-31' out:2001-12-31
> -the_time: in:'23:59:59' out:0:0:0
> -the_time_tz: in:'23:59:59-10:00' out:0:0:0
> +the_time: in:'23:59:59' out:23:59:59
> +the_time_tz: in:'23:59:59-10:00' out:9:59:59
>  the_quoted_binary: in: 65-66-0-67-39-68- out: 65-66-0-67-39-68-<<
>  the_escaped_binary_copy: in: 65-66-0-67-39-68- out: 65-66-0-67-39-68-<<
>
>
>
> On 01/01/2011 11:48 AM, John Gray wrote:
>> Same here, rebuilding libdbd-sqlite3 didn't fix the problem, and libdbi
>> isn't building.
>>
>> how frustrating.
>>
>> John
>>
>> On 01/01/2011 12:58 PM, Jeff Kletsky wrote:
>>> It does look to be the same issue with libdbi/libdbd. Recompiling and
>>> installing libdbd-sqlite3 hasn't resolved the problem, and I'm having
>>> problems with recompiling libdbi (openjade is croaking on the doc
>>> generation) to determine if that will resolve it.
>>>
>>> If anyone knows how to resolve the openjade problem, I'd like to be
>>> able to confirm that removing the -ffast-math optimisation "fixes"
>>> GNUCash and SQLite3.
>>>
>>> I hope we can get a more generic illustration of the problem because,
>>> as it is reported now, my guess is that it won't get much attention.
>>> It is a little surprising to me that GNUCash is the only app running
>>> into problems with this. Unfortunately Perl links to libsqlite3 and
>>> I'm guessing that the Mozilla products carry their own set of
>>> libraries, so it may need a "simple" C program to show that this is a
>>> "generic" problem.
>>>
>>> Jeff
>>>
>>>
>>>
>>>
>>> On 12/31/2010 06:36 PM, John Ralls wrote:
>>>> On Dec 31, 2010, at 5:18 PM, Derek Atkins wrote:
>>>>
>>>>> Er.. check the archives and look for fastmath, iirc.
>>>>>
>>>> To save you the trouble:
>>>> https://bugzilla.gnome.org/show_bug.cgi?id=611936#c28
>>>> https://lists.gnucash.org/pipermail/gnucash-devel/2010-August/029141.html
>>>>
>>>>
>>>> Jeff Kletsky has opened a new Gnucash bug for this:
>>>> https://bugzilla.gnome.org/show_bug.cgi?id=638414
>>>>
>>>> Good memory, Derek.
>>>>
>>>> Regards,
>>>> John Ralls
>>>>
>>>>
>>>> _______________________________________________
>>>> gnucash-devel mailing list
>>>> gnucash-devel at gnucash.org
>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>>> _______________________________________________
>>> gnucash-devel mailing list
>>> gnucash-devel at gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>>>
>> _______________________________________________
>> gnucash-devel mailing list
>> gnucash-devel at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel