#787928 libdbd-sqlite3: produces only one table with no rows from a large gnuca dataset

Package:
gnucash
Source:
gnucash
Description:
personal and small-business financial-accounting software
Submitter:
Anonymous
Date:
2015-06-06 14:33:06 UTC
Severity:
normal
#787928#5
Date:
2015-06-06 10:16:11 UTC
From:
To:
Dear Maintainer,

Using the gnucash export feature, an sqlite3 db file is created, but
it contains no data.  E.g.

  $ sqlite3 jailed_data.sqlite3.gnucash .schema
  CREATE TABLE gnclock ( Hostname varchar(255), PID int );

  $ sqlite3 jailed_data.sqlite3.gnucash "select * from gnclock;"
  <no output>

There is are thousands of records in gnucash.  This is the gnucash
version:

GnuCash 2.6.4
This copy was built from rev 79bdcf1+ on 2014-11-15.
#787928#10
Date:
2015-06-06 14:29:14 UTC
From:
To:
Control: reassign -1 gnucash 1:2.6.4-3
 You mixed up three different projects. SQLite3 (and its libraries)
and the libdbi database drivers are quite different from GNUCash. Just
for the record, GNUCash has nothing to do with the libdbi drivers,
it's linked directly to SQLite3.
 I reassign this to GNUCash itself and send a Cc to Dmitry who is the
maintainer of that project. Hope he can help you further.
 Just checked this on Jessie/amd64 and I confirm that this bug exists.
But please note that as I see 'export accounts' does only what it
says. Exports the account name, its currency and pretty much that's
all. The XML output is created but contains only these data and not
the transactions neither the balance.

Regards,
Laszlo/GCS