hi, i am using MysQL4.1.13. I tried doing the following. * Open a new session to DB. (Say session 1) * Using prepared statements provided by C API, issued a select statement to get some rows from a table. * This worked absolutely fine. * I didnt close the session, but still using the same session to issue the same select statement and get the results again. (while loop) * Before issuing the second select statement on session 1, I opened a new session(say session 2) and updated the entries in the table. Did a commit. * Now i issued the second select statement on session 1, but still it is showing the old results. Idealy it should show the new results, which are a result of updations done using session 2.
But when i issue a commit after the first select on session 1, and do the rest as i mentioned above, it is showing all the results properly. Is this the intended behaviour or do i need to make any configuration changes or any ?? Thank you sujay
