Skip to content

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

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