DROP TABLE t0; DROP TABLE t1; DROP TABLE t2; DROP TABLE t3; DROP TABLE t4; CREATE TABLE IF NOT EXISTS t0(c0 inet DEFAULT ('173.113.165.154') PRIMARY KEY NOT NULL, c1 boolean NOT NULL); CREATE UNLOGGED TABLE t1(LIKE t0 INCLUDING ALL); CREATE UNLOGGED TABLE IF NOT EXISTS t2(c0 DECIMAL UNIQUE PRIMARY KEY DEFAULT (0.061957296929007866) NOT NULL, c1 FLOAT DEFAULT ((0.15355176)::INT) NOT NULL); CREATE TABLE t3(LIKE t1 INCLUDING ALL); CREATE TABLE t4(LIKE t3 INCLUDING ALL); INSERT INTO t2(c0) VALUES(0.4054559764908453); INSERT INTO t2(c0) OVERRIDING USER VALUE VALUES(0.7883919384700094); DELETE FROM t1 WHERE t1.c1; VACUUM FREEZE ANALYZE t1(c0); INSERT INTO t4(c0, c1) VALUES('76.99.129.238', TRUE); INSERT INTO t4(c0, c1) VALUES('166.255.229.46', FALSE) ON CONFLICT (c0) DO NOTHING; INSERT INTO t2(c0, c1) VALUES(0.8157728915278553, 8.6568269E8), (0.990418606546871, -4.74261568E8), (0.5933161229953177, masklen('228.68.250.144')); INSERT INTO t4(c1, c0) VALUES(TRUE, '184.250.141.254'); INSERT INTO t2(c1, c0) VALUES(0.9171607, 0.7751684375758842); UPDATE t3 SET c1=FALSE WHERE (((((' F')||('/錘')) COLLATE "en_US.utf8") COLLATE "C") SIMILAR TO ((('H&' COLLATE "C.utf8") COLLATE "C") COLLATE "C")); INSERT INTO t2(c0) VALUES(0.8945993671407249), (0.6826036939465171), (0.49473760805688916), (0.24511987501892807), (0.6269860694730437) ON CONFLICT DO NOTHING; INSERT INTO t1(c1, c0) VALUES(TRUE, '193.53.0.246'), (TRUE, '144.16.238.143'), (TRUE, '26.208.247.30'), (FALSE, '149.207.248.239'), (FALSE, '14.162.54.129'); RESET ALL; INSERT INTO t2(c1, c0) VALUES(0.17691791, 0.22443924837220997); INSERT INTO t1(c0, c1) VALUES('210.89.91.130', FALSE); REINDEX DATABASE CONCURRENTLY database3; INSERT INTO t0(c0, c1) VALUES('75.199.51.146', TRUE); UPDATE t0 SET c1=TRUE WHERE t0.c1; INSERT INTO t4(c0, c1) VALUES('123.129.171.56', (num_nulls(0.05598414)) BETWEEN (1.999284054E9) AND (0.13885901227494757)); INSERT INTO t2(c0, c1) VALUES(0.5013607788410868, 0.5845536); INSERT INTO t4(c1, c0) VALUES(TRUE, '54.199.75.5'); INSERT INTO t3(c1, c0) VALUES(TRUE, '165.145.31.173'); CREATE SEQUENCE IF NOT EXISTS seq AS smallint INCREMENT BY -1356696934 NO CYCLE OWNED BY NONE; INSERT INTO t1(c1, c0) VALUES(FALSE, '242.238.204.100'); INSERT INTO t4(c1, c0) VALUES(FALSE, '45.54.170.84'), (TRUE, '76.93.114.108'), (TRUE, broadcast('86.241.168.106')); INSERT INTO t3(c0, c1) OVERRIDING SYSTEM VALUE VALUES(DEFAULT, (((((('-1001302001' COLLATE "pg_c_utf8"))||(lower('[-621826998,-497082610)'::int4range))))||((0.90394676)::MONEY)) SIMILAR TO CAST(num_nulls(CAST(0.9037121 AS MONEY)) AS VARCHAR))); INSERT INTO t4(c1) VALUES(TRUE); INSERT INTO t1(c1, c0) VALUES(FALSE, '140.255.52.84') ON CONFLICT DO NOTHING; INSERT INTO t2(c0, c1) VALUES(0.3422029995724941, 0.457949); COMMENT ON COLUMN t1.c0 IS NULL; INSERT INTO t2(c0) VALUES(0.48909843844459167), (0.5910676403975567), (0.06728042710802618), (0.7911210860091649), (0.298459278428008); INSERT INTO t0(c1) VALUES(TRUE); INSERT INTO t2(c0, c1) VALUES(0.6880656873908427, ascii((('ghiF>0' COLLATE "en_US.utf8") COLLATE "en_US.utf8"))); INSERT INTO t1(c1, c0) VALUES(FALSE, set_masklen('13.158.239.49', num_nulls(0.22028371397966162))), (abbrev('86.201.197.25')!~(CAST(CAST(0.5925129 AS MONEY) AS VARCHAR(38)) COLLATE "en_US.utf8"), '208.91.54.110'), (TRUE, '254.239.75.153'); INSERT INTO t3(c1, c0) VALUES(FALSE, '120.173.123.15'); INSERT INTO t2(c0) VALUES(0.26292503206953); DELETE FROM ONLY t2; INSERT INTO t3(c1, c0) VALUES(NOT (NOT (('(-627491712,-189021542)'::int4range) IN ('[539614978,1459855817]'::int4range))), hostmask('3.0.20.107')) ON CONFLICT DO NOTHING; INSERT INTO t1(c1) OVERRIDING SYSTEM VALUE VALUES((inet_client_port())::BOOLEAN); INSERT INTO t2(c0) VALUES(0.7867772320599189); INSERT INTO t0(c1, c0) VALUES(FALSE, '8.139.21.135'); TRUNCATE TABLE t1, t2, t4 CONTINUE IDENTITY; UPDATE t4 SET c1=TRUE, c0='108.198.173.173' WHERE t4.c1; INSERT INTO t2(c0) VALUES(0.9278590113708836); INSERT INTO t2(c0, c1) VALUES(0.2982120394066041, 0.10726042); INSERT INTO t2(c0) OVERRIDING SYSTEM VALUE VALUES(0.08286729543137561); INSERT INTO t2(c0) VALUES(0.4491810142169612); INSERT INTO t4(c0, c1) VALUES('80.229.167.120', TRUE); UPDATE t4 SET c0='244.228.75.231' WHERE t4.c1; INSERT INTO t4(c1) VALUES(FALSE), (TRUE), (FALSE) ON CONFLICT DO NOTHING; INSERT INTO t2(c0) VALUES(0.3820747088551154), (0.8557192209737884), (0.7384623791472148); DISCARD TEMP; INSERT INTO t2(c0, c1) VALUES(0.32933065106707404, 0.28561556); UPDATE t3 SET c1=(t3.c1), c0='238.75.144.34' WHERE t3.c1; INSERT INTO t2(c1, c0) VALUES(0.82730126, 0.14420569570952346); INSERT INTO t3(c1, c0) VALUES(FALSE, '105.23.164.253'); DROP INDEX IF EXISTS i2; INSERT INTO t3(c0, c1) VALUES('175.255.197.43', TRUE), ('119.11.244.243', TRUE), ('91.82.177.28', TRUE); INSERT INTO t2(c1, c0) VALUES(0.10913153, 0.9185504721885223), (0.41127384, 0.22608671637626854), (CAST((((strpos('~Yh~33', ''))^(strpos('lQ3', 'r_'))))::INT AS INT), 0.162278864857626); INSERT INTO t3(c1, c0) VALUES((lower((('-0.0')||(0.008610953235927532))) SIMILAR TO (upper('0.3211636040858402') COLLATE "pg_c_utf8")), '203.121.229.116'); INSERT INTO t0(c1, c0) VALUES(FALSE, '68.100.149.234'); SET enable_parallel_hash=DEFAULT; INSERT INTO t1(c0, c1) VALUES('31.137.56.124', ((CAST(0.6557072849024638 AS VARCHAR(968)))LIKE(CAST(0.0745549466896629 AS VARCHAR)))), ('110.159.33.128', TRUE), ('6.167.229.255', FALSE); INSERT INTO t0(c1, c0) VALUES(TRUE, '52.249.93.91'); INSERT INTO t2(c0, c1) VALUES(0.504279603416962, 0.686652); INSERT INTO t3(c0, c1) VALUES('54.132.173.108', NOT ((+ (((-905143984)-(556535050))))::BOOLEAN)); INSERT INTO t2(c0, c1) VALUES(0.6415080857288488, '-Infinity'), (0.6361525889534045, 0.97562456), (0.8890187319900674, 0.110326335); INSERT INTO t1(c0, c1) VALUES('182.244.18.201', TRUE); CLUSTER ; INSERT INTO t1(c0, c1) VALUES('5.13.18.107', TRUE); INSERT INTO t4(c1, c0) VALUES(FALSE, '161.119.216.77'); INSERT INTO t0(c0, c1) VALUES('112.133.123.177', TRUE); INSERT INTO t1(c1, c0) OVERRIDING SYSTEM VALUE VALUES(FALSE, '38.209.226.240'); INSERT INTO t0(c1, c0) VALUES(FALSE, '185.223.105.157'); UPDATE t2 SET c1=(t2.c1) WHERE (inet_same_family('248.28.179.252', '244.38.236.161')) IS UNKNOWN; INSERT INTO t2(c1, c0) VALUES(length('Q8'), 0.7658644055230165); INSERT INTO t2(c1) VALUES(0.6053229); INSERT INTO t1(c1) VALUES((((((('C')||(-975664935)) COLLATE "en_US.utf8"))||(0.29876256))) IS NULL); INSERT INTO t4(c1, c0) VALUES(TRUE, '37.247.156.42'); INSERT INTO t0(c1, c0) VALUES(TRUE, '120.79.247.161'), ((0.52594155) NOT IN (0.1847966757716495, 0.05442441928477215), '193.236.64.207'), (TRUE, '255.151.133.179') ON CONFLICT DO NOTHING; INSERT INTO t2(c0) VALUES(0.986196411487527) ON CONFLICT (c0) DO NOTHING; INSERT INTO t0(c1, c0) VALUES(TRUE, CAST('184.173.20.113' AS INET)); INSERT INTO t3(c0, c1) OVERRIDING USER VALUE VALUES('76.255.144.13', ((('195.112.129.69')::VARCHAR COLLATE "C") COLLATE "en_US.utf8")~rtrim(('jC&Y*섵C' COLLATE "en_US.utf8"))); INSERT INTO t2(c0, c1) VALUES(0.8654888043377064, 0.32804623); INSERT INTO t1(c1) VALUES((CAST(0.8856268 AS MONEY)) IS NOT NULL) ON CONFLICT DO NOTHING; INSERT INTO t2(c0) VALUES(0.36773811537959467); INSERT INTO t2(c0) OVERRIDING SYSTEM VALUE VALUES(0.7412974537489889); INSERT INTO t1(c0, c1) VALUES('208.119.164.63', (0.5954548658516244) NOT IN (0.8197385110368564)); SET LOCAL enable_tidscan=DEFAULT; INSERT INTO t2(c0) VALUES(0.761093823116178), (0.9072394635781578), (0.19302356562855105); UPDATE t4 SET c0=(t4.c0) WHERE t4.c1; INSERT INTO t2(c0, c1) VALUES(0.24549547761513513, ((pg_trigger_depth())*(+ (((upper('[-1290400348,-705118157]'::int4range))^(num_nonnulls((4.23522368E8)::MONEY))))))); INSERT INTO t0(c1, c0) VALUES(TRUE, '75.154.46.57'), ((((lower('') COLLATE "C.utf8") COLLATE "C.utf8") SIMILAR TO lower(CAST(B'1111111111111111111111111111111110011011001110001101110001011101' AS VARCHAR))), '123.31.248.224'), (TRUE, '5.172.165.176'), (TRUE, '80.103.98.15'), (FALSE, '37.93.107.30'); INSERT INTO t3(c1, c0) VALUES(TRUE, '177.18.135.34'); INSERT INTO t2(c0, c1) VALUES(0.048881918633187804, 0.41903082) ON CONFLICT DO NOTHING; INSERT INTO t1(c0, c1) VALUES('44.143.183.52', TRUE) ON CONFLICT DO NOTHING; SET CONSTRAINTS ALL DEFERRED; INSERT INTO t3(c0, c1) OVERRIDING SYSTEM VALUE VALUES('102.228.134.195', FALSE); INSERT INTO t2(c0, c1) VALUES(0.8224632349406945, 0.94582546) ON CONFLICT DO NOTHING; RESET ROLE; INSERT INTO t3(c1, c0) VALUES(((0.62426466)::MONEY) IN (CAST(0.7324301 AS MONEY)), '216.228.207.54') ON CONFLICT DO NOTHING; INSERT INTO t2(c0) VALUES(0.8639438548433902), (0.9281854083495114), (0.43493677758583715); INSERT INTO t3(c1, c0) VALUES(((0.82914853)::MONEY) IS NOT NULL, '144.146.0.91'); RESET ALL; DROP INDEX IF EXISTS i2 CASCADE; DROP INDEX IF EXISTS i4 RESTRICT; COMMIT; SET SESSION statement_timeout = 5000; -- -0 SELECT t2.c1 FROM ONLY t2 INNER JOIN t3 ON t3.c1; -- 0 (SELECT t2.c1 FROM ONLY t2 LEFT JOIN t3 ON t3.c1) INTERSECT ALL (SELECT t2.c1 FROM ONLY t2 RIGHT JOIN t3 ON t3.c1);