Re: Where are those memory leaks?

The statement

my $long_string = $sth->fetchrow_array();
[download]

looks odd. $sth->fetchrow_array() returns an array, but you are evaulating that in scalar context, so $long_string contains the length of the array, which is always 1 for your select statement. A simpler example:

% perl -e'@a=(2); my ($b) = @a; print "$b\n";'
2
% perl -e'@a=(2); my $b = @a; print "$b\n";'
1
[download]

-Mark

Comment on Re: Where are those memory leaks? Select or Download Code

Replies are listed 'Best First'.
Re: Re: Where are those memory leaks? by jZed (Prior) on Mar 24, 2004 at 04:56 UTC
fetchrow_array called in scalar context returns either the first or the last element of the array depending on the DBD. In this case, since it is a SELECT COUNT, there is only one element so it's both the first and the last.	[reply]