Hello !
I'm using GnuCash with a MySql backend using libdbi. There are some
strange errors with some versions of libdbi for which a workaround has been
built
which says one should change the version of libdbi. This error message has just
been included and it stops me from using my financial data. Because of that
i tried to find the error. At the moment it seems to me that it is linked to
dbi_conn_queryf.
The test in Gnucash calls it with
result = dbi_conn_queryf( conn,
"INSERT INTO numtest VALUES (%lld, %llu, %17e)",
testlonglong, testulonglong, testdouble );
where
gint64 testlonglong = -9223372036854775807LL, resultlonglong = 0;
guint64 testulonglong = 9223372036854775807LLU, resultulonglong = 0;
gdouble testdouble = 1.7976921348623157E+307, resultdouble = 0.0;
This fails at my system. The logfile of MySql states
110127 13:40:28 21 Connect christoph@localhost on gnucash
21 Query CREATE TEMPORARY TABLE numtest ( test_int
BIGINT, test_unsigned BIGINT, test_double FLOAT8 )
21 Query INSERT INTO numtest VALUES
(-9223372036854775807, 9223372036854775807, 1,797692e+307)
The last row is wrong because it is 1,797692e+307 instead of 1.797692e+307. The
separator is wrong. I guess this is because
the locale for germany where i live puts it that way.
I don't know if this is a feature or a bug. But i guess it would make life
simpler if printf in that function wouldn't be so locale specific ;-)
I'm not a C programmer and I'm not sure if the solution should be a change of
libdbi or GnuCash.
regards,
Christoph Holtermann
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
libdbi-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/libdbi-devel
