Incorrect DBI/DBD::SQLite type_info() result?

Mark Lawrence <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Message-ID <[email protected]>
Hi all,

I'm having trouble with $dbh->quote($value, $data_type) on SQLite not
doing the right thing, although it appears to be working fine for
Postgres. The attached test returns the following:

    ok 1 - SQL_INTEGER dbi:Pg:dbname=cpantest;port=5433
    not ok 2 - SQL_INTEGER dbi:SQLite:dbname=/tmp/Test-Database...
    #   Failed test 'SQL_INTEGER dbi:SQLite:dbname=/tmp/Test-Database...'
    #   at SQLite-type-info.t line 17.
    #          got: ''42''
    #     expected: '42'
    1..2
    # Looks like you failed 1 test of 2.

From what I read of the comments in DBI.pm, and from the debugging
statements I've added, it appears that it is DBI::type_info which is
returning the bad quoting, not DBD::SQLite. Presumably DBD::Pg is
overriding type_info() correctly.

Is this most likely a DBI bug I've found? Or should I resend this mail
to the DBD::SQLite folks?

Thanks,
Mark.
-- 
Mark Lawrence
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.