Re: [Lxr-developer] Weird MySQL bug

[Malcolm B. <ma...@br...>]

"Peder O. Klingenberg" wrote:
> 
> Malcolm Box <ma...@br...> writes:
> 
> > $dbh, which is the database handle in question, is a package
> > variable and therefore I think it should be scoped until the package
> > is removed, ie when the END block deletes things properly.
> 
> I would tend to agree with you, FWIW.  I don't use mysql myself, so I
> can't experiment, but have you tried

Hmm, I wonder if similar things show up with pgsql and if not, what the
code differences are.
 
>  * Setting $dbh->trace(n) with n>0 right after you connect?
> 
>  * Explicitly qualifying $dbh with the package, ie
>    s/$dbh/$LXR::Index::Mysql::dbh/ ?
> 
>  * A different version of perl?

I'm running 5.6.0 which is one down from the latest stable so I may try
the update.  I'll try the other things you suggest and see what turns
up.  This one is really baffling me at the moment!

> Not that I would know what was wrong given results of those tests, but
> maybe they can help shed light on the problem?

Hell, I'll try anything at the moment - shotgun debugging it is!

Malcolm