1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420
|
const char* tests[] = {
"SELECT 1",
"SELECT 1; SELECT 2",
"SELECT 1 FROM t(1)",
"SELECT sum(unique1) FILTER (WHERE unique1 IN (SELECT unique1 FROM onek WHERE unique1 < 100)) FROM tenk1",
"SELECT a AS b FROM x WHERE y = 5 AND z = y",
"SELECT FROM x WHERE y = 5 AND z = y",
"SELECT a AS b FROM public.x WHERE y = 5 AND z = y",
"SELECT DISTINCT a, b, * FROM c WHERE d = e",
"SELECT DISTINCT ON (a) a, b FROM c",
"SELECT * INTO films_recent FROM films WHERE date_prod >= '2002-01-01'",
"SELECT current_timestamp",
"SELECT current_time(2)",
"SELECT memory_total_bytes, memory_swap_total_bytes - memory_swap_free_bytes AS swap, date_part('year', s.collected_at) AS collected_at FROM snapshots s JOIN system_snapshots ON snapshot_id = s.id WHERE s.database_id = 23 AND s.collected_at >= 90 AND s.collected_at <= 160 ORDER BY collected_at ASC",
"SELECT * FROM a ORDER BY x ASC NULLS FIRST",
"SELECT * FROM a ORDER BY x ASC NULLS LAST",
"SELECT * FROM a ORDER BY x COLLATE \"tr_TR\" DESC NULLS LAST",
"SELECT 'foo' COLLATE \"tr_TR\"",
"WITH kodsis AS (SELECT * FROM application), kodsis2 AS (SELECT * FROM application) SELECT * FROM kodsis UNION SELECT * FROM kodsis ORDER BY id DESC",
"SELECT id, name FROM table1 UNION (SELECT id, name FROM table2 ORDER BY name) ORDER BY id ASC",
"SELECT a FROM kodsis EXCEPT SELECT a FROM application",
"SELECT * FROM (VALUES ('anne', 'smith'), ('bob', 'jones'), ('joe', 'blow')) names(first, last)",
"SELECT * FROM users WHERE name LIKE 'postgresql:%'",
"SELECT * FROM users WHERE name NOT LIKE 'postgresql:%'",
"SELECT * FROM users WHERE name ILIKE 'postgresql:%'",
"SELECT * FROM users WHERE name NOT ILIKE 'postgresql:%'",
"WITH t AS (SELECT random() AS x FROM generate_series(1, 3)) SELECT * FROM t",
"WITH RECURSIVE search_graph(id, link, data, depth, path, cycle) AS (SELECT g.id, g.link, g.data, 1, ARRAY[ROW(g.f1, g.f2)], false FROM graph g UNION ALL SELECT g.id, g.link, g.data, sg.depth + 1, path || ROW(g.f1, g.f2), ROW(g.f1, g.f2) = ANY(path) FROM graph g, search_graph sg WHERE g.id = sg.link AND NOT cycle) SELECT id, data, link FROM search_graph",
"SELECT OVERLAY(m.name PLACING '******' FROM 3 FOR 6) AS tc_kimlik FROM tb_test m",
"SELECT sum(price_cents) FROM products",
"SELECT ARRAY(SELECT id FROM products)::bigint[]",
"SELECT m.name AS mname, pname FROM manufacturers m, LATERAL get_product_names(m.id) pname",
"SELECT m.name AS mname, pname FROM manufacturers m LEFT JOIN LATERAL get_product_names(m.id) pname ON true",
"SELECT * FROM tb_test_main mh JOIN LATERAL (SELECT ftnrm.* FROM test ftnrm WHERE ftnrm.hizmet_id = mh.id UNION ALL SELECT ftarc.* FROM test.test2 ftarc WHERE ftarc.hizmet_id = mh.id) ft ON true",
"SELECT x, y FROM a CROSS JOIN b",
"SELECT x, y FROM a NATURAL JOIN b",
"SELECT x, y FROM a LEFT JOIN b ON 1 > 0",
"SELECT x, y FROM a RIGHT JOIN b ON 1 > 0",
"SELECT x, y FROM a FULL JOIN b ON 1 > 0",
"SELECT x, y FROM a JOIN b USING (z)",
"SELECT 2 + 2",
"SELECT * FROM x WHERE y IS NULL",
"SELECT * FROM x WHERE y IS NOT NULL",
"SELECT count(*) FROM x WHERE y IS NOT NULL",
"SELECT count(DISTINCT a) FROM x WHERE y IS NOT NULL",
"SELECT CASE WHEN a.status = 1 THEN 'active' WHEN a.status = 2 THEN 'inactive' END FROM accounts a",
"SELECT CASE 1 > 0 WHEN true THEN 'ok' ELSE NULL END",
"SELECT CASE WHEN a.status = 1 THEN 'active' WHEN a.status = 2 THEN 'inactive' ELSE 'unknown' END FROM accounts a",
"SELECT * FROM accounts WHERE status = CASE WHEN x = 1 THEN 'active' ELSE 'inactive' END",
"SELECT CASE WHEN EXISTS (SELECT 1) THEN 1 ELSE 2 END",
"SELECT (SELECT 'x')",
"SELECT * FROM (SELECT generate_series(0, 100)) a",
"SELECT * FROM x WHERE id IN (1, 2, 3)",
"SELECT * FROM x WHERE id IN (SELECT id FROM account)",
"SELECT * FROM x WHERE id NOT IN (1, 2, 3)",
"SELECT * FROM x JOIN (SELECT n FROM z) b ON a.id = b.id",
"SELECT * FROM x WHERE y = z[5]",
"SELECT (foo(1)).y",
"SELECT proname, (SELECT regexp_split_to_array(proargtypes::text, ' '))[idx] AS argtype, proargnames[idx] AS argname FROM pg_proc",
"SELECT COALESCE((SELECT customer.sp_person(n.id) AS sp_person).city_id, NULL::int) AS city_id FROM customer.tb_customer n",
"SELECT * FROM x WHERE y = z[1][4]",
"SELECT (k #= hstore('{id}'::text[], ARRAY[1::text])).* FROM test k",
"SELECT * FROM x WHERE NOT y",
"SELECT * FROM x WHERE x OR y",
"SELECT 1 WHERE (1 = 1 OR 1 = 2) AND 1 = 2",
"SELECT 1 WHERE (1 = 1 AND 2 = 2) OR 2 = 3",
"SELECT 1 WHERE 1 = 1 OR 2 = 2 OR 2 = 3",
"SELECT * FROM x WHERE x = ALL (SELECT x FROM y WHERE z = 20)",
"SELECT * FROM x WHERE x = ANY (SELECT x FROM y WHERE z = 20)",
"SELECT * FROM x WHERE x = COALESCE(y, z)",
"SELECT a, b, max(c) FROM c WHERE d = 1 GROUP BY a, b",
"SELECT * FROM x LIMIT 50",
"SELECT * FROM x OFFSET 50",
"SELECT amount * 0.5",
"SELECT * FROM x WHERE x BETWEEN '2016-01-01' AND '2016-02-02'",
"SELECT * FROM x WHERE x NOT BETWEEN '2016-01-01' AND '2016-02-02'",
"SELECT * FROM x WHERE x BETWEEN SYMMETRIC 20 AND 10",
"SELECT * FROM x WHERE x NOT BETWEEN SYMMETRIC 20 AND 10",
"SELECT NULLIF(id, 0) AS id FROM x",
"SELECT NULL FROM x",
"SELECT * FROM x WHERE y IS TRUE",
"SELECT * FROM x WHERE y IS NOT TRUE",
"SELECT * FROM x WHERE y IS FALSE",
"SELECT * FROM x WHERE y IS NOT FALSE",
"SELECT * FROM x WHERE y IS UNKNOWN",
"SELECT * FROM x WHERE y IS NOT UNKNOWN",
"SELECT * FROM crosstab('SELECT department, role, COUNT(id) FROM users GROUP BY department, role ORDER BY department, role', 'VALUES (''admin''::text), (''ordinary''::text)') AS (department varchar, admin int, ordinary int)",
"SELECT * FROM crosstab('SELECT department, role, COUNT(id) FROM users GROUP BY department, role ORDER BY department, role', 'VALUES (''admin''::text), (''ordinary''::text)') ctab (department varchar, admin int, ordinary int)",
"SELECT row_cols[0] AS dept, row_cols[1] AS sub, admin, ordinary FROM crosstab('SELECT ARRAY[department, sub] AS row_cols, role, COUNT(id) FROM users GROUP BY department, role ORDER BY department, role', 'VALUES (''admin''::text), (''ordinary''::text)') AS (row_cols varchar[], admin int, ordinary int)",
"SELECT 1::int8",
"SELECT CAST(1 + 3 AS int8)",
"SELECT x::regclass",
"SELECT table_field::bool, table_field::boolean FROM t",
"SELECT true, false",
"SELECT 1::boolean, 0::boolean",
"SELECT $5",
"INSERT INTO x (y, z) VALUES (1, 'abc')",
"INSERT INTO x (\"user\") VALUES ('abc')",
"INSERT INTO x (y, z) VALUES (1, 'abc') RETURNING id",
"INSERT INTO x SELECT * FROM y",
"WITH moved AS (DELETE FROM employees WHERE manager_name = 'Mary') INSERT INTO employees_of_mary SELECT * FROM moved",
"INSERT INTO x (y, z) VALUES (1, 'abc') ON CONFLICT (y) DO UPDATE SET \"user\" = excluded.\"user\" RETURNING y",
"INSERT INTO x (y, z) VALUES (1, 'abc') ON CONFLICT (y) DO NOTHING RETURNING y",
"INSERT INTO distributors (did, dname) VALUES (10, 'Conrad International') ON CONFLICT (did) WHERE is_active DO NOTHING",
"INSERT INTO distributors (did, dname) VALUES (9, 'Antwerp Design') ON CONFLICT ON CONSTRAINT distributors_pkey DO NOTHING",
"INSERT INTO foo (a, b, c, d) VALUES ($1) ON CONFLICT (id) DO UPDATE SET (a, b, c, d) = (excluded.a, excluded.b, excluded.c, CASE WHEN foo.d = excluded.d THEN excluded.d END)",
"INSERT INTO employees SELECT * FROM people WHERE 1 = 1 GROUP BY name HAVING count(name) > 1 ORDER BY name DESC LIMIT 10 OFFSET 15 FOR UPDATE",
"INSERT INTO films VALUES ('T_601', 'Yojimbo', 106, DEFAULT, 'Drama', DEFAULT)",
"SELECT * FROM people FOR UPDATE OF name, email",
"SELECT name::varchar(255) FROM people",
"SELECT name::varchar FROM people",
"SELECT age::numeric(5, 2) FROM people",
"SELECT age::numeric FROM people",
"UPDATE x SET y = 1 WHERE z = 'abc'",
"UPDATE ONLY x table_x SET y = 1 WHERE z = 'abc' RETURNING y AS changed_y",
"WITH archived AS (DELETE FROM employees WHERE manager_name = 'Mary') UPDATE users SET archived = true WHERE users.id IN (SELECT user_id FROM moved)",
"WITH archived AS (DELETE FROM employees WHERE manager_name = 'Mary' RETURNING user_id) UPDATE users SET archived = true FROM archived WHERE archived.user_id = id RETURNING id",
"INSERT INTO jackdanger_card_totals (id, amount_cents, created_at) SELECT series.i, random() * 1000, (SELECT '2015-08-25 00:00:00 -0700'::timestamp + (('2015-08-25 23:59:59 -0700'::timestamp - '2015-08-25 00:00:00 -0700'::timestamp) * random())) FROM generate_series(1, 10000) series(i)",
"UPDATE foo SET a = 24, b = true",
"UPDATE x SET \"user\" = 'emin'",
"DELETE FROM x WHERE y = 1",
"DELETE FROM ONLY x table_x USING table_z WHERE y = 1 RETURNING *",
"WITH archived AS (DELETE FROM employees WHERE manager_name = 'Mary') DELETE FROM users WHERE users.id IN (SELECT user_id FROM moved)",
"CREATE CAST (bigint AS int4) WITH FUNCTION int4(bigint) AS ASSIGNMENT",
"CREATE CAST (bigint AS int4) WITHOUT FUNCTION AS IMPLICIT",
"CREATE CAST (bigint AS int4) WITH INOUT AS ASSIGNMENT",
"CREATE DOMAIN us_postal_code AS text CHECK (\"VALUE\" ~ E'^\\\\d{5}$' OR \"VALUE\" ~ E'^\\\\d{5}-\\\\d{4}$')",
"CREATE FUNCTION getfoo(int) RETURNS SETOF users AS $$SELECT * FROM \"users\" WHERE users.id = $1;$$ LANGUAGE sql",
"CREATE OR REPLACE FUNCTION getfoo(int) RETURNS SETOF users AS $$SELECT * FROM \"users\" WHERE users.id = $1;$$ LANGUAGE sql",
"CREATE OR REPLACE FUNCTION getfoo(int) RETURNS SETOF users AS $$SELECT * FROM \"users\" WHERE users.id = $1;$$ LANGUAGE sql IMMUTABLE",
"CREATE OR REPLACE FUNCTION getfoo(int) RETURNS SETOF users AS $$SELECT * FROM \"users\" WHERE users.id = $1;$$ LANGUAGE sql IMMUTABLE RETURNS NULL ON NULL INPUT",
"CREATE OR REPLACE FUNCTION getfoo(int) RETURNS SETOF users AS $$SELECT * FROM \"users\" WHERE users.id = $1;$$ LANGUAGE sql IMMUTABLE CALLED ON NULL INPUT",
"CREATE OR REPLACE FUNCTION getfoo() RETURNS text AS $$SELECT name FROM \"users\" LIMIT 1$$ LANGUAGE sql IMMUTABLE CALLED ON NULL INPUT",
"CREATE SCHEMA myschema",
"CREATE SCHEMA AUTHORIZATION joe",
"CREATE SCHEMA IF NOT EXISTS test AUTHORIZATION joe",
"CREATE SCHEMA hollywood CREATE TABLE films (title text, release date, awards text[]) CREATE VIEW winners AS SELECT title, release FROM films WHERE awards IS NOT NULL",
"CREATE UNLOGGED TABLE cities (name text, population real, altitude double, identifier smallint, postal_code int, foreign_id bigint)",
"CREATE TABLE IF NOT EXISTS distributors (name varchar(40) DEFAULT 'Luso Films', len interval hour to second(3), name varchar(40) DEFAULT 'Luso Films', did int DEFAULT nextval('distributors_serial'), stamp timestamp DEFAULT now() NOT NULL, stamptz timestamp with time zone, \"time\" time NOT NULL, timetz time with time zone, CONSTRAINT name_len PRIMARY KEY (name, len))",
"CREATE TABLE types (a real, b double precision, c numeric(2, 3), d char(4), e char(5), f varchar(6), g varchar(7))",
"CREATE TABLE types (a geometry(point) NOT NULL)",
"CREATE TABLE tablename (colname int NOT NULL DEFAULT nextval('tablename_colname_seq'))",
"CREATE TABLE capitals (state char(2)) INHERITS (cities)",
"CREATE TEMPORARY TABLE temp AS SELECT c FROM t",
"CREATE TABLE films2 AS SELECT * FROM films",
"CREATE TEMPORARY TABLE films_recent ON COMMIT DROP AS SELECT * FROM films WHERE date_prod > $1",
"DROP SERVER IF EXISTS foo",
"DROP PUBLICATION mypublication",
"DROP TYPE box",
"DROP TABLESPACE mystuff",
"DROP CONVERSION myname",
"DROP SEQUENCE serial",
"DROP INDEX title_idx",
"DROP MATERIALIZED VIEW order_summary",
"DROP TRIGGER if_dist_exists ON films",
"DROP RULE newrule ON mytable",
"DROP CAST (text AS int)",
"DROP OPERATOR FAMILY float_ops USING btree",
"DROP AGGREGATE myavg(int), myavg(bigint)",
"DROP COLLATION german",
"DROP FOREIGN DATA WRAPPER dbi",
"DROP ACCESS METHOD heptree",
"DROP STATISTICS IF EXISTS accounting.users_uid_creation, public.grants_user_role",
"DROP TEXT SEARCH DICTIONARY english",
"DROP OPERATOR CLASS widget_ops USING btree",
"DROP POLICY p1 ON my_table",
"DROP SUBSCRIPTION mysub",
"DROP TEXT SEARCH CONFIGURATION my_english",
"DROP EVENT TRIGGER snitch",
"DROP TEXT SEARCH PARSER my_parser",
"DROP EXTENSION hstore",
"DROP DOMAIN box",
"DROP TEXT SEARCH TEMPLATE thesaurus",
"DROP TRANSFORM FOR hstore LANGUAGE plpythonu",
"DROP FOREIGN TABLE films, distributors",
"DROP FUNCTION sqrt(int)",
"DROP FUNCTION update_employee_salaries()",
"DROP FUNCTION update_employee_salaries",
"DROP TABLE IF EXISTS any_table CASCADE",
"DROP TABLE IF EXISTS any_table",
"DROP SCHEMA IF EXISTS any_schema",
"ALTER TABLE distributors DROP CONSTRAINT distributors_pkey, ADD CONSTRAINT distributors_pkey PRIMARY KEY USING INDEX dist_id_temp_idx, ADD CONSTRAINT zipchk CHECK (char_length(zipcode) = 5), ALTER COLUMN tstamp DROP DEFAULT, ALTER COLUMN tstamp TYPE timestamp with time zone USING 'epoch'::timestamp with time zone + (date_part('epoch', tstamp) * '1 second'::interval), ALTER COLUMN tstamp SET DEFAULT now(), ALTER COLUMN tstamp DROP DEFAULT, ALTER COLUMN tstamp SET STATISTICS -5, ADD COLUMN some_int int NOT NULL, DROP IF EXISTS other_column CASCADE",
"ALTER TABLE distributors RENAME TO suppliers",
"ALTER TABLE distributors ADD CONSTRAINT distfk FOREIGN KEY (address) REFERENCES addresses (address)",
"ALTER TABLE distributors ADD CONSTRAINT distfk FOREIGN KEY (address) REFERENCES addresses (address) NOT VALID",
"ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs",
"ALTER CONVERSION iso_8859_1_to_utf8 RENAME TO latin1_to_unicode",
"ALTER TABLE distributors RENAME CONSTRAINT zipchk TO zip_check",
"ALTER INDEX distributors RENAME TO suppliers",
"ALTER MATERIALIZED VIEW foo RENAME TO bar",
"ALTER TABLESPACE index_space RENAME TO fast_raid",
"ALTER TABLE distributors RENAME COLUMN address TO city",
"ALTER COLLATION \"de_DE\" RENAME TO german",
"ALTER TYPE electronic_mail RENAME TO email",
"ALTER DOMAIN zipcode RENAME CONSTRAINT zipchk TO zip_check",
"ALTER AGGREGATE myavg(int) RENAME TO my_average",
"ALTER FUNCTION sqrt(int) RENAME TO square_root",
"ALTER RULE notify_all ON emp RENAME TO notify_me",
"BEGIN",
"BEGIN ISOLATION LEVEL SERIALIZABLE",
"BEGIN READ ONLY",
"BEGIN ISOLATION LEVEL READ COMMITTED, DEFERRABLE",
"START TRANSACTION READ ONLY",
"ROLLBACK",
"ROLLBACK AND CHAIN",
"COMMIT",
"COMMIT AND CHAIN",
"SAVEPOINT \"x y\"",
"ROLLBACK TO SAVEPOINT x",
"RELEASE x",
"SELECT rank(*) OVER ()",
"SELECT rank(*) OVER (PARTITION BY id)",
"SELECT rank(*) OVER (ORDER BY id)",
"SELECT rank(*) OVER (PARTITION BY id, id2 ORDER BY id DESC, id2)",
"SELECT rank(*) OVER named_window",
"SELECT max(create_date::date) FILTER (WHERE cancel_date IS NULL) OVER (ORDER BY create_date DESC) FROM tb_x",
"ALTER VIEW foo RENAME TO bar",
"CREATE OR REPLACE TEMPORARY VIEW view_a AS SELECT * FROM a(1) WITH CHECK OPTION",
"DROP VIEW kinds",
"CREATE VIEW view_a (a, b) AS WITH RECURSIVE view_a(a, b) AS (SELECT * FROM a(1)) SELECT a, b FROM view_a",
"SET statement_timeout TO 10000",
"SET search_path TO my_schema, public",
"SET LOCAL search_path TO my_schema, public",
"SET \"user\" TO 4",
"SET TIME ZONE interval '+00:00' hour to minute",
"SET timezone TO -7",
"VACUUM",
"VACUUM t",
"VACUUM (FULL) t",
"VACUUM (FREEZE) t",
"VACUUM (VERBOSE) t",
"VACUUM (ANALYZE) t",
"VACUUM (FULL, FREEZE, VERBOSE, ANALYZE)",
"VACUUM (ANALYZE) t(a, b)",
"LOCK TABLE t",
"LOCK TABLE t, u",
"EXPLAIN SELECT a FROM b",
"EXPLAIN (ANALYZE) SELECT a FROM b",
"EXPLAIN (ANALYZE, BUFFERS) SELECT a FROM b",
"COPY t FROM STDIN",
"COPY t(c1, c2) FROM STDIN",
"COPY t FROM PROGRAM '/bin/false'",
"COPY t FROM '/dev/null'",
"COPY t TO STDOUT",
"COPY (SELECT 1 FROM foo) TO STDOUT",
"COPY t FROM STDIN WITH (convert_selectively, some_str test, some_num 1, some_list (a), some_star *)",
"DO $$BEGIN PERFORM * FROM information_schema.tables; END$$",
"DO LANGUAGE plpgsql $$ BEGIN PERFORM * FROM information_schema.tables; END $$",
"DO $$ BEGIN PERFORM * FROM information_schema.tables; END $$ LANGUAGE plpgsql",
"DISCARD ALL",
"DISCARD PLANS",
"DISCARD SEQUENCES",
"DISCARD TEMP",
"CREATE AGGREGATE aggregate1 (int4) (sfunc = sfunc1, stype = stype1)",
"CREATE AGGREGATE aggregate1 (int4, bool) (sfunc = sfunc1, stype = stype1)",
"CREATE AGGREGATE aggregate1 (*) (sfunc = sfunc1, stype = stype1)",
"CREATE AGGREGATE aggregate1 (int4) (sfunc = sfunc1, stype = stype1, finalfunc_extra, mfinalfuncextra)",
"CREATE AGGREGATE aggregate1 (int4) (sfunc = sfunc1, stype = stype1, finalfunc_modify = read_only, parallel = restricted)",
"CREATE AGGREGATE percentile_disc (float8 ORDER BY anyelement) (sfunc = ordered_set_transition, stype = internal, finalfunc = percentile_disc_final, finalfunc_extra)",
"CREATE OPERATOR + (procedure = plusfunc)",
"CREATE OPERATOR + (procedure = plusfunc, leftarg = int4, rightarg = int4)",
"CREATE OPERATOR + (procedure = plusfunc, hashes, merges)",
"CREATE TYPE type1",
"CREATE TYPE type1 AS (attr1 int4, attr2 bool)",
"CREATE TYPE type1 AS (attr1 int4 COLLATE collation1, attr2 bool)",
"CREATE TYPE type1 AS ENUM ('value1', 'value2', 'value3')",
"CREATE TYPE type1 AS RANGE (subtype = int4)",
"CREATE TYPE type1 AS RANGE (subtype = int4, receive = receive_func, passedbyvalue)",
"CREATE TYPE type1 (input = input1, output = output1)",
"CREATE TYPE type1 (input = input1, output = output1, passedbyvalue)",
"GRANT select ON \"table\" TO \"user\"",
"GRANT select, update, insert ON \"table\" TO \"user\"",
"GRANT select ON ALL TABLES IN SCHEMA schema TO \"user\"",
"GRANT select ON \"table\" TO user1, user2",
"GRANT select ON \"table\" TO public",
"GRANT select ON \"table\" TO CURRENT_USER",
"GRANT select ON \"table\" TO SESSION_USER",
"GRANT ALL ON \"table\" TO \"user\"",
"GRANT select ON \"table\" TO \"user\" WITH GRANT OPTION",
"GRANT select (\"column\") ON \"table\" TO \"user\"",
"GRANT select (column1, column2) ON \"table\" TO \"user\"",
"GRANT usage ON SEQUENCE sequence TO \"user\"",
"GRANT usage ON ALL SEQUENCES IN SCHEMA schema TO \"user\"",
"GRANT create ON DATABASE database TO \"user\"",
"GRANT usage ON DOMAIN domain TO \"user\"",
"GRANT usage ON FOREIGN DATA WRAPPER fdw TO \"user\"",
"GRANT usage ON FOREIGN SERVER server TO \"user\"",
"GRANT execute ON FUNCTION function TO \"user\"",
"GRANT execute ON FUNCTION function() TO \"user\"",
"GRANT execute ON FUNCTION function(string) TO \"user\"",
"GRANT execute ON FUNCTION function(string, string, boolean) TO \"user\"",
"GRANT execute ON ALL FUNCTIONS IN SCHEMA schema TO \"user\"",
"GRANT usage ON LANGUAGE plpgsql TO \"user\"",
"GRANT select ON LARGE OBJECT 1234 TO \"user\"",
"GRANT create ON SCHEMA schema TO \"user\"",
"GRANT create ON TABLESPACE tablespace TO \"user\"",
"GRANT usage ON TYPE type TO \"user\"",
"GRANT role TO \"user\"",
"GRANT role1, role2 TO \"user\"",
"GRANT role TO \"user\" WITH ADMIN OPTION",
"DROP ROLE jonathan",
"REVOKE ALL ON kinds FROM manuel",
"REVOKE admins FROM joe",
"REVOKE insert ON films FROM public",
"SELECT m.name AS mname, pname FROM manufacturers m LEFT JOIN LATERAL get_product_names(m.id) pname ON true",
"SELECT m.name AS mname, pname FROM manufacturers m LEFT JOIN LATERAL get_product_names(m.id) pname ON true; INSERT INTO manufacturers_daily (a, b) SELECT a, b FROM manufacturers",
"SELECT m.name AS mname, pname FROM manufacturers m LEFT JOIN LATERAL get_product_names(m.id) pname ON true; UPDATE users SET name = 'bobby; drop tables'; INSERT INTO manufacturers_daily (a, b) SELECT a, b FROM manufacturers",
"SELECT * FROM a CROSS JOIN (b CROSS JOIN c)",
"SELECT 1 FOR UPDATE",
"SELECT 1 FOR UPDATE NOWAIT",
"SELECT 1 FOR UPDATE SKIP LOCKED",
"COMMENT ON POLICY a ON b IS 'test'",
"COMMENT ON PROCEDURE a() IS 'test'",
"COMMENT ON ROUTINE a() IS 'test'",
"COMMENT ON TRANSFORM FOR int4 LANGUAGE sql IS 'test'",
"COMMENT ON OPERATOR CLASS a USING b IS 'test'",
"COMMENT ON OPERATOR FAMILY a USING b IS 'test'",
"COMMENT ON LARGE OBJECT 42 IS 'test'",
"COMMENT ON CAST (int4 AS int8) IS 'test'",
"SELECT ROW(1 + 2)",
"ALTER TABLE a ALTER COLUMN b SET DEFAULT 1",
"ALTER TABLE a ALTER COLUMN b DROP DEFAULT",
"SELECT (3 + 3) OPERATOR(pg_catalog.*) 2",
"SELECT 3 + (3 * 2)",
"SELECT LIMIT ALL",
"SELECT * FROM ROWS FROM (foo() AS (foo_res_a text COLLATE a, foo_res_b text))",
"CREATE DATABASE x OWNER abc CONNECTION LIMIT 5",
"CREATE DATABASE x ENCODING \"SQL_ASCII\"",
"CREATE DATABASE x LC_COLLATE \"en_US.UTF-8\"",
"CREATE DATABASE x LOCATION DEFAULT",
"CREATE DATABASE x TABLESPACE abc",
"CREATE DATABASE x TEMPLATE TRUE",
"ALTER DATABASE x CONNECTION LIMIT 5",
"ALTER DATABASE x ALLOW_CONNECTIONS FALSE",
"ALTER DATABASE x IS_TEMPLATE TRUE",
"ALTER DATABASE x TABLESPACE abc",
"ALTER DATABASE x SET work_mem TO \"10MB\"",
"ALTER EXTENSION x UPDATE",
"ALTER EXTENSION x UPDATE TO \"1.2\"",
"ALTER EXTENSION x ADD ACCESS METHOD a",
"ALTER EXTENSION x DROP ACCESS METHOD a",
"ALTER EXTENSION x ADD AGGREGATE a(b)",
"ALTER EXTENSION x ADD CAST (a AS b)",
"ALTER EXTENSION x ADD COLLATION a",
"ALTER EXTENSION x ADD CONVERSION a",
"ALTER EXTENSION x ADD DOMAIN a",
"ALTER EXTENSION x ADD FUNCTION a(b)",
"ALTER EXTENSION x ADD LANGUAGE a",
"ALTER EXTENSION x ADD OPERATOR ~~(a, b)",
"ALTER EXTENSION x ADD OPERATOR CLASS a USING b",
"ALTER EXTENSION x ADD OPERATOR FAMILY a USING b",
"ALTER EXTENSION x ADD PROCEDURE a(b)",
"ALTER EXTENSION x ADD ROUTINE a(b)",
"ALTER EXTENSION x ADD SCHEMA a",
"ALTER EXTENSION x ADD EVENT TRIGGER a",
"ALTER EXTENSION x ADD TABLE a",
"ALTER EXTENSION x ADD TEXT SEARCH PARSER a",
"ALTER EXTENSION x ADD TEXT SEARCH DICTIONARY a",
"ALTER EXTENSION x ADD TEXT SEARCH TEMPLATE a",
"ALTER EXTENSION x ADD TEXT SEARCH CONFIGURATION a",
"ALTER EXTENSION x ADD SEQUENCE a",
"ALTER EXTENSION x ADD VIEW a",
"ALTER EXTENSION x ADD MATERIALIZED VIEW a",
"ALTER EXTENSION x ADD FOREIGN TABLE a",
"ALTER EXTENSION x ADD FOREIGN DATA WRAPPER a",
"ALTER EXTENSION x ADD SERVER a",
"ALTER EXTENSION x ADD TRANSFORM FOR a LANGUAGE b",
"ALTER EXTENSION x ADD TYPE a",
"ALTER TABLESPACE x SET (seq_page_cost=3)",
"ALTER TABLESPACE x RESET (random_page_cost)",
"CREATE TABLESPACE x LOCATION 'a'",
"CREATE TABLESPACE x OWNER a LOCATION 'b' WITH (random_page_cost=42, seq_page_cost=3)",
"ALTER FUNCTION x(y) DEPENDS ON EXTENSION a",
"ALTER FUNCTION x(y) NO DEPENDS ON EXTENSION a",
"ALTER PROCEDURE x(y) DEPENDS ON EXTENSION a",
"ALTER ROUTINE x(y) DEPENDS ON EXTENSION a",
"ALTER TRIGGER x ON y DEPENDS ON EXTENSION a",
"ALTER MATERIALIZED VIEW x DEPENDS ON EXTENSION a",
"ALTER INDEX x DEPENDS ON EXTENSION a",
"LOAD 'test file'",
"ALTER SYSTEM SET fsync TO OFF",
"ALTER SYSTEM RESET fsync",
"CREATE EXTENSION x",
"CREATE EXTENSION IF NOT EXISTS x CASCADE VERSION \"1.2\" SCHEMA a",
"CREATE TABLE like_constraint_rename_cache (LIKE constraint_rename_cache INCLUDING ALL)",
"COPY manual_export TO STDOUT CSV HEADER",
"SELECT 1 FROM a.b.c",
"CREATE PUBLICATION foo FOR TABLES IN SCHEMA bar",
"ALTER TABLE ALL IN TABLESPACE foo OWNED BY bar, quux SET TABLESPACE fred NOWAIT",
"MERGE INTO measurement m USING new_measurement nm ON m.city_id = nm.city_id AND m.logdate = nm.logdate WHEN MATCHED AND nm.peaktemp IS NULL THEN DELETE WHEN MATCHED THEN UPDATE SET peaktemp = GREATEST(m.peaktemp, nm.peaktemp), unitsales = m.unitsales + COALESCE(nm.unitsales, 0) WHEN NOT MATCHED THEN INSERT (city_id, logdate, peaktemp, unitsales) VALUES (city_id, logdate, peaktemp, unitsales)",
"COPY vistest FROM STDIN FREEZE CSV",
"CREATE INDEX \"foo.index\" ON foo USING btree (bar)",
"CREATE TABLE distributors (did int, name varchar(40), UNIQUE (name) WITH (fillfactor=70)) WITH (fillfactor=70)",
"SHOW ALL",
"ALTER TABLE ONLY public.\"Test 123\" ADD CONSTRAINT \"Test 123_pkey\" PRIMARY KEY (c1)",
"CREATE PROCEDURE insert_data(a int, b int) LANGUAGE sql BEGIN ATOMIC INSERT INTO tbl VALUES (a); INSERT INTO tbl VALUES (b); END",
"CREATE PROCEDURE do_nothing() LANGUAGE sql BEGIN ATOMIC END",
"CREATE PROCEDURE returns_one() LANGUAGE sql BEGIN ATOMIC RETURN 1; END",
"CREATE PROCEDURE updates_and_returns_one() LANGUAGE sql BEGIN ATOMIC UPDATE tbl SET a = 1; RETURN 1; END",
"SELECT 1 FROM tbl LIMIT COALESCE($1, $2)",
"SELECT (false AND true) IS FALSE",
"SELECT a = (true IS FALSE)",
"ALTER TABLE a ENABLE TRIGGER b",
"ALTER TABLE a ENABLE TRIGGER ALL",
"ALTER TABLE a ENABLE TRIGGER USER",
"ALTER TABLE a DISABLE TRIGGER b",
"ALTER TABLE a DISABLE TRIGGER ALL",
"ALTER TABLE a DISABLE TRIGGER USER",
"CREATE INDEX myindex ON public.mytable USING btree (col1, (col2::varchar) varchar_pattern_ops)",
"SELECT * FROM CAST(1 AS text)",
"DECLARE \"Foo1\" SCROLL CURSOR FOR SELECT * FROM tenk1 ORDER BY unique2",
"FETCH BACKWARD 23 \"Foo1\"",
"CREATE TABLE my_table (created_at timestamptz NOT NULL DEFAULT (now() AT TIME ZONE 'UTC'))",
"CREATE TABLE my_table (created_at timestamptz NOT NULL DEFAULT (now() AT LOCAL))",
"CREATE TABLE my_table (created_at timestamptz NOT NULL DEFAULT '1 hour'::interval + (current_timestamp AT TIME ZONE 'UTC'))",
"ALTER TABLE my_table ADD COLUMN created_at timestamptz NOT NULL DEFAULT '1 hour'::interval + (current_timestamp AT TIME ZONE 'UTC')",
"CREATE TABLE my_table (created_at int NOT NULL DEFAULT 1 + 2)"
};
size_t testsLength = __LINE__ - 4;
|