Active statement handles mystery?

I have a script that operates on SQLite and SQLite2 that finished like;

$sth->finish; # Statement handle for $data_dbh
$sth_users_dbh->finish; # Statement handle for $users_dbh
$data_dbh->disconnect;
$users_dbh->disconnect;

__END__

After running successfully, it reports;

"closing dbh with active statement handles at dl_update line ....."

When I add

undef $sth;
undef $sth_users_dbh;

after the finish statements, the message is not reported.

I don't think it is important, but wonder if this is an oddity, or just something I am not doing?


TIA

Re: Active statement handles mystery?

On Sun, Jul 15, 2007 at 03:55:43PM +1000, Owen wrote:
>
> I have a script that operates on SQLite and SQLite2 that finished like;
>
> $sth->finish; # Statement handle for $data_dbh
> $sth_users_dbh->finish; # Statement handle for $users_dbh
> $data_dbh->disconnect;
> $users_dbh->disconnect;
>
> __END__
>
> After running successfully, it reports;
>
> "closing dbh with active statement handles at dl_update line ....."
>
> When I add
>
> undef $sth;
> undef $sth_users_dbh;
>
> after the finish statements, the message is not reported.
>
> I don't think it is important, but wonder if this is an oddity, or just something I am not doing?

Looks like a bug. Please report it.

Tim.