Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- description: multiple SELECT statements
input: SELECT * FROM t1; SELECT * FROM t2
result:
- text: SELECT * FROM t1
baseline: 0
start:
line: 1
column: 1
end:
line: 1
column: 17
range:
start: 0
end: 16
empty: false
- text: " SELECT * FROM t2"
baseline: 0
start:
line: 1
column: 18
end:
line: 1
column: 35
range:
start: 17
end: 34
empty: false
- description: modern Oracle DDL supported by omni splitter
input: "CREATE VECTOR INDEX vec_idx ON docs (embedding);\nCREATE JSON RELATIONAL DUALITY VIEW emp_dv AS SELECT employee_id FROM employees;"
result:
- text: CREATE VECTOR INDEX vec_idx ON docs (embedding)
baseline: 0
start:
line: 1
column: 1
end:
line: 1
column: 48
range:
start: 0
end: 47
empty: false
- text: "\nCREATE JSON RELATIONAL DUALITY VIEW emp_dv AS SELECT employee_id FROM employees"
baseline: 0
start:
line: 1
column: 49
end:
line: 2
column: 80
range:
start: 48
end: 128
empty: false
- description: SQLPlus line commands are skipped
input: "SET DEFINE OFF\nPROMPT creating table\nSELECT 1 FROM dual;\nSPOOL install.log\nSELECT 2 FROM dual;\nSPOOL OFF"
result:
- text: SELECT 1 FROM dual
baseline: 2
start:
line: 3
column: 1
end:
line: 3
column: 19
range:
start: 37
end: 55
empty: false
- text: SELECT 2 FROM dual
baseline: 4
start:
line: 5
column: 1
end:
line: 5
column: 19
range:
start: 75
end: 93
empty: false
- description: SQLPlus script commands are skipped
input: "@preflight.sql\n@@nested/install.sql arg1 arg2\nSTART post.sql\nSELECT 1 FROM dual;\nEXIT SUCCESS"
result:
- text: SELECT 1 FROM dual
baseline: 3
start:
line: 4
column: 1
end:
line: 4
column: 19
range:
start: 61
end: 79
empty: false
- description: SQLPlus command words inside SQL are retained
input: "SELECT 'SET DEFINE OFF' AS txt FROM dual; SELECT prompt FROM t;"
result:
- text: SELECT 'SET DEFINE OFF' AS txt FROM dual
baseline: 0
start:
line: 1
column: 1
end:
line: 1
column: 41
range:
start: 0
end: 40
empty: false
- text: " SELECT prompt FROM t"
baseline: 0
start:
line: 1
column: 42
end:
line: 1
column: 63
range:
start: 41
end: 62
empty: false
- description: package spec and body without slash separators
input: |-
CREATE PACKAGE pkg IS
PROCEDURE p;
END pkg;
CREATE PACKAGE BODY pkg IS
PROCEDURE p IS
BEGIN
NULL;
END;
END pkg;
result:
- text: |-
CREATE PACKAGE pkg IS
PROCEDURE p;
END pkg;
baseline: 0
start:
line: 1
column: 1
end:
line: 3
column: 9
range:
start: 0
end: 45
empty: false
- text: |-
CREATE PACKAGE BODY pkg IS
PROCEDURE p IS
BEGIN
NULL;
END;
END pkg;
baseline: 2
start:
line: 3
column: 9
end:
line: 9
column: 9
range:
start: 45
end: 123
empty: false
- description: multiple statements with newlines
input: "\n\t\t\t\tselect * from t;\n\t\t\t\tcreate table table$1 (id int)\n\t\t\t"
result:
- text: "\n\t\t\t\tselect * from t"
baseline: 0
start:
line: 1
column: 1
end:
line: 2
column: 20
range:
start: 0
end: 20
empty: false
- text: "\n\t\t\t\tcreate table table$1 (id int)"
baseline: 1
start:
line: 2
column: 21
end:
line: 3
column: 34
range:
start: 21
end: 55
empty: false
- description: procedure with forward slash separator
input: |-
CREATE OR REPLACE PROCEDURE test_proc IS
BEGIN
CALL DBMS_OUTPUT.PUT_LINE('Hello');
END;
/
result:
- text: |-
CREATE OR REPLACE PROCEDURE test_proc IS
BEGIN
CALL DBMS_OUTPUT.PUT_LINE('Hello');
END;
baseline: 0
start:
line: 1
column: 1
end:
line: 4
column: 5
range:
start: 0
end: 91
empty: false
- description: two procedures with forward slash separator
input: |-
CREATE OR REPLACE PROCEDURE proc1 IS
BEGIN
NULL;
END;
/
CREATE OR REPLACE PROCEDURE proc2 IS
BEGIN
NULL;
END;
/
result:
- text: |-
CREATE OR REPLACE PROCEDURE proc1 IS
BEGIN
NULL;
END;
baseline: 0
start:
line: 1
column: 1
end:
line: 4
column: 5
range:
start: 0
end: 57
empty: false
- text: "\nCREATE OR REPLACE PROCEDURE proc2 IS\nBEGIN\n NULL;\nEND;"
baseline: 4
start:
line: 5
column: 2
end:
line: 9
column: 5
range:
start: 59
end: 117
empty: false
- description: SELECT statements separated by forward slash
input: |-
SELECT * FROM t1;
/
SELECT * FROM t2;
result:
- text: SELECT * FROM t1
baseline: 0
start:
line: 1
column: 1
end:
line: 1
column: 17
range:
start: 0
end: 16
empty: false
- text: "\nSELECT * FROM t2"
baseline: 1
start:
line: 2
column: 2
end:
line: 3
column: 17
range:
start: 19
end: 36
empty: false
- description: anonymous block with forward slash
input: |-
BEGIN
CALL DBMS_OUTPUT.PUT_LINE('Test');
END;
/
result:
- text: |-
BEGIN
CALL DBMS_OUTPUT.PUT_LINE('Test');
END;
baseline: 0
start:
line: 1
column: 1
end:
line: 3
column: 5
range:
start: 0
end: 49
empty: false
- description: ALTER TABLE with PARTITION
input: |-
ALTER TABLE DATA.TEST
MODIFY PARTITION BY RANGE (TXN_DATE)
INTERVAL (NUMTODSINTERVAL(1, 'DAY'))
(
PARTITION TEST_PO VALUES LESS THAN (
TO_DATE('2000-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')
)
)
ONLINE;
result:
- text: |-
ALTER TABLE DATA.TEST
MODIFY PARTITION BY RANGE (TXN_DATE)
INTERVAL (NUMTODSINTERVAL(1, 'DAY'))
(
PARTITION TEST_PO VALUES LESS THAN (
TO_DATE('2000-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')
)
)
ONLINE
baseline: 0
start:
line: 1
column: 1
end:
line: 9
column: 7
range:
start: 0
end: 232
empty: false
- description: CALL procedure
input: CALL my_procedure()
result:
- text: CALL my_procedure()
baseline: 0
start:
line: 1
column: 1
end:
line: 1
column: 20
range:
start: 0
end: 19
empty: false
- description: DROP TABLESPACE with CASCADE CONSTRAINTS
input: DROP TABLESPACE xxx INCLUDING CONTENTS CASCADE CONSTRAINTS
result:
- text: DROP TABLESPACE xxx INCLUDING CONTENTS CASCADE CONSTRAINTS
baseline: 0
start:
line: 1
column: 1
end:
line: 1
column: 59
range:
start: 0
end: 58
empty: false
- description: DROP TABLESPACE CASCADE alone is split lexically
input: DROP TABLESPACE xxx CASCADE
result:
- text: DROP TABLESPACE xxx CASCADE
baseline: 0
start:
line: 1
column: 1
end:
line: 1
column: 28
range:
start: 0
end: 27
empty: false
- description: DROP TABLESPACE then CASCADE is split lexically
input: DROP TABLESPACE xxx; CASCADE
result:
- text: DROP TABLESPACE xxx
baseline: 0
start:
line: 1
column: 1
end:
line: 1
column: 20
range:
start: 0
end: 19
empty: false
- text: " CASCADE"
baseline: 0
start:
line: 1
column: 21
end:
line: 1
column: 29
range:
start: 20
end: 28
empty: false
- description: CREATE TABLE with ROW STORE COMPRESS ADVANCED
input: |-
CREATE TABLE DATA.SMY_LAO_ACCOUNT_BLK_TXN_MTH (
TXN_DATE DATE,
TXN_NBR VARCHAR2(100 CHAR),
ARRANGEMENT_NBR VARCHAR2(100 CHAR),
TXN_NARRATIVE VARCHAR2(4000 CHAR),
FROM_DATE DATE,
TO_DATE DATE,
BLK_AMT NUMBER,
INPUTTER VARCHAR2(1000 CHAR),
NOTE VARCHAR2(4000 CHAR),
AUTHORISER VARCHAR2(1000 CHAR),
LAST_UPDATE_DATE DATE,
LAST_UPDATED_BY VARCHAR2(255 CHAR)
)
ROW STORE COMPRESS ADVANCED
TABLESPACE ARCHIVE_TBS
PCTFREE 10
NOLOGGING
PARTITION BY RANGE (TXN_DATE)
INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))
(
PARTITION PART_01 VALUES LESS THAN (TO_DATE('2012-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
NOLOGGING
COMPRESS FOR OLTP
TABLESPACE ARCHIVE_TBS
PCTFREE 10
STORAGE (INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
);
result:
- text: |-
CREATE TABLE DATA.SMY_LAO_ACCOUNT_BLK_TXN_MTH (
TXN_DATE DATE,
TXN_NBR VARCHAR2(100 CHAR),
ARRANGEMENT_NBR VARCHAR2(100 CHAR),
TXN_NARRATIVE VARCHAR2(4000 CHAR),
FROM_DATE DATE,
TO_DATE DATE,
BLK_AMT NUMBER,
INPUTTER VARCHAR2(1000 CHAR),
NOTE VARCHAR2(4000 CHAR),
AUTHORISER VARCHAR2(1000 CHAR),
LAST_UPDATE_DATE DATE,
LAST_UPDATED_BY VARCHAR2(255 CHAR)
)
ROW STORE COMPRESS ADVANCED
TABLESPACE ARCHIVE_TBS
PCTFREE 10
NOLOGGING
PARTITION BY RANGE (TXN_DATE)
INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))
(
PARTITION PART_01 VALUES LESS THAN (TO_DATE('2012-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
NOLOGGING
COMPRESS FOR OLTP
TABLESPACE ARCHIVE_TBS
PCTFREE 10
STORAGE (INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
)
baseline: 0
start:
line: 1
column: 1
end:
line: 28
column: 2
range:
start: 0
end: 845
empty: false
- description: 'position semantic: leading newlines'
input: "\n\nSELECT 1 FROM dual"
result:
- text: "\n\nSELECT 1 FROM dual"
baseline: 0
start:
line: 1
column: 1
end:
line: 3
column: 19
range:
start: 0
end: 20
empty: false
- description: 'position semantic: leading spaces and newlines'
input: "\n \n SELECT 1 FROM dual"
result:
- text: "\n \n SELECT 1 FROM dual"
baseline: 0
start:
line: 1
column: 1
end:
line: 3
column: 21
range:
start: 0
end: 24
empty: false
- description: 'position semantic: multi-statement with leading whitespace'
input: "SELECT 1 FROM dual;\n\n SELECT 2 FROM dual"
result:
- text: SELECT 1 FROM dual
baseline: 0
start:
line: 1
column: 1
end:
line: 1
column: 19
range:
start: 0
end: 18
empty: false
- text: "\n\n SELECT 2 FROM dual"
baseline: 0
start:
line: 1
column: 20
end:
line: 3
column: 21
range:
start: 19
end: 41
empty: false
- description: 'BYT-9367: trailing semicolon with leading space does not leak (cell b)'
input: "insert into t values('a',1) ;\n\ninsert into t values('b',2) ;"
result:
- text: "insert into t values('a',1)"
baseline: 0
start:
line: 1
column: 1
end:
line: 1
column: 28
range:
start: 0
end: 27
empty: false
- text: "\n\ninsert into t values('b',2)"
baseline: 0
start:
line: 1
column: 30
end:
line: 3
column: 28
range:
start: 29
end: 58
empty: false
- description: 'BYT-9367: trailing semicolon with leading inline comment does not leak (cell c)'
input: "insert into t values('a',1) /* note */ ;\ninsert into t values('b',2) ;"
result:
- text: "insert into t values('a',1)"
baseline: 0
start:
line: 1
column: 1
end:
line: 1
column: 28
range:
start: 0
end: 27
empty: false
- text: "\ninsert into t values('b',2)"
baseline: 0
start:
line: 1
column: 41
end:
line: 2
column: 28
range:
start: 40
end: 68
empty: false
- description: 'BYT-9367: trailing semicolon with multiple newlines does not leak (cell d)'
input: "insert into t values('a',1)\n\n;\n\ninsert into t values('b',2);"
result:
- text: "insert into t values('a',1)"
baseline: 0
start:
line: 1
column: 1
end:
line: 1
column: 28
range:
start: 0
end: 27
empty: false
- text: "\n\ninsert into t values('b',2)"
baseline: 2
start:
line: 3
column: 2
end:
line: 5
column: 28
range:
start: 30
end: 59
empty: false
- description: 'BYT-9367: anonymous block followed by SELECT with no separator (cell f, bail-on-default-channel)'
input: "BEGIN NULL; END;\nSELECT 1 FROM dual"
result:
- text: "BEGIN NULL; END;"
baseline: 0
start:
line: 1
column: 1
end:
line: 1
column: 17
range:
start: 0
end: 16
empty: false
- text: "\nSELECT 1 FROM dual"
baseline: 0
start:
line: 1
column: 17
end:
line: 2
column: 19
range:
start: 16
end: 35
empty: false
- description: 'BYT-9367: trailing semicolon with leading space at EOF (cell h)'
input: "insert into t values('a',1) ;"
result:
- text: "insert into t values('a',1)"
baseline: 0
start:
line: 1
column: 1
end:
line: 1
column: 28
range:
start: 0
end: 27
empty: false