2.4 and sqlite...

[Jeff Kletsky]

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