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
j...@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 <mhoeni...@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@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
