On Wed, May 23, 2007 at 08:09:15AM +0300, Alexandru Toth wrote:
Hello,
You assume here that auto-commit is re-enabled when the statements fall outside the transaction brackets. The mode change and the consequences should be clearly documented in Mapi. It may indeed be useful to fall-back to auto-commit outside explicit transaction boundaries.
regards, Martin
It is indeed a "SQL style error" to forget the start transaction + commit around some statements. But the same script runs fine in mysql, postgres and sqlite. Would it be possible to fall-back to auto- commit, or to generate an error message? Monet behavior is not intuitive, and it would be hard to find in the documentation. Its clearly a bug. Could you report it as such on the sourceforge bugtracker?
Niels
BR, Alex
------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl