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

Alexandru Toth alexandru.toth at gmail.com
Wed May 23 07:09:15 CEST 2007


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.

BR, Alex




More information about the developers-list mailing list