Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- input: |-
UPDATE test SET test.c1 = 1 WHERE test.b1 = 1;
UPDATE test SET test.c1 = 2 WHERE test.b1 = 2;
UPDATE test SET test.c1 = 3 WHERE test.b1 = 3;
UPDATE test SET test.c1 = 4 WHERE test.b1 = 4;
UPDATE test SET test.c1 = 5 WHERE test.b1 = 5;
UPDATE test SET test.c1 = 6 WHERE test.b1 = 6;
UPDATE test SET test.c1 = 7 WHERE test.b1 = 7;
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_test_db` LIKE `db`.`test`;
INSERT INTO `backupDB`.`_rollback_test_db` SELECT `test`.* FROM test WHERE test.b1 = 1
UNION ALL
SELECT `test`.* FROM test WHERE test.b1 = 2
UNION ALL
SELECT `test`.* FROM test WHERE test.b1 = 3
UNION ALL
SELECT `test`.* FROM test WHERE test.b1 = 4
UNION ALL
SELECT `test`.* FROM test WHERE test.b1 = 5
UNION ALL
SELECT `test`.* FROM test WHERE test.b1 = 6
UNION ALL
SELECT `test`.* FROM test WHERE test.b1 = 7;
sourceschema: ""
sourcetablename: test
targettablename: _rollback_test_db
startposition:
line: 1
column: 1
endposition:
line: 7
column: 47
- input: DELETE test FROM test, test2 as t2 where test.id = t2.id;
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test` LIKE `db`.`test`;
INSERT INTO `backupDB`.`_rollback_0_test` SELECT `test`.* FROM test, test2 as t2 where test.id = t2.id;
sourceschema: ""
sourcetablename: test
targettablename: _rollback_0_test
startposition:
line: 1
column: 1
endposition:
line: 1
column: 58
- input: DELETE t1, t2 FROM test as t1, test2 as t2 WHERE t1.id = t2.id;
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test` LIKE `db`.`test`;
INSERT INTO `backupDB`.`_rollback_0_test` SELECT `t1`.* FROM test as t1, test2 as t2 WHERE t1.id = t2.id;
sourceschema: ""
sourcetablename: test
targettablename: _rollback_0_test
startposition:
line: 1
column: 1
endposition:
line: 1
column: 64
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test2` LIKE `db`.`test2`;
INSERT INTO `backupDB`.`_rollback_0_test2` SELECT `t2`.* FROM test as t1, test2 as t2 WHERE t1.id = t2.id;
sourceschema: ""
sourcetablename: test2
targettablename: _rollback_0_test2
startposition:
line: 1
column: 1
endposition:
line: 1
column: 64
- input: DELETE FROM t1, t2 USING test as t1, test2 as t2 WHERE t1.id = t2.id;
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test` LIKE `db`.`test`;
INSERT INTO `backupDB`.`_rollback_0_test` SELECT `t1`.* FROM test as t1, test2 as t2 WHERE t1.id = t2.id;
sourceschema: ""
sourcetablename: test
targettablename: _rollback_0_test
startposition:
line: 1
column: 1
endposition:
line: 1
column: 70
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test2` LIKE `db`.`test2`;
INSERT INTO `backupDB`.`_rollback_0_test2` SELECT `t2`.* FROM test as t1, test2 as t2 WHERE t1.id = t2.id;
sourceschema: ""
sourcetablename: test2
targettablename: _rollback_0_test2
startposition:
line: 1
column: 1
endposition:
line: 1
column: 70
- input: DELETE FROM test as t1 WHERE t1.c1 = 1;
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test` LIKE `db`.`test`;
INSERT INTO `backupDB`.`_rollback_0_test` SELECT `t1`.* FROM test as t1 WHERE t1.c1 = 1;
sourceschema: ""
sourcetablename: test
targettablename: _rollback_0_test
startposition:
line: 1
column: 1
endposition:
line: 1
column: 40
- input: DELETE FROM test WHERE c1 = 1;
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test` LIKE `db`.`test`;
INSERT INTO `backupDB`.`_rollback_0_test` SELECT `test`.* FROM test WHERE c1 = 1;
sourceschema: ""
sourcetablename: test
targettablename: _rollback_0_test
startposition:
line: 1
column: 1
endposition:
line: 1
column: 31
- input: UPDATE test x SET x.c1 = 1 WHERE x.c1 = 1
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test` LIKE `db`.`test`;
INSERT INTO `backupDB`.`_rollback_0_test` SELECT `x`.* FROM test x WHERE x.c1 = 1;
sourceschema: ""
sourcetablename: test
targettablename: _rollback_0_test
startposition:
line: 1
column: 1
endposition:
line: 1
column: 42
- input: UPDATE test SET c1 = 1 WHERE c1=2;
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test` LIKE `db`.`test`;
INSERT INTO `backupDB`.`_rollback_0_test` SELECT `test`.* FROM test WHERE c1=2;
sourceschema: ""
sourcetablename: test
targettablename: _rollback_0_test
startposition:
line: 1
column: 1
endposition:
line: 1
column: 35
- input: UPDATE test t1, test2 t2 SET t1.c1 = 1 WHERE t1.c1 = t2.c1;
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test` LIKE `db`.`test`;
INSERT INTO `backupDB`.`_rollback_0_test` SELECT `t1`.* FROM test t1, test2 t2 WHERE t1.c1 = t2.c1;
sourceschema: ""
sourcetablename: test
targettablename: _rollback_0_test
startposition:
line: 1
column: 1
endposition:
line: 1
column: 60
- input: UPDATE test t1, test2 t2 SET t1.c1 = 1, t2.c2 = 2 WHERE t1.c1 = t2.c1;
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test` LIKE `db`.`test`;
INSERT INTO `backupDB`.`_rollback_0_test` SELECT `t1`.* FROM test t1, test2 t2 WHERE t1.c1 = t2.c1;
sourceschema: ""
sourcetablename: test
targettablename: _rollback_0_test
startposition:
line: 1
column: 1
endposition:
line: 1
column: 71
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test2` LIKE `db`.`test2`;
INSERT INTO `backupDB`.`_rollback_0_test2` SELECT `t2`.* FROM test t1, test2 t2 WHERE t1.c1 = t2.c1;
sourceschema: ""
sourcetablename: test2
targettablename: _rollback_0_test2
startposition:
line: 1
column: 1
endposition:
line: 1
column: 71
- input: UPDATE test t1 INNER JOIN test2 t2 ON t1.a = t2.a SET c = 1 WHERE t1.a = 1;
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test` LIKE `db`.`test`;
INSERT INTO `backupDB`.`_rollback_0_test` SELECT `t1`.* FROM test t1 INNER JOIN test2 t2 ON t1.a = t2.a WHERE t1.a = 1;
sourceschema: ""
sourcetablename: test
targettablename: _rollback_0_test
startposition:
line: 1
column: 1
endposition:
line: 1
column: 76
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test2` LIKE `db`.`test2`;
INSERT INTO `backupDB`.`_rollback_0_test2` SELECT `t2`.* FROM test t1 INNER JOIN test2 t2 ON t1.a = t2.a WHERE t1.a = 1;
sourceschema: ""
sourcetablename: test2
targettablename: _rollback_0_test2
startposition:
line: 1
column: 1
endposition:
line: 1
column: 76
- input: UPDATE test t1 INNER JOIN test2 t2 ON t1.a = t2.a SET t1.c = 1 WHERE t1.a = 1;
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test` LIKE `db`.`test`;
INSERT INTO `backupDB`.`_rollback_0_test` SELECT `t1`.* FROM test t1 INNER JOIN test2 t2 ON t1.a = t2.a WHERE t1.a = 1;
sourceschema: ""
sourcetablename: test
targettablename: _rollback_0_test
startposition:
line: 1
column: 1
endposition:
line: 1
column: 79
- input: UPDATE test t1 INNER JOIN test2 t2 ON t1.a = t2.a SET t1.c = 1, t2.c = 2 WHERE t1.a = 1;
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test` LIKE `db`.`test`;
INSERT INTO `backupDB`.`_rollback_0_test` SELECT `t1`.* FROM test t1 INNER JOIN test2 t2 ON t1.a = t2.a WHERE t1.a = 1;
sourceschema: ""
sourcetablename: test
targettablename: _rollback_0_test
startposition:
line: 1
column: 1
endposition:
line: 1
column: 89
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test2` LIKE `db`.`test2`;
INSERT INTO `backupDB`.`_rollback_0_test2` SELECT `t2`.* FROM test t1 INNER JOIN test2 t2 ON t1.a = t2.a WHERE t1.a = 1;
sourceschema: ""
sourcetablename: test2
targettablename: _rollback_0_test2
startposition:
line: 1
column: 1
endposition:
line: 1
column: 89
- input: UPDATE t1 INNER JOIN t3 ON t1.a = t3.a SET c = 1 WHERE t1.a = 1;
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_t1` LIKE `db`.`t1`;
INSERT INTO `backupDB`.`_rollback_0_t1` SELECT `t1`.* FROM t1 INNER JOIN t3 ON t1.a = t3.a WHERE t1.a = 1;
sourceschema: ""
sourcetablename: t1
targettablename: _rollback_0_t1
startposition:
line: 1
column: 1
endposition:
line: 1
column: 65
- input: UPDATE t1 INNER JOIN t3 ON t1.a = t3.a SET d = 1 WHERE t1.a = 1;
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_t3` LIKE `db`.`t3`;
INSERT INTO `backupDB`.`_rollback_0_t3` SELECT `t3`.* FROM t1 INNER JOIN t3 ON t1.a = t3.a WHERE t1.a = 1;
sourceschema: ""
sourcetablename: t3
targettablename: _rollback_0_t3
startposition:
line: 1
column: 1
endposition:
line: 1
column: 65
- input: UPDATE t1 INNER JOIN t3 ON t1.a = t3.a SET c = 1, t3.d = 2 WHERE t1.a = 1;
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_t1` LIKE `db`.`t1`;
INSERT INTO `backupDB`.`_rollback_0_t1` SELECT `t1`.* FROM t1 INNER JOIN t3 ON t1.a = t3.a WHERE t1.a = 1;
sourceschema: ""
sourcetablename: t1
targettablename: _rollback_0_t1
startposition:
line: 1
column: 1
endposition:
line: 1
column: 75
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_t3` LIKE `db`.`t3`;
INSERT INTO `backupDB`.`_rollback_0_t3` SELECT `t3`.* FROM t1 INNER JOIN t3 ON t1.a = t3.a WHERE t1.a = 1;
sourceschema: ""
sourcetablename: t3
targettablename: _rollback_0_t3
startposition:
line: 1
column: 1
endposition:
line: 1
column: 75
- input: |-
UPDATE test t1 SET t1.c1 = 2 WHERE t1.c1 = 1 ;
UPDATE test t2 SET t2.c1 = 3 WHERE t2.c1 = 5 ;
result:
- statement: |-
CREATE TABLE `backupDB`.`_rollback_0_test` LIKE `db`.`test`;
INSERT INTO `backupDB`.`_rollback_0_test` SELECT `t1`.* FROM test t1 WHERE t1.c1 = 1;
sourceschema: ""
sourcetablename: test
targettablename: _rollback_0_test
startposition:
line: 1
column: 1
endposition:
line: 1
column: 47
- statement: |-
CREATE TABLE `backupDB`.`_rollback_1_test` LIKE `db`.`test`;
INSERT INTO `backupDB`.`_rollback_1_test` SELECT `t2`.* FROM test t2 WHERE t2.c1 = 5;
sourceschema: ""
sourcetablename: test
targettablename: _rollback_1_test
startposition:
line: 1
column: 47
endposition:
line: 2
column: 47