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 * FROM |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM public.|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
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 test.|
want:
- text: order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: users
type: TABLE
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM t1
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 public.t1
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 test.auto
want:
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: users
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT cc1.| FROM t2 cc1
want:
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, 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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT public.t2.| FROM t2
want:
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT | FROM t1 JOIN t2 ON t1.c1 = t2.c1
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM t1 cc1 JOIN t2 ON cc1.c1 = t2.|
want:
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, 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: public.t1 | int, 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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT | FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 test.auto c ON b.c1 = c.id
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: a
type: TABLE
definition: ""
comment: ""
priority: 0
- text: auto
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: users
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 test.auto c ON b.c1 = c.id
want:
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- input: SELECT | FROM (SELECT c1 FROM t1) cc1
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 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: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: WITH x AS (SELECT * FROM t2) SELECT x.| FROM x;
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: c2
type: COLUMN
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: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 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: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: SELECT * FROM t1 WHERE |
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 test.auto WHERE |
want:
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM test.auto WHERE test.auto.|
want:
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- input: SELECT c1 as eid FROM t1 WHERE |
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM t1 WHERE c1 IN (SELECT | FROM t2)
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: eid
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 ORDER BY |
want:
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: eid
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: xid
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: eid
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: eid
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: xid
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 ORDER BY x.|
want:
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM t2 x GROUP BY x.|
want:
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT MAX(cc1.|) FROM t2 cc1
want:
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT COUNT(|) FROM t1
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: INSERT INTO test.| VALUES (1)
want:
- text: order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: users
type: TABLE
definition: ""
comment: ""
priority: 0
- input: INSERT INTO t1 (|) VALUES (1)
want:
- text: c1
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: user_id
type: COLUMN
definition: test.users | int, NOT NULL
comment: ""
priority: 0
- text: username
type: COLUMN
definition: test.users | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: UPDATE test.|
want:
- text: order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: users
type: TABLE
definition: ""
comment: ""
priority: 0
- input: UPDATE t1 SET |
want:
- text: c1
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: user_id
type: COLUMN
definition: test.users | int, NOT NULL
comment: ""
priority: 0
- text: username
type: COLUMN
definition: test.users | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.mv1
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: user_id
type: COLUMN
definition: test.users | int, NOT NULL
comment: ""
priority: 0
- text: username
type: COLUMN
definition: test.users | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.mv1
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: user_id
type: COLUMN
definition: test.users | int, NOT NULL
comment: ""
priority: 0
- text: username
type: COLUMN
definition: test.users | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DELETE FROM |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DELETE FROM test.|
want:
- text: order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: users
type: TABLE
definition: ""
comment: ""
priority: 0
- input: DELETE FROM t1 WHERE |
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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;SELECT * FROM |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 count(1) from t1 where id; SELECT * FROM |
select * from QRTZ_J0B_DETAILS qjd where J0B_NAME like '%gray';
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 v1
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM t1 JOIN test.auto ON t1.c1 = test.auto.id
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: users
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: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 * FROM t1 JOIN test.auto a ON t1.c1 = a.id WHERE a.|
want:
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- input: SELECT | FROM t1 RIGHT JOIN t2 ON t1.c1 = t2.c1
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 FULL OUTER JOIN t2 ON t1.c1 = t2.c1
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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.|
want:
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM t1 FULL OUTER JOIN t2 ON t1.c1 = t2.|
want:
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM t1 CROSS JOIN t2 WHERE t1.|
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM t1 JOIN t2 USING (|)
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 test.auto ON t2.c1 = test.auto.id
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: users
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM t2 WHERE c1 BETWEEN | AND c2
want:
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 test.auto WHERE name LIKE |
want:
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: users
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 t2 WHERE CASE WHEN c1 > 0 THEN | END = 1
want:
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 DISTINCT | FROM t2
want:
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 DISTINCT ON (|) c1, c2 FROM t2
want:
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 OFFSET |
want:
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 t2 WHERE c1 > 0 RETURNING |
want:
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 t2 SET c1 = 1 RETURNING |
want:
- text: c1
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: user_id
type: COLUMN
definition: test.users | int, NOT NULL
comment: ""
priority: 0
- text: username
type: COLUMN
definition: test.users | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 ft1 WHERE |
want:
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: ft1
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 mv1 WHERE |
want:
- text: c1
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: mv1
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 public.ft1 WHERE |
want:
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: ft1
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 public.mv1 WHERE |
want:
- text: c1
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: mv1
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 ft1.| FROM ft1
want:
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- input: SELECT | FROM ft1
want:
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: ft1
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 mv1.| FROM mv1
want:
- text: c1
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- input: SELECT | FROM mv1
want:
- text: c1
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: mv1
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: INSERT INTO |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: UPDATE | SET c1 = 1
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE TABLE test_tbl (id int, FOREIGN KEY (id) REFERENCES |)
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE TABLE test_tbl (id int, FOREIGN KEY (id) REFERENCES public.|)
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
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 test_tbl (id int REFERENCES |)
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE TABLE test_tbl (id int REFERENCES t1(|))
want:
- text: c1
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: user_id
type: COLUMN
definition: test.users | int, NOT NULL
comment: ""
priority: 0
- text: username
type: COLUMN
definition: test.users | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE INDEX idx ON |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE INDEX idx ON public.|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
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: public.mv1
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: user_id
type: COLUMN
definition: test.users | int, NOT NULL
comment: ""
priority: 0
- text: username
type: COLUMN
definition: test.users | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.mv1
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: user_id
type: COLUMN
definition: test.users | int, NOT NULL
comment: ""
priority: 0
- text: username
type: COLUMN
definition: test.users | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE MATERIALIZED VIEW mv AS SELECT | FROM t1
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 test_tbl AS SELECT | FROM t1
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 test_tbl (LIKE |)
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE TRIGGER trig AFTER INSERT ON |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: CREATE TRIGGER trig AFTER INSERT ON public.|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
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: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER TABLE public.|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
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 COLUMN c2 int REFERENCES |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.mv1
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: user_id
type: COLUMN
definition: test.users | int, NOT NULL
comment: ""
priority: 0
- text: username
type: COLUMN
definition: test.users | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.mv1
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: user_id
type: COLUMN
definition: test.users | int, NOT NULL
comment: ""
priority: 0
- text: username
type: COLUMN
definition: test.users | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER TABLE t1 ALTER COLUMN |
want:
- text: c1
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: user_id
type: COLUMN
definition: test.users | int, NOT NULL
comment: ""
priority: 0
- text: username
type: COLUMN
definition: test.users | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER TABLE t1 ALTER COLUMN | SET NOT NULL
want:
- text: c1
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: user_id
type: COLUMN
definition: test.users | int, NOT NULL
comment: ""
priority: 0
- text: username
type: COLUMN
definition: test.users | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.mv1
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: user_id
type: COLUMN
definition: test.users | int, NOT NULL
comment: ""
priority: 0
- text: username
type: COLUMN
definition: test.users | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.mv1
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: user_id
type: COLUMN
definition: test.users | int, NOT NULL
comment: ""
priority: 0
- text: username
type: COLUMN
definition: test.users | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER INDEX | RENAME TO new_name
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER VIEW |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER VIEW public.|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
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 SEQUENCE |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: ALTER SEQUENCE public.|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
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 MATERIALIZED VIEW |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DROP TABLE |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DROP TABLE public.|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
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 IF EXISTS |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DROP VIEW |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DROP VIEW public.|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
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 INDEX |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DROP SEQUENCE |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DROP MATERIALIZED VIEW |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: TRUNCATE |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: TRUNCATE public.|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
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: COMMENT ON TABLE |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: COMMENT ON TABLE public.|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
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: COMMENT ON COLUMN t1.|
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- input: COMMENT ON COLUMN public.t1.|
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- input: GRANT SELECT ON |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: GRANT SELECT ON public.|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
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: GRANT ALL ON ALL TABLES IN SCHEMA |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: REVOKE SELECT ON |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: REVOKE SELECT ON public.|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
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: GRANT USAGE ON SEQUENCE |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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 | FROM x JOIN t1 ON x.c1 = t1.c1) SELECT * FROM x
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 x.| FROM x JOIN t1 ON x.c1 = t1.c1) SELECT * FROM x
want:
- input: WITH x AS (SELECT * FROM t2) INSERT INTO t1 SELECT | FROM x
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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, LATERAL (SELECT | FROM t2 WHERE t2.c1 = t1.c1) sub
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: SELECT sub.| FROM t1, LATERAL (SELECT c1, c2 FROM t2 WHERE t2.c1 = t1.c1) sub
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: ""
comment: ""
priority: 0
- input: SELECT | FROM t1 LEFT JOIN LATERAL (SELECT * FROM t2 WHERE t2.c1 = t1.c1) sub ON true
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: SELECT * FROM t1, LATERAL (SELECT t1.| FROM t2) sub
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM t2 x, LATERAL (SELECT x.| FROM t1) sub
want:
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT | FROM generate_series(1, 10) g
want:
- text: c1
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.mv1
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: f1
type: COLUMN
definition: public.ft1 | int, NOT NULL
comment: ""
priority: 0
- text: f2
type: COLUMN
definition: public.ft1 | varchar, NOT NULL
comment: ""
priority: 0
- text: id
type: COLUMN
definition: test.auto | int, NOT NULL
comment: ""
priority: 0
- text: name
type: COLUMN
definition: test.auto | varchar, NOT NULL
comment: ""
priority: 0
- text: user_id
type: COLUMN
definition: test.users | int, NOT NULL
comment: ""
priority: 0
- text: username
type: COLUMN
definition: test.users | varchar, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT g.| FROM generate_series(1, 10) g
want:
- input: SELECT | FROM t1, generate_series(1, 10) g
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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, LATERAL (SELECT * FROM t1 WHERE t1.c1 = x.c1) sub
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: x
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT (SELECT | FROM t1) FROM t2
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 t1.| FROM t1) FROM t2
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM t1 WHERE c1 = ANY(SELECT | FROM t2)
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 = ALL(SELECT | FROM t2)
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 * FROM (SELECT | FROM t1) a) b
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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 b.| FROM (SELECT * FROM (SELECT c1 FROM t1) a) b
want:
- text: c1
type: COLUMN
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1 WHERE EXISTS (SELECT 1 FROM t2 WHERE t2.c1 = t1.|)
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
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: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: SELECT sub.| 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
- input: SELECT c1 FROM t1 INTERSECT SELECT | FROM t2
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: 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 c1 FROM t1 EXCEPT ALL SELECT | FROM t2
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: c1
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM "public".|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
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 public."t1" WHERE |
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM public.t|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
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.c|
want:
- text: c1
type: COLUMN
definition: public.t1 | int, NOT NULL
comment: ""
priority: 0
- input: SELECT * FROM test.a|
want:
- text: order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: users
type: TABLE
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM tes|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- input: INSERT INTO t|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: UPDATE t|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: DELETE FROM t|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT * FROM t1 JOIN t|
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT 1; INSERT INTO |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT 1; UPDATE |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: SELECT 1; DELETE FROM |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
type: TABLE
definition: ""
comment: ""
priority: 0
- text: v1
type: VIEW
definition: ""
comment: ""
priority: 0
- input: INVALID SQL; SELECT * FROM |
want:
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: c2
type: COLUMN
definition: public.t2 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: seq1
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: test.order_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: user_id_seq
type: SEQUENCE
definition: ""
comment: ""
priority: 0
- text: t1
type: TABLE
definition: ""
comment: ""
priority: 0
- text: t2
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.auto
type: TABLE
definition: ""
comment: ""
priority: 0
- text: test.users
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: public.t1 | int, NOT NULL
comment: ""
priority: 0
- text: ft1
type: FOREIGNTABLE
definition: ""
comment: ""
priority: 0
- text: mv1
type: MATERIALIZEDVIEW
definition: ""
comment: ""
priority: 0
- text: public
type: SCHEMA
definition: ""
comment: ""
priority: 0
- text: test
type: SCHEMA
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