autorollback on error
I just realized that there is no transaction level autorollback on error. Am I wrong?
Here is an example of what I'm saying about:
create local temp table t (i integer) order by i unsegmented all nodes;
set session autocommit = off;
insert into t values(1);
insert into t values('a');
insert into t values(2);
I expect that the whole begin-commit block is forced to rollback as it contains error in second insert (like postgres do for example). I figured out for now that I have to check every statement in transaction for error and invoke rollback explicitly if error happened.
So, is there any autorollback option in vertica? All I can find is ON_ERROR_STOP for vsql. Maybe I missed something...