On Tue, Nov 16, 2004 at 08:12:25PM +1100, Ron Savage wrote:
> Hi Folks
>
> Under MySQL V 4.1.* I have found that:
> $dbh -> do('drop database x')
> $dbh -> do('create database x')
> leads - via DBIx::SQLEngine (at least) - to losing the connexion to the
> database, so after the drop & crete, it is not possible to create tables.
>
> The create fails with:
> Error: DBIx::SQLEngine Query failed ...
> DBD::mysql::st execute failed: No database selected ...
> where the ... means I have chopped some text.
That's not really surprising. You probably just need to $dbh->do('use database
x');
> At MySQL's web site, I went thru the changes for all versions 4.1.0 .. 4.1.8
> and 4.1.x, but did not see anything relating to this change in behaviour.
I'd guess it's a side effect of a bug fix.
But please log a bug report with them about it so a note does get added.
Tim.
