Skip Menu |

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

Report information
The Basics
Id: 18295
Status: resolved
Priority: 0/
Queue: DBD-mysql

Owner: CAPTTOFU [...]
Requestors: ZMAN [...]

Bug Information
Severity: Critical
Broken in:
  • 3.0002_1
  • 3.0002_2
  • 3.0002_3
  • 3.0002_4
  • 3.0002_5
Fixed in: 3.0003

Subject: incorrect value returned for int column
Download (untitled) / with headers
text/plain 1.1k
See also <>. 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;

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to