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: 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: []