| Subject: | get_affected_rows has maximum of 252 for UPDATE |
Net-MySQL-0.08 (installed as local libary)
perl, v5.6.0 built for sun4-solaris
SunOS sysa.abdn.ac.uk 5.8 Generic_108528-19 sun4u sparc SUNW,Ultra-Enterprise
MySQL 3.23.51
Hi,
print 'Affected rows '.$mysql->query("UPDATE `file_table` SET status = -1 WHERE $ids");
OR
$mysql->query("UPDATE `file_table` SET status = -1 WHERE $ids");
$affected_rows = $mysql->get_affected_rows;
print 'Affected rows '. $affected_rows;
Both print 252 for all UPDATES affecting more than 252 rows. Using DEBUG=>1
Net::MySQL::_execute_command():
T . . . . U P D A T E . f i l e _ t a b l e . S E T s t a t u s . . 1 W H E R E . i d . . . 1 2 8 5 A N D . . . i
...Large Query...
d . . . 1 2 8 6 A N D . . . i d . . . 1 2 8 7 A N D . . . i d . . . 1 2 8 8 A N D . . . i d . . . 1 2 8 9 A N D . . . i d . . . 1 2 9 0 A N D . . . i d . . . 1 2 9 1 A N D . . . i d . . . 1 2 9 2 A N D . . 1
Net::MySQL::_execute_command():
34 00 00 01 00 fc 0e 05 00 2e 52 6f 77 73 20 6d 61 74 63 68 65 64 3a 20 31 32 39 34 20 20 43 68 61 6e 67 65 64 3a 20 31 32 39 34 20 20 57 61 72 6e 69 6e 67 73 3a 20 30
Net::MySQL::_execute_command():
4 . . . . . . . . . R o w s m a t c h e d . 1 2 9 4 C h a n g e d . 1 2 9 4 W a r n i n g s . 0
Affected rows 252
As suggested by the MySQL response the update is succesful.