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

Reply via email to