Skip to content

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

55.9 KB
Raw Blame
- description: Test for SELECT INFO
  statement: SELECT * FROM sys.someTable;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T1",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 3
    results: []
    sourcecolumns:
        - server: ""
          database: SYS
          schema: ""
          table: SOMETABLE
          column: ""
    predicatecolumns: []
- description: Test for Explain
  statement: EXPLAIN PLAN FOR SELECT * FROM SCHEMA1.V1;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T1",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 2
    results: []
    sourcecolumns:
        - server: ""
          database: SCHEMA1
          schema: ""
          table: V1
          column: ""
    predicatecolumns: []
- description: Test for DDL
  statement: create table t(a int);
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T1",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 4
    results: []
    sourcecolumns: []
    predicatecolumns: []
- description: Test for DML
  statement: insert into t values(1);
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T1",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 5
    results: []
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
    predicatecolumns: []
- description: Test for cross-schema view
  statement: SELECT * FROM SCHEMA1.V1;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T1",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                }
              ]
            }
          ]
        }
      ]
    }
  crossDatabaseMetadata: |-
    {
      "name":  "SCHEMA1",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                }
              ]
            }
          ],
          "views": [
            {
              "name":  "V1",
              "definition": "SELECT A, B FROM T"
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: A
          sourcecolumns:
            - server: ""
              database: SCHEMA1
              schema: ""
              table: T
              column: A
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: B
          sourcecolumns:
            - server: ""
              database: SCHEMA1
              schema: ""
              table: T
              column: B
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: SCHEMA1
          schema: ""
          table: V1
          column: ""
    predicatecolumns: []
- description: Test for alias.* with join
  statement: SELECT t1.*, alias1.* FROM t1 JOIN (select * from t1) alias1 on t1.a = alias1.a;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T1",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: A
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T1
              column: A
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: B
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T1
              column: B
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: A
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T1
              column: A
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: B
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T1
              column: B
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T1
          column: ""
    predicatecolumns: []
- description: Test for Join
  statement: SELECT T1.* FROM T1 JOIN T2;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T1",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                }
              ]
            },
            {
              "name":  "T2",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: A
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T1
              column: A
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: B
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T1
              column: B
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T1
          column: ""
        - server: ""
          database: PUBLIC
          schema: ""
          table: T2
          column: ""
    predicatecolumns: []
- description: Test For Database Link With View
  statement: SELECT * FROM SCHEMA1.LV1@REMOTE;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ],
      "linkedDatabases":  [
        {
          "name":  "REMOTE",
          "username":  "SCHEMA1"
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: LC1
          sourcecolumns:
            - server: ""
              database: SCHEMA1
              schema: ""
              table: LT2
              column: LC1
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: LC2
          sourcecolumns:
            - server: ""
              database: SCHEMA1
              schema: ""
              table: LT2
              column: LC2
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - instance: INSTANCE_ID_B
          server: REMOTE
          database: SCHEMA1
          schema: ""
          table: LV1
          column: ""
    predicatecolumns: []
- description: Test For Database Link
  statement: SELECT * FROM SCHEMA1.LT1@REMOTE;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ],
      "linkedDatabases":  [
        {
          "name":  "REMOTE",
          "username":  "SCHEMA1"
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: LC1
          sourcecolumns:
            - server: ""
              database: SCHEMA1
              schema: ""
              table: LT1
              column: LC1
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - instance: INSTANCE_ID_B
          server: REMOTE
          database: SCHEMA1
          schema: ""
          table: LT1
          column: ""
    predicatecolumns: []
- description: Test For Database Link Mixed With Local Table
  statement: SELECT * FROM T, SCHEMA1.LT1@REMOTE;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ],
      "linkedDatabases":  [
        {
          "name":  "REMOTE",
          "username":  "SCHEMA1"
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: A
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: LC1
          sourcecolumns:
            - server: ""
              database: SCHEMA1
              schema: ""
              table: LT1
              column: LC1
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
        - instance: INSTANCE_ID_B
          server: REMOTE
          database: SCHEMA1
          schema: ""
          table: LT1
          column: ""
    predicatecolumns: []
- description: Test For Database Link Unqualified
  statement: SELECT * FROM LT1@REMOTE;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ],
      "linkedDatabases":  [
        {
          "name":  "REMOTE",
          "username":  "SCHEMA1"
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: LC1
          sourcecolumns:
            - server: ""
              database: SCHEMA1
              schema: ""
              table: LT1
              column: LC1
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - instance: INSTANCE_ID_B
          server: REMOTE
          database: SCHEMA1
          schema: ""
          table: LT1
          column: ""
    predicatecolumns: []
- description: Test For Database Link In Scalar Subquery
  statement: SELECT (SELECT MAX(LC1) FROM SCHEMA1.LT1@REMOTE) AS M FROM T;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ],
      "linkedDatabases":  [
        {
          "name":  "REMOTE",
          "username":  "SCHEMA1"
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: M
          sourcecolumns:
            - server: ""
              database: SCHEMA1
              schema: ""
              table: LT1
              column: LC1
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
        - instance: INSTANCE_ID_B
          server: REMOTE
          database: SCHEMA1
          schema: ""
          table: LT1
          column: ""
    predicatecolumns: []
- description: Test For Database Link Unresolvable
  statement: SELECT * FROM T, SCHEMA1.LT1@NOLINK;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ],
      "linkedDatabases":  [
        {
          "name":  "REMOTE",
          "username":  "SCHEMA1"
        }
      ]
    }
  querySpan:
    type: 1
    results: []
    sourcecolumns:
        - server: NOLINK
          database: SCHEMA1
          schema: ""
          table: LT1
          column: ""
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
    predicatecolumns: []
- description: Test For Database Link With A Connection Qualifier
  statement: SELECT * FROM T, SCHEMA1.LT1@REMOTE@Q;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ],
      "linkedDatabases":  [
        {
          "name":  "REMOTE",
          "username":  "SCHEMA1"
        }
      ]
    }
  querySpan:
    type: 1
    results: []
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
        - server: REMOTE@Q
          database: SCHEMA1
          schema: ""
          table: LT1
          column: ""
    predicatecolumns: []
- description: Test For Database Link With Local Namesake
  statement: SELECT * FROM SCHEMA1.LT1@REMOTE;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ],
      "linkedDatabases":  [
        {
          "name":  "REMOTE",
          "username":  "SCHEMA1"
        }
      ]
    }
  crossDatabaseMetadata: |-
    {
      "name":  "SCHEMA1",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "LT1",
              "columns":  [
                {
                  "name":  "LOCAL_ONLY"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: LC1
          sourcecolumns:
            - server: ""
              database: SCHEMA1
              schema: ""
              table: LT1
              column: LC1
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - instance: INSTANCE_ID_B
          server: REMOTE
          database: SCHEMA1
          schema: ""
          table: LT1
          column: ""
    predicatecolumns: []
- description: Test For Database Link To The Connected Instance
  statement: SELECT * FROM SCHEMA1.LT1@LOOPBACK;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ],
      "linkedDatabases":  [
        {
          "name":  "LOOPBACK",
          "username":  "SCHEMA1"
        }
      ]
    }
  crossDatabaseMetadata: |-
    {
      "name":  "SCHEMA1",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "LT1",
              "columns":  [
                {
                  "name":  "LOCAL_LC1"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: LOCAL_LC1
          sourcecolumns:
            - server: ""
              database: SCHEMA1
              schema: ""
              table: LT1
              column: LOCAL_LC1
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - instance: INSTANCE_ID_A
          server: LOOPBACK
          database: SCHEMA1
          schema: ""
          table: LT1
          column: ""
    predicatecolumns: []
- description: Test For Database Link To The Connected Instance Unqualified
  statement: SELECT * FROM T, LT1@LOOPBACK;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ],
      "linkedDatabases":  [
        {
          "name":  "LOOPBACK",
          "username":  "SCHEMA1"
        }
      ]
    }
  crossDatabaseMetadata: |-
    {
      "name":  "SCHEMA1",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "LT1",
              "columns":  [
                {
                  "name":  "LOCAL_LC1"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: A
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: LOCAL_LC1
          sourcecolumns:
            - server: ""
              database: SCHEMA1
              schema: ""
              table: LT1
              column: LOCAL_LC1
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - instance: INSTANCE_ID_A
          server: LOOPBACK
          database: SCHEMA1
          schema: ""
          table: LT1
          column: ""
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
    predicatecolumns: []
- description: Test For Database Link Into A System Schema
  statement: SELECT * FROM SYS.DBA_USERS@REMOTE;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ],
      "linkedDatabases":  [
        {
          "name":  "REMOTE",
          "username":  "SCHEMA1"
        }
      ]
    }
  querySpan:
    type: 1
    results: []
    sourcecolumns:
        - server: REMOTE
          database: SYS
          schema: ""
          table: DBA_USERS
          column: ""
    predicatecolumns: []
- description: Test For Database Link Into A System Schema Mixed With Local Table
  statement: SELECT * FROM T, SYS.DBA_USERS@REMOTE;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ],
      "linkedDatabases":  [
        {
          "name":  "REMOTE",
          "username":  "SCHEMA1"
        }
      ]
    }
  querySpan:
    type: 1
    results: []
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
        - server: REMOTE
          database: SYS
          schema: ""
          table: DBA_USERS
          column: ""
    predicatecolumns: []
- description: Test For Local Table With SYS.DUAL And A Link
  statement: SELECT T.A, (SELECT 1 FROM SYS.DUAL) AS ONE FROM T, SCHEMA1.LT1@REMOTE;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ],
      "linkedDatabases":  [
        {
          "name":  "REMOTE",
          "username":  "SCHEMA1"
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: A
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: ONE
          sourcecolumns: []
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
        - instance: INSTANCE_ID_B
          server: REMOTE
          database: SCHEMA1
          schema: ""
          table: LT1
          column: ""
    predicatecolumns: []
- description: Test For A Real Table Named DUAL
  statement: SELECT * FROM APP.DUAL, SCHEMA1.DUAL@REMOTE, SYS.DUAL;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ],
      "linkedDatabases":  [
        {
          "name":  "REMOTE",
          "username":  "SCHEMA1"
        }
      ]
    }
  crossDatabaseMetadata: |-
    {
      "name":  "APP",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "DUAL",
              "columns":  [
                {
                  "name":  "SECRET"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results: []
    sourcecolumns:
        - server: ""
          database: APP
          schema: ""
          table: DUAL
          column: ""
        - instance: INSTANCE_ID_B
          server: REMOTE
          database: SCHEMA1
          schema: ""
          table: DUAL
          column: ""
    predicatecolumns: []
- description: Test For Explain statements
  statement: EXPLAIN PLAN for SELECT 1 FROM DUAL;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 2
    results: []
    sourcecolumns: []
    predicatecolumns: []
- description: Test for simple select const
  statement: SELECT 1 FROM DUAL;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: "1"
          sourcecolumns: []
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns: []
    predicatecolumns: []
- description: Test asterisk and column
  statement: SELECT A, T.* FROM T;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                },
                {
                  "name":  "C"
                },
                {
                  "name":  "D"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: A
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: A
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: B
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: B
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: C
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: C
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: D
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: D
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
    predicatecolumns: []
- description: Happy path for A simple select statement
  statement: SELECT * FROM T
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                },
                {
                  "name":  "C"
                },
                {
                  "name":  "D"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: A
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: B
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: B
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: C
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: C
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: D
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: D
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
    predicatecolumns: []
- description: Referenced table fields by different format
  statement: SELECT A, T.B, PUBLIC.T.C, PUBLIC.T.D FROM T;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                },
                {
                  "name":  "C"
                },
                {
                  "name":  "D"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: A
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: B
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: B
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: C
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: C
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: D
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: D
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
    predicatecolumns: []
- description: Scalar subquery in select fields
  statement: SELECT 1 AS col_1, (SELECT(2) FROM DUAL) AS col_2, (SELECT AVG(A + B * C) FROM T) AS avg_a_b_c FROM T;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                },
                {
                  "name":  "C"
                },
                {
                  "name":  "D"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: COL_1
          sourcecolumns: []
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: COL_2
          sourcecolumns: []
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: AVG_A_B_C
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: B
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: C
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
    predicatecolumns: []
- description: Multiple-Row subquery in where clause
  statement: SELECT 1 FROM T WHERE A IN (SELECT A FROM T);
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                },
                {
                  "name":  "C"
                },
                {
                  "name":  "D"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: "1"
          sourcecolumns: []
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
    predicatecolumns: []
- description: Correlated subquery in the target field clause.
  statement: SELECT CITY, (SELECT COUNT(*) FROM PAINTINGS p WHERE g.ID = p.GALLERY_ID) AS total_paintings FROM GALLERIES g;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "GALLERIES",
              "columns":  [
                {
                  "name":  "ID"
                },
                {
                  "name":  "CITY"
                }
              ]
            },
            {
              "name":  "PAINTINGS",
              "columns":  [
                {
                  "name":  "GALLERY_ID"
                },
                {
                  "name":  "ARTIST_ID"
                },
                {
                  "name":  "TITLE"
                },
                {
                  "name":  "PRICE"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: CITY
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: GALLERIES
              column: CITY
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: TOTAL_PAINTINGS
          sourcecolumns: []
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: GALLERIES
          column: ""
        - server: ""
          database: PUBLIC
          schema: ""
          table: PAINTINGS
          column: ""
    predicatecolumns: []
- description: Test for functions
  statement: SELECT max(A), A-B AS c1, A=B AS c2, A>B, B in (A, C, D) from (SELECT * FROM T) result;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                },
                {
                  "name":  "C"
                },
                {
                  "name":  "D"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: max(A)
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: C1
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: B
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: C2
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: B
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: A>B
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: B
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: Bin(A,C,D)
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: B
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: C
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: D
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
    predicatecolumns: []
- description: Test for SELECT partial FROM JOIN clause
  statement: SELECT T1.*, T2.C, 0 FROM T1 JOIN T2 ON 1 = 1;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T1",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                }
              ]
            },
            {
              "name":  "T2",
              "columns":  [
                {
                  "name":  "C"
                },
                {
                  "name":  "D"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: A
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T1
              column: A
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: B
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T1
              column: B
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: C
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T2
              column: C
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: "0"
          sourcecolumns: []
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T1
          column: ""
        - server: ""
          database: PUBLIC
          schema: ""
          table: T2
          column: ""
    predicatecolumns: []
- description: Test for JOIN with USING clause
  statement: SELECT * FROM T T1 JOIN T T2 USING(A);
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                },
                {
                  "name":  "C"
                },
                {
                  "name":  "D"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: A
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: B
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: B
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: C
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: C
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: D
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: D
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: B
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: B
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: C
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: C
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: D
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: D
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
    predicatecolumns: []
- description: Simple CTE
  statement: WITH T1 AS (SELECT * FROM T) SELECT * FROM T1;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                },
                {
                  "name":  "C"
                },
                {
                  "name":  "D"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: A
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: B
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: B
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: C
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: C
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: D
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: D
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
    predicatecolumns: []
- description: Multi-level CTE
  statement: WITH tt2 AS (WITH tt2 AS (SELECT * FROM T) SELECT MAX(A) FROM tt2) SELECT * FROM tt2;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                },
                {
                  "name":  "C"
                },
                {
                  "name":  "D"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: MAX(A)
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
    predicatecolumns: []
- description: Test for CTE rename fields name
  statement: WITH T1(D, C, B, A) AS (SELECT * FROM T) SELECT * FROM T1;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                },
                {
                  "name":  "C"
                },
                {
                  "name":  "D"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: D
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: C
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: B
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: B
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: C
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: A
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: D
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
    predicatecolumns: []
- description: Test for Recursive Common Table Expression dependent closures
  statement: WITH T1(cc1, cc2, cc3, n) AS (SELECT A AS c1, B AS c2, C AS c3, 1 AS n FROM T UNION ALL SELECT cc1*cc2, cc2 + cc1, cc3 * cc2, n+1 FROM T1 WHERE n < 10) SELECT * FROM T1;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                },
                {
                  "name":  "C"
                },
                {
                  "name":  "D"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: CC1
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: B
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: CC2
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: B
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: CC3
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: B
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: C
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: "N"
          sourcecolumns: []
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
    predicatecolumns: []
- description: Test for Non-Recursive Common Table Expression with RECURSIVE key words
  statement: WITH T1 AS (SELECT 1 AS c1, 2 AS c2, 3 AS c3, 4 AS c4 FROM DUAL UNION ALL SELECT A, B, D, C FROM T) SELECT * FROM T1;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                },
                {
                  "name":  "C"
                },
                {
                  "name":  "D"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: C1
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: A
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: C2
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: B
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: C3
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: D
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: C4
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T
              column: C
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T
          column: ""
    predicatecolumns: []
- description: SELECT * leaves out invisible columns
  statement: SELECT * FROM T_HIDDEN;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T_HIDDEN",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "H",
                  "isInvisible":  true
                },
                {
                  "name":  "B"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: A
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T_HIDDEN
              column: A
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: B
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T_HIDDEN
              column: B
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T_HIDDEN
          column: ""
    predicatecolumns: []
- description: A reference by name reaches an invisible column
  statement: SELECT H FROM T_HIDDEN;
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T_HIDDEN",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "H",
                  "isInvisible":  true
                },
                {
                  "name":  "B"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: H
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T_HIDDEN
              column: H
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T_HIDDEN
          column: ""
    predicatecolumns: []
- description: SELECT * keeps an invisible column a subquery selects
  statement: SELECT * FROM (SELECT A, H FROM T_HIDDEN);
  defaultDatabase: PUBLIC
  metadata: |-
    {
      "name":  "PUBLIC",
      "schemas":  [
        {
          "name": "",
          "tables":  [
            {
              "name":  "T_HIDDEN",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "H",
                  "isInvisible":  true
                },
                {
                  "name":  "B"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: A
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T_HIDDEN
              column: A
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
        - name: H
          sourcecolumns:
            - server: ""
              database: PUBLIC
              schema: ""
              table: T_HIDDEN
              column: H
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: PUBLIC
          schema: ""
          table: T_HIDDEN
          column: ""
    predicatecolumns: []