Re: Mysql smallint out of range. How to fetch warning?


XP is just a number
	PerlMonks

Re: Mysql smallint out of range. How to fetch warning?

by samtregar (Abbot)

on Oct 16, 2010 at 03:39 UTC ( [id://865620]=note: print w/replies, xml )

Need Help??

in reply to Mysql smallint out of range. How to fetch warning?

Just use the SHOW WARNINGS statement:

   $dbh->do("CREATE TEMPORARY TABLE foo (bar SMALLINT)")
   $dbh->do("INSERT INTO foo (bar) VALUES (100000000)");

   use Data::Dumper;
   print Dumper($dbh->selectall_arrayref("SHOW WARNINGS"));
[download]

Output:

$VAR1 = [
          [
            'Warning',
            '1264',
            'Out of range value adjusted for column \'bar\' at row 1'
          ]
        ];
[download]

-sam