Skip to content

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

1.7 KB
Raw Blame
- input: |-
    INSERT INTO T VALUES ('
      Bytebase Inc.
    ');
  description: Cross line string using `'` as quote.
  batches:
    - statements:
        text: |-
            INSERT INTO T VALUES ('
              Bytebase Inc.
            ');
        start: 0
        end: 43
      command: ""
- input: |-
    SELECT * FROM T;
    GO
    INSERT INTO T VALUES (1);
    GO
  description: Multiple batches
  batches:
    - statements:
        text: SELECT * FROM T;
        start: 0
        end: 16
      command: GO 1
    - statements:
        text: INSERT INTO T VALUES (1);
        start: 20
        end: 45
      command: GO 1
- input: |-
    /*
    * Bytebase Inc.
    * Migration SQL File 2023/11/30
    * INSERT INTO XXX VALUES (1);
    */
    INSERT INTO T VALUES (1);
  description: Multi-line comment
  batches:
    - statements:
        text: |-
            /*
            * Bytebase Inc.
            * Migration SQL File 2023/11/30
            * INSERT INTO XXX VALUES (1);
            */
            INSERT INTO T VALUES (1);
        start: 0
        end: 109
      command: ""
- input: |-
    -- Migration SQL File 2023/11/30
    INSERT INTO T VALUES (1);
  description: ""
  batches:
    - statements:
        text: |-
            -- Migration SQL File 2023/11/30
            INSERT INTO T VALUES (1);
        start: 0
        end: 58
      command: ""
- input: |-
    SELECT * FROM T;
    GO 2
  description: Run a batch twice
  batches:
    - statements:
        text: SELECT * FROM T;
        start: 0
        end: 16
      command: GO 2
- input: SELECT * FROM T;
  description: Simple statement
  batches:
    - statements:
        text: SELECT * FROM T;
        start: 0
        end: 16
      command: ""