===========================================================
.___ __ __
_________________ __ __ __| _/|__|/ |_
/ ___\_` __ \__ \ | | \/ __ | | \\_ __\
/ /_/ > | \// __ \| | / /_/ | | || |
\___ /|__| (____ /____/\____ | |__||__|
/_____/ \/ \/
grep rough audit - static analysis tool
v2.8 written by @Wireghoul
=================================[justanotherhacker.com]===
pgformatter-4.4/t/02_regress.t-5-
pgformatter-4.4/t/02_regress.t:6:my $ret = `perl -I. -wc $pg_format 2>&1`;
pgformatter-4.4/t/02_regress.t-7-ok( $? == 0, "$pg_format compiles OK" ) or exit $?;
##############################################
pgformatter-4.4/t/02_regress.t-31- my $cmd = "$pg_format $opt -u 2 -X $f >/tmp/output.sql";
pgformatter-4.4/t/02_regress.t:32: `$cmd`;
pgformatter-4.4/t/02_regress.t-33- $f =~ s/test-files\//test-files\/expected\//;
pgformatter-4.4/t/02_regress.t-34- if (lc($ARGV[0]) eq 'update') {
pgformatter-4.4/t/02_regress.t:35: `cp -f /tmp/output.sql $f`;
pgformatter-4.4/t/02_regress.t-36- } else {
pgformatter-4.4/t/02_regress.t:37: my @diff = `diff -u /tmp/output.sql $f | grep "^[+-]" | grep -v "^[+-]\t\$" | grep -v "^[+-][+-][+-]"`;
pgformatter-4.4/t/02_regress.t-38- ok( $#diff < 0, "Test file $f");
##############################################
pgformatter-4.4/t/pg-test-files/expected/hash_func.sql-181- v AS value,
pgformatter-4.4/t/pg-test-files/expected/hash_func.sql:182: hashmacaddr(v)::bit(32) AS standard,
pgformatter-4.4/t/pg-test-files/expected/hash_func.sql-183- hashmacaddrextended(v, 0)::bit(32) AS extended0,
##############################################
pgformatter-4.4/t/pg-test-files/expected/hash_func.sql-192-WHERE
pgformatter-4.4/t/pg-test-files/expected/hash_func.sql:193: hashmacaddr(v)::bit(32) != hashmacaddrextended(v, 0)::bit(32)
pgformatter-4.4/t/pg-test-files/expected/hash_func.sql:194: OR hashmacaddr(v)::bit(32) = hashmacaddrextended(v, 1)::bit(32);
pgformatter-4.4/t/pg-test-files/expected/hash_func.sql-195-
##############################################
pgformatter-4.4/t/pg-test-files/expected/plpgsql.sql-3707- -- no rows
pgformatter-4.4/t/pg-test-files/expected/plpgsql.sql:3708: EXECUTE 'select * from foo where f1 = $1 or f1::text = $2'
pgformatter-4.4/t/pg-test-files/expected/plpgsql.sql-3709- USING 0,
##############################################
pgformatter-4.4/t/pg-test-files/expected/privileges.sql-1311- RETURNS text
pgformatter-4.4/t/pg-test-files/expected/privileges.sql:1312: AS 'select col1 from atest2 where col2 = $1;'
pgformatter-4.4/t/pg-test-files/expected/privileges.sql-1313- LANGUAGE sql
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-16- RETURNS SETOF rngfunc2
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:17: AS 'SELECT * FROM rngfunc2 WHERE rngfuncid = $1 ORDER BY f2;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-18- LANGUAGE SQL;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-396- RETURNS SETOF int
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:397: AS 'SELECT rngfuncid FROM rngfunc WHERE rngfuncid = $1;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-398- LANGUAGE SQL;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-440- RETURNS SETOF text
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:441: AS 'SELECT rngfuncname FROM rngfunc WHERE rngfuncid = $1;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-442- LANGUAGE SQL;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-484- RETURNS rngfunc
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:485: AS 'SELECT * FROM rngfunc WHERE rngfuncid = $1;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-486- LANGUAGE SQL;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-528- RETURNS SETOF rngfunc
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:529: AS 'SELECT * FROM rngfunc WHERE rngfuncid = $1;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-530- LANGUAGE SQL;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-572- RETURNS RECORD
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:573: AS 'SELECT * FROM rngfunc WHERE rngfuncid = $1;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-574- LANGUAGE SQL;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-621- RETURNS SETOF record
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:622: AS 'SELECT * FROM rngfunc WHERE rngfuncid = $1;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-623- LANGUAGE SQL;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-670- RETURNS int
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:671: AS 'DECLARE rngfuncint int; BEGIN SELECT rngfuncid into rngfuncint FROM rngfunc WHERE rngfuncid = $1; RETURN rngfuncint; END;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-672- LANGUAGE plpgsql;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-714- RETURNS rngfunc
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql:715: AS 'DECLARE rngfunctup rngfunc%ROWTYPE; BEGIN SELECT * into rngfunctup FROM rngfunc WHERE rngfuncid = $1; RETURN rngfunctup; END;'
pgformatter-4.4/t/pg-test-files/expected/rangefuncs.sql-716- LANGUAGE plpgsql;
##############################################
pgformatter-4.4/t/pg-test-files/expected/rules.sql-1169- RETURNS int4
pgformatter-4.4/t/pg-test-files/expected/rules.sql:1170: AS 'select count(*)::int4 from rtest_view2 where a = $1'
pgformatter-4.4/t/pg-test-files/expected/rules.sql-1171- LANGUAGE sql;
##############################################
pgformatter-4.4/t/pg-test-files/sql/hash_func.sql-89-
pgformatter-4.4/t/pg-test-files/sql/hash_func.sql:90:SELECT v as value, hashmacaddr(v)::bit(32) as standard,
pgformatter-4.4/t/pg-test-files/sql/hash_func.sql-91- hashmacaddrextended(v, 0)::bit(32) as extended0,
##############################################
pgformatter-4.4/t/pg-test-files/sql/hash_func.sql-95- ('ea:29:b1:5e:1f:a5')) x(v)
pgformatter-4.4/t/pg-test-files/sql/hash_func.sql:96:WHERE hashmacaddr(v)::bit(32) != hashmacaddrextended(v, 0)::bit(32)
pgformatter-4.4/t/pg-test-files/sql/hash_func.sql:97: OR hashmacaddr(v)::bit(32) = hashmacaddrextended(v, 1)::bit(32);
pgformatter-4.4/t/pg-test-files/sql/hash_func.sql-98-
##############################################
pgformatter-4.4/t/pg-test-files/sql/hs_standby_allowed.sql-97-PREPARE hsp AS select count(*) from hs1;
pgformatter-4.4/t/pg-test-files/sql/hs_standby_allowed.sql:98:PREPARE hsp_noexec (integer) AS insert into hs1 values ($1);
pgformatter-4.4/t/pg-test-files/sql/hs_standby_allowed.sql-99-
##############################################
pgformatter-4.4/t/pg-test-files/sql/join.sql-667- on (a.unique2 = b.unique1 and exists
pgformatter-4.4/t/pg-test-files/sql/join.sql:668: (select 1 from tenk1 c where c.thousand = b.unique2 and $1));
pgformatter-4.4/t/pg-test-files/sql/join.sql-669-execute foo(true);
##############################################
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql-743-SELECT count(*) FROM testjsonb WHERE j @@ '$.wait == null';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql:744:SELECT count(*) FROM testjsonb WHERE j @@ '"CC" == $.wait';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql:745:SELECT count(*) FROM testjsonb WHERE j @@ '$.wait == "CC" && true == $.public';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql-746-SELECT count(*) FROM testjsonb WHERE j @@ '$.age == 25';
##############################################
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql-783-SELECT count(*) FROM testjsonb WHERE j @@ 'exists($.wait ? (@ == null))';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql:784:SELECT count(*) FROM testjsonb WHERE j @@ '"CC" == $.wait';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql:785:SELECT count(*) FROM testjsonb WHERE j @@ '$.wait == "CC" && true == $.public';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql-786-SELECT count(*) FROM testjsonb WHERE j @@ '$.age == 25';
##############################################
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql-863-SELECT count(*) FROM testjsonb WHERE j @@ 'exists($.wait ? (@ == null))';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql:864:SELECT count(*) FROM testjsonb WHERE j @@ '"CC" == $.wait';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql:865:SELECT count(*) FROM testjsonb WHERE j @@ '$.wait == "CC" && true == $.public';
pgformatter-4.4/t/pg-test-files/sql/jsonb.sql-866-SELECT count(*) FROM testjsonb WHERE j @@ '$.age == 25';
##############################################
pgformatter-4.4/t/pg-test-files/sql/opr_sanity.sql-40- if $2 = 'pg_catalog.anyrange'::pg_catalog.regtype then
pgformatter-4.4/t/pg-test-files/sql/opr_sanity.sql:41: if (select typtype from pg_catalog.pg_type where oid = $1) = 'r'
pgformatter-4.4/t/pg-test-files/sql/opr_sanity.sql-42- then return true; end if;
##############################################
pgformatter-4.4/t/pg-test-files/sql/opr_sanity.sql-65- if $2 = 'pg_catalog.anyrange'::pg_catalog.regtype then
pgformatter-4.4/t/pg-test-files/sql/opr_sanity.sql:66: if (select typtype from pg_catalog.pg_type where oid = $1) = 'r'
pgformatter-4.4/t/pg-test-files/sql/opr_sanity.sql-67- then return true; end if;
##############################################
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-334-prepare ab_q1 (int, int, int) as
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql:335:select * from ab where a between $1 and $2 and b <= $3;
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-336-
##############################################
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-565- select tableoid::regclass,a,b from ab
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql:566:) ab where a = $1 and b = (select -10);
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-567-
##############################################
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-687-prepare part_abc_q1 (int, int, int) as
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql:688:select * from part_abc where a = $1 and b = $2 and c = $3;
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-689-
##############################################
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-785-analyze ma_test;
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql:786:prepare mt_q1 (int) as select a from ma_test where a >= $1 and a % 10 = 5 order by b;
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-787-
##############################################
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-972- ) s(a, b, c)
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql:973:where s.a = $1 and s.b = $2 and s.c = (select 1);
pgformatter-4.4/t/pg-test-files/sql/partition_prune.sql-974-
##############################################
pgformatter-4.4/t/pg-test-files/sql/plancache.sql-12--- and one with parameters
pgformatter-4.4/t/pg-test-files/sql/plancache.sql:13:PREPARE prepstmt2(bigint) AS SELECT * FROM pcachetest WHERE q1 = $1;
pgformatter-4.4/t/pg-test-files/sql/plancache.sql-14-
##############################################
pgformatter-4.4/t/pg-test-files/sql/plancache.sql-187-
pgformatter-4.4/t/pg-test-files/sql/plancache.sql:188:prepare test_mode_pp (int) as select count(*) from test_mode where a = $1;
pgformatter-4.4/t/pg-test-files/sql/plancache.sql-189-
##############################################
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-1016-begin
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql:1017: select into rec * from PSlot where slotname = $1;
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-1018- if not found then
##############################################
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-1060-begin
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql:1061: select into psrec * from PSlot where slotname = $1;
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-1062- if not found then
##############################################
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-1096-begin
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql:1097: select into rec * from WSlot where slotname = $1;
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-1098- if not found then
##############################################
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-2304- -- no rows
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql:2305: execute 'select * from foo where f1 = $1 or f1::text = $2' using 0, 'foo' into strict x;
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-2306- raise notice 'x.f1 = %, x.f2 = %', x.f1, x.f2;
##############################################
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-3473-create function error1(text) returns text language sql as
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql:3474:$$ SELECT relname::text FROM pg_class c WHERE c.oid = $1::regclass $$;
pgformatter-4.4/t/pg-test-files/sql/plpgsql.sql-3475-
##############################################
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-34- SELECT datname, datistemplate, datallowconn
pgformatter-4.4/t/pg-test-files/sql/prepare.sql:35: FROM pg_database WHERE datname = $1;
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-36-
##############################################
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-39-PREPARE q3(text, int, float, boolean, smallint) AS
pgformatter-4.4/t/pg-test-files/sql/prepare.sql:40: SELECT * FROM tenk1 WHERE string4 = $1 AND (four = $2 OR
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-41- ten = $3::bigint OR true = $4 OR odd = $5::int)
##############################################
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-59-PREPARE q5(int, text) AS
pgformatter-4.4/t/pg-test-files/sql/prepare.sql:60: SELECT * FROM tenk1 WHERE unique1 = $1 OR stringu1 = $2
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-61- ORDER BY unique1;
##############################################
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-69-PREPARE q6 AS
pgformatter-4.4/t/pg-test-files/sql/prepare.sql:70: SELECT * FROM tenk1 WHERE unique1 = $1 AND stringu1 = $2;
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-71-PREPARE q7(unknown) AS
pgformatter-4.4/t/pg-test-files/sql/prepare.sql:72: SELECT * FROM road WHERE thepath = $1;
pgformatter-4.4/t/pg-test-files/sql/prepare.sql-73-
##############################################
pgformatter-4.4/t/pg-test-files/sql/privileges.sql-448-CREATE FUNCTION priv_testfunc4(boolean) RETURNS text
pgformatter-4.4/t/pg-test-files/sql/privileges.sql:449: AS 'select col1 from atest2 where col2 = $1;'
pgformatter-4.4/t/pg-test-files/sql/privileges.sql-450- LANGUAGE sql SECURITY DEFINER;
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-5-
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:6:CREATE FUNCTION rngfunct(int) returns setof rngfunc2 as 'SELECT * FROM rngfunc2 WHERE rngfuncid = $1 ORDER BY f2;' LANGUAGE SQL;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-7-
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-101--- sql, proretset = t, prorettype = b
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:102:CREATE FUNCTION getrngfunc2(int) RETURNS setof int AS 'SELECT rngfuncid FROM rngfunc WHERE rngfuncid = $1;' LANGUAGE SQL;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-103-SELECT * FROM getrngfunc2(1) AS t1;
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-112--- sql, proretset = t, prorettype = b
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:113:CREATE FUNCTION getrngfunc3(int) RETURNS setof text AS 'SELECT rngfuncname FROM rngfunc WHERE rngfuncid = $1;' LANGUAGE SQL;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-114-SELECT * FROM getrngfunc3(1) AS t1;
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-123--- sql, proretset = f, prorettype = c
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:124:CREATE FUNCTION getrngfunc4(int) RETURNS rngfunc AS 'SELECT * FROM rngfunc WHERE rngfuncid = $1;' LANGUAGE SQL;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-125-SELECT * FROM getrngfunc4(1) AS t1;
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-134--- sql, proretset = t, prorettype = c
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:135:CREATE FUNCTION getrngfunc5(int) RETURNS setof rngfunc AS 'SELECT * FROM rngfunc WHERE rngfuncid = $1;' LANGUAGE SQL;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-136-SELECT * FROM getrngfunc5(1) AS t1;
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-145--- sql, proretset = f, prorettype = record
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:146:CREATE FUNCTION getrngfunc6(int) RETURNS RECORD AS 'SELECT * FROM rngfunc WHERE rngfuncid = $1;' LANGUAGE SQL;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-147-SELECT * FROM getrngfunc6(1) AS t1(rngfuncid int, rngfuncsubid int, rngfuncname text);
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-159--- sql, proretset = t, prorettype = record
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:160:CREATE FUNCTION getrngfunc7(int) RETURNS setof record AS 'SELECT * FROM rngfunc WHERE rngfuncid = $1;' LANGUAGE SQL;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-161-SELECT * FROM getrngfunc7(1) AS t1(rngfuncid int, rngfuncsubid int, rngfuncname text);
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-173--- plpgsql, proretset = f, prorettype = b
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:174:CREATE FUNCTION getrngfunc8(int) RETURNS int AS 'DECLARE rngfuncint int; BEGIN SELECT rngfuncid into rngfuncint FROM rngfunc WHERE rngfuncid = $1; RETURN rngfuncint; END;' LANGUAGE plpgsql;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-175-SELECT * FROM getrngfunc8(1) AS t1;
##############################################
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-184--- plpgsql, proretset = f, prorettype = c
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql:185:CREATE FUNCTION getrngfunc9(int) RETURNS rngfunc AS 'DECLARE rngfunctup rngfunc%ROWTYPE; BEGIN SELECT * into rngfunctup FROM rngfunc WHERE rngfuncid = $1; RETURN rngfunctup; END;' LANGUAGE plpgsql;
pgformatter-4.4/t/pg-test-files/sql/rangefuncs.sql-186-SELECT * FROM getrngfunc9(1) AS t1;
##############################################
pgformatter-4.4/t/pg-test-files/sql/rowsecurity.sql-559--- prepared statement with regress_rls_alice privilege
pgformatter-4.4/t/pg-test-files/sql/rowsecurity.sql:560:PREPARE p1(int) AS SELECT * FROM t1 WHERE a <= $1;
pgformatter-4.4/t/pg-test-files/sql/rowsecurity.sql-561-EXECUTE p1(2);
##############################################
pgformatter-4.4/t/pg-test-files/sql/rowsecurity.sql-573-
pgformatter-4.4/t/pg-test-files/sql/rowsecurity.sql:574:PREPARE p2(int) AS SELECT * FROM t1 WHERE a = $1;
pgformatter-4.4/t/pg-test-files/sql/rowsecurity.sql-575-EXECUTE p2(2);
##############################################
pgformatter-4.4/t/pg-test-files/sql/rules.sql-432-create function rtest_viewfunc1(int4) returns int4 as
pgformatter-4.4/t/pg-test-files/sql/rules.sql:433: 'select count(*)::int4 from rtest_view2 where a = $1'
pgformatter-4.4/t/pg-test-files/sql/rules.sql-434- language sql;
##############################################
pgformatter-4.4/t/pg-test-files/sql/select_parallel.sql-423-
pgformatter-4.4/t/pg-test-files/sql/select_parallel.sql:424:PREPARE pstmt(text, int[]) AS SELECT * FROM fooarr WHERE f1 = $1 AND f2 = $2;
pgformatter-4.4/t/pg-test-files/sql/select_parallel.sql-425-EXPLAIN (COSTS OFF) EXECUTE pstmt('1', make_some_array(1,2));
##############################################
pgformatter-4.4/t/regress_test.pl-30- my $cmd = "./pg_format $opt -u 2 $f >/tmp/output.sql";
pgformatter-4.4/t/regress_test.pl:31: `$cmd`;
pgformatter-4.4/t/regress_test.pl-32- $f =~ s/test-files\//test-files\/expected\//;
pgformatter-4.4/t/regress_test.pl-33- if (lc($ARGV[0]) eq 'update') {
pgformatter-4.4/t/regress_test.pl:34: `cp -f /tmp/output.sql $f`;
pgformatter-4.4/t/regress_test.pl-35- } else {
pgformatter-4.4/t/regress_test.pl:36: my @diff = `diff -u /tmp/output.sql $f | grep "^[+-]" | grep -v "^[+-]\t\$" | grep -v "^[+-][+-][+-]"`;
pgformatter-4.4/t/regress_test.pl-37- if ($#diff < 0) {
##############################################
pgformatter-4.4/t/regress_test.pl-57- my $cmd = "./pg_format $opt -u 2 $f >/tmp/output.sql";
pgformatter-4.4/t/regress_test.pl:58: `$cmd`;
pgformatter-4.4/t/regress_test.pl-59- $f =~ s/\/sql\//\/expected\//;
pgformatter-4.4/t/regress_test.pl-60- if (lc($ARGV[0]) eq 'update') {
pgformatter-4.4/t/regress_test.pl:61: `cp -f /tmp/output.sql $f`;
pgformatter-4.4/t/regress_test.pl-62- } else {
pgformatter-4.4/t/regress_test.pl:63: my @diff = `diff -u /tmp/output.sql $f | grep "^[+-]" | grep -v "^[+-]\$" | grep -v "^[+-]\t\$" | grep -v "^[+-][+-][+-]"`;
pgformatter-4.4/t/regress_test.pl-64- if ($#diff < 0) {
##############################################
pgformatter-4.4/t/test-files/ex17.sql-55- FROM pwds
pgformatter-4.4/t/test-files/ex17.sql:56: WHERE username = $1;
pgformatter-4.4/t/test-files/ex17.sql-57-
##############################################
pgformatter-4.4/t/test-files/ex19.sql-23- pg_index on (pg_class.oid = pg_index.indrelid and attnum = any (indkey))
pgformatter-4.4/t/test-files/ex19.sql:24: WHERE pg_class.oid = '$f$ || $1 || $f$ '::regclass and indisprimary $f$
pgformatter-4.4/t/test-files/ex19.sql-25- LOOP
##############################################
pgformatter-4.4/t/test-files/ex19.sql-63- FROM pg_attribute JOIN pg_class on (oid=attrelid)
pgformatter-4.4/t/test-files/ex19.sql:64: WHERE pg_class.oid = $1::regclass and attlen = -1
pgformatter-4.4/t/test-files/ex19.sql-65- LOOP
##############################################
pgformatter-4.4/t/test-files/ex27.sql:1:SELECT opgt.part_id, opgt.art_id, rGpe.slot_id, rGpe.grp_art_id FROM ( SELECT id, part_product_kind_id FROM part_product ldm WHERE nb_colis > 0 AND statut_part_product IN ('DISPATCH','CANCELED','SALE_PROD') AND ldm.art_frect_id IS NULL AND NOT EXISTS ( SELECT subparts.id FROM part_product subparts WHERE ldm.id = subparts.part_product_parent_id )) ldm JOIN LATERAL ( SELECT opgt.id, part.id as part_id, opgt.art_id FROM part_product part JOIN part_product_kind opgt ON opgt.id = part.part_product_kind_id WHERE part.id = ldm.id AND opgt.plateforme_distribution_id = ($1) AND opgt.day_export_shop_id IN ( SELECT id FROM day_export_shop jem WHERE day <= to_timestamp($2) AND day > current_date - interval '4 mons')) opgt ON true JOIN LATERAL (SELECT r.id AS slot_id, ga.id AS grp_art_id FROM part_product_kind lm JOIN art a ON a.id = lm.art_id JOIN grp_art ga ON ga.id = a.grp_art_id JOIN slot r ON r.id = ga.slot_id WHERE opgt.id = lm.id) rGpe ON true UNION SELECT opgt.part_id, opgt.art_id, rGpe.slot_id, rGpe.grp_art_id FROM ( SELECT id, art_frect_id, part_product_kind_id FROM part_product ldm WHERE nb_colis > 0 AND statut_part_product IN ('DISPATCH','CANCELED','SALE_PROD') AND art_frect_id IS NOT NULL AND NOT EXISTS ( SELECT subparts.id FROM part_product subparts WHERE ldm.id = subparts.part_product_parent_id )) ldm JOIN LATERAL ( SELECT opgt.id, part.id as part_id, opgt.art_id FROM part_product part JOIN part_product_kind opgt ON opgt.id = part.part_product_kind_id WHERE part.id = ldm.id AND opgt.plateforme_distribution_id = ($3) AND opgt.day_export_shop_id IN ( SELECT id FROM day_export_shop jem WHERE day <= to_timestamp($4) AND day > current_date - interval '4 mons')) opgt ON true JOIN LATERAL (SELECT r.id AS slot_id, ga.id AS grp_art_id FROM part_product lm JOIN art a ON a.id = lm.art_frect_id JOIN grp_art ga ON ga.id = a.grp_art_id JOIN slot r ON r.id = ga.slot_id WHERE opgt.id = lm.id) rGpe ON true;
pgformatter-4.4/t/test-files/ex27.sql-2-
##############################################
pgformatter-4.4/t/test-files/ex53.sql-170--- original snippet
pgformatter-4.4/t/test-files/ex53.sql:171:\set user `echo $PGRST_DB_USER`
pgformatter-4.4/t/test-files/ex53.sql:172:\set passwd `echo $PGRST_DB_PWD`
pgformatter-4.4/t/test-files/ex53.sql-173-CREATE ROLE :user WITH LOGIN noinherit PASSWORD :'passwd';
##############################################
pgformatter-4.4/t/test-files/expected/ex19.sql-24- pg_index on (pg_class.oid = pg_index.indrelid and attnum = any (indkey))
pgformatter-4.4/t/test-files/expected/ex19.sql:25: WHERE pg_class.oid = '$f$ || $1 || $f$ '::regclass and indisprimary $f$ LOOP
pgformatter-4.4/t/test-files/expected/ex19.sql-26- IF pkcols = '' THEN
##############################################
pgformatter-4.4/t/test-files/expected/ex53.sql-236--- original snippet
pgformatter-4.4/t/test-files/expected/ex53.sql:237:\set user `echo $PGRST_DB_USER`
pgformatter-4.4/t/test-files/expected/ex53.sql:238:\set passwd `echo $PGRST_DB_PWD`
pgformatter-4.4/t/test-files/expected/ex53.sql-239-CREATE ROLE :user WITH LOGIN noinherit PASSWORD :'passwd';