database0.log
application/octet-stream
Filename: database0.log
Type: application/octet-stream
Part: 0
--java.lang.AssertionError: SELECT t0.c0 FROM t0* JOIN ONLY t5 ON (((((t5.c0)*(t5.c0)))-(t5.c0))) IN (t0.c0);
-- at sqlancer.common.query.SQLQueryAdapter.checkException(SQLQueryAdapter.java:124)
-- at sqlancer.common.query.SQLQueryAdapter.executeAndGet(SQLQueryAdapter.java:154)
-- at sqlancer.ComparatorHelper.getResultSetFirstColumnAsString(ComparatorHelper.java:56)
-- at sqlancer.postgres.oracle.tlp.PostgresTLPWhereOracle.whereCheck(PostgresTLPWhereOracle.java:30)
-- at sqlancer.postgres.oracle.tlp.PostgresTLPWhereOracle.check(PostgresTLPWhereOracle.java:22)
-- at sqlancer.common.oracle.CompositeTestOracle.check(CompositeTestOracle.java:22)
-- at sqlancer.ProviderAdapter.generateAndTestDatabase(ProviderAdapter.java:61)
-- at sqlancer.Main$DBMSExecutor.run(Main.java:459)
-- at sqlancer.Main$2.run(Main.java:673)
-- at sqlancer.Main$2.runThread(Main.java:655)
-- at sqlancer.Main$2.run(Main.java:646)
-- at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
-- at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
-- at java.base/java.lang.Thread.run(Thread.java:829)
--Caused by: org.postgresql.util.PSQLException: ERROR: type with OID 2139062143 does not exist
-- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
-- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
-- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
-- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)
-- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)
-- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:333)
-- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:319)
-- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:295)
-- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:244)
-- at sqlancer.common.query.SQLQueryAdapter.executeAndGet(SQLQueryAdapter.java:144)
-- ... 12 more
---- Time: 2024/02/23 16:27:12
-- Database: database0
-- Database version: 17devel
-- seed value: 1708669015859
\c test;
DROP DATABASE IF EXISTS database0;
CREATE DATABASE database0 TEMPLATE template0;
\c database0;
CREATE TEMP TABLE t0(c0 money UNIQUE PRIMARY KEY CHECK ((CAST(0.40689787 AS MONEY)) BETWEEN SYMMETRIC (CAST(-1.87958515E9 AS MONEY)) AND (t0.c0)) NOT NULL, CHECK(NOT ((3.08388129E8) NOT IN (CAST(0.30835719208976164 AS INT))))) PARTITION BY HASH((CAST(0.06974718 AS MONEY))jsonb_path_ops);
CREATE TABLE t0(c0 DECIMAL , c1 boolean NULL) PARTITION BY HASH(('125.158.194.191'));
CREATE TEMP TABLE IF NOT EXISTS t0(c0 boolean , CHECK((((((((('[-747752566,460501876)'::int4range)+('[-315151146,1075685336]'::int4range)))-((('(-1476241735,535030099]'::int4range)*('(-1627073963,1983540981)'::int4range)))))-((((('[-301581924,827506194)'::int4range)-('[720268942,1685003029]'::int4range)))-((('(-1627174261,1649230783)'::int4range)*('(-795542365,9223372036854775807)'::int4range)))))))&<((((((('(-614554480,-423518517)'::int4range)-('(1259198448,1441762412]'::int4range)))+((('(-976704578,1389920967)'::int4range)-('[-1197450808,827506194]'::int4range)))))*((((('(-1994976915,-1789932939)'::int4range)*('[-1299359591,962139238)'::int4range)))+((('[-1580450390,-333389581)'::int4range)+('(-1234556970,962139238)'::int4range)))))))))) PARTITION BY HASH(('15.125.87.14'));
CREATE UNLOGGED TABLE t0(c0 int4range , UNIQUE(c0)) WITH (autovacuum_analyze_threshold=1028158055, autovacuum_vacuum_threshold=612930784, autovacuum_freeze_min_age=822614240, autovacuum_vacuum_cost_delay=72);
CREATE TABLE t1(c0 int4range PRIMARY KEY, c1 smallint , UNIQUE(c1), FOREIGN KEY (c1) REFERENCES t0(c0) ON UPDATE SET DEFAULT DEFERRABLE INITIALLY DEFERRED, CHECK(((NOT (((t1.c0)&&(((t1.c0)+(t1.c0))))))OR(((upper('g *p\r d0'))::BOOLEAN)::BOOLEAN)))) PARTITION BY HASH((CAST(t1.c0 AS VARCHAR(636)))range_ops, ('170.150.134.16'), ((((((((B'1111111111111111111111111111111110010000010101101111101100010111')>>(B'111111111111111111111111111111111111111111111111111111111111111')))>>(((B'1110111100111101110101101001100')|(B'1010101111000011111011001110010')))))>>(((((B'1111111111111111111111111111111110111100101110000011110010010100')>>(B'1111111111111111111111111111111111011010000101111110011010010011')))&(((B'1010101111000011111011001110010')||(B'1010101111000011111011001110010')))))))::INT)array_ops);
CREATE TABLE t1(LIKE t0);
CREATE TEMPORARY TABLE t2(c0 inet , c1 smallint ) ON COMMIT DELETE ROWS ;
CREATE TEMPORARY TABLE t3(LIKE t0);
CREATE TEMPORARY TABLE t4(c0 DECIMAL UNIQUE DEFAULT (0.9711940667944703) NOT NULL PRIMARY KEY, EXCLUDE (c0 DESC NULLS FIRST WITH >, c0 interval_ops WITH =)) USING heap ON COMMIT DROP ;
CREATE TEMP TABLE IF NOT EXISTS t4(LIKE t1);
CREATE TEMPORARY TABLE t5(c0 TEXT COLLATE "en_DK.utf8" , UNIQUE(c0) WITH (autovacuum_vacuum_threshold=981636728, fillfactor=14, autovacuum_freeze_max_age=1412919597, autovacuum_vacuum_scale_factor=0.9, autovacuum_freeze_table_age=1603561708, autovacuum_vacuum_cost_delay=29, autovacuum_enabled=1), EXCLUDE (c0 array_ops DESC NULLS FIRST WITH <=) WHERE ((((t5.c0)||('97.251.68.226')) SIMILAR TO lower(((t5.c0)||('[1259198448,1884761246]'::int4range))))), FOREIGN KEY (c0) REFERENCES t1(c0) MATCH SIMPLE) INHERITS(t2) PARTITION BY RANGE((((CAST(0.47422032619783905 AS INT))-(('225.104.200.27')::INT))));
CREATE UNLOGGED TABLE t5(LIKE t4);
UNLISTEN test;
INSERT INTO t4(c0) OVERRIDING SYSTEM VALUE VALUES('(120438848,333280565]'::int4range);
DELETE FROM ONLY t1 RETURNING CAST(0.550729 AS MONEY);
INSERT INTO t4(c0) VALUES('(343223966,588159435)'::int4range), ((((((((('[-1228402224,-885598684]'::int4range)-('(-593678008,2078608571]'::int4range)))+((('(-1311775940,-1006292944]'::int4range)+('(-1431654661,-447148096]'::int4range)))))+((((('(-296914727,1859196040]'::int4range)*('(-1627073963,-1050866176)'::int4range)))+((('[-1367281732,335349511)'::int4range)+('[-1311775940,-164434417)'::int4range)))))))-((((((('(-2103754354,-1962028280)'::int4range)-('(-1834259279,308388129)'::int4range)))*((('[-912907009,1343739201]'::int4range)*('[-987973625,-368092860)'::int4range)))))*(CAST(('' SIMILAR TO 'Iﳗ_皕>') AS int4range)))))), ('[-1871195156,-431575042]'::int4range), ('(-294615392,248039615]'::int4range), ('[-1,441214914]'::int4range);
INSERT INTO t2(c1, c0) VALUES(CAST(((((((B'1111111111111111111111111111111110100110001110101100010010010001')|(B'1101001101100010000001010011001')))<<(((B'1111111111111111111111111111111111111010000001011000101001001110')||(B'1111111111111111111111111111111111011100001000100100001000001000')))))&(((((B'1111111111111111111111111111111111110000111100000101110110000110')|(B'1011111001010101110100000000100')))>>(((B'1111111111111111111111111111111111111001001010011111010011001010')<<(B'1111111111111111111111111111111111011000001111011011101101111110')))))) AS INT), '220.63.70.124'), (((((0.2723502)::MONEY)::INT)/(CAST(('142774574' COLLATE "en_DK.utf8") AS INT))), '140.203.123.249'), (1132060722, '18.155.174.215');
INSERT INTO t0(c0) OVERRIDING USER VALUE VALUES((((((((('[-1780596960,274671402)'::int4range)*('(-2068888114,-510700105)'::int4range)))*((('(176869229,1731641277)'::int4range)-('[17162102,1203300141]'::int4range)))))-((((('[-1547470161,726840172)'::int4range)-('(1074818035,2124105680)'::int4range)))-((('(-1367281732,-792837710]'::int4range)+('(-751650150,-400891655)'::int4range)))))))*((((((('(-456832077,756733219)'::int4range)-('(-712456312,830445631]'::int4range)))*('[-2092352814,-554392274]'::int4range)))*((((('[-774342885,-295780473]'::int4range)*('[-984180943,1367991912)'::int4range)))*((('[-1031772675,1156725355)'::int4range)*('(-1540691590,577249662)'::int4range)))))))));
INSERT INTO t2(c1, c0) VALUES(2145323351, '126.48.103.241');
INSERT INTO t1(c0) VALUES('(219416428,1259404286)'::int4range);
DISCARD PLANS;
DROP INDEX IF EXISTS i0, i4;
RESET ROLE;
INSERT INTO t0(c0) VALUES('[-365996575,721671927]'::int4range), ('[830445631,1628043778]'::int4range), ('(-2063250906,864210597)'::int4range);
COMMENT ON COLUMN t5.c0 IS '';
INSERT INTO t2(c1, c0) VALUES(((upper((('(-1432471843,-141451756]'::int4range)+('(-1838951123,248039615]'::int4range))))^(strpos(split_part('\k', -389453490), (('GPX{D')||('-1994976915'))))), '221.242.150.190');
INSERT INTO t3(c0) VALUES(((((range_merge((('[-653129412,1023340772)'::int4range)*('(-2062308113,-1912699861)'::int4range)), (('[-2026010185,1568824192)'::int4range)-('(294215636,2042424751]'::int4range))))+((((('[1006539436,1858512759)'::int4range)+('[-2002514408,1371508206)'::int4range)))*((('[-747752566,1537821130)'::int4range)+('[-200327118,406130485)'::int4range)))))))*((((((('(-1311775940,1013737497)'::int4range)-('[-1232759507,1344212448)'::int4range)))*((('[-1562436726,-1365618943]'::int4range)-('(-2055750994,-61306731)'::int4range)))))*((((('[-1798081325,830445631]'::int4range)-('[-1288453191,-131330182)'::int4range)))-((('(238941813,1434742038]'::int4range)-('(-1790379711,-131330182]'::int4range)))))))));
INSERT INTO t1(c0) OVERRIDING USER VALUE VALUES((((((((('[308388129,343223966)'::int4range)*('(-1190102358,1043975397)'::int4range)))+((('(-1630957741,2056730253)'::int4range)-('[-1579362181,419878171)'::int4range)))))-((((('[-543373109,511934038)'::int4range)-('[-1530317544,-1210621084]'::int4range)))+((('(-2146501961,-1384901031)'::int4range)+('[830445631,9223372036854775807)'::int4range)))))))-((((((('[-1268545429,1706794637)'::int4range)-('[192147946,1261580419)'::int4range)))*(('219.78.182.25')::int4range)))*((((('[-1006773156,-497208059]'::int4range)+('[-1431654661,-1260145055]'::int4range)))-((('(-914497710,1695213082)'::int4range)-('[-1500349725,-716048239)'::int4range))))))))), ((((((((('[-2115554778,-774342885]'::int4range)*('[-131330182,248039615]'::int4range)))*('(679788643,1601387367)'::int4range)))-((((('(-1195929587,-1099955883]'::int4range)*('[-1243143951,-762357178]'::int4range)))+(range_merge('(-1092899455,122614597)'::int4range, '(-1581042901,722526809)'::int4range))))))+((((((('[-153904095,1218363712]'::int4range)*('(-1023313959,1259584089)'::int4range)))*((('[-1006773156,824176359)'::int4range)+('(-1311775940,-539726932)'::int4range)))))+((((('[622793623,1787507647]'::int4range)+('(-2026010185,699885578)'::int4range)))+((('(-1252359337,1830738701)'::int4range)-('(-153904095,1820565743]'::int4range))))))))), ('(284603926,1488393074)'::int4range);
INSERT INTO t5(c0) VALUES((((((((('[1,1075685336]'::int4range)*('(-1190102358,-1059407530]'::int4range)))*((('[-2102257356,-573227534]'::int4range)+('(-2141678377,263812954)'::int4range)))))-((((('(-100300210,2092266891]'::int4range)+('[-1627073963,-1530317544]'::int4range)))-('(-1876178169,-449411595]'::int4range)))))+(((range_merge((('(-1666603058,1955308745)'::int4range)*(NULL)), (('(-1063839873,-494862750]'::int4range)-('[-1432471843,1342303326]'::int4range))))+((((('(-1941332898,203478669]'::int4range)+('[412975799,1019491899]'::int4range)))-((('[-912907009,232501458)'::int4range)-('(-417728072,1259198448]'::int4range))))))))), ('(-891507882,1723539258]'::int4range), (((((((range_merge('(-1652890704,962139238]'::int4range, '(811162845,1178464974)'::int4range))+((('[-1790379711,343223966]'::int4range)-('[-1512163794,1331952280)'::int4range)))))+((((('[-2045816775,1287347469)'::int4range)*('(-468392493,1186843442)'::int4range)))-((('(-2098562161,1160430217)'::int4range)+('[537179917,599172620]'::int4range)))))))-((((((('[183307955,2124133599)'::int4range)-('[-1909090622,1440872050)'::int4range)))-('[-1918334492,356792477]'::int4range)))-((((('(-1530317544,1827513486]'::int4range)-('(-1311775940,-953190796)'::int4range)))-((('(-1245315510,-163075269]'::int4range)*('(715007194,1344212448)'::int4range)))))))));
INSERT INTO t5(c0) VALUES('(-1452278967,-562000738)'::int4range);
DELETE FROM ONLY t2;
CREATE TEMP SEQUENCE IF NOT EXISTS seq INCREMENT 2110383124 CACHE 2070551783;
INSERT INTO t5(c0) VALUES('(-912907009,1415390419]'::int4range), (NULL), ((((((((('[-721824477,-97399112]'::int4range)+('[-1817899399,1536309557]'::int4range)))+((('(-381385453,1917221830)'::int4range)*('[-821500903,1755490304)'::int4range)))))+((((('[-1574574191,-552459196)'::int4range)+('[-2064735005,692159991]'::int4range)))*((('(1490677195,1586516146)'::int4range)*('[-912907009,1792025509)'::int4range)))))))*((((((('[29541074,2017186161]'::int4range)*('[-1789585436,-1355299617]'::int4range)))+((('(-2069374575,1460047484)'::int4range)+('(-2146501961,1357454288]'::int4range)))))-((((('[-367745330,1069689550]'::int4range)*('(-1121534562,2145717186)'::int4range)))+((('[-51503197,1945694734]'::int4range)*('(136727648,1746658917)'::int4range)))))))));
DELETE FROM t0 WHERE CAST(((('0.4615078468696574')||(t0.c0)) COLLATE "en_IL.utf8")!~*(((('0.3145480635825415')||(B'1011000101001110011000101111111')))||(((NULL)&(B'11110111010010111111110011100')))) AS BOOLEAN);
DELETE FROM t5 WHERE (((t5.c0)-(t5.c0))) BETWEEN (((((((t5.c0)-(t5.c0)))-(((t5.c0)*(t5.c0)))))+(t5.c0))) AND (((t5.c0)+(t5.c0))) RETURNING '253.211.219.227';
DROP INDEX IF EXISTS i0, i0, i4;
RESET ROLE;
DISCARD PLANS;
CLUSTER t0;
CLUSTER t3;
CLUSTER t2;
CLUSTER ;
VACUUM FULL ANALYZE t5;
DROP INDEX IF EXISTS i0, i0 CASCADE;
DISCARD ALL;
DELETE FROM t0;
DISCARD TEMP;
RESET ROLE;
INSERT INTO t0(c0) VALUES((((((((('(300054333,1143215014]'::int4range)-('[1556465597,2102622186]'::int4range)))+((('(-1954296044,-225079582)'::int4range)+('(-1521539057,660725891]'::int4range)))))*((((('[198988762,237526222]'::int4range)+('(-1666747938,-214959778]'::int4range)))+((('[-214959778,827506194)'::int4range)-('[-1754775597,644268084]'::int4range)))))))*((((((('(-1539313911,248039615)'::int4range)*('[830445631,2081896189]'::int4range)))+((('[-552459196,-413149358)'::int4range)-('(1013737497,1216922291)'::int4range)))))-((((('[266171403,802586236]'::int4range)+('(-1268545429,1818681120]'::int4range)))-((('(-390055216,1163459296]'::int4range)-('[-1536073595,-552459196)'::int4range)))))))));
INSERT INTO t1(c0) VALUES((((((((('[-2069374575,1918595259]'::int4range)-('(599190763,1860205638]'::int4range)))*((('[-2096086960,419878171]'::int4range)-('[393354361,1858512759)'::int4range)))))*((((('[-10175884,599190763)'::int4range)-('[-1547044709,599190763]'::int4range)))+((('(-1006773156,1132060722]'::int4range)+('(-1627073963,-164434417]'::int4range)))))))-((((('(235475032,479978559]'::int4range)-((('(1440872050,2124133599)'::int4range)*('[-924673278,1934959892]'::int4range)))))-((((('[-164988601,1541023115)'::int4range)-('[-1190102358,9223372036854775807)'::int4range)))-((('[369072115,1565477444]'::int4range)*('[-1196791672,-912907009]'::int4range)))))))));
INSERT INTO t5(c0) VALUES('[-1960732053,340389964]'::int4range);
COMMIT;
SET SESSION statement_timeout = 5000;\n;