Skip to content

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

11.5 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 `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