Hello out there,
it seems that I cannot handle transactions with mySQL connections anymore.
In older versions I could do something like this:
/*sqldev:stmt*/begin; select * from dt_log; delete from dt_log where log_tsn=13068; /*sqldev:stmt*/rollback;
Now these /*sqldev:stmt*/ hints do not work properly anymore. The first one seems to work. But the second one gives an error like this:
SELECT command denied to user 'tsn'@'pc259.vu2k.vertriebsunion.de' for table 'all_tab_cols'
Now, is this intended and if so, is there a way to use transactions on mySQL?
This issue is solved in 4.0EA3.