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

Reply via email to