Hi Bob --
> -----Ursprüngliche Nachricht-----
> Von: Bob McGowan [mailto:bob_mcgowan@stripped]
> Gesendet: Samstag, 14. November 2009 01:04
> I'm having trouble with retrieving data from mySQL, where the
> update or create was done by another application connection
> and happened while my Perl DBI/DBD connection was active.
> If I disconnect/reconnect to the server, I can see the changes.
> Is this expected behavior? Or is there some parameter that
> I'm missing? Neither the standard 'mysql' client nor the
> Bugzilla GUI seem to have this problem.
I'm not sure whether this answers your question, since you just said you have trouble (but
not, which trouble): have you tried to fiddle with the connection parameter
mysql_use_result (as per the DBD::mysql docs)? If set to false (the default), the result
set for some select that you do may just be buffered locally.
Alternatively, are you connecting to a transactional table, and may the transaction still
be in progress? Are you doing your select in a loop for contunuous updating, or how do
you control whether the external table update is somewhere between your selects? Given
the current lot of information, it is hard to tell.