Re: SELECT gets suspended if the table contains a row lock (!)
"Robert Klemme" <[email protected]>
| Newsgroups | gmane.comp.db.maxdb |
|---|---|
| Message-ID | <[email protected]> |
2007/2/15, Eduard M <[email protected]>: > Hi, > I experience the following scenario: > 1. update a row in a table (say, in one SQLStudio session, without doing > commit). > 2. In another session (SQLStudio or whatever), try to select * from this > table. Or try to select the row that is being updated. SELECT does not > return until the other session is committed. > > Is this a feature of Maxdb or it can be controlled by some database > parameter? http://dev.mysql.com/doc/maxdb/en/a9/5727401544ed01e10000000a155106/content.htm http://dev.mysql.com/doc/maxdb/en/c4/812640632cec01e10000000a155106/content.htm robert -- Have a look: http://www.flickr.com/photos/fussel-foto/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[email protected]