Bug (8.4beta): FailedAssertion("!(bms_is_subset(relids, qualscope))", File: "initsplan.c", Line: 915)

From: Stefan Huehner <stefan(at)huehner(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug (8.4beta): FailedAssertion("!(bms_is_subset(relids, qualscope))", File: "initsplan.c", Line: 915)
Date: 2009-05-05 20:21:36
Message-ID: 20090505202136.GA3026@huehner.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I noticed the following bug when testing an application (openbravo 2.40) on postgresql 8.4:

Environment:
8.4beta
Package from: https://launchpad.net/~pitti/+archive/postgresql
recompiled for ubuntu intrepid

The following query does trigger the FailedAssertion:

SELECT ad_field.name As Name, ad_field_trl.name as columnname
FROM ad_field left join ad_field_trl on ad_field.ad_field_id = ad_field_trl.ad_field_id
and ad_field_trl.ad_language = 'en_US',
ad_column
WHERE ad_field.ad_column_id = ad_column.ad_column_id
and ad_tab_id = to_number(1) and isParent='Y'
and exists(select 1 from ad_column c, ad_field f where c.ad_column_id = f.ad_column_id and c.iskey='Y'
and ad_tab_id=to_number(1) and UPPER(c.columnname) = UPPER(ad_column.columnname));

The minimum needed table-structure and function definition (to_number) are attached.

The original usecase did have to_number(?) via jdbc-preparedstatement and passing the parameter via setString, thus using the to_number(text) function. But the same assertion does also happen with the query shown above..

Feel free to ask for any more needed information.

Regards,
Stefan

Attachment Content-Type Size
test.dump text/plain 3.6 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2009-05-06 08:33:50 Re: BUG #4785: Installation fails
Previous Message Krimstock, Roger I (Roger) 2009-05-05 18:56:22 Re: BUG #4785: Installation fails