Hi, Using old tests:
Library information: -------------------- Current: 1 Revision: 0 Age: 1 Version string: libdbi v1.0-pre2 Driver information: ------------------- Name: sqlite3 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 Version: dbd_sqlite3 v0.9.0-pre1 Compiled: Apr 25 2009 the_longlong: in:-9223372036854775807 out:0<< the_ulonglong: in:9223372036854775807 out:0<< The the_longlong is BIGINT. 2009/5/2 Markus Hoenicka <markus.hoeni...@mhoenicka.de>: > Mariusz Mazur writes: > > I assume sqlite is mostly off the radar and just seen as legacy, but I > think > > this should at least get a mention in bacula's docs: sqlite via libdbi is > > majorly broken (standard 686 platform). Reason is this: selects for bigints > > (and bacula's volume sizes are bigints) always return a 0 no matter what > the > > actual value is. > > > > I've confirmed this using bacula's debugging output (the native 'sqlite' > > client showed correct values with the exact same SELECT), but didn't bother > > I cannot confirm this problem on a FreeBSD box. Running "gmake check" > in libdbi-drivers (current cvs revision) tells me that the sqlite > driver stores and retrieves all sizes of integers ok, including long > long int and unsigned long long int. I cannot find changes since 0.8.3 > which would affect this behaviour either. Is there some specific > problem with using the sqlite driver with bacula? > > regards, > Markus > > -- > Markus Hoenicka > markus.hoeni...@cats.de > (Spam-protected email: replace the quadrupeds with "mhoenicka") > http://www.mhoenicka.de > -- ----------------------------------------------------------- João Henrique Freitas - joaohf_at_gmail.com Campinas-SP-Brasil BSD051283 LPI 1 http://www.joaohfreitas.eti.br ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ Libdbi-drivers-devel mailing list Libdbi-drivers-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel