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