Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- statement: INSERT INTO tech_book SELECT * FROM tech_book;
- statement: |
INSERT INTO tech_book SELECT * FROM tech_book;
INSERT INTO tech_book SELECT * FROM tech_book LIMIT 1;
want:
- status: 2
code: 1103
title: STATEMENT_DISALLOW_LIMIT
content: LIMIT clause is forbidden in INSERT, UPDATE and DELETE statement, but "INSERT INTO tech_book SELECT * FROM tech_book LIMIT 1;" uses
startposition:
line: 2
column: 0
endposition: null
- statement: |
INSERT INTO tech_book SELECT * FROM tech_book;
INSERT INTO tech_book SELECT * FROM tech_book UNION SELECT * FROM tech_book LIMIT 1;
want:
- status: 2
code: 1103
title: STATEMENT_DISALLOW_LIMIT
content: LIMIT clause is forbidden in INSERT, UPDATE and DELETE statement, but "INSERT INTO tech_book SELECT * FROM tech_book UNION SELECT * FROM tech_book LIMIT 1;" uses
startposition:
line: 2
column: 0
endposition: null
- statement: |
INSERT INTO tech_book SELECT * FROM tech_book;
INSERT INTO tech_book SELECT * FROM tech_book UNION SELECT * FROM tech_book LIMIT 1;
want:
- status: 2
code: 1103
title: STATEMENT_DISALLOW_LIMIT
content: LIMIT clause is forbidden in INSERT, UPDATE and DELETE statement, but "INSERT INTO tech_book SELECT * FROM tech_book UNION SELECT * FROM tech_book LIMIT 1;" uses
startposition:
line: 2
column: 0
endposition: null
- statement: |
INSERT INTO tech_book SELECT * FROM tech_book;
INSERT INTO tech_book (SELECT * FROM tech_book LIMIT 1);
want:
- status: 2
code: 1103
title: STATEMENT_DISALLOW_LIMIT
content: LIMIT clause is forbidden in INSERT, UPDATE and DELETE statement, but "INSERT INTO tech_book (SELECT * FROM tech_book LIMIT 1);" uses
startposition:
line: 2
column: 0
endposition: null
- statement: |
UPDATE tech_book SET name = 'my name';
UPDATE tech_book SET name = 'my name' LIMIT 10;
want:
- status: 2
code: 1102
title: STATEMENT_DISALLOW_LIMIT
content: LIMIT clause is forbidden in INSERT, UPDATE and DELETE statement, but "UPDATE tech_book SET name = 'my name' LIMIT 10;" uses
startposition:
line: 2
column: 0
endposition: null
- statement: |
DELETE FROM tech_book;
DELETE FROM tech_book LIMIT 10;
want:
- status: 2
code: 1106
title: STATEMENT_DISALLOW_LIMIT
content: LIMIT clause is forbidden in INSERT, UPDATE and DELETE statement, but "DELETE FROM tech_book LIMIT 10;" uses
startposition:
line: 2
column: 0
endposition: null