[Monetdb-developers] possible bug regarding auto-commit mixing with start transaction?
alexandru.toth at gmail.com
Wed May 23 07:09:15 CEST 2007
> 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.
More information about the developers-list