[Monetdb-developers] possible bug regarding auto-commit mixing with start transaction?

Niels Nes Niels.Nes at cwi.nl
Wed May 23 09:36:43 CEST 2007


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 at 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 at cwi.nl




More information about the developers-list mailing list