Skip Menu |

This queue is for tickets about the DBD-SQLite CPAN distribution.

Report information
The Basics
Id: 73314
Status: resolved
Priority: 0/
Queue: DBD-SQLite

People
Owner: Nobody in particular
Requestors: lamoz [...] adriver.ru
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 1.34_02
Fixed in: (no value)



Subject: binding of 64bit integers fail on 1.34_02
The following test case works great on versions prior to 1.34_02 but fails onwards with error message "DBD::SQLite::st execute warning: datatype mismatch: bind 0 type 1 as 10000000000". v5.8.8 built for x86_64-linux-thread-multi DBI v1.616 === test follows === use strict; use warnings; use DBI qw(:sql_types); my $dbh = DBI->connect( 'dbi:SQLite:database=:memory:' ); $dbh->do( 'CREATE TABLE Test ( ID integer )' ); my $sth = $dbh->prepare( 'INSERT INTO Test VALUES( ? )' ); $sth->bind_param( 1, 10000000000, SQL_INTEGER ); $sth->execute
Fixed in the trunk. Thanks. On Fri Dec 16 21:00:54 2011, lamoz wrote: Show quoted text
> The following test case works great on versions prior to 1.34_02 but > fails onwards with error message "DBD::SQLite::st execute warning: > datatype mismatch: bind 0 type 1 as 10000000000". > > v5.8.8 built for x86_64-linux-thread-multi > DBI v1.616 > > === test follows === > use strict; > use warnings; > use DBI qw(:sql_types); > my $dbh = DBI->connect( 'dbi:SQLite:database=:memory:' ); > > $dbh->do( 'CREATE TABLE Test ( ID integer )' ); > my $sth = $dbh->prepare( 'INSERT INTO Test VALUES( ? )' ); > > $sth->bind_param( 1, 10000000000, SQL_INTEGER ); > $sth->execute
DBD::SQLite 1.36_01 with the fix is released. Thanks.