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