r17927 - gnucash/trunk/src - Fix 64 bit integer handling. In an sqlite3 db, column types are basically ignored.

Phil Longstaff plongstaff at cvs.gnucash.org
Mon Feb 16 11:22:19 EST 2009


Author: plongstaff
Date: 2009-02-16 11:22:18 -0500 (Mon, 16 Feb 2009)
New Revision: 17927
Trac: http://svn.gnucash.org/trac/changeset/17927

Modified:
   gnucash/trunk/src/backend/dbi/gnc-backend-dbi.c
   gnucash/trunk/src/backend/sql/gnc-backend-sql.c
   gnucash/trunk/src/backend/sql/gnc-backend-sql.h
   gnucash/trunk/src/backend/sql/gnc-lots-sql.c
   gnucash/trunk/src/backend/sql/gnc-price-sql.c
   gnucash/trunk/src/backend/sql/gnc-slots-sql.c
   gnucash/trunk/src/backend/sql/gnc-transaction-sql.c
   gnucash/trunk/src/business/business-core/sql/gnc-bill-term-sql.c
   gnucash/trunk/src/business/business-core/sql/gnc-customer-sql.c
   gnucash/trunk/src/business/business-core/sql/gnc-employee-sql.c
   gnucash/trunk/src/business/business-core/sql/gnc-entry-sql.c
   gnucash/trunk/src/business/business-core/sql/gnc-invoice-sql.c
   gnucash/trunk/src/business/business-core/sql/gnc-tax-table-sql.c
Log:
Fix 64 bit integer handling.  In an sqlite3 db, column types are basically ignored.  
However, libdbi uses the column type name to determine how big it thinks the integer 
value is.  Therefore, change all 64 bit integer values (including num/denom in numeric 
values) to 'bigint'.  Tables will be automatically upgraded when an sqlite3 file is 
opened.




More information about the gnucash-patches mailing list