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 "backupSchema"."rollback_test_public" AS
SELECT "public"."test".* FROM test WHERE test.b1 = 1
UNION
SELECT "public"."test".* FROM test WHERE test.b1 = 2
UNION
SELECT "public"."test".* FROM test WHERE test.b1 = 3
UNION
SELECT "public"."test".* FROM test WHERE test.b1 = 4
UNION
SELECT "public"."test".* FROM test WHERE test.b1 = 5
UNION
SELECT "public"."test".* FROM test WHERE test.b1 = 6
UNION
SELECT "public"."test".* FROM test WHERE test.b1 = 7;
sourceschema: public
sourcetablename: test
targettablename: rollback_test_public
startposition:
line: 1
column: 0
endposition:
line: 7
column: 46
- input: |-
DELETE FROM t
USING test
WHERE t.c1 = 1 and t.a1 = test.a1;
result:
- statement: |-
CREATE TABLE "backupSchema"."rollback_t_public" AS
SELECT "public"."t".* FROM t, test WHERE t.c1 = 1 and t.a1 = test.a1;
sourceschema: public
sourcetablename: t
targettablename: rollback_t_public
startposition:
line: 1
column: 0
endposition:
line: 3
column: 34
- input: |-
DELETE FROM test
USING test2
WHERE test.c1 = 1 and test.c1 = test2.c1;
result:
- statement: |-
CREATE TABLE "backupSchema"."rollback_test_public" AS
SELECT "public"."test".* FROM test, test2 WHERE test.c1 = 1 and test.c1 = test2.c1;
sourceschema: public
sourcetablename: test
targettablename: rollback_test_public
startposition:
line: 1
column: 0
endposition:
line: 3
column: 41
- input: |-
UPDATE test
SET test.c1 = 2
FROM test2
WHERE test.c1 = 1 and test.c1 = test2.c1;
result:
- statement: |-
CREATE TABLE "backupSchema"."rollback_test_public" AS
SELECT "public"."test".* FROM test, test2 WHERE test.c1 = 1 and test.c1 = test2.c1;
sourceschema: public
sourcetablename: test
targettablename: rollback_test_public
startposition:
line: 1
column: 0
endposition:
line: 4
column: 41
- input: |-
DELETE FROM test1 WHERE c1 = 1;
UPDATE test SET test.c1 = 2 WHERE test.c1 = 1;
result:
- statement: |-
CREATE TABLE "backupSchema"."rollback_test1_public" AS
SELECT "public"."test1".* FROM test1 WHERE c1 = 1;
sourceschema: public
sourcetablename: test1
targettablename: rollback_test1_public
startposition:
line: 1
column: 0
endposition:
line: 1
column: 31
- statement: |-
CREATE TABLE "backupSchema"."rollback_test_public" AS
SELECT "public"."test".* FROM test WHERE test.c1 = 1;
sourceschema: public
sourcetablename: test
targettablename: rollback_test_public
startposition:
line: 2
column: 0
endposition:
line: 2
column: 46
- input: DELETE FROM test WHERE c1 = 1;
result:
- statement: |-
CREATE TABLE "backupSchema"."rollback_test_public" AS
SELECT "public"."test".* FROM test WHERE c1 = 1;
sourceschema: public
sourcetablename: test
targettablename: rollback_test_public
startposition:
line: 1
column: 0
endposition:
line: 1
column: 30
- input: UPDATE test SET c1 = 1 WHERE c1=2;
result:
- statement: |-
CREATE TABLE "backupSchema"."rollback_test_public" AS
SELECT "public"."test".* FROM test WHERE c1=2;
sourceschema: public
sourcetablename: test
targettablename: rollback_test_public
startposition:
line: 1
column: 0
endposition:
line: 1
column: 34
- input: |-
UPDATE test SET test.c1 = 2 WHERE test.c1 = 1 ;
UPDATE test SET test.c1 = 3 WHERE test.c1 = 5 ;
result:
- statement: |-
CREATE TABLE "backupSchema"."rollback_test_public" AS
SELECT "public"."test".* FROM test WHERE test.c1 = 1
UNION
SELECT "public"."test".* FROM test WHERE test.c1 = 5;
sourceschema: public
sourcetablename: test
targettablename: rollback_test_public
startposition:
line: 1
column: 0
endposition:
line: 2
column: 46
- input: |-
DELETE FROM test t1
USING test2 t2
WHERE t1.c1 = t2.c1;
result:
- statement: |-
CREATE TABLE "backupSchema"."rollback_test_public" AS
SELECT "t1".* FROM test t1, test2 t2 WHERE t1.c1 = t2.c1;
sourceschema: public
sourcetablename: test
targettablename: rollback_test_public
startposition:
line: 1
column: 0
endposition:
line: 3
column: 20
- input: WITH cte AS (SELECT a FROM test2) UPDATE test SET c = 1 FROM cte WHERE test.a = cte.a;
result:
- statement: |-
CREATE TABLE "backupSchema"."rollback_test_public" AS
WITH cte AS (SELECT a FROM test2)
SELECT "public"."test".* FROM test, cte WHERE test.a = cte.a;
sourceschema: public
sourcetablename: test
targettablename: rollback_test_public
startposition:
line: 1
column: 0
endposition:
line: 1
column: 86
- input: WITH cte AS (SELECT a FROM test2) DELETE FROM test USING cte WHERE test.a = cte.a;
result:
- statement: |-
CREATE TABLE "backupSchema"."rollback_test_public" AS
WITH cte AS (SELECT a FROM test2)
SELECT "public"."test".* FROM test, cte WHERE test.a = cte.a;
sourceschema: public
sourcetablename: test
targettablename: rollback_test_public
startposition:
line: 1
column: 0
endposition:
line: 1
column: 82
- input: WITH cte AS (SELECT a FROM test2) UPDATE test ta SET b = 1 FROM cte WHERE cte.a = ta.a;
result:
- statement: |-
CREATE TABLE "backupSchema"."rollback_test_public" AS
WITH cte AS (SELECT a FROM test2)
SELECT "ta".* FROM test ta, cte WHERE cte.a = ta.a;
sourceschema: public
sourcetablename: test
targettablename: rollback_test_public
startposition:
line: 1
column: 0
endposition:
line: 1
column: 87