From: | Andreas Seltenreich <seltenreich(at)gmx(dot)de> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | [sqlsmith] ERROR: failed to build any %d-way joins |
Date: | 2015-08-08 11:04:29 |
Message-ID: | 87bneit51e.fsf@ex.ansel.ydns.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
there's a 1/1e6 chance that a sqlsmith query on the regression db of
master (c124cef) fails with
ERROR: failed to build any {4..8}-way joins
They all appear to work fine on REL9_5_STABLE.
sample query:
select 1 from
information_schema.collations as rel_60113935
inner join information_schema.sql_sizing_profiles as rel_60113936
on (rel_60113935.pad_attribute = rel_60113936.sizing_name )
inner join information_schema.foreign_tables as rel_60113937
on (rel_60113936.profile_id = rel_60113937.foreign_table_catalog )
right join information_schema.constraint_table_usage as rel_60113938
on (rel_60113935.collation_schema = rel_60113938.table_catalog )
left join public.btree_tall_tbl as rel_60113939
on (rel_60113936.required_value = rel_60113939.id )
where rel_60113938.table_name is not NULL;
regards,
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Seltenreich | 2015-08-08 11:30:31 | Re: [sqlsmith] ERROR: failed to build any %d-way joins |
Previous Message | Shay Rojansky | 2015-08-08 09:31:46 | statement_timeout affects query results fetching? |