Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

6.6 KB
Raw Blame
- 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