Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- input: |-
select count(1) from t1 where id 'asdfsadf'; SELECT * FROM |
select * from QRTZ_J0B_DETAILS qjd where J0B_NAME like '%gray';
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: INSERT INTO t1(|);
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: INSERT INTO t2(c1, |);
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: WITH x(x1, x2) AS (SELECT * FROM t2) SELECT x.| FROM x;
want:
- text: x1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: x2
type: COLUMN
definition: ""
comment: ""
priority: 0
- input: WITH x(x1, x2) AS (SELECT * FROM t2) SELECT | FROM x
want:
- text: x1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: x2
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: x
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1 as eid, c2 as xid FROM t2 ORDER BY |
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: eid
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: xid
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1 as eid FROM t1 ORDER BY |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: eid
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT FROM basdkfjasldf;SELECT | FROM t1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM (SELECT c1 FROM t1) cc1(cc1c1)
want:
- text: cc1c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: cc1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM (SELECT c1 FROM t1) cc1
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: cc1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: |-
SELECT
FROM |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: |-
SELECT
FROM |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT FROM |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT FROM t1 WHERE |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT FROM t1 ORDER BY |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT FROM t1 GROUP BY |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT FROM t1 JOIN |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: UPDATE |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: UPDATE t1 SET |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DELETE FROM |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: INSERT INTO |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER TABLE |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DROP TABLE |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM db.|
want:
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1 JOIN |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1, |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * from t1 cc1 JOIN t2 on cc1.|
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- input: SELECT MAX(cc1.|) FROM t2 cc1
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM t1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM t2 x
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: x
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT DISTINCT | FROM t2
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM t2 LIMIT 10
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1, | FROM t2
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: |-
SELECT
|
FROM t1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: |-
SELECT *
FROM
|
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM /* comment */ |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: |-
SELECT * FROM t1 -- comment
WHERE |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM t2 FOR UPDATE
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT t1.| FROM t1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- input: SELECT cc1.| FROM t2 cc1
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- input: SELECT cc1.| FROM t1 cc1 JOIN t2 ON NOT cc1.c1 = t2.c1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- input: SELECT db.t2.| FROM t2
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- input: SELECT a.| FROM t1 a JOIN t1 b ON a.c1 = b.c1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- input: SELECT b.| FROM t1 a JOIN t1 b ON a.c1 = b.c1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- input: SELECT COUNT(|) FROM t1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM t1 JOIN t2 ON t1.c1 = t2.c1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1 cc1 JOIN t2 ON cc1.c1 = t2.|
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- input: SELECT | FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM t1 RIGHT JOIN t2 ON t1.c1 = t2.c1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM t1 CROSS JOIN t2
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM t1 NATURAL JOIN t2
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM t1 a JOIN t2 b ON a.c1 = b.c1 JOIN t2 c ON b.c1 = c.c1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: a
type: TABLE
definition: ""
comment: ""
priority: 0
- text: b
type: TABLE
definition: ""
comment: ""
priority: 0
- text: c
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c.| FROM t1 a JOIN t2 b ON a.c1 = b.c1 JOIN t2 c ON b.c1 = c.c1
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM t1 RIGHT JOIN t2 ON t1.c1 = t2.|
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM t1 CROSS JOIN t2 WHERE t1.|
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM t1 JOIN t2 ON t1.c1 = t2.c1 LEFT JOIN t2 t3 ON t2.c1 = t3.c1 WHERE |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t3
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT a.| FROM t1 a NATURAL JOIN t2 b
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM t1 LEFT JOIN |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM t1 JOIN t2 ON t1.c1 = t2.c1 LEFT JOIN t2 t3 ON t2.c1 = t3.c1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t3
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1 JOIN t2 USING (|)
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT x.| FROM (SELECT * FROM t2) x
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM (SELECT * FROM (SELECT c1 FROM t1) inner_q) outer_q
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: outer_q
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM (SELECT c1 FROM t1) sub1 JOIN t2 ON sub1.c1 = t2.c1
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: sub1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM (SELECT c1 FROM (SELECT c1 FROM (SELECT c1 FROM t1) a) b) c
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: c
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT b.| FROM (SELECT * FROM (SELECT c1 FROM t1) a) b
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- input: (SELECT c1 FROM t1) UNION (SELECT | FROM t2)
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1 WHERE c1 IN (SELECT | FROM t2)
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1 WHERE EXISTS (SELECT | FROM t2)
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1 WHERE c1 = (SELECT MAX(|) FROM t2)
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1 x WHERE x.c1 IN (SELECT c1 FROM t2 WHERE |)
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: x
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1 WHERE EXISTS (SELECT 1 FROM t2 WHERE t2.c1 = t1.|)
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- input: SELECT (SELECT | FROM t1) FROM t2
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: WITH a AS (SELECT c1 FROM t1), b AS (SELECT c1, c2 FROM t2) SELECT | FROM a JOIN b ON a.c1 = b.c1
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: a
type: TABLE
definition: ""
comment: ""
priority: 0
- text: b
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: WITH a AS (SELECT c1 FROM t1), b AS (SELECT c1, c2 FROM t2) SELECT b.| FROM a JOIN b ON a.c1 = b.c1
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: ""
comment: ""
priority: 0
- input: WITH x AS (SELECT c1 FROM t1) SELECT | FROM (SELECT * FROM x) sub1
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: sub1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: x
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: With a AS (SELECT c1 FROM t1), b AS (SELECT * FROM a) SELECT | FROM b
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: a
type: TABLE
definition: ""
comment: ""
priority: 0
- text: b
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: With a AS (SELECT c1 FROM t1), b AS (SELECT a.| FROM a) SELECT * FROM b
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- input: WITH x AS (SELECT c1 FROM t1) SELECT | FROM x, t2
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: x
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: WITH x AS (SELECT c1 FROM t1) SELECT x.| FROM x JOIN t2 ON x.c1 = t2.c1
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- input: WITH x(a, b) AS (SELECT c1, c2 FROM t2) SELECT | FROM x JOIN t1 ON x.a = t1.c1
want:
- text: a
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: b
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: x
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: WITH x AS (SELECT * FROM t2) INSERT INTO t1 SELECT | FROM x
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: x
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: WITH x AS (SELECT c1, c2 FROM t2) UPDATE t1 SET c1 = (SELECT | FROM x)
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: x
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: WITH x AS (SELECT * FROM t2) DELETE FROM t1 WHERE c1 IN (SELECT | FROM x)
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: x
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: WITH RECURSIVE x AS (SELECT c1 FROM t1 UNION ALL SELECT c1 FROM x) SELECT | FROM x
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: x
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: WITH x AS (SELECT c1 FROM t1 UNION SELECT c1 FROM t2) SELECT x.| FROM x
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t2 WHERE c1 = 1 AND |
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t2 WHERE (c1 = 1 AND |)
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t2 WHERE c1 IS NOT NULL AND |
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t2 WHERE c1 IS NULL OR |
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t2 WHERE NOT |
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t2 WHERE c1 > |
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t2 WHERE c1 + | > 0
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t2 WHERE c1 IN (1, 2) AND |
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t2 WHERE c1 BETWEEN | AND c2
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t2 WHERE c1 BETWEEN c2 AND |
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t2 WHERE c1 LIKE |
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t2 WHERE CASE WHEN c1 > 0 THEN | END = 1
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1 a JOIN t2 b ON a.c1 = b.c1 WHERE |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: a
type: TABLE
definition: ""
comment: ""
priority: 0
- text: b
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1 a JOIN t2 b ON a.c1 = b.c1 WHERE a.|
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- input: |-
SELECT
FROM t1
WHERE |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1 as eid FROM t1 WHERE |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1 as eid FROM t1 GROUP BY |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: eid
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1 as eid, c2 as xid FROM t2 HAVING |
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: eid
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: xid
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1 FROM t1 UNION SELECT c1 FROM t2 ORDER BY |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1 FROM t1 UNION ALL SELECT c1 FROM t2 ORDER BY |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t2 LIMIT |
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t2 ORDER BY c1 LIMIT |
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: INSERT INTO db.|
want:
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: INSERT INTO t1 SELECT | FROM t2
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: INSERT INTO t1 VALUES (|)
want: []
- input: SELECT 1; INSERT INTO |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: UPDATE | SET c1 = 1
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: UPDATE db.|
want:
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: UPDATE t1 SET c1 = |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: UPDATE t1 SET c1 = 1 WHERE |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DELETE FROM db.|
want:
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DELETE FROM t1 WHERE |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT 1; UPDATE |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT 1; DELETE FROM |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DELETE FROM t1 WHERE c1 > 0 AND |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER TABLE db.|
want:
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER TABLE t1 ADD COLUMN c2 int REFERENCES |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER TABLE t1 DROP COLUMN |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER TABLE t1 RENAME COLUMN | TO new_name
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER TABLE t1 MODIFY COLUMN |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER TABLE t1 ADD CONSTRAINT fk FOREIGN KEY (|) REFERENCES t2
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER TABLE t1 ADD CONSTRAINT fk FOREIGN KEY (c1) REFERENCES t2(|)
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DROP TABLE db.|
want:
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DROP TABLE IF EXISTS |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DROP VIEW |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DROP INDEX |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- input: TRUNCATE TABLE |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE TABLE t3 (id int, FOREIGN KEY (id) REFERENCES |)
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE TABLE t3 (id int REFERENCES t1(|))
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE INDEX idx ON |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE INDEX idx ON t1 (|)
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE INDEX idx ON t2 (c1, |)
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE VIEW v2 AS SELECT | FROM t1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE VIEW v2 AS SELECT * FROM |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE TABLE t3 AS SELECT | FROM t1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1 FROM t1 UNION SELECT | FROM t2
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1 FROM t1 UNION ALL SELECT | FROM t2
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1 FROM t1 INTERSECT SELECT | FROM t2
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1 FROM t1 EXCEPT SELECT | FROM t2
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1 FROM t1 UNION SELECT c1 FROM t1 UNION SELECT | FROM t2
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1 FROM t1 EXCEPT ALL SELECT | FROM t2
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1 FROM t1 INTERSECT ALL SELECT | FROM t2
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM t2 UNION SELECT * FROM t1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM (SELECT c1 FROM t1 UNION SELECT c1 FROM t2) x WHERE x.|
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM (SELECT c1, c2 FROM t2 UNION SELECT c1, c2 FROM t2) sub
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: sub
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: INVALID SQL; SELECT * FROM |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1; SELECT * FROM t2 WHERE |
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT; SELECT | FROM t1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1 WHERE; SELECT | FROM t2
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE TABLE x (id int); SELECT | FROM t1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT 1; UPDATE |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT 1; DELETE FROM |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t|
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM db.t|
want:
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT t1.c|
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- input: INSERT INTO t|
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: UPDATE t|
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DELETE FROM t|
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1 JOIN t|
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1 WHERE t1.c|
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- input: ALTER TABLE t|
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DROP TABLE t|
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM `t1`
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT `t1`.| FROM t1
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM `db`.|
want:
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM `db`.`t1` WHERE |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: "SELECT\t|\tFROM t1"
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: 'SELECT * FROM t1 WHERE | '
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: |-
SELECT
*
FROM
t1
WHERE |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: /* leading comment */ SELECT * FROM |
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1 WHERE c1 = /* inline */ |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: INSERT INTO `t1`(|)
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1, SUM(c2) OVER (PARTITION BY |) FROM t2
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1, SUM(c2) OVER (ORDER BY |) FROM t2
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1, ROW_NUMBER() OVER (PARTITION BY | ORDER BY c1) FROM t2
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT COALESCE(|, 0) FROM t2
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT COALESCE(c1, |) FROM t2
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT NULLIF(|, 0) FROM t2
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT CAST(| AS int) FROM t2
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT IF(|, 1, 0) FROM t2
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT IFNULL(|, 0) FROM t2
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1 as 'eid' FROM t1 ORDER BY |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: eid
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT c1 as "xid" FROM t1 ORDER BY |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: xid
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t2 AS Foo WHERE foo.|
want:
- text: c1
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: t2 | , NOT NULL
comment: ""
priority: 0
- input: WITH Foo AS (SELECT c1 FROM t1) SELECT foo.| FROM Foo
want: []
- input: ALTER TABLE t1 DROP COLUMN |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER TABLE t1 RENAME COLUMN | TO new_name
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER TABLE db.t1 DROP COLUMN |
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: INSERT IGNORE t1 (|) VALUES (1)
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: INSERT IGNORE INTO t1 (|) VALUES (1)
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: REPLACE INTO t1 (|) VALUES (1)
want:
- text: c1
type: COLUMN
definition: t1 | , NOT NULL
comment: ""
priority: 0
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DROP VIEW db.|
want:
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM other_db.t2
want:
- text: db
type: DATABASE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0