No, it does a new hashref every time. At least, this works for me:

my @result;
while (my $row = $sth->fetchrow_hashref()) {
    push @result, $row;
}
[download]