./sqlsmith --verbose --target="host=/tmp port=5432 dbname=regression" --max-queries=1 --dry-run
SQLsmith v1.0-157-g2194f0e-dirty
Loading types...done.
Loading tables...done.
Loading columns and constraints...done.
Loading operators...done.
Loading routines...done.
Loading routine parameters...done.
Loading aggregates...done.
Loading aggregate parameters...done.
Generating indexes...done.
select
subq_0.c0 as c0,
(select classoid from pg_catalog.pg_seclabel limit 1 offset 5)
as c1,
(select pg_catalog.min(valuntil) from pg_catalog.pg_shadow)
as c2,
(select lanvalidator from pg_catalog.pg_language limit 1 offset 1)
as c3
from
pg_catalog.pg_attribute as sample_0 tablesample system (2.9)
inner join (select
sample_1.connamespace as c0,
(select autoanalyze_count from pg_catalog.pg_stat_user_tables limit 1 offset 5)
as c1,
(select rolcreatedb from pg_catalog.pg_roles limit 1 offset 2)
as c2,
sample_1.contoencoding as c3,
sample_1.contoencoding as c4,
sample_1.connamespace as c5,
(select prepared from pg_catalog.pg_prepared_xacts limit 1 offset 2)
as c6,
case when EXISTS (
select
(select pg_catalog.avg(procost) from pg_catalog.pg_proc)
as c0,
ref_0.domain_name as c1,
ref_0.domain_schema as c2,
ref_0.domain_catalog as c3
from
information_schema.column_domain_usage as ref_0
where (false)
or (ref_0.domain_name is not NULL)) then sample_1.conname else sample_1.conname end
as c7,
50 as c8
from
pg_catalog.pg_conversion as sample_1 tablesample system (6)
where (sample_1.contoencoding is NULL)
or (sample_1.conproc is not NULL)
limit 68) as subq_0
on (case when (select table_schema from information_schema.role_column_grants limit 1 offset 1)
is NULL then case when cast(null as bpchar) ~>~ cast(null as bpchar) then cast(null as date) else cast(null as date) end
else case when cast(null as bpchar) ~>~ cast(null as bpchar) then cast(null as date) else cast(null as date) end
end
>= subq_0.c6)
where cast(null as tinterval) #>= case when subq_0.c0 is not NULL then case when EXISTS (
select
sample_2.collowner as c0
from
pg_catalog.pg_collation as sample_2 tablesample bernoulli (9.4)
inner join information_schema.sql_parts as ref_1
on (cast(null as uuid) = cast(null as uuid))
where (false)
and (cast(null as box) << cast(null as box))
limit 73) then case when (false)
or (cast(null as bpchar) < cast(null as bpchar)) then pg_catalog.reltimein(
cast(pg_catalog.time_out(
cast(cast(null as "time") as "time")) as cstring)) else pg_catalog.reltimein(
cast(pg_catalog.time_out(
cast(cast(null as "time") as "time")) as cstring)) end
else case when (false)
or (cast(null as bpchar) < cast(null as bpchar)) then pg_catalog.reltimein(
cast(pg_catalog.time_out(
cast(cast(null as "time") as "time")) as cstring)) else pg_catalog.reltimein(
cast(pg_catalog.time_out(
cast(cast(null as "time") as "time")) as cstring)) end
end
else case when EXISTS (
select
sample_2.collowner as c0
from
pg_catalog.pg_collation as sample_2 tablesample bernoulli (9.4)
inner join information_schema.sql_parts as ref_1
on (cast(null as uuid) = cast(null as uuid))
where (false)
and (cast(null as box) << cast(null as box))
limit 73) then case when (false)
or (cast(null as bpchar) < cast(null as bpchar)) then pg_catalog.reltimein(
cast(pg_catalog.time_out(
cast(cast(null as "time") as "time")) as cstring)) else pg_catalog.reltimein(
cast(pg_catalog.time_out(
cast(cast(null as "time") as "time")) as cstring)) end
else case when (false)
or (cast(null as bpchar) < cast(null as bpchar)) then pg_catalog.reltimein(
cast(pg_catalog.time_out(
cast(cast(null as "time") as "time")) as cstring)) else pg_catalog.reltimein(
cast(pg_catalog.time_out(
cast(cast(null as "time") as "time")) as cstring)) end
end
end
;
