Matthias Schweizer wrote: > Hi, > > we are using 7.5.0.11. > > We set autocommit off. With all isolation levels > 0 in our > installation INSERT to table T1 locks all "SELECT * FROM T1" > until commit or rollback. > > This means, we can not display a list of all entries in T1 > while someone else inserts a new entry but has not committed the work. > > We expect to get all committed rows from the select. > > Switching to isolation level 0 is not a solution (we get > uncommitted data). > > Can we somehow change this behavior? > > > We currently check, if we can port an application from oracle > to MaxDB.
Hi, Try it with the lock option ignore. Example: select * from t1 with lock (ignore) This won't wait for uncomitted rows and shows you all commited rows. For more information see: http://www.mysql.de/documentation/maxdb/ac/738ef13f4a11d3a98200a0c9449261/frameset.htm Kind regards, Holger SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
