Bug #18426: incorrect value returned for int column

See and Ticket/Display.html?id=18295>.

Description:
An integer column with -1 stored in it returns 4294967295 instead of
-1.

The details of my setup:

Mac OS X Tiger 10.4.5 (PPC)
perl 5.8.6
DBI 1.49
DBD::mysql 3.0002_5 (vs 3.0002) (built with mysql-4.1.18 libraries)
mysql 4.1.18

It appears this bug was introduced between 3.0002 and 3.0002_1 and is
still present in 3.0002_5. I tested this on Linux and could not
reproduce it there, so it appears to be specific to Mac OS X.


How to repeat:
This script below, when run with DBD::mysql 3.0002 outputs ...

value is: -1

.... but with DBD::mysql 3.0002_5 (and 3.0002_1) it prints ...

value is: 4294967295


#!/usr/bin/perl -w
use DBI;

my $dbh = DBI->connect('DBI:mysql:test', 'test');
my $table = 'DBDmysql30002_1bug';

$dbh->do("DROP TABLE IF EXISTS $table") or die $dbh->errstr;
$dbh->do("CREATE TABLE $table (value int)") or die $dbh->errstr;
$dbh->do("INSERT INTO $table VALUES (-1)") or die $dbh->errstr;
$h = $dbh->selectrow_hashref("SELECT * FROM $table");

print 'value is: ' . $h->{value} . "\n";

## cleanup
$dbh->do("DROP TABLE IF EXISTS $table") or die $dbh->errstr;
$dbh->disconnect;

1;


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org