QuackatronHQ / Gigarepo

Inconsistent capitalization detected SQL-L014
Style
Major
33 occurrences in this check
Inconsistent capitalisation of unquoted identifiers
19CREATE TABLE midprimarykeyswapcleanup AS SELECT * FROM generate_series(1,3) AS a;
20-- This schema change is used to enable the primary key swap. The backup is not taken during this schema change.
21ALTER TABLE midprimarykeyswapcleanup ALTER COLUMN a SET NOT NULL;
22ALTER TABLE midprimarykeyswapcleanup ALTER PRIMARY KEY USING COLUMNS (a);23BACKUP defaultdb.* TO 'nodelocal://1/midprimarykeyswapcleanup';
24DROP TABLE midprimarykeyswapcleanup;
Inconsistent capitalisation of unquoted identifiers
18
19CREATE TABLE midprimarykeyswapcleanup AS SELECT * FROM generate_series(1,3) AS a;
20-- This schema change is used to enable the primary key swap. The backup is not taken during this schema change.
21ALTER TABLE midprimarykeyswapcleanup ALTER COLUMN a SET NOT NULL;22ALTER TABLE midprimarykeyswapcleanup ALTER PRIMARY KEY USING COLUMNS (a);
23BACKUP defaultdb.* TO 'nodelocal://1/midprimarykeyswapcleanup';
24DROP TABLE midprimarykeyswapcleanup;
Inconsistent capitalisation of unquoted identifiers
14  a+(b*c), (a+b)*c             -- ditto
15
16
17INSERT INTO mnop (m, n) SELECT i, (1e9 + i/2e4)::float FROM generate_series(1, 2e4) AS i(i) RETURNING NOTHING18
19CREATE TABLE midprimarykeyswapcleanup AS SELECT * FROM generate_series(1,3) AS a;
20-- This schema change is used to enable the primary key swap. The backup is not taken during this schema change.
Inconsistent capitalisation of unquoted identifiers
186
187ALTER TABLE lineitem ADD CONSTRAINT lineitem_fkey_orders FOREIGN KEY (l_orderkey) references orders (o_orderkey);
188ALTER TABLE lineitem ADD CONSTRAINT lineitem_fkey_part FOREIGN KEY (l_partkey) references part (p_partkey);
189ALTER TABLE lineitem ADD CONSTRAINT lineitem_fkey_supplier FOREIGN KEY (l_suppkey) references supplier (s_suppkey);
Inconsistent capitalisation of unquoted identifiers
185) WITH delimiter='|';
186
187ALTER TABLE lineitem ADD CONSTRAINT lineitem_fkey_orders FOREIGN KEY (l_orderkey) references orders (o_orderkey);
188ALTER TABLE lineitem ADD CONSTRAINT lineitem_fkey_part FOREIGN KEY (l_partkey) references part (p_partkey);189ALTER TABLE lineitem ADD CONSTRAINT lineitem_fkey_supplier FOREIGN KEY (l_suppkey) references supplier (s_suppkey);
Inconsistent capitalisation of unquoted identifiers
184  'gs://sf-10/lineitem.tbl.8'
185) WITH delimiter='|';
186
187ALTER TABLE lineitem ADD CONSTRAINT lineitem_fkey_orders FOREIGN KEY (l_orderkey) references orders (o_orderkey);188ALTER TABLE lineitem ADD CONSTRAINT lineitem_fkey_part FOREIGN KEY (l_partkey) references part (p_partkey);
189ALTER TABLE lineitem ADD CONSTRAINT lineitem_fkey_supplier FOREIGN KEY (l_suppkey) references supplier (s_suppkey);
Inconsistent capitalisation of unquoted identifiers
170  INDEX l_cd      (l_commitdate ASC),
171  INDEX l_rd      (l_receiptdate ASC),
172  INDEX l_pk_sk   (l_partkey ASC, l_suppkey ASC),
173  INDEX l_sk_pk   (l_suppkey ASC, l_partkey ASC)174);
175
176IMPORT INTO lineitem CSV DATA(
Inconsistent capitalisation of unquoted identifiers
169  INDEX l_sd      (l_shipdate ASC),
170  INDEX l_cd      (l_commitdate ASC),
171  INDEX l_rd      (l_receiptdate ASC),
172  INDEX l_pk_sk   (l_partkey ASC, l_suppkey ASC),173  INDEX l_sk_pk   (l_suppkey ASC, l_partkey ASC)
174);
175
Inconsistent capitalisation of unquoted identifiers
168  INDEX l_sk      (l_suppkey ASC),
169  INDEX l_sd      (l_shipdate ASC),
170  INDEX l_cd      (l_commitdate ASC),
171  INDEX l_rd      (l_receiptdate ASC),172  INDEX l_pk_sk   (l_partkey ASC, l_suppkey ASC),
173  INDEX l_sk_pk   (l_suppkey ASC, l_partkey ASC)
174);
Inconsistent capitalisation of unquoted identifiers
167  INDEX l_pk      (l_partkey ASC),
168  INDEX l_sk      (l_suppkey ASC),
169  INDEX l_sd      (l_shipdate ASC),
170  INDEX l_cd      (l_commitdate ASC),171  INDEX l_rd      (l_receiptdate ASC),
172  INDEX l_pk_sk   (l_partkey ASC, l_suppkey ASC),
173  INDEX l_sk_pk   (l_suppkey ASC, l_partkey ASC)
Inconsistent capitalisation of unquoted identifiers
166  INDEX l_ok      (l_orderkey ASC),
167  INDEX l_pk      (l_partkey ASC),
168  INDEX l_sk      (l_suppkey ASC),
169  INDEX l_sd      (l_shipdate ASC),170  INDEX l_cd      (l_commitdate ASC),
171  INDEX l_rd      (l_receiptdate ASC),
172  INDEX l_pk_sk   (l_partkey ASC, l_suppkey ASC),
Inconsistent capitalisation of unquoted identifiers
165  PRIMARY KEY     (l_orderkey, l_linenumber),
166  INDEX l_ok      (l_orderkey ASC),
167  INDEX l_pk      (l_partkey ASC),
168  INDEX l_sk      (l_suppkey ASC),169  INDEX l_sd      (l_shipdate ASC),
170  INDEX l_cd      (l_commitdate ASC),
171  INDEX l_rd      (l_receiptdate ASC),
Inconsistent capitalisation of unquoted identifiers
164  l_comment       VARCHAR(44) NOT NULL,
165  PRIMARY KEY     (l_orderkey, l_linenumber),
166  INDEX l_ok      (l_orderkey ASC),
167  INDEX l_pk      (l_partkey ASC),168  INDEX l_sk      (l_suppkey ASC),
169  INDEX l_sd      (l_shipdate ASC),
170  INDEX l_cd      (l_commitdate ASC),
Inconsistent capitalisation of unquoted identifiers
163  l_shipmode      CHAR(10) NOT NULL,
164  l_comment       VARCHAR(44) NOT NULL,
165  PRIMARY KEY     (l_orderkey, l_linenumber),
166  INDEX l_ok      (l_orderkey ASC),167  INDEX l_pk      (l_partkey ASC),
168  INDEX l_sk      (l_suppkey ASC),
169  INDEX l_sd      (l_shipdate ASC),
Inconsistent capitalisation of unquoted identifiers
162  l_shipinstruct  CHAR(25) NOT NULL,
163  l_shipmode      CHAR(10) NOT NULL,
164  l_comment       VARCHAR(44) NOT NULL,
165  PRIMARY KEY     (l_orderkey, l_linenumber),166  INDEX l_ok      (l_orderkey ASC),
167  INDEX l_pk      (l_partkey ASC),
168  INDEX l_sk      (l_suppkey ASC),
Inconsistent capitalisation of unquoted identifiers
143  'gs://sf-10/orders.tbl.8'
144) WITH delimiter='|';
145
146ALTER TABLE orders ADD CONSTRAINT orders_fkey_customer FOREIGN KEY (o_custkey) references customer (c_custkey);147
148CREATE TABLE lineitem (
149  l_orderkey      INTEGER NOT NULL,
Inconsistent capitalisation of unquoted identifiers
129  o_shippriority       INTEGER NOT NULL,
130  o_comment            VARCHAR(79) NOT NULL,
131  INDEX o_ck           (o_custkey ASC),
132  INDEX o_od           (o_orderdate ASC)133);
134
135IMPORT INTO orders CSV DATA(
Inconsistent capitalisation of unquoted identifiers
128  o_clerk              CHAR(15) NOT NULL,
129  o_shippriority       INTEGER NOT NULL,
130  o_comment            VARCHAR(79) NOT NULL,
131  INDEX o_ck           (o_custkey ASC),132  INDEX o_od           (o_orderdate ASC)
133);
134
Inconsistent capitalisation of unquoted identifiers
116  'gs://sf-10/customer.tbl.8'
117) WITH delimiter='|';
118
119ALTER TABLE customer ADD CONSTRAINT customer_fkey_nation FOREIGN KEY (c_nationkey) references nation (n_nationkey);120
121CREATE TABLE orders (
122  o_orderkey           INTEGER NOT NULL PRIMARY KEY,
Inconsistent capitalisation of unquoted identifiers
102  c_acctbal         FLOAT NOT NULL,
103  c_mktsegment      CHAR(10) NOT NULL,
104  c_comment         VARCHAR(117) NOT NULL,
105  INDEX c_nk        (c_nationkey ASC)106);
107
108IMPORT INTO customer CSV DATA(
Inconsistent capitalisation of unquoted identifiers
 91) WITH delimiter='|';
 92
 93ALTER TABLE partsupp ADD CONSTRAINT partsupp_fkey_part FOREIGN KEY (ps_partkey) references part (p_partkey);
 94ALTER TABLE partsupp ADD CONSTRAINT partsupp_fkey_supplier FOREIGN KEY (ps_suppkey) references supplier (s_suppkey); 95
 96CREATE TABLE customer (
 97  c_custkey         INTEGER NOT NULL PRIMARY KEY,
Inconsistent capitalisation of unquoted identifiers
 90  'gs://sf-10/partsupp.tbl.8'
 91) WITH delimiter='|';
 92
 93ALTER TABLE partsupp ADD CONSTRAINT partsupp_fkey_part FOREIGN KEY (ps_partkey) references part (p_partkey); 94ALTER TABLE partsupp ADD CONSTRAINT partsupp_fkey_supplier FOREIGN KEY (ps_suppkey) references supplier (s_suppkey);
 95
 96CREATE TABLE customer (
Inconsistent capitalisation of unquoted identifiers
 76  ps_supplycost         FLOAT NOT NULL,
 77  ps_comment            VARCHAR(199) NOT NULL,
 78  PRIMARY KEY           (ps_partkey, ps_suppkey),
 79  INDEX ps_sk           (ps_suppkey ASC) 80);
 81
 82IMPORT INTO partsupp CSV DATA(
Inconsistent capitalisation of unquoted identifiers
 75  ps_availqty           INTEGER NOT NULL,
 76  ps_supplycost         FLOAT NOT NULL,
 77  ps_comment            VARCHAR(199) NOT NULL,
 78  PRIMARY KEY           (ps_partkey, ps_suppkey), 79  INDEX ps_sk           (ps_suppkey ASC)
 80);
 81
Inconsistent capitalisation of unquoted identifiers
 67  'gs://sf-10/supplier.tbl.8'
 68) WITH delimiter='|';
 69
 70ALTER TABLE supplier ADD CONSTRAINT supplier_fkey_nation FOREIGN KEY (s_nationkey) references nation (n_nationkey); 71
 72CREATE TABLE partsupp (
 73  ps_partkey            INTEGER NOT NULL,