Hi all, This is driving me nuts.
I have a simple test case where I do something like this : loop select count(*) from some_table sleep 2 seconds end loop My problem is that the count shows the number of rows the first time it executes and from that point never changes. While the program is running, I insert rows into the table from another session but the count never changes. If I kill the program and restart it, it shows the new count but again never changes. Is this some quirk with mysql? It certainly doesn't behave that way using DBD::Oracle. I've tried several different methods of selecting the data but I always see the same behaviour. I'm using : mysql version 5.5, DBI version 1.609, DBD::mysql version 4.013 Perl 5.10.1 (on Centos 6) Thanks, Steve --------------------------------------------------------------------------------------- This email is intended solely for the use of the addressee and may contain information that is confidential, proprietary, or both. If you receive this email in error please immediately notify the sender and delete the email. ---------------------------------------------------------------------------------------
