数据仓库服务 GaussDB(DWS)-ROLLBACK TO SAVEPOINT:示例

时间:2023-11-01 16:15:26

示例

撤销 my_savepoint 建立之后执行的命令的影响:

1
ROLLBACK TO SAVEPOINT my_savepoint;

游标位置不受保存点回滚的影响:

 1 2 3 4 5 6 7 8 910111213
BEGIN;DECLARE foo CURSOR FOR SELECT 1 UNION SELECT 2;SAVEPOINT foo;FETCH 1 FROM foo; ?column? ----------        1ROLLBACK TO SAVEPOINT foo;FETCH 1 FROM foo; ?column? ----------        2COMMIT;
support.huaweicloud.com/sqlreference-811-dws/dws_06_0269.html